Please help resolve the issue of H2 database file corruption caused by abnormal power outage

75 views
Skip to first unread message
Message has been deleted

Thompson Hollis

unread,
Jul 7, 2025, 11:45:13 AMJul 7
to h2-da...@googlegroups.com
Due to abnormal power outage, the h2 database file was damaged, and the exception prompt is:
java.lang.IllegalStateException: File corrupted in chunk 1546880 not found [1.4.200/9] [50000-200] HY000/50000

Try using:java -cp h2-1.4.200.jar org.h2.tools.Recover

 The damaged database file is 640MB, and the generated SQL file is only 15KB. Then run:

 java -cp h2-1.4.200.jar org.h2.tools.RunScript -url jdbc:h2:./snsdba -user sns -password sns -   script snsdb.h2.sql
     
 The generated snsdba.db file is only 16KB, which is why I need to know how to fix my database file.

     Thank you very much!!!
Reply all
Reply to author
Forward
0 new messages