You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-user@db.apache.org by Shankar Devi <sh...@sasken.com> on 2010/02/10 12:08:47 UTC
ERROR XSDG2: Invalid checksum on Page Page(0,Container(0, 1216)).
Hi,
I have an intensive data-processing application which utilises Apache Derby
version - 10.3.1.4.
My Customer is running this application on Windows 2003 and has 30GB derby
database size.
Customer has reported the following error.
ERROR XSDG2: Invalid checksum on Page Page(0,Container(0, 1216)).
After that application is crashing with
java.sql.SQLTransientConnectionException: No current connection error.
I have looked into event logs and no hard disk issue has reported. Each time
application is failing at page 1216.
This issue is similar with http://issues.apache.org/jira/browse/DERBY-3611 &
http://www.nabble.com/ERROR-XSDG2%3A-Invalid-checksum-on-Page-Page%280%2CContainer%280%2C-1313%29%29-td16389697.html.
I have asked the customer to try with Apache Derby - 10.5.3.0 with old derby
database. Still Customer is getting the same error.
Table referred in derby.log is
CREATE TABLE cfgdata_property(
objKey INT,
versionID BIGINT DEFAULT 0,
viewID INT DEFAULT 0,
objData BLOB(2M),
CONSTRAINT kvk_cfgdata_property Foreign Key (objKey, versionID)
REFERENCES cfgdata_objects(objKey, versionID) ON DELETE CASCADE);
Herewith I have attached both derby.log file(10.3.1.4 & 10.5.3.0).
Please let me know which is causing the issue.
Thanks & Regards,
Devi
--
View this message in context: http://old.nabble.com/ERROR-XSDG2%3A-Invalid-checksum-on-Page-Page%280%2CContainer%280%2C-1216%29%29.-tp27528119p27528119.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.
Re: ERROR XSDG2: Invalid checksum on Page Page(0,Container(0, 1216)).
Posted by Knut Anders Hatlen <Kn...@Sun.COM>.
Shankar Devi <sh...@sasken.com> writes:
> Hi,
> I have an intensive data-processing application which utilises Apache Derby
> version - 10.3.1.4.
> My Customer is running this application on Windows 2003 and has 30GB derby
> database size.
> Customer has reported the following error.
>
> ERROR XSDG2: Invalid checksum on Page Page(0,Container(0, 1216)).
Hi Devi,
I suspect you've been hit by a data corruption bug present in Derby
10.3.1.4 and 10.3.2.1: https://issues.apache.org/jira/browse/DERBY-3347
You'll have to recover the database from backup and upgrade to a Derby
version that does not have this bug (10.3.3.0 or later).
Hope this helps,
--
Knut Anders
Re: ERROR XSDG2: Invalid checksum on Page Page(0,Container(0,
1216)).
Posted by Shankar Devi <sh...@sasken.com>.
Attached my derby.log
Due to size, I have cut down the Hex code.
----------------------------------------------------------------
2010-02-05 18:15:45.867 GMT:
Booting Derby version The Apache Software Foundation - Apache Derby -
10.5.3.0 - (802917): instance a816c00e-0126-9f58-3b28-000001c83860
on database directory G:\Nortel\ddb
Database Class Loader started - derby.database.classpath=''
------------ BEGIN SHUTDOWN ERROR STACK -------------
ERROR XSDG2: Invalid checksum on Page Page(0,Container(0, 1216)),
expected=2,123,489,974, on-disk version=4,195,712,410, page dump follows:
Hex dump:
00000000: 0076 0000 0001 0000 0000 0000 52f8 0000 .v..........R...
00000010: 0000 0006 0000 0000 0000 0000 0000 0000 ................
00001fe0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
00001ff0: 0000 0000 0000 0000 0000 0000 fa15 7d9a ...............?
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.AllocPage.initFromData(Unknown
Source)
at org.apache.derby.impl.store.raw.data.CachedPage.setIdentity(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.getAllocPage(Unknown
Source)
at org.apache.derby.impl.store.raw.data.BaseContainer.getAllocPage(Unknown
Source)
at
org.apache.derby.impl.store.raw.data.BaseContainerHandle.getAllocPage(Unknown
Source)
at org.apache.derby.impl.store.raw.data.AllocationCache.validate(Unknown
Source)
at
org.apache.derby.impl.store.raw.data.AllocationCache.getLastPageNumber(Unknown
Source)
at org.apache.derby.impl.store.raw.data.FileContainer.pageValid(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.access.heap.HeapConglomerateFactory.readConglomerate(Unknown
Source)
at
org.apache.derby.impl.store.access.RAMAccessManager.conglomCacheFind(Unknown
Source)
at
org.apache.derby.impl.store.access.RAMTransaction.findExistingConglomerate(Unknown
Source)
at org.apache.derby.impl.store.access.RAMTransaction.openStoreCost(Unknown
Source)
at
org.apache.derby.impl.sql.compile.CompilerContextImpl.getStoreCostController(Unknown
Source)
at
org.apache.derby.impl.sql.compile.FromBaseTable.getStoreCostController(Unknown
Source)
at org.apache.derby.impl.sql.compile.FromBaseTable.estimateCost(Unknown
Source)
at
org.apache.derby.impl.sql.compile.OptimizerImpl.estimateTotalCost(Unknown
Source)
at
org.apache.derby.impl.sql.compile.OptimizerImpl.costBasedCostOptimizable(Unknown
Source)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costOptimizable(Unknown
Source)
at org.apache.derby.impl.sql.compile.FromBaseTable.optimizeIt(Unknown
Source)
at org.apache.derby.impl.sql.compile.ProjectRestrictNode.optimizeIt(Unknown
Source)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(Unknown
Source)
at org.apache.derby.impl.sql.compile.SelectNode.optimize(Unknown Source)
at
org.apache.derby.impl.sql.compile.DMLStatementNode.optimizeStatement(Unknown
Source)
at org.apache.derby.impl.sql.compile.CursorNode.optimizeStatement(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.EmbedPreparedStatement20.<init>(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement40.<init>(Unknown
Source)
at org.apache.derby.jdbc.Driver40.newEmbedPreparedStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown
Source)
at com.netsation.configurator.server.DerbyStorage.getObject(Unknown Source)
at com.netsation.configurator.server.DerbyStorage.getPropertySet(Unknown
Source)
at
com.netsation.configurator.common.StorageMechanism.loadPropertySet(Unknown
Source)
at
com.netsation.configurator.common.StorageMechanism.loadPropertySet(Unknown
Source)
at
com.netsation.configurator.server.LowLevelServices.loadPropertySet(Unknown
Source)
at
com.netsation.configurator.server.PropertySetService.loadPropertySet(Unknown
Source)
at
com.netsation.configurator.server.PropertySetService.getPropertySet(Unknown
Source)
at com.netsation.configurator.server.CConfigurable.getPropertySet(Unknown
Source)
at
com.netsation.configurator.server.NsConfigurationServer.do_GET_PROPERTY_SET(Unknown
Source)
at com.netsation.configurator.server.NsConfigurationServer.receive(Unknown
Source)
at
com.netsation.configurator.server.NsConfigurationClientProxyThread.receive(Unknown
Source)
at com.netsation.net.NsClientProxyThread.run(Unknown Source)
------------ END SHUTDOWN ERROR STACK -------------
2010-02-05 18:25:40.433 GMT 10.130.36.51:2349 (XID = 7295339074), (SESSIONID
= 49), (DATABASE = ddb), (DRDAID = null), Cleanup action starting
2010-02-05 18:25:40.433 GMT 10.130.36.51:2349 (XID = 7295339074), (SESSIONID
= 49), (DATABASE = ddb), (DRDAID = null), Failed Statement is: select
viewid, objdata from cfgdata_property where objkey = ? and versionid = ?
ERROR XSDG2: Invalid checksum on Page Page(0,Container(0, 1216)),
expected=2,123,489,974, on-disk version=4,195,712,410, page dump follows:
Hex dump:
00000000: 0076 0000 0001 0000 0000 0000 52f8 0000 .v..........R...
00000010: 0000 0006 0000 0000 0000 0000 0000 0000 ................
00000020: 0000 0000 0001 0000 0000 0000 0000 0000 ................
00000030: 0000 0000 0000 0000 0000 0000 0000 0000 ................
00000040: 0000 5291 0000 0000 0000 5291 0000 0000 ..R?......R?....
00000050: 0000 0000 0000 0000 0000 0000 0000 0000 ................
00001f50: 0000 0000 0000 0000 0000 0000 0000 0000 ................
00001f60: 0000 0000 0000 0000 0000 0000 0000 0000 ................
00001f70: 0000 0000 0000 0000 0000 0000 0000 0000 ................
00001f80: 0000 0000 0000 0000 0000 0000 0000 0000 ................
00001f90: 0000 0000 0000 0000 0000 0000 0000 0000 ................
00001fa0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
00001fb0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
00001fc0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
00001fd0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
00001fe0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
00001ff0: 0000 0000 0000 0000 0000 0000 fa15 7d9a ...............?
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.AllocPage.initFromData(Unknown
Source)
at org.apache.derby.impl.store.raw.data.CachedPage.setIdentity(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.getAllocPage(Unknown
Source)
at org.apache.derby.impl.store.raw.data.BaseContainer.getAllocPage(Unknown
Source)
at
org.apache.derby.impl.store.raw.data.BaseContainerHandle.getAllocPage(Unknown
Source)
at org.apache.derby.impl.store.raw.data.AllocationCache.validate(Unknown
Source)
at
org.apache.derby.impl.store.raw.data.AllocationCache.getLastPageNumber(Unknown
Source)
at org.apache.derby.impl.store.raw.data.FileContainer.pageValid(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.access.heap.HeapConglomerateFactory.readConglomerate(Unknown
Source)
at
org.apache.derby.impl.store.access.RAMAccessManager.conglomCacheFind(Unknown
Source)
at
org.apache.derby.impl.store.access.RAMTransaction.findExistingConglomerate(Unknown
Source)
at org.apache.derby.impl.store.access.RAMTransaction.openStoreCost(Unknown
Source)
at
org.apache.derby.impl.sql.compile.CompilerContextImpl.getStoreCostController(Unknown
Source)
at
org.apache.derby.impl.sql.compile.FromBaseTable.getStoreCostController(Unknown
Source)
at org.apache.derby.impl.sql.compile.FromBaseTable.estimateCost(Unknown
Source)
at
org.apache.derby.impl.sql.compile.OptimizerImpl.estimateTotalCost(Unknown
Source)
at
org.apache.derby.impl.sql.compile.OptimizerImpl.costBasedCostOptimizable(Unknown
Source)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costOptimizable(Unknown
Source)
at org.apache.derby.impl.sql.compile.FromBaseTable.optimizeIt(Unknown
Source)
at org.apache.derby.impl.sql.compile.ProjectRestrictNode.optimizeIt(Unknown
Source)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(Unknown
Source)
at org.apache.derby.impl.sql.compile.SelectNode.optimize(Unknown Source)
at
org.apache.derby.impl.sql.compile.DMLStatementNode.optimizeStatement(Unknown
Source)
at org.apache.derby.impl.sql.compile.CursorNode.optimizeStatement(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.EmbedPreparedStatement20.<init>(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement40.<init>(Unknown
Source)
at org.apache.derby.jdbc.Driver40.newEmbedPreparedStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown
Source)
at com.netsation.configurator.server.DerbyStorage.getObject(Unknown Source)
at com.netsation.configurator.server.DerbyStorage.getPropertySet(Unknown
Source)
at
com.netsation.configurator.common.StorageMechanism.loadPropertySet(Unknown
Source)
at
com.netsation.configurator.common.StorageMechanism.loadPropertySet(Unknown
Source)
at
com.netsation.configurator.server.LowLevelServices.loadPropertySet(Unknown
Source)
at
com.netsation.configurator.server.PropertySetService.loadPropertySet(Unknown
Source)
at
com.netsation.configurator.server.PropertySetService.getPropertySet(Unknown
Source)
at com.netsation.configurator.server.CConfigurable.getPropertySet(Unknown
Source)
at
com.netsation.configurator.server.NsConfigurationServer.do_GET_PROPERTY_SET(Unknown
Source)
at com.netsation.configurator.server.NsConfigurationServer.receive(Unknown
Source)
at
com.netsation.configurator.server.NsConfigurationClientProxyThread.receive(Unknown
Source)
at com.netsation.net.NsClientProxyThread.run(Unknown Source)
2010-02-05 18:25:40.433 GMT:
Shutting down instance a816c00e-0126-9f58-3b28-000001c83860
----------------------------------------------------------------
Cleanup action completed
----------------------------------------------------------------
--
View this message in context: http://old.nabble.com/ERROR-XSDG2%3A-Invalid-checksum-on-Page-Page%280%2CContainer%280%2C-1216%29%29.-tp27528119p27528678.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.