db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rick Hillegas <rick.hille...@gmail.com>
Subject Re: Identity column and 40XL1 error
Date Fri, 08 Jun 2018 22:42:14 GMT
Great. Can you log a bug and attach the code to the bug?


On 6/8/18 6:59 AM, palo.liska wrote:
> Rick Hillegas-3 wrote
>> On 4/10/18 4:19 AM, palo.liska wrote:
>>> Rick Hillegas-3 wrote
>>>> Can you make this error occur in a new database, one which hasn't
>>>> already exhausted the ranges of its identity columns and sequence
>>>> generators? If you can, then I recommend the following next steps:
>> I was able to reproduce this issue with many concurrent inserts.
>> The setup is set of threads inserting random entries in loop, and another
>> set of threads concurrently updating last entry in table (actually done by
>> count = select count(*) and then update .. where id=count-1).
>> With this setup I have high chance of 40XL1 error.
>> If requested I will share actual code.
> --
> Sent from: http://apache-database.10148.n7.nabble.com/Apache-Derby-Users-f95095.html

View raw message