You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "motomi inoue (Jira)" <ji...@apache.org> on 2019/12/23 07:59:00 UTC
[jira] [Updated] (DERBY-7060) XSDG2 Invalid checksum on Page occurs
in 10.6.1.0 version
[ https://issues.apache.org/jira/browse/DERBY-7060?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
motomi inoue updated DERBY-7060:
--------------------------------
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
was:
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?
------
> 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)