Hi, I could analyze it now. The problem seems to be that creating a temporary table is not committed, and then the temporary table is deleted in another session. I have a fix / workaround for that, but so far no test case. Please tell me if you have a reproducible test case.
Regards, Thomas On Tuesday, May 27, 2014, too <[email protected]> wrote: > Even though I can reproduce this with our app I fail to create separate > test case to reproduce the problem (i.e. to break the DB). What I can do is > send you database that H2 fails to open. Perhaps it is not really bug > during close but not robust enough recovery during startup. Zipped DB has > 10MB and I can share it for you privately if you think that can help > > thanks > Tono > > On Thursday, May 22, 2014 5:47:11 PM UTC+2, too wrote: > > I have experimented with this a little and here are few notes > > - lock file remains in place - this is consistent with shutdown hooks > not being executed during JVM abort > - size of DB file remains intact during runtime but during process > termination the size rises by approximately 50MB - which contradicts > previous point and it seems there is something executed during abort > - I can replicate problem with 100% success rate using our app but I > fail to create test app to replicate the problem (still have a few ideas to > try) > - I can replicate the problem with older 1.3.x releases as well as > with latest 1.4.x release (with MV_STORE=FALSE) > - even though I do not think that there are transactions in progress > at the time of termination it is possible there are open cursors or > something similar - read-related > > I can avoid this problem by running H2 in server mode but that is not what > I want. > > Tono > > On Tuesday, May 20, 2014 3:16:03 PM UTC+2, too wrote: > > Hi, > Sometimes when our application is shut down forcibly it is unable to start > again with exceptions below. It does not appear that transaction is in > progress at the time of shutdown but I can not be sure. I was unable to > create test case but our application reproduces this quite consistently > (it's very rare that it starts after being terminated). > I have attached debug trace file for failed start - not for the shutdown. > I tried INFO logging for shutdown (breaking the db) but nothing seemed > interesting there, just bunch of selects. Also no error is logged during > shutdown or startup. > > Environment details are > > - H2 - 1.3.176 > - Java Runtime - Java(TM) SE Runtime Environment (1.7.0_17-b02, > 32b) on Java HotSpot(TM) Client VM (23.7-b01, mixed mode) > - Operating System - Windows 7 (64b, Service Pack 1, version 6.1) > - connection URL - jdbc:h2:./dbfile;IFEXISTS=TRUE > > > NullPointerException - this is what usually happens > > org.h2.jdbc.JdbcSQLException: General error: "java.lang.NullPointerException" > [50000-176] > at org.h2.message.DbException.getJdbcSQLException(DbException.java:344) > ~[h2.jar:1.3.176] > at org.h2.message.DbException.get(DbException.java:167) ~[h2.jar:1.3.176] > at org.h2.message.DbException.convert(DbException.java:294) > ~[h2.jar:1.3.176] > at org.h2.engine.Database.openDatabase(Database.java:291) > ~[h2.jar:1.3.176] > at org.h2.engine.Database.<init>(Database.java:254) ~[h2.jar:1.3.176] > at org.h2.engine.Engine.openSession(Engine.java:57) ~[h2.jar:1.3.176] > at org.h2.engine.Engine.openSession(Engine.java:164) ~[h2.jar:1.3.176] > at org.h2.engine.Engine.createSessionAndValidate(Engine.java:142) > ~[h2.jar:1.3.176] > at org.h2.engine.Engine.createSession(Engine.java:125) ~[h2.jar:1.3.176] > at org.h2.engine.Engine.createSession(Engine.java:27) ~[h2.jar:1.3.176] > > -- > 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] > <javascript:_e(%7B%7D,'cvml','h2-database%[email protected]');> > . > To post to this group, send email to [email protected] > <javascript:_e(%7B%7D,'cvml','[email protected]');>. > Visit this group at http://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/d/optout. > -- 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. For more options, visit https://groups.google.com/d/optout.
