Hello, today one of my dbs failed to connect and presented the following error message:
*Unable to obtain connection from database (jdbc:h2:file:C:\Users\Username\.appfiles\db\appdb) for user 'sa': File corrupted while reading record: null. Possible solution: use the recovery tool [90030-200]* *---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------* *SQL State : 90030* *Error Code : 90030* *Message : File corrupted while reading record: null. Possible solution: use the recovery tool [90030-200]* As suggested I tried to use the recover tool as instructed by the documentation, the steps I executed were the following: 1. Go to your h2 data file directory 2. java -cp h2-1.4.200.jar org.h2.tools.Recover 3. Use SQL file generated by the recovery tool to recreate the database The steps created two files, a .sql and a .txt file, but the SQL generated by the tool didn't have any data or DDL from the database, just some aliases and a bunch of comments. This is the sql output: https://pastebin.com/DFfwPemP This is the txt output: https://pastebin.com/6zwCgqN3 Is there any step I'm not doing right or is any other thing I can try to recover the db? Any suggestion is welcome. Thanks! -- 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/68303db0-4681-477d-9475-0865b4491010n%40googlegroups.com.
