Derby
  1. Derby
  2. DERBY-6136

Create a custom/optional tool for dumping the data in a corrupted database.

    Details

    • Type: Improvement Improvement
    • Status: Open
    • Priority: Major Major
    • Resolution: Unresolved
    • Affects Version/s: 10.11.1.1
    • Fix Version/s: None
    • Component/s: Tools
    • Labels:
      None
    • Urgency:
      Normal

      Description

      It would be useful to have a tool for dumping the data in a corrupted database. This could start out as a custom tool. After we debug the tool and get some experience with it, we can consider promoting it to be a (possibly undocumented) optional tool which we ship with the product. I think the tool should have the following behavior:

      1) The tool should not subvert the security of the corrupted database. If the corrupted database is password-protected, then you would need to present its DBO's credentials in order to use the tool. Naturally, an encryption key would have to be presented in order to decode an encrypted database.

      2) The tool should not stop reading a table when it hits a corrupt record. Instead, the tool should soldier on and collect a list of warnings on bad records.

      Such a tool would be useful in situations where some part of a heap table is corrupt but the following heap conglomerates are intact:

      i) SYSSCHEMAS
      ii) SYSTABLES
      iii) SYSCONGLOMERATES
      iv) SYSCOLUMNS
      v) property conglomerate

      Such a tool would be useful for some situations where data can't be dumped even after you delete the log files in order to short-circuit recovery.

      1. DataFileVTI.java
        59 kB
        Rick Hillegas
      2. DataFileVTI.java
        59 kB
        Rick Hillegas
      3. DataFileVTI.java
        63 kB
        Rick Hillegas
      4. DataFileVTI.java
        58 kB
        Rick Hillegas
      5. DataFileVTI.java
        57 kB
        Rick Hillegas
      6. dataFileVTI.sql
        4 kB
        Rick Hillegas
      7. DerbyRecovery-0.0.1-SNAPSHOT.jar
        29 kB
        José Arcángel Salazar Delgado
      8. RawDBReader.java
        22 kB
        Rick Hillegas
      9. RawDBReader.java
        22 kB
        Rick Hillegas

        Issue Links

          Activity

          Rick Hillegas created issue -
          Rick Hillegas made changes -
          Field Original Value New Value
          Link This issue relates to DERBY-5201 [ DERBY-5201 ]
          Rick Hillegas made changes -
          Attachment DataFileVTI.java [ 12576422 ]
          Attachment dataFileVTI.sql [ 12576423 ]
          Rick Hillegas made changes -
          Attachment RawDBReader.java [ 12576427 ]
          Rick Hillegas made changes -
          Attachment DataFileVTI.java [ 12576586 ]
          Attachment RawDBReader.java [ 12576587 ]
          Rick Hillegas made changes -
          Attachment DataFileVTI.java [ 12576991 ]
          Rick Hillegas made changes -
          Link This issue is related to DERBY-6151 [ DERBY-6151 ]
          Rick Hillegas made changes -
          Attachment DataFileVTI.java [ 12577216 ]
          Rick Hillegas made changes -
          Attachment DataFileVTI.java [ 12577218 ]
          Gavin made changes -
          Workflow jira [ 12774565 ] Default workflow, editable Closed status [ 12802445 ]
          José Arcángel Salazar Delgado made changes -
          Attachment DerbyRecovery-0.0.1-SNAPSHOT.jar [ 12704132 ]

            People

            • Assignee:
              Unassigned
              Reporter:
              Rick Hillegas
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:

                Development