[DERBY-5739] database will not boot, encountering a checksum error on one of the pages

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 10.6.1.0
• Component/s: Store
• Labels: derby_triage10_10
• Environment: Windows 7 and Ubuntu Linux
• Urgency: Normal
• Bug behavior facts: Data corruption, Seen in production
• Assignee: Unassigned
• Reporter: Arunagiri
• Created: 03/May/12 09:01
• Updated: 01/Jul/13 20:02

Description

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)