Derby
  1. Derby
  2. DERBY-4589

Corrupted database prevents startup and should be automatically repaired perhaps

    Details

    • Type: Improvement Improvement
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 10.5.3.0
    • Fix Version/s: 10.8.1.2, 10.9.1.0
    • Component/s: Store
    • Labels:
      None
    • Environment:
      Windows 2000, SP4. J2SE 1.6
    • Urgency:
      Urgent
    • Issue & fix info:
      Repro attached
    • Bug behavior facts:
      Data corruption

      Description

      I have found a database in my application that prevents startup due to it being corrupted.
      The driver reports that the database does not exist, even though it does. Then when my app tries to create the database using ;create=true; on the URL it fails.

      I think this happened due to the app being killed in Task Manager while it was creating the database.

      I have the database saved so that you can reproduce the problem. (I'm not sure if I can attach it yet)

      1. 2010-03.zip
        12 kB
        Jeff Mckenzie
      2. Test_4589.java
        2 kB
        Rick Hillegas
      3. Test_4589.java
        2 kB
        Rick Hillegas
      4. derby-4589-01-ab-missingServiceProperties.diff
        10 kB
        Rick Hillegas
      5. derby-4589-01-ac-missingServiceProperties.diff
        11 kB
        Rick Hillegas

        Issue Links

          Activity

          Jeff Mckenzie created issue -
          Jeff Mckenzie made changes -
          Field Original Value New Value
          Attachment 2010-03.zip [ 12439128 ]
          Rick Hillegas made changes -
          Link This issue relates to DERBY-4098 [ DERBY-4098 ]
          Mike Matrigali made changes -
          Component/s Store [ 11412 ]
          Rick Hillegas made changes -
          Attachment Test_4589.java [ 12476129 ]
          Rick Hillegas made changes -
          Issue & fix info [Repro attached]
          Rick Hillegas made changes -
          Attachment Test_4589.java [ 12476132 ]
          Rick Hillegas made changes -
          Link This issue is blocked by DERBY-4733 [ DERBY-4733 ]
          Rick Hillegas made changes -
          Rick Hillegas made changes -
          Issue & fix info [Repro attached] [Patch Available, Repro attached]
          Rick Hillegas made changes -
          Rick Hillegas made changes -
          Assignee Rick Hillegas [ rhillegas ]
          Rick Hillegas made changes -
          Status Open [ 1 ] Resolved [ 5 ]
          Issue & fix info [Repro attached, Patch Available] [Repro attached]
          Fix Version/s 10.8.1.2 [ 12316362 ]
          Fix Version/s 10.9.0.0 [ 12316344 ]
          Resolution Fixed [ 1 ]
          Kathey Marsden made changes -
          Link This issue relates to DERBY-5526 [ DERBY-5526 ]
          Knut Anders Hatlen made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Gavin made changes -
          Workflow jira [ 12502191 ] Default workflow, editable Closed status [ 12802691 ]

            People

            • Assignee:
              Rick Hillegas
              Reporter:
              Jeff Mckenzie
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development