Closed GoogleCodeExporter closed 9 years ago
Sorry, I had to find out while trying to drop the table, that it was corrupted:
An error occurred when executing the SQL command:
DROP TABLE IF EXISTS APP.TBL_LOGS CASCADE
File corrupted while reading record: "wrong checksum". Possible solution: use
the recovery tool; SQL statement:
DROP TABLE IF EXISTS APP.TBL_LOGS CASCADE [90030-169] [SQL State=90030, DB
Errorcode=90030]
Execution time: 0.17s
(Statement 1 of 8 finished)
Script execution finished
Total script execution time: 30.036s
The question remains, how the corruption occurred.
Original comment by Dolland....@gmail.com
on 27 Mar 2015 at 3:27
Hi,
This looks like a corrupt database. To recover the data, use the tool
org.h2.tools.Recover to create the SQL script file, and then re-create the
database using this script.
This is a relatively old version of H2, version 1.3.169 from 2012-09-09. This
issue is already fixed now (see the change log for details). So I set this
issue as "works for me".
Original comment by thomas.t...@gmail.com
on 29 Mar 2015 at 6:27
Hi Thomas,
which issue you mean is already fixed? The issue that H2 responds with an
ArrayIndexOutOfBoundsException to a corrupt table (for this case: how it is
reacting now?), or the issue, that the table was corrupted? Is there a general
strategy to prevent this?
Original comment by Dolland....@gmail.com
on 30 Mar 2015 at 3:01
Hi,
which issue you mean is already fixed?
This issue is fixed in a newer version of H2.
Is there a general strategy to prevent this?
Yes, upgrade to a more recent version of H2. But usually, you should also have
backups of the database file.
Regards,
Thomas
Original comment by thomas.t...@gmail.com
on 10 Apr 2015 at 5:47
Original issue reported on code.google.com by
Dolland....@gmail.com
on 27 Mar 2015 at 12:38