[
https://issues.apache.org/jira/browse/DERBY-7060?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17002397#comment-17002397
]
Bryan Pendleton commented on DERBY-7060:
----------------------------------------
I am sorry you are having these problems. 10.6 is definitely quite an old
release at this point, so it would certainly be worth investigating whether you
can upgrade. However, I'm not sure that there have been many changes to this
part of the system in a very long time.
A good place for you to start would be if you could review the comments and
discussion in DERBY-6425, which was a more recent issue and one that we never
really got to the bottom of.
There are some excellent suggestions and observations in the DERBY-6425
discussion threads that could give you some ideas about how to narrow down the
problem and perhaps gather more details so that we can get to the bottom of it.
Also, there are some suggestions about system configuration settings you can
experiment with that could perhaps make the problem go away.
> 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)
