I've updated to 1.3.173. Now I sometimes get the following Exception:
09-19 12:15:38 jdbc[2]: exception
org.h2.jdbc.JdbcSQLException: File corrupted while reading record:
"page[61779266] b-tree leaf table:212525 entries:0". Possible solution: use
the recovery tool; SQL statement:
<-- as described in previous posts -->
at org.h2.message.DbException.getJdbcSQLException(DbException.java:331)
at org.h2.message.DbException.get(DbException.java:171)
at org.h2.message.DbException.get(DbException.java:148)
at org.h2.index.PageDataIndex.getPage(PageDataIndex.java:239)
at org.h2.index.PageDataNode.addRowTry(PageDataNode.java:129)
at org.h2.index.PageDataNode.addRowTry(PageDataNode.java:130)
at org.h2.index.PageDataIndex.addTry(PageDataIndex.java:172)
at org.h2.index.PageDataIndex.add(PageDataIndex.java:135)
at org.h2.table.RegularTable.addRow(RegularTable.java:125)
at org.h2.result.ResultTempTable.addRow(ResultTempTable.java:113)
at org.h2.result.LocalResult.addRow(LocalResult.java:267)
at
org.h2.command.dml.SelectUnion.queryWithoutCache(SelectUnion.java:194)
at org.h2.command.dml.SelectUnion.query(SelectUnion.java:408)
at org.h2.command.dml.Query.query(Query.java:284)
at
org.h2.command.dml.SelectUnion.queryWithoutCache(SelectUnion.java:183)
at org.h2.command.dml.SelectUnion.query(SelectUnion.java:408)
at org.h2.command.dml.Query.query(Query.java:284)
at
org.h2.command.dml.SelectUnion.queryWithoutCache(SelectUnion.java:183)
at org.h2.command.dml.SelectUnion.query(SelectUnion.java:408)
at org.h2.command.dml.Query.query(Query.java:284)
at
org.h2.command.dml.SelectUnion.queryWithoutCache(SelectUnion.java:183)
at org.h2.command.dml.SelectUnion.query(SelectUnion.java:408)
at org.h2.command.dml.Query.query(Query.java:284)
at
org.h2.command.dml.SelectUnion.queryWithoutCache(SelectUnion.java:183)
at org.h2.command.dml.SelectUnion.query(SelectUnion.java:408)
at org.h2.command.dml.Query.query(Query.java:284)
at
org.h2.command.dml.SelectUnion.queryWithoutCache(SelectUnion.java:183)
at org.h2.command.dml.SelectUnion.query(SelectUnion.java:408)
at org.h2.command.dml.Query.query(Query.java:284)
at
org.h2.command.dml.SelectUnion.queryWithoutCache(SelectUnion.java:183)
at org.h2.command.dml.SelectUnion.query(SelectUnion.java:408)
at org.h2.command.dml.Query.query(Query.java:284)
at
org.h2.command.dml.SelectUnion.queryWithoutCache(SelectUnion.java:183)
at org.h2.command.dml.SelectUnion.query(SelectUnion.java:408)
at org.h2.command.dml.Query.query(Query.java:284)
at
org.h2.command.dml.SelectUnion.queryWithoutCache(SelectUnion.java:183)
at org.h2.command.dml.SelectUnion.query(SelectUnion.java:408)
at org.h2.command.dml.Query.query(Query.java:284)
at org.h2.index.ViewIndex.find(ViewIndex.java:253)
at org.h2.index.BaseIndex.find(BaseIndex.java:126)
at org.h2.index.IndexCursor.find(IndexCursor.java:155)
at org.h2.table.TableFilter.next(TableFilter.java:328)
at org.h2.command.dml.Select.queryFlat(Select.java:518)
at org.h2.command.dml.Select.queryWithoutCache(Select.java:625)
at org.h2.command.dml.Query.query(Query.java:314)
at org.h2.command.dml.Query.query(Query.java:284)
at
org.h2.command.dml.SelectUnion.queryWithoutCache(SelectUnion.java:184)
at org.h2.command.dml.SelectUnion.query(SelectUnion.java:408)
at org.h2.command.dml.Query.query(Query.java:284)
at org.h2.command.dml.Query.query(Query.java:36)
at org.h2.command.CommandContainer.query(CommandContainer.java:91)
at org.h2.command.Command.executeQuery(Command.java:195)
at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:177)
at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:156)
...
09-19 12:15:38 jdbc[9]: exception
org.h2.jdbc.JdbcSQLException: File corrupted while reading record:
"page[61779265] data leaf table:212524 TEMP_RESULT_SET_212524 entries:0
parent:0 keys:null offsets:null". Possible solution: use the recovery tool;
SQL statement:
<-- as described in previous posts -->
at org.h2.message.DbException.getJdbcSQLException(DbException.java:331)
at org.h2.message.DbException.get(DbException.java:171)
at org.h2.message.DbException.get(DbException.java:148)
at org.h2.index.PageBtreeIndex.getPage(PageBtreeIndex.java:154)
at org.h2.index.PageBtreeNode.find(PageBtreeNode.java:304)
at org.h2.index.PageBtreeIndex.find(PageBtreeIndex.java:180)
at org.h2.index.PageBtreeIndex.find(PageBtreeIndex.java:171)
at org.h2.result.ResultTempTable.find(ResultTempTable.java:208)
at org.h2.result.ResultTempTable.addRow(ResultTempTable.java:111)
at org.h2.result.ResultTempTable.addRows(ResultTempTable.java:124)
at org.h2.result.LocalResult.addRow(LocalResult.java:263)
at
org.h2.command.dml.SelectUnion.queryWithoutCache(SelectUnion.java:191)
at org.h2.command.dml.SelectUnion.query(SelectUnion.java:408)
at org.h2.command.dml.Query.query(Query.java:284)
at
org.h2.command.dml.SelectUnion.queryWithoutCache(SelectUnion.java:183)
at org.h2.command.dml.SelectUnion.query(SelectUnion.java:408)
at org.h2.command.dml.Query.query(Query.java:284)
at org.h2.index.ViewIndex.find(ViewIndex.java:253)
at org.h2.index.BaseIndex.find(BaseIndex.java:126)
at org.h2.index.IndexCursor.find(IndexCursor.java:155)
at org.h2.table.TableFilter.next(TableFilter.java:328)
at org.h2.command.dml.Select.queryFlat(Select.java:518)
at org.h2.command.dml.Select.queryWithoutCache(Select.java:625)
at org.h2.command.dml.Query.query(Query.java:314)
at org.h2.command.dml.Query.query(Query.java:284)
at
org.h2.command.dml.SelectUnion.queryWithoutCache(SelectUnion.java:184)
at org.h2.command.dml.SelectUnion.query(SelectUnion.java:408)
at org.h2.command.dml.Query.query(Query.java:284)
at org.h2.command.dml.Query.query(Query.java:36)
at org.h2.command.CommandContainer.query(CommandContainer.java:91)
at org.h2.command.Command.executeQuery(Command.java:195)
at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:177)
at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:156)
...
09-19 12:15:55 jdbc[7]: exception
org.h2.jdbc.JdbcSQLException: General error: "java.lang.RuntimeException:
Undo entry not written"; SQL statement:
<-- as described in previous posts -->
at org.h2.message.DbException.getJdbcSQLException(DbException.java:331)
at org.h2.message.DbException.get(DbException.java:160)
at org.h2.message.DbException.convert(DbException.java:283)
at org.h2.table.RegularTable.addRow(RegularTable.java:143)
at org.h2.result.ResultTempTable.addRow(ResultTempTable.java:113)
at org.h2.result.LocalResult.addRow(LocalResult.java:267)
at
org.h2.command.dml.SelectUnion.queryWithoutCache(SelectUnion.java:191)
at org.h2.command.dml.SelectUnion.query(SelectUnion.java:408)
at org.h2.command.dml.Query.query(Query.java:284)
at
org.h2.command.dml.SelectUnion.queryWithoutCache(SelectUnion.java:183)
at org.h2.command.dml.SelectUnion.query(SelectUnion.java:408)
at org.h2.command.dml.Query.query(Query.java:284)
at
org.h2.command.dml.SelectUnion.queryWithoutCache(SelectUnion.java:183)
at org.h2.command.dml.SelectUnion.query(SelectUnion.java:408)
at org.h2.command.dml.Query.query(Query.java:284)
at
org.h2.command.dml.SelectUnion.queryWithoutCache(SelectUnion.java:183)
at org.h2.command.dml.SelectUnion.query(SelectUnion.java:408)
at org.h2.command.dml.Query.query(Query.java:284)
at
org.h2.command.dml.SelectUnion.queryWithoutCache(SelectUnion.java:183)
at org.h2.command.dml.SelectUnion.query(SelectUnion.java:408)
at org.h2.command.dml.Query.query(Query.java:284)
at
org.h2.command.dml.SelectUnion.queryWithoutCache(SelectUnion.java:183)
at org.h2.command.dml.SelectUnion.query(SelectUnion.java:408)
at org.h2.command.dml.Query.query(Query.java:284)
at org.h2.index.ViewIndex.find(ViewIndex.java:253)
at org.h2.index.BaseIndex.find(BaseIndex.java:126)
at org.h2.index.IndexCursor.find(IndexCursor.java:155)
at org.h2.table.TableFilter.next(TableFilter.java:328)
at org.h2.command.dml.Select.queryFlat(Select.java:518)
at org.h2.command.dml.Select.queryWithoutCache(Select.java:625)
at org.h2.command.dml.Query.query(Query.java:314)
at org.h2.command.dml.Query.query(Query.java:284)
at
org.h2.command.dml.SelectUnion.queryWithoutCache(SelectUnion.java:184)
at org.h2.command.dml.SelectUnion.query(SelectUnion.java:408)
at org.h2.command.dml.Query.query(Query.java:284)
at org.h2.command.dml.Query.query(Query.java:36)
at org.h2.command.CommandContainer.query(CommandContainer.java:91)
at org.h2.command.Command.executeQuery(Command.java:195)
at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:177)
at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:156)
...
Caused by: java.lang.RuntimeException: Undo entry not written
at org.h2.message.DbException.throwInternalError(DbException.java:230)
at org.h2.store.PageLog.addUndo(PageLog.java:485)
at org.h2.store.PageStore.update(PageStore.java:1061)
at org.h2.index.PageBtreeLeaf.addRow(PageBtreeLeaf.java:165)
at org.h2.index.PageBtreeLeaf.addRowTry(PageBtreeLeaf.java:101)
at org.h2.index.PageBtreeNode.addRowTry(PageBtreeNode.java:201)
at org.h2.index.PageBtreeNode.addRowTry(PageBtreeNode.java:201)
at org.h2.index.PageBtreeIndex.addRow(PageBtreeIndex.java:95)
at org.h2.index.PageBtreeIndex.add(PageBtreeIndex.java:86)
at org.h2.table.RegularTable.addRow(RegularTable.java:125)
... 46 more
--
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/groups/opt_out.
