H2 1.4.200 - Unable to Recover 90030 File corrupted while reading record

[Richard Tan]

Hi all.

Version 1.4.200

We had an issue with our database where the database got corrupted. If you try to open it, you get the error 90030.

The database is around 500MB.

We copied the database with the issue into a folder and then run

java -cp /some/location/h2-1.4.200.jar org.h2.tools.Recover

This creates two files

dbname.h2.sql

dbname.mv.txt

The SQL file is 32Kb, and the TXT file is 50MB

Then I run the below command to create a new DB based on the recover tool

java -cp /some/location/h2-1.4.200.jar org.h2.tools.RunScript -url jdbc:h2./newdbname -user user -password password -script dbname.h2.sql -showResults -continueOnError -checkResults

I do get a new DB created without errors, but it is only 16Kb in size. When you connect to it, it does not have the schema that was based on my original corrupted DB. It seems like an shell DB..

As the Recover tool gives a txt file as well, I did use this but you get errors

A small sample of the sql and txt file are shown below. The SQL file seems to have meta data to chunks??

Is there something wrong with the way I am trying to recover this DB. Also as it spits out two files, do the two files need to be merge in anyway. What is the purpose of the two files.

SQL file:

-- MVStore

CREATE ALIAS IF NOT EXISTS READ_BLOB FOR "org.h2.tools.Recover.readBlob";

CREATE ALIAS IF NOT EXISTS READ_CLOB FOR "org.h2.tools.Recover.readClob";

CREATE ALIAS IF NOT EXISTS READ_BLOB_DB FOR "org.h2.tools.Recover.readBlobDb";

CREATE ALIAS IF NOT EXISTS READ_CLOB_DB FOR "org.h2.tools.Recover.readClobDb";

CREATE ALIAS IF NOT EXISTS READ_BLOB_MAP FOR "org.h2.tools.Recover.readBlobMap";

CREATE ALIAS IF NOT EXISTS READ_CLOB_MAP FOR "org.h2.tools.Recover.readClobMap";

-- Meta

-- chunk.1ebb3c = chunk:1ebb3c,block:74fb,len:38f,liveMax:417c80,livePages:261,map:210,max:4229e0,pages:2bd,root:7aecf000e2ba90d,time:e2827c48,unusedAtVersion:1edc49,version:1ebb3c,pinCount:0

-- chunk.1ebb3d = chunk:1ebb3d,block:2f97,len:334,liveMax:303600,livePages:20c,map:210,max:3ce220,pages:2d6,root:7aecf400cc1628d,time:e2827dd5,unusedAtVersion:1ee7ed,version:1ebb3d,pinCount:0

-- chunk.1ebb98 = chunk:1ebb98,block:bf7d,len:38e,liveMax:f3000,livePages:89,map:210,max:434a30,pages:295,root:7aee6000e25894b,time:e283e74b,unusedAtVersion:1ee7ed,version:1ebb98,pinCount:0

-- chunk.1ebb9b = chunk:1ebb9b,block:9715,len:21c,liveMax:292880,livePages:15d,map:210,max:29ada0,pages:197,root:7aee6c00861a74b,time:e283e844,unusedAtVersion:1ebc7a,version:1ebb9b,pinCount:0

..

..

-- Tables

---- Schema SET ----

---- Table Data ----

---- Schema ----

DROP ALIAS READ_BLOB;

DROP ALIAS READ_CLOB;

DROP ALIAS READ_BLOB_DB;

DROP ALIAS READ_CLOB_DB;

DROP ALIAS READ_BLOB_MAP;

DROP ALIAS READ_CLOB_MAP;

DROP TABLE IF EXISTS INFORMATION_SCHEMA.LOB_BLOCKS;

Text File

File /home2/username/somedir/dbname.mv.db, 539852800 bytes, 514 MB

00000000 fileHeader H:2,block:33f2,blockSize:1000,chunk:1f03ed,created:18591915411,format:1,version:1f03ed,fletcher:9fe6a76f

00001000 fileHeader H:2,block:33f2,blockSize:1000,chunk:1f03ed,created:18591915411,format:1,version:1f03ed,fletcher:9fe6a76f

 

00002000 chunkHeader chunk:1f030e,block:2,len:8,map:210,max:8e00,next:c,pages:33,root:7c0c380000e354b,time:e3ac526b,version:1f030e,pinCount:0

+000000c5 node, map 4, 5 entries, 81 bytes, maxLen 60

    265 children @ chunk 1f02a0 +00002313

    1614 children @ chunk 1f02a0 +0000407b

    2182 children @ chunk 1f02a0 +0000e6c8

    72729 children @ chunk 1f0309 +00000116

    202682 children @ chunk 1f030e +00000116

+00000116 node, map 4, 29 entries, 439 bytes, maxLen 200

    6694 children @ chunk 1f02ee +00000ac6

    7001 children @ chunk 1f02ee +00001ab2

    6811 children @ chunk 1f02ee +00003938

    6947 children @ chunk 1f02ee +00020e73