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

XSDG2 Invalid checksum on Page occurs in 10.6.1.0 version

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 10.6.1.0
    • Fix Version/s: None
    • Component/s: Network Server
    • Labels:
      None
    • Environment:
      OS: Linux version 3.0.35.
      java version: Java 1.8.
      framework:Knopflerfish OSGi. equinox 3.5.2.
      Derby Server address: localhost.
    • Urgency:
      Urgent

      Description

      Our products use Derby 10.6.1.0.
      Our products have experienced three similar symptoms to the known issue DERBY-3611.
      Once it occurs, then The [Cleanup action starting] log appears multiple times, but the phenomenon does not recover.
      We looked at the dump and found nothing wrong.
      It works fine after restarting Derby. with same data.
      The derby.log when an error occurs is as follows.
      (I omit the folder path and the contents of the dump.)

      Is this an issue that has already been fixed?
      If so, what version should I update to?

      ------
      2019-09-21 19:17:34.500 GMT : Apache Derby Network Server - 10.6.1.0 - (938214) started and ready to accept connections on port 1527
      ----------------------------------------------------------------
      2019-09-21 19:17:35.391 GMT:
      Booting Derby version The Apache Software Foundation - Apache Derby - 10.6.1.0 - (938214): instance a816c00e-016d-5542-0890-00004542b78a
      on database directory (Omit directory path.) with class loader org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader@10ad4ff[org.apache.derby.libraries:10.6.1.0(id=60)]

      Database Class Loader started - derby.database.classpath=''

      ------------ BEGIN SHUTDOWN ERROR STACK -------------

      ERROR XSDG2: Invalid checksum on Page Page(9,Container(0, 3280)), expected=1,738,070,319, on-disk version=1,221,251,861, page dump follows: Hex dump:
      (Omit the dump data.)

      at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
      at org.apache.derby.impl.store.raw.data.StoredPage.validateChecksum(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.getUserPage(Unknown Source)
      at org.apache.derby.impl.store.raw.data.FileContainer.getPage(Unknown Source)
      at org.apache.derby.impl.store.raw.data.BaseContainerHandle.getPage(Unknown Source)
      at org.apache.derby.impl.store.raw.data.OverflowInputStream.fillByteHolder(Unknown Source)
      at org.apache.derby.impl.store.raw.data.BufferedByteHolderInputStream.read(Unknown Source)
      at java.io.DataInputStream.read(Unknown Source)
      at org.apache.derby.iapi.types.SQLClob.getStreamWithDescriptor(Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedClob.<init>(Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedResultSet.getClob(Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedResultSet.getObject(Unknown Source)
      at org.apache.derby.impl.drda.DRDAConnThread.getObjectForWriteFdoca(Unknown Source)
      at org.apache.derby.impl.drda.DRDAConnThread.writeFDODTA(Unknown Source)
      at org.apache.derby.impl.drda.DRDAConnThread.writeQRYDTA(Unknown Source)
      at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown Source)
      at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source)

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

      2019-10-25 06:54:18.082 GMT Thread[DRDAConnThread_40,5,derby.daemons] (XID = 23029299), (SESSIONID = 10761), (DATABASE = mdm), (DRDAID = NF000001.DA33-868348731172564756

      {5379}), Cleanup action starting
      2019-10-25 06:54:18.083 GMT Thread[DRDAConnThread_40,5,derby.daemons] (XID = 23029299), (SESSIONID = 10761), (DATABASE = mdm), (DRDAID = NF000001.DA33-868348731172564756{5379}

      ), Failed Statement is: call SYSIBM.SQLCAMESSAGE(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
      java.lang.NullPointerException
      at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openContainer(Unknown Source)
      at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openContainer(Unknown Source)
      at org.apache.derby.impl.store.raw.xact.Xact.openContainer(Unknown Source)
      at org.apache.derby.impl.store.access.conglomerate.OpenConglomerate.init(Unknown Source)
      at org.apache.derby.impl.store.access.heap.Heap.open(Unknown Source)
      at org.apache.derby.impl.store.access.RAMTransaction.openConglomerate(Unknown Source)
      at org.apache.derby.impl.store.access.RAMTransaction.openConglomerate(Unknown Source)
      at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.getDescriptorViaIndexMinion(Unknown Source)
      at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.getDescriptorViaIndex(Unknown Source)
      at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.getAliasDescriptor(Unknown Source)
      at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.getRoutineList(Unknown Source)
      at org.apache.derby.impl.sql.compile.StaticMethodCallNode.resolveRoutine(Unknown Source)
      at org.apache.derby.impl.sql.compile.StaticMethodCallNode.bindExpression(Unknown Source)
      at org.apache.derby.impl.sql.compile.JavaToSQLValueNode.bindExpression(Unknown Source)
      at org.apache.derby.impl.sql.compile.CallStatementNode.bindStatement(Unknown Source)
      at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
      at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
      at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedCallableStatement.<init>(Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedCallableStatement20.<init>(Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedCallableStatement30.<init>(Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedCallableStatement40.<init>(Unknown Source)
      at org.apache.derby.jdbc.Driver40.newEmbedCallableStatement(Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedConnection.prepareCall(Unknown Source)
      at org.apache.derby.impl.drda.DRDAStatement.prepare(Unknown Source)
      at org.apache.derby.impl.drda.DRDAStatement.explicitPrepare(Unknown Source)
      at org.apache.derby.impl.drda.DRDAConnThread.parsePRPSQLSTT(Unknown Source)
      at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown Source)
      at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source)
      Cleanup action completed

       

        Attachments

        1. derby.log
          13 kB
          motomi inoue

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              minoue motomi inoue
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:

                Time Tracking

                Estimated:
                Original Estimate - 504h
                504h
                Remaining:
                Remaining Estimate - 504h
                504h
                Logged:
                Time Spent - Not Specified
                Not Specified