[h2] Possible deadlock using H2 table functions the query H2

2014-05-14 Thread christoff . schmitz
Hi, Our application uses an embedded H2 database (1.3.173). During execution, table functions are created. Some of them execute select-statements in the H2 database. When not running in in multi-threaded mode, and if multiple threads (each with separate connection) are accessing the same table

Re: [h2] Possible deadlock using H2 table functions the query H2

2014-05-14 Thread Noel Grandin
That is a classic example of an ABBA lock, and we are happy to track them down and fix them. Can you identify for us a stack-trace where it synchronizes over the database while holding a lock on a TableView? If you are using the Eclipse debugger, this is very easy - when it is paused,

Re: [h2] Possible deadlock using H2 table functions the query H2

2014-05-14 Thread christoff . schmitz
...@gmail.com To: h2-database@googlegroups.com Date: 14.05.2014 15:05 Subject:Re: [h2] Possible deadlock using H2 table functions the query H2 Sent by:h2-database@googlegroups.com That is a classic example of an ABBA lock, and we are happy to track them down and fix them

Re: [h2] Possible deadlock using H2 table functions the query H2

2014-05-14 Thread Noel Grandin
Hi Thanks for the stacktrace. I think I've fixed this in SVN. You could either build H2 yourself, or wait until tomorrow and try out the daily build. Regards, Noel On 2014-05-14 16:09, christoff.schm...@finaris.de wrote: Hi, see the stack trace below, I marked the positions where