I don't have a reproducible test-case yet but I have some more info, which I think might be related. When I'm trying to connect to the same database I now get the following error: ERROR - FileDataBlockDB:database close org.h2.message.DbException: File corrupted while reading record: "index not found 34". Possible solution: use the recovery tool [90030-166] at org.h2.message.DbException.get(DbException.java:169) at org.h2.message.DbException.get(DbException.java:146) at org.h2.store.PageStore.getPage(PageStore.java:804) at org.h2.store.PageStore.compact(PageStore.java:696) at org.h2.store.PageStore.compact(PageStore.java:524) at org.h2.engine.Database.closeOpenFilesAndUnlock(Database.java:1198) at org.h2.engine.Database.close(Database.java:1148) at org.h2.engine.Database.removeSession(Database.java:1027) at org.h2.engine.Session.close(Session.java:563) at org.h2.jdbc.JdbcConnection.close(JdbcConnection.java:363)
The database has only one table so it is not unlikely that the problems are related. On Friday, April 13, 2012 12:00:16 PM UTC+2, Carl Hasselskog wrote: > > I don't the undo-support is causing the problem but doesn't it > seem unnecessary to track undos for ResultSets? I will try to create a > simple reproducible case. > > Regards > Carl > > On Thursday, April 12, 2012 9:13:22 PM UTC+2, Thomas Mueller wrote: >> >> Hi, >> >> Do you have a reproducible test case? If possible, could you send it? >> >>> >>> 1. What does this do? log.addUndo(pageId, null); >>> (in PageStore.java:1212) >>> >>> As in the comment in the source code, "ensure the undo entry is already >> written". >> >>> >>> 1. To me it looks like setting the page-parameter to null is what is >>> causing the exception. >>> >>> No, it's just a verification. >> >>> >>> 1. Wouldn't it be better to just delete the ResultSet-table without >>> undo-support? Is there any use-case when you want to undo the closing of >>> a >>> ResultSet? >>> >>> I don't think that's the problem. >> >> Regards, >> Thomas >> > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To view this discussion on the web visit https://groups.google.com/d/msg/h2-database/-/S_7wDkMjSyoJ. 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.
