org.h2.message.DbException: IO Exception: "java.io.IOException: Error in parsing script, statement size exceeds 1G,

26 Views Asked by At

recently my H2 database of around 24 GB got corrupted. To recover the data i tried using command

java -cp h2*.jar org.h2.tools.Recover

after that a txt file was generated of almost around 9GB.

Now again to convert the txt file to DB file i used the command

java -Xmx24G -cp h2*.jar org.h2.tools.RunScript -url jdbc:h2:~/Desktop/db -user sa -script db.txt

But I'm getting following error

Exception in thread "main" org.h2.message.DbException: IO Exception: "java.io.IOException: Error in parsing script, statement size exceeds 1G, first 80 characters of statement looks like: File E:/dbfile/db.mv.db, 25048920064 bytes, 23888 MB000000000 fileHeader H:2,bl" [90028-200]
        at org.h2.message.DbException.get(DbException.java:194)
        at org.h2.message.DbException.convertIOException(DbException.java:392)
        at org.h2.util.ScriptReader.readStatement(ScriptReader.java:101)
        at org.h2.tools.RunScript.process(RunScript.java:203)
        at org.h2.tools.RunScript.process(RunScript.java:192)
        at org.h2.tools.RunScript.process(RunScript.java:328)
        at org.h2.tools.RunScript.runTool(RunScript.java:143)
        at org.h2.tools.RunScript.main(RunScript.java:70)

How do i solve the issue

0

There are 0 best solutions below