You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Kathey Marsden (JIRA)" <de...@db.apache.org> on 2006/08/05 00:00:13 UTC
[jira] Created: (DERBY-1648) Create a tool for database recovery
Create a tool for database recovery
-----------------------------------
Key: DERBY-1648
URL: http://issues.apache.org/jira/browse/DERBY-1648
Project: Derby
Issue Type: New Feature
Components: Tools
Affects Versions: 10.1.3.1
Reporter: Kathey Marsden
If a Derby database is corrupted by dual boot or for some other reason, it is really necessary to create a new database and transfer the data. Currently there is not a utility to do this.
It would be good to have a tool which given a corrupted database would attempt to recover it by creating a new database and transferring the data while preserving the state of the original corrupted db.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Updated: (DERBY-1648) Create a tool for salvaging data from
a database that will not boot.
Posted by "Kathey Marsden (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1648?page=all ]
Kathey Marsden updated DERBY-1648:
----------------------------------
Summary: Create a tool for salvaging data from a database that will not boot. (was: Create a tool for database recovery)
Description:
If a Derby database is corrupted by dual boot or for some other reason, it is really necessary to create a new database and transfer the data. Currently there is not a utility to do this.
It would be good to have a tool which given a corrupted database would attempt to salvage the data it can by creating a new database and transferring the data while preserving the state of the original corrupted db for analysis
was:
If a Derby database is corrupted by dual boot or for some other reason, it is really necessary to create a new database and transfer the data. Currently there is not a utility to do this.
It would be good to have a tool which given a corrupted database would attempt to recover it by creating a new database and transferring the data while preserving the state of the original corrupted db.
Mike suggested I change the the title of this issue to accurately reflect that the data cannot be fully recovered. Only some of it may be salvagable and it is useful sometimes to do so if users do not back up as they should.
> Create a tool for salvaging data from a database that will not boot.
> ----------------------------------------------------------------------
>
> Key: DERBY-1648
> URL: http://issues.apache.org/jira/browse/DERBY-1648
> Project: Derby
> Issue Type: New Feature
> Components: Tools
> Affects Versions: 10.1.3.1
> Reporter: Kathey Marsden
>
> If a Derby database is corrupted by dual boot or for some other reason, it is really necessary to create a new database and transfer the data. Currently there is not a utility to do this.
> It would be good to have a tool which given a corrupted database would attempt to salvage the data it can by creating a new database and transferring the data while preserving the state of the original corrupted db for analysis
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Updated: (DERBY-1648) Create a tool for salvaging data from
a database that will not boot.
Posted by "David Sitsky (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-1648?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
David Sitsky updated DERBY-1648:
--------------------------------
Attachment: derby.txt
Here is the patch to the code which I used successfully to fix a corrupted Derby database. In this instance, I was lucky, the corruption was on a single page, that was just used by an index, so there was no data loss.
> Create a tool for salvaging data from a database that will not boot.
> --------------------------------------------------------------------
>
> Key: DERBY-1648
> URL: https://issues.apache.org/jira/browse/DERBY-1648
> Project: Derby
> Issue Type: New Feature
> Components: Tools
> Affects Versions: 10.1.3.1
> Reporter: Kathey Marsden
> Attachments: derby.txt
>
>
> If a Derby database is corrupted by dual boot or for some other reason, it is really necessary to create a new database and transfer the data. Currently there is not a utility to do this.
> It would be good to have a tool which given a corrupted database would attempt to salvage the data it can by creating a new database and transferring the data while preserving the state of the original corrupted db for analysis
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-1648) Create a tool for salvaging data
from a database that will not boot.
Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-1648?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12718934#action_12718934 ]
Kathey Marsden commented on DERBY-1648:
---------------------------------------
There was a thread on derby-user with a proposed alternate solution to this problem which might recover more data and in a more consistent state. The idea is to provide a property which allows users to skip problematic log records so they can boot and then drop the offending index or table.
http://www.nabble.com/Repairing-a-corrupted-database-with-invalid-checksum-on-page-td23956934.html#a23956934
> Create a tool for salvaging data from a database that will not boot.
> --------------------------------------------------------------------
>
> Key: DERBY-1648
> URL: https://issues.apache.org/jira/browse/DERBY-1648
> Project: Derby
> Issue Type: New Feature
> Components: Tools
> Affects Versions: 10.1.3.1
> Reporter: Kathey Marsden
>
> If a Derby database is corrupted by dual boot or for some other reason, it is really necessary to create a new database and transfer the data. Currently there is not a utility to do this.
> It would be good to have a tool which given a corrupted database would attempt to salvage the data it can by creating a new database and transferring the data while preserving the state of the original corrupted db for analysis
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.