Hi, > I suspect there is bug in my application which can cause that single connection is used by multiple threads to execute statements and commit concurrently on that connection.
That shouldn't be a problem. I did find a concurrency problem, but so far I can only reproduce it when using the option "multi_threaded" in the database URL. So if you find out how to reproduce the problem (if you have a test case that I can run that at least sometimes runs into this situation) then that would be great! Regards, Thomas On Wed, Apr 30, 2014 at 10:47 AM, too <[email protected]> wrote: > Hi, > I made further investigation and I can not replicate this in any reliable > matter. It happened again though during processing of different type of > data. I do not think blobs are involved. Both failures seem to have in > common 30+ column count. Application is very generic and it is not possible > for me to identify what were other threads storing to DB at the time of > failure, All I get is the record that failed. During the second occurrence > of index out of bounds it was not followed by subsequent problems and app > ran fine for a while and then again failed with index out of bounds later > on. > I suspect there is bug in my application which can cause that single > connection is used by multiple threads to execute statements and commit > concurrently on that connection. I need to prove that though and I > definitely hope that is not the case :) > > thanks > Tono > > > On Friday, April 25, 2014 3:36:33 PM UTC+2, Thomas Mueller wrote: > >> Hi, >> >> Yes, it looks like a concurrency problem. Would it be possible to post or >> send me a reproducible test case? If not, could you describe what your >> program is doing (how many tables, does it use transactions, BLOB or CLOB, >> what is the schema of the table or tables,...)? >> >> Regards, >> Thomas >> >> >> On Fri, Apr 25, 2014 at 1:52 PM, too <[email protected]> wrote: >> >>> I realized I should have perhaps posted the connection string so here it >>> is jdbc:h2:./db/test;IFEXISTS=TRUE;LOCK_TIMEOUT=30000 >>> There is nothing interesting or special about it though >>> >>> Tono >>> >>> -- >>> You received this message because you are subscribed to the Google >>> Groups "H2 Database" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to [email protected]. >>> To post to this group, send email to [email protected]. >>> >>> Visit this group at http://groups.google.com/group/h2-database. >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
