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: 4 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: : 0076 0001 93b4 .v..モᄡ.. 0010: 0006 0020: 0001 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
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
Re: deleting a corrupted database with invalid checksum on page
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]" To: "EagleS" 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
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 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. >