[DERBY-4894] Database corrupt with ERROR XSDB0: Unexpected exception on in-memory page Page(103,Container(0, 1137))

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Cannot Reproduce
• Affects Version/s: 10.5.3.0
• Component/s: Store
• Bug behavior facts: Crash, Data corruption
• Assignee: Unassigned
• Reporter: Katherine Marsden
• Created: 08/Nov/10 20:19
• Updated: 17/Jun/13 09:19
• Resolved: 03/Feb/11 22:48

Description

I am looking at a user database that is corrupt. The database is in 10.5 format and the stack trace on connect is below.

ERROR XSDB0: Unexpected exception on in-memory page Page(103,Container(0, 1137))

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

at org.apache.derby.impl.store.raw.data.StoredPage.initSlotTable(Unknown Source)

at org.apache.derby.impl.store.raw.data.StoredPage.initFromData(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.getAnyPage(Unknown Source)

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

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

at org.apache.derby.impl.store.raw.data.PageBasicOperation.findpage(Unknown Source)

at org.apache.derby.impl.store.raw.data.PageBasicOperation.needsRedo(Unknown Source)

at org.apache.derby.impl.store.raw.log.FileLogger.redo(Unknown Source)

at org.apache.derby.impl.store.raw.log.LogToFile.recover(Unknown Source)

at org.apache.derby.impl.store.raw.RawStore.boot(Unknown Source)

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

at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source)

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

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

at org.apache.derby.impl.store.access.RAMAccessManager.boot(Unknown Source)

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

at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source)

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

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

at org.apache.derby.impl.db.BasicDatabase.bootStore(Unknown Source)

at org.apache.derby.impl.db.BasicDatabase.boot(Unknown Source)

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

at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source)

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

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

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

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

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

at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknown Source)

at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)

at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown Source)

at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)

at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source)

at java.sql.DriverManager.getConnection(DriverManager.java:322)

at java.sql.DriverManager.getConnection(DriverManager.java:297)

at org.apache.derby.impl.tools.ij.ij.dynamicConnection(Unknown Source)

at org.apache.derby.impl.tools.ij.ij.ConnectStatement(Unknown Source)

at org.apache.derby.impl.tools.ij.ij.ijStatement(Unknown Source)

at org.apache.derby.impl.tools.ij.utilMain.runScriptGuts(Unknown Source)

at org.apache.derby.impl.tools.ij.utilMain.go(Unknown Source)

at org.apache.derby.impl.tools.ij.Main.go(Unknown Source)

at org.apache.derby.impl.tools.ij.Main.mainCore(Unknown Source)

at org.apache.derby.impl.tools.ij.Main.main(Unknown Source)

at org.apache.derby.tools.ij.main(Unknown Source)

------------ END SHUTDOWN ERROR STACK -------------

2010-11-08 19:59:32.965 GMT:
Shutting down instance a816c00e-012c-2d12-7233-000000073238 with class loader sun.misc.Launcher$AppClassLoader@4be14be1

----------------------------------------------------------------

2010-11-08 19:59:32.981 GMT Thread[main,5,main] Cleanup action starting

java.sql.SQLException: Failed to start database 'persistenceDB' with class loader sun.misc.Launcher$AppClassLoader@4be14be1, see the next exception for details.

at org.apache.derby.impl.jdbc.SQLExceptionFactory40.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.EmbedConnection.bootDatabase(Unknown Source)

at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)

at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown Source)

at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)

at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source)

at java.sql.DriverManager.getConnection(DriverManager.java:322)

at java.sql.DriverManager.getConnection(DriverManager.java:297)

at org.apache.derby.impl.tools.ij.ij.dynamicConnection(Unknown Source)

at org.apache.derby.impl.tools.ij.ij.ConnectStatement(Unknown Source)

at org.apache.derby.impl.tools.ij.ij.ijStatement(Unknown Source)

at org.apache.derby.impl.tools.ij.utilMain.runScriptGuts(Unknown Source)

at org.apache.derby.impl.tools.ij.utilMain.go(Unknown Source)

at org.apache.derby.impl.tools.ij.Main.go(Unknown Source)

at org.apache.derby.impl.tools.ij.Main.mainCore(Unknown Source)

at org.apache.derby.impl.tools.ij.Main.main(Unknown Source)

at org.apache.derby.tools.ij.main(Unknown Source)

Caused by: java.sql.SQLException: Failed to start database 'persistenceDB' with class loader sun.misc.Launcher$AppClassLoader@4be14be1, see the next exception for details.

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

at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)

... 19 more

Caused by: java.sql.SQLException: Unexpected exception on in-memory page Page(103,Container(0, 1137))

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

at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)

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

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

... 16 more

Caused by: ERROR XSDB0: Unexpected exception on in-memory page Page(103,Container(0, 1137))

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

at org.apache.derby.impl.store.raw.data.StoredPage.initSlotTable(Unknown Source)

at org.apache.derby.impl.store.raw.data.StoredPage.initFromData(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.getAnyPage(Unknown Source)

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

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

at org.apache.derby.impl.store.raw.data.PageBasicOperation.findpage(Unknown Source)

at org.apache.derby.impl.store.raw.data.PageBasicOperation.needsRedo(Unknown Source)

at org.apache.derby.impl.store.raw.log.FileLogger.redo(Unknown Source)

at org.apache.derby.impl.store.raw.log.LogToFile.recover(Unknown Source)

at org.apache.derby.impl.store.raw.RawStore.boot(Unknown Source)

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

at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source)

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

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

at org.apache.derby.impl.store.access.RAMAccessManager.boot(Unknown Source)

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

at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source)

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

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

at org.apache.derby.impl.db.BasicDatabase.bootStore(Unknown Source)

at org.apache.derby.impl.db.BasicDatabase.boot(Unknown Source)

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

at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source)

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

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

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

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

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

... 16 more

============= begin nested exception, level (1) ===========

java.sql.SQLException: Unexpected exception on in-memory page Page(103,Container(0, 1137))

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

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

at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknown Source)

at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)

at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown Source)

at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)

at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source)

at java.sql.DriverManager.getConnection(DriverManager.java:322)

at java.sql.DriverManager.getConnection(DriverManager.java:297)

at org.apache.derby.impl.tools.ij.ij.dynamicConnection(Unknown Source)

at org.apache.derby.impl.tools.ij.ij.ConnectStatement(Unknown Source)

at org.apache.derby.impl.tools.ij.ij.ijStatement(Unknown Source)

at org.apache.derby.impl.tools.ij.utilMain.runScriptGuts(Unknown Source)

at org.apache.derby.impl.tools.ij.utilMain.go(Unknown Source)

at org.apache.derby.impl.tools.ij.Main.go(Unknown Source)

at org.apache.derby.impl.tools.ij.Main.mainCore(Unknown Source)

at org.apache.derby.impl.tools.ij.Main.main(Unknown Source)

at org.apache.derby.tools.ij.main(Unknown Source)

Caused by: java.sql.SQLException: Unexpected exception on in-memory page Page(103,Container(0, 1137))

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

at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)

... 18 more

Caused by: ERROR XSDB0: Unexpected exception on in-memory page Page(103,Container(0, 1137))

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

at org.apache.derby.impl.store.raw.data.StoredPage.initSlotTable(Unknown Source)

at org.apache.derby.impl.store.raw.data.StoredPage.initFromData(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.getAnyPage(Unknown Source)

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

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

at org.apache.derby.impl.store.raw.data.PageBasicOperation.findpage(Unknown Source)

at org.apache.derby.impl.store.raw.data.PageBasicOperation.needsRedo(Unknown Source)

at org.apache.derby.impl.store.raw.log.FileLogger.redo(Unknown Source)

at org.apache.derby.impl.store.raw.log.LogToFile.recover(Unknown Source)

at org.apache.derby.impl.store.raw.RawStore.boot(Unknown Source)

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

at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source)

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

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

at org.apache.derby.impl.store.access.RAMAccessManager.boot(Unknown Source)

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

at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source)

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

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

at org.apache.derby.impl.db.BasicDatabase.bootStore(Unknown Source)

at org.apache.derby.impl.db.BasicDatabase.boot(Unknown Source)

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

at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source)

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

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

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

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

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

... 16 more

============= end nested exception, level (1) ===========

============= begin nested exception, level (2) ===========

java.sql.SQLException: Unexpected exception on in-memory page Page(103,Container(0, 1137))

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

at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)

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

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

at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknown Source)

at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)

at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown Source)

at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)

at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source)

at java.sql.DriverManager.getConnection(DriverManager.java:322)

at java.sql.DriverManager.getConnection(DriverManager.java:297)

at org.apache.derby.impl.tools.ij.ij.dynamicConnection(Unknown Source)

at org.apache.derby.impl.tools.ij.ij.ConnectStatement(Unknown Source)

at org.apache.derby.impl.tools.ij.ij.ijStatement(Unknown Source)

at org.apache.derby.impl.tools.ij.utilMain.runScriptGuts(Unknown Source)

at org.apache.derby.impl.tools.ij.utilMain.go(Unknown Source)

at org.apache.derby.impl.tools.ij.Main.go(Unknown Source)

at org.apache.derby.impl.tools.ij.Main.mainCore(Unknown Source)

at org.apache.derby.impl.tools.ij.Main.main(Unknown Source)

at org.apache.derby.tools.ij.main(Unknown Source)

Caused by: ERROR XSDB0: Unexpected exception on in-memory page Page(103,Container(0, 1137))

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

at org.apache.derby.impl.store.raw.data.StoredPage.initSlotTable(Unknown Source)

at org.apache.derby.impl.store.raw.data.StoredPage.initFromData(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.getAnyPage(Unknown Source)

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

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

at org.apache.derby.impl.store.raw.data.PageBasicOperation.findpage(Unknown Source)

at org.apache.derby.impl.store.raw.data.PageBasicOperation.needsRedo(Unknown Source)

at org.apache.derby.impl.store.raw.log.FileLogger.redo(Unknown Source)

at org.apache.derby.impl.store.raw.log.LogToFile.recover(Unknown Source)

at org.apache.derby.impl.store.raw.RawStore.boot(Unknown Source)

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

at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source)

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

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

at org.apache.derby.impl.store.access.RAMAccessManager.boot(Unknown Source)

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

at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source)

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

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

at org.apache.derby.impl.db.BasicDatabase.bootStore(Unknown Source)

at org.apache.derby.impl.db.BasicDatabase.boot(Unknown Source)

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

at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source)

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

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

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

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

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

... 16 more

============= end nested exception, level (2) ===========

============= begin nested exception, level (3) ===========

ERROR XSDB0: Unexpected exception on in-memory page Page(103,Container(0, 1137))

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

at org.apache.derby.impl.store.raw.data.StoredPage.initSlotTable(Unknown Source)

at org.apache.derby.impl.store.raw.data.StoredPage.initFromData(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.getAnyPage(Unknown Source)

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

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

at org.apache.derby.impl.store.raw.data.PageBasicOperation.findpage(Unknown Source)

at org.apache.derby.impl.store.raw.data.PageBasicOperation.needsRedo(Unknown Source)

at org.apache.derby.impl.store.raw.log.FileLogger.redo(Unknown Source)

at org.apache.derby.impl.store.raw.log.LogToFile.recover(Unknown Source)

at org.apache.derby.impl.store.raw.RawStore.boot(Unknown Source)

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

at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source)

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

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

at org.apache.derby.impl.store.access.RAMAccessManager.boot(Unknown Source)

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

at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source)

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

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

at org.apache.derby.impl.db.BasicDatabase.bootStore(Unknown Source)

at org.apache.derby.impl.db.BasicDatabase.boot(Unknown Source)

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

at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source)

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

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

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

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

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

at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknown Source)

at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)

at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown Source)

at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)

at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source)

at java.sql.DriverManager.getConnection(DriverManager.java:322)

at java.sql.DriverManager.getConnection(DriverManager.java:297)

at org.apache.derby.impl.tools.ij.ij.dynamicConnection(Unknown Source)

at org.apache.derby.impl.tools.ij.ij.ConnectStatement(Unknown Source)

at org.apache.derby.impl.tools.ij.ij.ijStatement(Unknown Source)

at org.apache.derby.impl.tools.ij.utilMain.runScriptGuts(Unknown Source)

at org.apache.derby.impl.tools.ij.utilMain.go(Unknown Source)

at org.apache.derby.impl.tools.ij.Main.go(Unknown Source)

at org.apache.derby.impl.tools.ij.Main.mainCore(Unknown Source)

at org.apache.derby.impl.tools.ij.Main.main(Unknown Source)

at org.apache.derby.tools.ij.main(Unknown Source)

============= end nested exception, level (3) ===========

Cleanup action completed

Attached also is the derby.log connecting with a trunk sane build and the following properties set:
derby.debug.true=LogTrace
derby.database.allowPreReleaseUpgrade=true
as derbywtrunk.log

That one fails with the assertion:

DEBUG LogTrace OUTPUT: scanned 30061 : Page Operation: Page(103,Container(0, 1137)) pageVersion 424 : Insert : Slot=110 recordId=297 instant = (66,264948) logEnd = (66,265114) logIn at 27 available 123

Exception trace:

org.apache.derby.shared.common.sanity.AssertFailure: ASSERT FAILED

at org.apache.derby.shared.common.sanity.SanityManager.ASSERT(SanityManager.java:98)

at org.apache.derby.impl.store.raw.data.StoredPage.getRecordPortionLength(StoredPage.java:2045)

at org.apache.derby.impl.store.raw.data.StoredPage.initSlotTable(StoredPage.java:2214)

at org.apache.derby.impl.store.raw.data.StoredPage.initFromData(StoredPage.java:780)

at org.apache.derby.impl.store.raw.data.CachedPage.setIdentity(CachedPage.java:210)

at org.apache.derby.impl.services.cache.ConcurrentCache.find(ConcurrentCache.java:295)

at org.apache.derby.impl.store.raw.data.FileContainer.getAnyPage(FileContainer.java:2527)

at org.apache.derby.impl.store.raw.data.BaseContainer.getAnyPage(BaseContainer.java:496)

at org.apache.derby.impl.store.raw.data.BaseContainerHandle.getAnyPage(BaseContainerHandle.java:611)

at org.apache.derby.impl.store.raw.data.PageBasicOperation.findpage(PageBasicOperation.java:304)

at org.apache.derby.impl.store.raw.data.PageBasicOperation.needsRedo(PageBasicOperation.java:160)

at org.apache.derby.impl.store.raw.log.FileLogger.redo(FileLogger.java:1395)

at org.apache.derby.impl.store.raw.log.LogToFile.recover(LogToFile.java:924)

at org.apache.derby.impl.store.raw.RawStore.boot(RawStore.java:339)

Showing that it fails on an entry early in log66.dat and we have a log67.dat to go.
Unfortunately I cannot post the db but just thought I would put this out there in case anyone in the community has ideas.

I am still trying to reconstruct the history with the user. The copy has no date information but as far as I can tell the db was last successfully updated on 10/30 and failed when they tried to connect on 11/10. I was surprised that the database was in 10.5 format as we thought they only just upgraded to 10.5 as part of the support process after encountering the error. The current db copy I have did not preserve the timestamps so am trying to get that too.
The problem occurred as part of a product upgrade (not necessarily a derby upgrade) which first failed due to running out of disk space, but it is not clear it even got to the point of accessing Derby. After making more space available, the user retried the install and got this error.

I am going to try just printing the transaction log to see if the additional records are well formed. Mike said because there are not extensive comments on this assert, probably it has never been hit in the field before. He will add more info to the assert and post a patch to try here.

Issue Links

• relates to: DERBY-5002 In case of checksum error, insure correct error reported to user.