Hello,
A couple of processes (around 10) connect to a H2 database using the
AUTO_SERVER mode (and h2.bindAddress = localhost). From time to time,
the database get corrupted:
org.h2.jdbc.JdbcSQLException: File corrupted while reading record:
"[5319] stream data key:4379 pos:11 remaining:0". Possible solution:
use the recovery tool; SQL statement:
at
org.h2.message.DbException.getJdbcSQLException(DbException.java:327)
at org.h2.message.DbException.get(DbException.java:167)
at org.h2.message.DbException.get(DbException.java:144)
at org.h2.index.PageDataIndex.getPage(PageDataIndex.java:231)
at org.h2.index.PageDataNode.getRowWithKey(PageDataNode.java:
269)
at org.h2.index.PageDataNode.getRowWithKey(PageDataNode.java:
270)
at org.h2.index.PageDataIndex.getRowWithKey(PageDataIndex.java:
401)
at org.h2.index.PageDataIndex.getRow(PageDataIndex.java:390)
at org.h2.table.RegularTable.getRow(RegularTable.java:118)
at org.h2.index.PageBtreeIndex.getRow(PageBtreeIndex.java:283)
at org.h2.index.PageBtreeCursor.get(PageBtreeCursor.java:45)
at org.h2.index.IndexCursor.get(IndexCursor.java:220)
at org.h2.table.TableFilter.getValue(TableFilter.java:868)
at
org.h2.expression.ExpressionColumn.getValue(ExpressionColumn.java:171)
at org.h2.command.dml.Select.queryFlat(Select.java:518)
at org.h2.command.dml.Select.queryWithoutCache(Select.java:
617)
at org.h2.command.dml.Query.query(Query.java:298)
at org.h2.command.dml.Query.query(Query.java:268)
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)
at org.h2.server.TcpServerThread.process(TcpServerThread.java:
278)
at org.h2.server.TcpServerThread.run(TcpServerThread.java:137)
at java.lang.Thread.run(Thread.java:619)
What could I do to either reduce the corruption likelihood or at least
help to figure out the problem ?
Thank you
Sylvain.
--
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.
