Could you post your SQL statements, database setup, JDBC url and trace files ? It would facilitate in helping out.
On Aug 5, 1:24 am, Sylvain <[email protected]> wrote: > 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.
