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