[DERBY-5659] Database corrupted after delete operation - results in sqlcode XSDB2

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Cannot Reproduce
• Affects Version/s: 10.6.1.0
• Component/s: Store
• Labels: corruption derby_triage10_10 xsdb2
• Environment: Windows 7 32 bit
• Urgency: Normal
• Bug behavior facts: Crash, Data corruption
• Assignee: Unassigned
• Reporter: ratish ram
• Created: 15/Mar/12 14:23
• Updated: 16/Jan/13 20:18
• Resolved: 16/Jan/13 20:18

Description

Derby Embedded Database became non-accessible after a delete operation. Trying to connect to the database now results in the following exception.

Caused by: org.apache.derby.client.am.SqlException: DERBY SQL error: SQLCODE: -1, SQLSTATE: XJ040, SQLERRMC: Failed to start database 'XXXX' with class loader org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader@73983ad7, see the next exception for details.::SQLSTATE: XSDB2Unknown container format at container null : 1,702,392,933
at org.apache.derby.client.am.Connection.completeSqlca(Unknown Source)
at org.apache.derby.client.net.NetConnectionReply.parseRdbAccessFailed(Unknown Source)
at org.apache.derby.client.net.NetConnectionReply.parseAccessRdbError(Unknown Source)
at org.apache.derby.client.net.NetConnectionReply.parseACCRDBreply(Unknown Source)
at org.apache.derby.client.net.NetConnectionReply.readAccessDatabase(Unknown Source)
at org.apache.derby.client.net.NetConnection.readSecurityCheckAndAccessRdb(Unknown Source)
at org.apache.derby.client.net.NetConnection.flowSecurityCheckAndAccessRdb(Unknown Source)
at org.apache.derby.client.net.NetConnection.flowUSRIDPWDconnect(Unknown Source)
at org.apache.derby.client.net.NetConnection.flowConnect(Unknown Source)
at org.apache.derby.client.net.NetConnection.<init>(Unknown Source)
at org.apache.derby.client.net.NetConnection40.<init>(Unknown Source)
at org.apache.derby.client.net.ClientJDBCObjectFactoryImpl40.newNetConnection(Unknown Source)
... 52 more