[
https://issues.apache.org/jira/browse/DERBY-5739?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13697114#comment-13697114
]
Kathey Marsden edited comment on DERBY-5739 at 7/1/13 8:02 PM:
---------------------------------------------------------------
Sorry your question was missed.
For partial writes of this nature due to a power down one work around that
might help is to use pageSize of 4096.
See: http://db.apache.org/derby/docs/10.10/ref/rrefproper40688.html
Unfortunately, you have to set this property before creating the table or index.
Another thing to consider is using roll-forward recovery in your backup/restore
strategy so that you can recover from a failure like this.
https://builds.apache.org/job/Derby-docs/lastSuccessfulBuild/artifact/trunk/out/adminguide/cadminrollforward.html
was (Author: kmarsden):
Sorry your question was missed.
For partial writes of this nature due to a power down one work around that
might work is to use pageSize of 4K.
> 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
