We are a firm having multiple software products & we use the Derby DB in all our suite of products for quite many years now. We are facing a blocker situation that is halting all our release process.
Any help would be appreciated on the below DB corruption error. Derby versions tried: Derby 10.3.1.2 & 10.4.1.3 User scenario is: Our base application runs 2 Derby DBs. Another application (which is part of the suite of products) as per deployment strategy would need to be installed on top of it. In this process of installation, the installer first brings down the base application (thereby the DBs are shutdown), installs the 2nd application & then brings up the base application as well as the other application. (Internal process while re-starting application: DBs from the base application are brought up & then the DB from the 2nd application is brought up.) The DB gets corrupted then. Below is the error: java.sql.SQLException: Invalid checksum on Page Page(0,Container(0, 2033)), expected=2,731,401,932, on-disk version=2,375,776,513, page dump follows: Hex dump: 00000000: 0076 0000 0001 0000 0000 0000 0002 0000 .v.............. 00000010: 0000 0006 0000 0000 0000 0000 0000 0000 ................ 00000020: 0000 0000 0001 0000 0000 0000 0000 0000 ................ 00000030: 0000 0000 0000 0000 0000 0000 ffff ffff ................ 00000040: ffff ffff 0000 0000 0000 0000 0000 0000 ................ 00000050: 0000 0000 0000 0000 0000 0000 0000 0000 ................ 00000060: 0000 0000 0000 0000 0000 0000 5000 0000 ............P... at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknow n Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedCallableStatement.executeStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.execute(Unknown Source) at com.mchange.v2.c3p0.impl.NewProxyCallableStatement.execute(NewProxyCallableS tatement.java:3044) at ae.sphere.arena.database.management.backup.BackupStategy.createBackup(Backup Stategy.java:56) at ae.sphere.arena.database.management.backup.BackupStategy.doSchedulerJob(Back upStategy.java:41) at ae.sphere.arena.common.jobscheduler.Scheduler$1.run(Scheduler.java:49) at org.eclipse.core.internal.jobs.Worker.run(Worker.java:58) 00000070: 0000 0000 0000 0000 0000 0000 0000 0000 ................ 00000080: 0000 0000 0000 0000 0000 0000 0000 0000 ................ 00000090: 0000 0000 0000 0000 0000 0000 0000 0000 ................ 000000a0: 0000 0000 0000 0000 0000 0000 0000 0000 ................ 000000b0: 0000 0 Thanks & regards, Binoy
