Also when I tried to recover data from the corrupt database, I was only able to recover 10% of it. The original DB size was 1.6 GB while the recovered database size was only 81 MB. Is their something wrong that I am doing?
On Sep 15, 8:31 am, ssk1287 <[email protected]> wrote: > For our multithreaded application that uses H2 database, we saw the > following error in our logs immediately following a heap space error: > > java.util.concurrent.ExecutionException: java.lang.OutOfMemoryError: > Java heap space > > ........ > org.h2.jdbc.JdbcSQLException: File corrupted while reading record: > "[17806] stream data key:1922 pos:11 remaining:0". Possible solution: > use the recovery tool; SQL statement: > update keys set taken=false where taken=true [90030-155] > 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:230) > 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.Update.update(Update.java:89) > at org.h2.command.CommandContainer.update(CommandContainer.java:71) > at org.h2.command.Command.executeUpdate(Command.java:212) > at org.h2.jdbc.JdbcStatement.executeUpdateInternal(JdbcStatement.java: > 125) > at org.h2.jdbc.JdbcStatement.executeUpdate(JdbcStatement.java:110) > ... 6 more > > Is this a known issue with H2 ? -- 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.
