[
https://issues.apache.org/jira/browse/DERBY-5739?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13463506#comment-13463506
]
Arunagiri commented on DERBY-5739:
----------------------------------
Hi,
Thanks for your earlier responses. I would like to know how can I prevent this
as this happens randomly in few clients? Will upgrading to latest help?
The following is the error trace happened in one of the client recently.
2012.09.25 16:51:50.852 [ERROR] DerbyDBDeployer:warmup(61) - db warm up failed
org.apache.commons.dbcp.SQLNestedException: Cannot create
PoolableConnectionFactory (Failed to start database 'runtime' with class loader
sun.misc.Launcher$AppClassLoader@35ce36, see the next exception for details.)
at
org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225)
~[commons-dbcp-1.2.2.jar:1.2.2]
.
.
... 3 common frames omitted
Caused by: org.apache.derby.impl.jdbc.EmbedSQLException: Failed to start
database 'runtime' with class loader sun.misc.Launcher$AppClassLoader@35ce36,
see the next exception for details.
at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
~[derby-10.6.1.0.jar:na]
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown
Source) ~[derby-10.6.1.0.jar:na]
... 17 common frames omitted
Caused by: org.apache.derby.impl.jdbc.EmbedSQLException: Invalid checksum on
Page Page(0,Container(0, 1328)), expected=150,019,028, on-disk
version=1,050,525,858, page dump follows: Hex dump:
00000000: 0076 0000 0001 0000 0000 0000 00a2 0000 .v...........ᄁ..
00000010: 0000 0006 0000 0000 0000 0000 0000 0000 ................
00000020: 0000 0000 0001 0000 0578 5474 0000 0000 .........xTt....
00000030: 0000 0000 0000 0000 0000 0000 ffff ffff ................
00000040: ffff ffff 0000 0000 0000 0000 0000 0000 ................
00000050: 0000 0000 0000 0000 0000 0000 0000 0000 ................
00000060: 0000 0000 0000 0000 0000 0000 5000 0000 ............P...
00000070: 0000 0000 0000 0000 0000 0000 0000 0000 ................
00000080: 0000 0000 0000 0000 0000 0000 0000 0000 ................
00000090: 0000 0000 0000 0000 0000 0000 0000 0000 ................
000000a0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
000000b0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
000000c0: 0000 0080 0000 0000 0000 0000 0100 0000 ...タ............
.
.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
~[derby-10.6.1.0.jar:na]
at org.apache.derby.impl.store.raw.data.StoredPage.validateChecksum(Unknown
Source) ~[derby-10.6.1.0.jar:na]
at org.apache.derby.impl.store.raw.data.StoredPage.initFromData(Unknown Source)
~[derby-10.6.1.0.jar:na]
at org.apache.derby.impl.store.raw.data.AllocPage.initFromData(Unknown Source)
~[derby-10.6.1.0.jar:na]
at org.apache.derby.impl.store.raw.data.CachedPage.setIdentity(Unknown Source)
~[derby-10.6.1.0.jar:na]
at org.apache.derby.impl.store.raw.data.CachedPage.setIdentity(Unknown Source)
~[derby-10.6.1.0.jar:na]
at org.apache.derby.impl.services.cache.ConcurrentCache.find(Unknown Source)
~[derby-10.6.1.0.jar:na]
> database will not boot, encountering a checksum error on one of the pages
> -------------------------------------------------------------------------
>
> Key: DERBY-5739
> URL: https://issues.apache.org/jira/browse/DERBY-5739
> Project: Derby
> Issue Type: Bug
> Components: Store
> Affects Versions: 10.6.1.0
> Environment: Windows 7 and Ubuntu Linux
> Reporter: Arunagiri
> Labels: derby_triage10_10
> Attachments: derby.log
>
>
> Cannot able to connect database.
> ------------ BEGIN SHUTDOWN ERROR STACK -------------
> ERROR XSDG2: Invalid checksum on Page Page(0,Container(0, 1424)),
> expected=3,663,358,272, on-disk version=2,621,194,794, page dump follows: Hex
> dump:
> 00000000: 0076 0000 0001 0000 0000 0000 004d 0000 .v...........M..
> 00000010: 0000 0006 0000 0000 0000 0000 0000 0000 ................
> 00000020: 0000 0000 0001 0000 ccfd 3287 0000 0000 ........ᅩ.2ヌ....
> 00000030: 0000 0000 0000 0000 0000 0000 ffff ffff ................
> 00000040: ffff ffff 0000 0000 0000 0000 0000 0000 ................
> 00000050: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 00000060: 0000 0000 0000 0000 0000 0000 5000 0000 ............P...
> 00000070: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 00000080: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 00000090: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 000000a0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 000000b0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 000000c0: 0000 0080 0000 0000 0000 0000 0100 0000 ...タ............
> 000000d0: 0000 0152 9000 0000 4c30 0000 0000 0000 ...Rミ...L0......
> 000000e0: 5000 0000 0000 0000 0000 0000 0000 0000 P...............
> 000000f0: 0000 0000 0000 0000 5000 0000 0000 0000 ........P.......
> 00000100: 0000 0000 0000 5000 0000 0000 0000 0000 ......P.........
> 00000110: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 00000120: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> and the trace ends with
> 00007fc0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 00007fd0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 00007fe0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 00007ff0: 0000 0000 0000 0000 0000 0000 9c3c 422a ............ワ.B.
> 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.getAnyPage(Unknown Source)
> at
> org.apache.derby.impl.store.raw.data.BaseContainer.getAnyPage(Unknown Source)
> at
> org.apache.derby.impl.store.raw.data.BaseContainerHandle.getAnyPage(Unknown
> Source)
> at
> org.apache.derby.impl.store.raw.data.PageBasicOperation.findpage(Unknown
> Source)
> at
> org.apache.derby.impl.store.raw.data.PageBasicOperation.needsRedo(Unknown
> Source)
> at org.apache.derby.impl.store.raw.log.FileLogger.redo(Unknown Source)
> at org.apache.derby.impl.store.raw.log.LogToFile.recover(Unknown Source)
> at org.apache.derby.impl.store.raw.RawStore.boot(Unknown Source)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown
> Source)
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira