[
https://issues.apache.org/jira/browse/DERBY-7060?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17003425#comment-17003425
]
Bryan Pendleton commented on DERBY-7060:
----------------------------------------
Thank you for the follow-up.
Please let us know, after you have had some time to write and run some tests,
what your results are, they will help others who may struggle with this issue
in the future.
> XSDG2 Invalid checksum on Page occurs in 10.6.1.0 version
> ---------------------------------------------------------
>
> Key: DERBY-7060
> URL: https://issues.apache.org/jira/browse/DERBY-7060
> Project: Derby
> Issue Type: Bug
> Components: Network Server
> Affects Versions: 10.6.1.0
> Environment: OS: Linux version 3.0.35.
> java version: Java 1.8.
> framework:Knopflerfish OSGi. equinox 3.5.2.
> Derby Server address: localhost.
> Reporter: motomi inoue
> Priority: Major
> Attachments: derby.log
>
> Original Estimate: 504h
> Remaining Estimate: 504h
>
> 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
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
