Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-4894

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

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Cannot Reproduce
    • Affects Version/s: 10.5.3.0
    • Fix Version/s: None
    • Component/s: Store
    • Labels:
      None
    • Bug behavior facts:
      Crash, Data corruption

      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.

        Attachments

        1. derbywtrunk.log
          398 kB
          Katherine Marsden
        2. derby4894_diff.txt
          4 kB
          Mike Matrigali

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                kmarsden Katherine Marsden
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: