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 h2-database@googlegroups.com. To unsubscribe from this group, send email to h2-database+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.