[DERBY-4589] Corrupted database prevents startup and should be automatically repaired perhaps

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.5.3.0
• Fix Version/s: 10.8.1.2, 10.9.1.0
• Component/s: Store
• Environment: Windows 2000, SP4. J2SE 1.6
• Urgency: Urgent
• Issue & fix info: Repro attached
• Bug behavior facts: Data corruption
• Assignee: Richard N. Hillegas
• Reporter: Jeff Mckenzie
• Created: 18/Mar/10 07:15
• Updated: 17/Jun/13 09:19
• Resolved: 13/Apr/11 13:36

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)

Issue Links

• is blocked by: DERBY-4733 Get error "Failed to create database - directory already exists" when attempting to connect to a database that failed during creation
• relates to: DERBY-4098 ERROR XBM0J: Directory /var/db/sw-abc already exists.
• relates to: DERBY-5526 on upgrade from 10.5 to 10.8.2 , getting ERROR XBM0A: The database directory 'C:\cygwin\home\debugfat\clientdb' exists. However, it does not contain the expected 'service.properties' file.