DB corruption & db_dump db_load errors
558087Apr 6 2007 — edited Apr 13 2007Hi,
I ran db_verify and I saw :
db_verify: Page 191914: incorrect next_pgno 191918 found in leaf chain (should be 191917)
db_verify: Page 191917: incorrect prev_pgno 191918 found in leaf chain (should be 191914)
db_verify: Page 191917: incorrect next_pgno 191920 found in leaf chain (should be 191918)
db_verify: Page 191918: incorrect prev_pgno 191914 found in leaf chain (should be 191917)
db_verify: Page 191917: linked twice
db_verify: Page 163979: item 4 has incorrect record count of 6, should be 5
db_verify: Page 384: item 30 has incorrect record count of 441, should be 442
db_verify: Page 384: item 36 has incorrect record count of 195, should be 194
db_verify: Page 384: bad record count: has 16235 records, claims 16234
db_verify: Page 163388: item 11 has incorrect record count of 234, should be 233
db_verify: Page 479: item 24 has incorrect record count of 446, should be 447
db_verify: Page 479: item 29 has incorrect record count of 74, should be 73
db_verify: Page 479: bad record count: has 12672 records, claims 12671
db_verify: Page 175444: item 3 has incorrect record count of 270, should be 269
db_verify: Page 175079: item 3 has incorrect record count of 272, should be 271
db_verify: Page 486: item 20 has incorrect record count of 449, should be 448
db_verify: Page 486: item 25 has incorrect record count of 84, should be 83
db_verify: Page 486: bad record count: has 11274 records, claims 11275
db_verify: Page 174041: item 7 has incorrect record count of 362, should be 360
db_verify: Page 252: item 186 has incorrect record count of 195, should be 193
db_verify: /opt/db/db/title: DB_VERIFY_BAD: Database verification failed
Then I ran db_dump and db_load to try to fix the problem, and I got:
db_load: Duplicate data items are not supported with sorted data
db_load: /opt/db/db/title: line 166757: key already exists, not loaded:
5a016d626c6f78656d695f6d6f
db_load: Duplicate data items are not supported with sorted data
db_load: /opt/db/db/title: line 333629: key already exists, not loaded:
8a3b3c6d626c6f78656d695f6d6f
db_load: Duplicate data items are not supported with sorted data
db_load: /opt/db/db/title: line 831421: key already exists, not loaded:
8a3d3e6d626c6f78656d695f6d6f
db_load: Duplicate data items are not supported with sorted data
db_load: /opt/db/db/title: line 1717085: key already exists, not loaded:
8a41366d626c6f78656d695f6d6f746578742f786d6c
db_load: Duplicate data items are not supported with sorted data
db_load: /opt/db/db/title: line 1845979: key already exists, not loaded:
8a423e6d626c6f78656d695f6d6f
db_load: Duplicate data items are not supported with sorted data
db_load: /opt/db/db/title: line 2536487: key already exists, not loaded: 92353673797374656d406e6176696f2e636f6d
db_load: Duplicate data items are not supported with sorted data
db_load: /opt/db/db/title: line 2701395: key already exists, not loaded:
92443666616c7365
Above are the errors I’ve never seen before. Besides, the size of the title file after db_load was about 1/3 less. Does that mean loss of data (or it's actually ok and good to use)? Could anyone explain and help me to solve the problem? What are the ways to fix corrupted DB?
Thanks
Agnes