db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Arunagiri (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DERBY-5739) database will not boot, encountering a checksum error on one of the pages
Date Wed, 26 Sep 2012 04:28:08 GMT

    [ 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

Mime
View raw message