[
https://issues.apache.org/jira/browse/DERBY-7060?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17386990#comment-17386990
]
masami yoshida commented on DERBY-7060:
---------------------------------------
We are sorry that we have not been able to respond to this inquiry.
This problem has recurred, so let me ask you again.
Previously, when an Invalid checksum occurred, it was recovered by restarting
the system(Derby) and then disappeared.
However, this time, even if the system is restarted, the Invalid checksum
occurs repeatedly.
When I insert record into a certain table, the Invalid checksum occurs.
However, after rebooting the system, all the tables are normal and the Invalid
checksum does not appear.
It seems to recover when I run Compress. Do you think Compress is effective in
resolving this issue?
> 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)
