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.
