Hi all,
i've an error when executing simple query "Select * From TBCLASSART"
08-30 08:38:22 jdbc[2]: exception
org.h2.jdbc.JdbcSQLException: General error: "java.lang.RuntimeException:
page[29799] data leaf table:192 TBCLASSART entries:16 parent:29744
keys:[3174320, 3174321, 3174322, 3174323, 3174324, 3174325, 3174326,
3174327, 3174328, 3174329, 3174330, 3174331, 3174332, 3174333, 3174334,
3174335] offsets:[1974, 1895, 1825, 1756, 1687, 1618, 1550, 1482, 1414,
1352, 1268, 1182, 1113, 1018, 952, 870] parent 29744 expected 30118"; SQL
statement:
Select * From TBCLASSART [50000-164]
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.command.Command.executeQuery(Command.java:191)
at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:173)
at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:152)
at
net.sourceforge.squirrel_sql.client.session.SQLExecuterTask.processQuery(SQLExecuterTask.java:410)
at
net.sourceforge.squirrel_sql.client.session.SQLExecuterTask.run(SQLExecuterTask.java:220)
at
net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.lang.RuntimeException: page[29799] data leaf table:192
TBCLASSART entries:16 parent:29744 keys:[3174320, 3174321, 3174322,
3174323, 3174324, 3174325, 3174326, 3174327, 3174328, 3174329, 3174330,
3174331, 3174332, 3174333, 3174334, 3174335] offsets:[1974, 1895, 1825,
1756, 1687, 1618, 1550, 1482, 1414, 1352, 1268, 1182, 1113, 1018, 952, 870]
parent 29744 expected 30118
at org.h2.message.DbException.throwInternalError(DbException.java:228)
at org.h2.index.PageDataIndex.getPage(PageDataIndex.java:239)
at org.h2.index.PageDataNode.getNextPage(PageDataNode.java:226)
at org.h2.index.PageDataLeaf.getNextPage(PageDataLeaf.java:392)
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:238)
at org.h2.table.TableFilter.next(TableFilter.java:353)
at org.h2.command.dml.Select.queryFlat(Select.java:513)
at org.h2.command.dml.Select.queryWithoutCache(Select.java:618)
at org.h2.command.dml.Query.query(Query.java:297)
at org.h2.command.dml.Query.query(Query.java:267)
at org.h2.command.dml.Query.query(Query.java:36)
at org.h2.command.CommandContainer.query(CommandContainer.java:82)
at org.h2.command.Command.executeQuery(Command.java:187)
... 6 more
i don't use MVCC.
There are any solutions?
Thanks
--
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/-/g_aJwYa3SN4J.
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.
