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.
