Sorry, not really enough data :-(
when it happens, try connecting with VisualVM and getting a full thread
dump.
Also, what is your database URL?
On 2013-02-12 14:17, Johan Parent wrote:
Hi all,
I'm using 1.3.170 in combination with hibernate. Every now and then my
app has issues related to its persistence backend. Suddenly the
hibernate session takes forever (well it never stops). Today I managed
to get hold of a thread dump when the problem happened.
I do suspect that the problem occurs during concurrent access to the
db. But I always expected the locking mechanism would just make the
hibernate session fail (as I've seen it happen more than once).
Anyway, if I'm not mistaken there may be a locking issue
causing my problem. I don't have more information to provide. I hope
it is enough for the gurus ;) Partial thread dump below.
Keep up the good work. Love this database using it for years now.
Best regards,
Johan Parent
State: RUNNABLE
Total blocked: 5 Total waited: 68
Stack trace:
java.net.SocketInputStream.socketRead0(Native Method)
java.net.SocketInputStream.read(SocketInputStream.java:150)
java.net.SocketInputStream.read(SocketInputStream.java:121)
java.io.BufferedInputStream.fill(BufferedInputStream.java:235)
java.io.BufferedInputStream.read(BufferedInputStream.java:254)
- locked java.io.BufferedInputStream@1c7783f
java.io.DataInputStream.readInt(DataInputStream.java:387)
org.h2.value.Transfer.readInt(Transfer.java:151)
org.h2.engine.SessionRemote.done(SessionRemote.java:561)
org.h2.command.CommandRemote.executeQuery(CommandRemote.java:149)
- locked org.h2.engine.SessionRemote@a7ae8f
org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:109)
- locked org.h2.engine.SessionRemote@a7ae8f
org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
org.hibernate.loader.Loader.doQuery(Loader.java:802)
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
org.hibernate.loader.Loader.doList(Loader.java:2533)
org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
org.hibernate.loader.Loader.list(Loader.java:2271)
org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:119)
org.hibernate.impl.SessionImpl.list(SessionImpl.java:1716)
org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:347)
org.hibernate.impl.CriteriaImpl.uniqueResult(CriteriaImpl.java:369)
--
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.
--
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.
