db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Binoy Thomas" <binoy.tho...@sphere.ae>
Subject DB gets corrupts in 10.3.1.2!!
Date Mon, 28 Apr 2008 10:09:55 GMT

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





Mime
View raw message