db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From EagleS <...@silvereagle.co.uk>
Subject deleting a corrupted database with invalid checksum on page
Date Mon, 10 Mar 2014 08:14:43 GMT
Hi,

I have a database table POS_RESOURCES.RESOURCES that has been corrupted.
There is a Mirror file to this so easy to recreate it but I am unable to
delete it due to the corruption.

Whatever I try and do to the table I get them same result of:

SQLState:  08006
ErrorCode: 40000
Error: DERBY SQL error: SQLCODE: -1, SQLSTATE: XSDG2, SQLERRMC: Invalid
checksum on Page Page(0,Container(0, 474144)), expected=229,350,622, on-disk
version=1,888,684,690, page dump follows: Hex dump:
00000000: 0076 0000 0001 0000 0000 0000 93b4 0000  .v..........モᄡ..
00000010: 0000 0006 0000 0000 0000 0000 0000 0000  ................
00000020: 0000 0000 0001 0000 0000 0000 0000 0000  ................
And the hex dump continues for ages.

What can I do to just delete this table and then rebuild it from the Mirror
file? 

Thanks.



--
View this message in context: http://apache-database.10148.n7.nabble.com/deleting-a-corrupted-database-with-invalid-checksum-on-page-tp137773.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.

Mime
View raw message