You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-user@db.apache.org by EagleS <jo...@silvereagle.co.uk> on 2014/03/10 09:14:43 UTC
deleting a corrupted database with invalid checksum on page
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.
Re: deleting a corrupted database with invalid checksum on page
Posted by Myrna van Lunteren <m....@gmail.com>.
Perhaps there is something that can help you on this page:
https://wiki.apache.org/db-derby/DatabaseCorruption
HTH
Myrna
On Mon, Mar 10, 2014 at 8:18 AM, EagleS <jo...@silvereagle.co.uk> wrote:
> I can't do rename table either unfortunately. Whatever query I try to run
> I get the same error and hex dump.
>
> ----- Reply message -----
> From: "Bryan Pendleton-3 [via Apache Database]" <[hidden email]<http://user/SendEmail.jtp?type=node&node=137791&i=0>
> >
> To: "EagleS" <[hidden email]<http://user/SendEmail.jtp?type=node&node=137791&i=1>
> >
> Subject: deleting a corrupted database with invalid checksum on page
> Date: Mon, Mar 10, 2014 14:55
>
> > What can I do to just delete this table and then rebuild it from the
> Mirror
> > file?
>
> Can you use RENAME TABLE?
>
> Then you can create your new table with the old name, and just
> leave that old, damaged table around.
>
> Of course, you'll want to arrange a more long-term solution,
> but that might get you back on your feet again while you
> build a more solid overall plan.
>
> bryan
>
>
>
> ------------------------------
> If you reply to this email, your message will be added to the discussion
> below:
>
> http://apache-database.10148.n7.nabble.com/deleting-a-corrupted-database-with-invalid-checksum-on-page-tp137773p137789.html
> To unsubscribe from deleting a corrupted database with invalid checksum
> on page, click here.
> NAML<http://apache-database.10148.n7.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>
>
> ------------------------------
> View this message in context: Re: deleting a corrupted database with
> invalid checksum on page<http://apache-database.10148.n7.nabble.com/deleting-a-corrupted-database-with-invalid-checksum-on-page-tp137773p137791.html>
>
> Sent from the Apache Derby Users mailing list archive<http://apache-database.10148.n7.nabble.com/Apache-Derby-Users-f95095.html>at Nabble.com.
>
Re: deleting a corrupted database with invalid checksum on page
Posted by EagleS <jo...@silvereagle.co.uk>.
I can't do rename table either unfortunately. Whatever query I try to run I get the same error and hex dump.
----- Reply message -----
From: "Bryan Pendleton-3 [via Apache Database]" <ml...@n7.nabble.com>
To: "EagleS" <jo...@silvereagle.co.uk>
Subject: deleting a corrupted database with invalid checksum on page
Date: Mon, Mar 10, 2014 14:55
> What can I do to just delete this table and then rebuild it from the Mirror
> file?
Can you use RENAME TABLE?
Then you can create your new table with the old name, and just
leave that old, damaged table around.
Of course, you'll want to arrange a more long-term solution,
but that might get you back on your feet again while you
build a more solid overall plan.
bryan
If you reply to this email, your message will be added to the discussion below:
http://apache-database.10148.n7.nabble.com/deleting-a-corrupted-database-with-invalid-checksum-on-page-tp137773p137789.html
To unsubscribe from deleting a corrupted database with invalid checksum on page, click here.
NAML
--
View this message in context: http://apache-database.10148.n7.nabble.com/deleting-a-corrupted-database-with-invalid-checksum-on-page-tp137773p137791.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.
Re: deleting a corrupted database with invalid checksum on page
Posted by Bryan Pendleton <bp...@gmail.com>.
> What can I do to just delete this table and then rebuild it from the Mirror
> file?
Can you use RENAME TABLE?
Then you can create your new table with the old name, and just
leave that old, damaged table around.
Of course, you'll want to arrange a more long-term solution,
but that might get you back on your feet again while you
build a more solid overall plan.
bryan