Hi,
I recently migrated from an older version of H2 to v1.3.155. Things
looked great in dev, but now, after I shipped, users seem to have
trouble when (for whatever reason) the process crashes without closing
the database.
As an example, a process crashed while H2 still had a table ("SONGS")
locked, potentially still performing operations on that table. The
next time the app was started the exception below appeared.
My questions are:
- What exactly does this error message mean?
- What's the best (programmatic, non-interactive) way to recover from
this error?
- What can be the best and what the worst result one can hope for when
attempting recovery?
Thank you very much for you help!
-hendrik
Used URL: jdbc:h2:C:\Users\xxx
\somefile;TRACE_LEVEL_FILE=1;TRACE_LEVEL_SYSTEM_OUT=1;LOCK_TIMEOUT=10000;CACHE_SIZE=16384
java.lang.RuntimeException: page[88252] data leaf table:170 SONGS
entries:1 parent:132055 keys:[114347] offsets:[1442] parent 132055
expected 88276
at org.h2.message.DbException.throwInternalError(DbException.java:
226)
at org.h2.index.PageDataIndex.getPage(PageDataIndex.java:235)
at org.h2.index.PageDataNode.getNextPage(PageDataNode.java:226)
at org.h2.index.PageDataLeaf.getNextPage(PageDataLeaf.java:391)
at org.h2.index.PageDataCursor.nextRow(PageDataCursor.java:90)
at org.h2.index.PageDataCursor.next(PageDataCursor.java:49)
at org.h2.index.IndexCursor.next(IndexCursor.java:235)
at org.h2.table.TableFilter.next(TableFilter.java:352)
at org.h2.command.dml.Select.queryGroup(Select.java:310)
at org.h2.command.dml.Select.queryWithoutCache(Select.java:612)
at org.h2.command.dml.Query.query(Query.java:290)
at org.h2.command.dml.Query.query(Query.java:260)
at org.h2.command.dml.Query.query(Query.java:37)
at org.h2.command.CommandContainer.query(CommandContainer.java:80)
at org.h2.command.Command.executeQuery(Command.java:181)
... 41 more
--
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.
