Hi everyone,
We are encountering recurring data corruption in one of our products using H2 as database. Until now we got 2 corrupted databases; and our application will be installed in more than 20 machines. - The version of H2 is 1.4.189 with hibernate+ JPA - The database schema is composed of 62 small tables without binaries. - Database url is the following jdbc:h2:file:C:/Storage/MDBASE;MVCC=TRUE;MV_STORE=TRUE;AUTO_SERVER=TRUE;CACHE_SIZE=16384 - Backuping the corrupted database gives the following error : Exception in thread "main" java.lang.IllegalStateException: File corrupted in chunk 13439, expected page length 4..32, got -486539227 [1.4.191/6] at org.h2.mvstore.DataUtils.newIllegalStateException(DataUtils.java:773) at org.h2.mvstore.Page.read(Page.java:649) at org.h2.mvstore.Page.read(Page.java:195) at org.h2.mvstore.MVStore.readPage(MVStore.java:1939) at org.h2.mvstore.MVMap.readPage(MVMap.java:736) at org.h2.mvstore.Page.getChildPage(Page.java:217) at org.h2.mvstore.Cursor.fetchNext(Cursor.java:150) at org.h2.mvstore.Cursor.next(Cursor.java:50) at org.h2.mvstore.MVMap$2$1.next(MVMap.java:879) at org.h2.mvstore.MVMap$2$1.next(MVMap.java:870) at org.h2.tools.Recover.dumpLobMaps(Recover.java:701) at org.h2.tools.Recover.dumpMVStoreFile(Recover.java:603) at org.h2.tools.Recover.process(Recover.java:345) at org.h2.tools.Recover.runTool(Recover.java:196) at org.h2.tools.Recover.main(Recover.java:159) Picked up JAVA_TOOL_OPTIONS: -Djava.vendor="Sun Microsystems Inc." I cannot provide an example of a corrupted database, since I cannot reproduce the issue, and the data we manage is really sensitive... Do you have an idea what will be the cause of these crashes ? How it is possible to recover these databases ? Any pointer or insight would be greatly appreciated, Thanks -- 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 h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.