Hi everyone,

 

I have been using an embedded setup of derby (version 10.4.1.3) for quite some time.  It appears that my database has become corrupt for some reason, possibly related to https://issues.apache.org/jira/browse/DERBY-3725

 

Stacktrace

java.sql.SQLException: Unknown page format at page Page(257,Container(0, 432592))

      at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)

      at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)

      at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source)

      at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown 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.EmbedResultSet.closeOnTransactionError(Unknown Source)

      at org.apache.derby.impl.jdbc.EmbedResultSet.movePosition(Unknown Source)

      at org.apache.derby.impl.jdbc.EmbedResultSet.next(Unknown Source)

      at com.linoma.derby.corrupt.Derby.verifyDatabase(Derby.java:108)

      at com.linoma.derby.corrupt.DerbyMain.main(DerbyMain.java:17)

Caused by: java.sql.SQLException: No class was registered for identifier 0.

      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(Unknown Source)

      ... 9 more

Caused by: ERROR XBM0U: No class was registered for identifier 0.

      at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)

      at org.apache.derby.impl.services.monitor.BaseMonitor.classFromIdentifier(Unknown Source)

      at org.apache.derby.impl.services.monitor.BaseMonitor.newInstanceFromIdentifier(Unknown Source)

      at org.apache.derby.iapi.services.monitor.Monitor.newInstanceFromIdentifier(Unknown Source)

      at org.apache.derby.impl.store.raw.data.CachedPage.changeInstanceTo(Unknown Source)

      at org.apache.derby.impl.store.raw.data.CachedPage.setIdentity(Unknown Source)

      at org.apache.derby.impl.services.cache.ConcurrentCache.find(Unknown Source)

      at org.apache.derby.impl.store.raw.data.FileContainer.getUserPage(Unknown Source)

      at org.apache.derby.impl.store.raw.data.FileContainer.getNextHeadPage(Unknown Source)

      at org.apache.derby.impl.store.raw.data.BaseContainer.getNextPage(Unknown Source)

      at org.apache.derby.impl.store.raw.data.BaseContainerHandle.getNextPage(Unknown Source)

      at org.apache.derby.impl.store.access.conglomerate.GenericScanController.positionAtNextPage(Unknown Source)

      at org.apache.derby.impl.store.access.conglomerate.GenericScanController.fetchRows(Unknown Source)

      at org.apache.derby.impl.store.access.heap.HeapScan.next(Unknown Source)

      at org.apache.derby.iapi.db.ConsistencyChecker.checkTable(Unknown Source)

      at org.apache.derby.catalog.SystemProcedures.SYSCS_CHECK_TABLE(Unknown Source)

      at org.apache.derby.exe.acf81e0010x0129xb2c4xb230x00000015ed900.e5(Unknown Source)

      at org.apache.derby.impl.services.reflect.DirectCall.invoke(Unknown Source)

      at org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.doProjection(Unknown Source)

      at org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.getNextRowCore(Unknown Source)

      at org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.getNextRow(Unknown Source)

      ... 4 more

 

Is there any way to tell for sure if this issue is related to DERBY-3725?  If so, and I upgrade the database, is there a way to repair the existing database?  Is there any additional information I can provide to give further insight?

 

Thank you,

 

ERICK J. LICHTAS

Linoma Software

Software Engineer

p. 402.944.4242 x714

f. 402.944.4243

www.LinomaSoftware.com

www.GoAnywheremft.com

 



__________ Information from ESET NOD32 Antivirus, version of virus signature database 5262 (20100708) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com