Hi Noel, Thanks for the suggestion. As it turns out it was a speed issue. I needed an index in a few places. I was mistaken in my interpretation of the thread dump. I must have hit the same state (in the dumps) because those queries happen a lot.
Many thanks for you help! Johan On Wednesday, February 13, 2013 10:27:02 AM UTC+1, Noel Grandin wrote: > > You've got some kind of extremely long running query. > > Try turning tracing on > > http://h2database.com/javadoc/org/h2/tools/ConvertTraceFile.html > http://h2database.com/html/grammar.html#set_trace_level > > And seeing which query is causing the problem. > > On 2013-02-13 11:21, Johan Parent wrote: > > Good idea. And the issue now happens frequently enough for me to get > > hold if it already. > > > > Before I forget about the url: nothing special no threading or MVCC > > plain :h2:tcp://host/appmonitor2_db > > > > I took a thread dump of my app and the h2database (server). I've > > attached them to this message. > > > > Below I pasted the two thread I believe (not really know how things > > are related except it is about reading an int) might related . One h2 > > server side, the other app side. In the app thread I've found no other > > thread (alive a that point) that has h2 in it call stack. But again, > > don't know enough. > > > > Many thanks for your suggestion. Hope we can find a solution. > > > > > > -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
