db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "palo.liska" <palo.li...@gmail.com>
Subject Re: Identity column and 40XL1 error
Date Fri, 08 Jun 2018 13:59:44 GMT
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