Problem with H2 database recovery

[aje....@googlemail.com]

Hi,

I have a problem with the recovery of an corrupted H2 database.

When I use the recovery tool like it is described, I get the following error:

Exception in thread "main" java.lang.IllegalStateException: Illegal page length

-1335449 reading at 21762201; file size 20426752  [1.4.179/6]

        at org.h2.mvstore.DataUtils.newIllegalStateException(DataUtils.java:756)

        at org.h2.mvstore.Page.read(Page.java:189)

        at org.h2.mvstore.MVStore.readPage(MVStore.java:1866)

        at org.h2.mvstore.MVMap.readPage(MVMap.java:751)

        at org.h2.mvstore.Page.getChildPage(Page.java:221)

        at org.h2.mvstore.MVMap.binarySearch(MVMap.java:446)

        at org.h2.mvstore.MVMap.get(MVMap.java:428)

        at org.h2.mvstore.MVStore.getChunkIfFound(MVStore.java:830)

        at org.h2.mvstore.MVStore.getChunk(MVStore.java:811)

        at org.h2.mvstore.MVStore.readPage(MVStore.java:1858)

        at org.h2.mvstore.MVMap.readPage(MVMap.java:751)

        at org.h2.mvstore.Page.getChildPage(Page.java:221)

        at org.h2.mvstore.Cursor.min(Cursor.java:129)

        at org.h2.mvstore.Cursor.hasNext(Cursor.java:36)

        at org.h2.mvstore.MVStore.readFileHeader(MVStore.java:637)

        at org.h2.mvstore.MVStore.<init>(MVStore.java:303)

        at org.h2.mvstore.MVStore$Builder.open(MVStore.java:2739)

        at org.h2.tools.Recover.dumpMVStoreFile(Recover.java:585)

        at org.h2.tools.Recover.process(Recover.java:326)

        at org.h2.tools.Recover.runTool(Recover.java:192)

        at org.h2.tools.Recover.main(Recover.java:155)

[Noel Grandin]

Yeah, sometimes the recovery tool just can't do anything.