In the short term, I'd suggest turning MVCC off, until Thomas has a chance to figure out where the bug is.
Atul Chowdhury wrote: > Hi All - > > I'm connected to H2 with these settings: > > When I kill the java process (usually due to unresponsive queries / or > application crashes (Java Swing)) and start it > back up, I get this exception: > > Exception = org.h2.jdbc.JdbcSQLException: General error: > "java.lang.ArrayIndexOutOfBoundsException: 61" [50000-158] > at org.h2.message.DbException.getJdbcSQLException(DbException.java:329) > at org.h2.message.DbException.get(DbException.java:158) > at org.h2.message.DbException.convert(DbException.java:281) > at org.h2.engine.Database.openDatabase(Database.java:250) > at org.h2.engine.Database.<init>(Database.java:215) > at org.h2.engine.Engine.openSession(Engine.java:56) > at org.h2.engine.Engine.openSession(Engine.java:159) > at org.h2.engine.Engine.createSessionAndValidate(Engine.java:138) > at org.h2.engine.Engine.createSession(Engine.java:121) > at org.h2.server.TcpServerThread.run(TcpServerThread.java:124) > at java.lang.Thread.run(Thread.java:595) > Caused by: java.lang.ArrayIndexOutOfBoundsException: 61 > at org.h2.index.PageDataLeaf.getRowAt(PageDataLeaf.java:327) > at org.h2.index.PageDataLeaf.getRowWithKey(PageDataLeaf.java:443) > at org.h2.index.PageDataNode.getRowWithKey(PageDataNode.java:270) > at org.h2.index.PageDataIndex.getRowWithKey(PageDataIndex.java:403) > at org.h2.store.PageStore.redoDelete(PageStore.java:1448) > at org.h2.store.PageLog.recover(PageLog.java:332) > at org.h2.store.PageStore.recover(PageStore.java:1328) > at org.h2.store.PageStore.openExisting(PageStore.java:349) > at org.h2.store.PageStore.open(PageStore.java:273) > at org.h2.engine.Database.getPageStore(Database.java:2049) > at org.h2.engine.Database.open(Database.java:553) > at org.h2.engine.Database.openDatabase(Database.java:220) > ... 7 more > | Stack = at java.sql.DriverManager.getConnection(String , Properties , > ClassLoader ) > at java.sql.DriverManager.getConnection(String url, String user, String > password, CallerID ) > at java.sql.DriverManager.getConnection(String url, String user, String > password) > > I'm using H2 1.3.158 - it's about 550MB large. When I gracefully start/stop > it it seems to work OK. > > My connection URL looks like: > > dboptions=;CACHE_SIZE=262144;DB_CLOSE_ON_EXIT=FALSE;LOG=1;WRITE_DELAY=3000;MVCC=TRUE > > Any thoughts? > > Thanks in Advance - > > AC > -- > You received this message because you are subscribed to the Google Groups "H2 > Database" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/h2-database?hl=en. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
