I have a 9gig database file that was open when my Linux machine crashed and rebooted and now I get the following when I try to load the database:
[error] Caused by: java.lang.IllegalStateException: File corrupted in chunk 1550574, expected page length 4..1024, got 1852517937 [1.4.191/6] [error] at org.h2.mvstore.DataUtils.newIllegalStateException(DataUtils.java:773) [error] at org.h2.mvstore.Page.read(Page.java:649) [error] at org.h2.mvstore.Page.read(Page.java:195) [error] at org.h2.mvstore.MVStore.readPage(MVStore.java:1939) [error] at org.h2.mvstore.MVMap.readPage(MVMap.java:736) [error] at org.h2.mvstore.Page.getChildPage(Page.java:217) [error] at org.h2.mvstore.MVMap.binarySearch(MVMap.java:468) [error] at org.h2.mvstore.MVMap.binarySearch(MVMap.java:469) [error] at org.h2.mvstore.MVMap.binarySearch(MVMap.java:469) [error] at org.h2.mvstore.MVMap.get(MVMap.java:450) [error] at org.h2.mvstore.MVStore.getChunkIfFound(MVStore.java:954) [error] at org.h2.mvstore.MVStore.getChunk(MVStore.java:931) [error] at org.h2.mvstore.MVStore.readPage(MVStore.java:1930) [error] at org.h2.mvstore.MVMap.readPage(MVMap.java:736) I have run `Recover` but it also crashes with this: [info] 2016.03.03 08:54:40:629 [main] ERROR t.n.c.NaboCloud$.main:38 - java.lang.IllegalStateException: File corrupted in chunk 1550574, expected page length 4..1024, got 1852517937 [1.4.191/6] [info] at org.h2.mvstore.DataUtils.newIllegalStateException(DataUtils.java:773) [info] at org.h2.mvstore.Page.read(Page.java:649) [info] at org.h2.mvstore.Page.read(Page.java:195) [info] at org.h2.mvstore.MVStore.readPage(MVStore.java:1939) [info] at org.h2.mvstore.MVMap.readPage(MVMap.java:736) [info] at org.h2.mvstore.Page.getChildPage(Page.java:217) [info] at org.h2.mvstore.MVMap.binarySearch(MVMap.java:468) [info] at org.h2.mvstore.MVMap.binarySearch(MVMap.java:469) [info] at org.h2.mvstore.MVMap.binarySearch(MVMap.java:469) [info] at org.h2.mvstore.MVMap.get(MVMap.java:450) [info] at org.h2.mvstore.MVStore.getChunkIfFound(MVStore.java:954) [info] at org.h2.mvstore.MVStore.getChunk(MVStore.java:931) [info] at org.h2.mvstore.MVStore.readPage(MVStore.java:1930) [info] at org.h2.mvstore.MVMap.readPage(MVMap.java:736) [info] at org.h2.mvstore.Page.getChildPage(Page.java:217) Is there anything I can do to recover the data? I've been using H2 in production systems because it's faster than other SQL databases, but if it's this easy to corrupt and lose data then I'm going to have to re-think that. Any insights would be greatly appreciated. Thanks, Matt Hicks OUTR Technologies, LLC -- 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.
