Malformed database disk image file - storage.db3

[Moondawgie]

I noticed that one of the newsgroups which I'm subscribed to with Newsbin (Version 6.73B4 Build 4817) wasn't showing posts for the last 7 days. Being one of the most active newsgroups I suspected that there was a problem, and used the SQLite3 "Pragma integrity_check" command to check that's newsgroup's Newsbin database files. The StorageData.db3 file checked okay, but the Storage.db3 file drew the error of "database disk image is malformed".

The output was as follows:

Code: Select all

*** in database main ***
Page 62339: btreeInitPage() returns error code 11
On tree page 62164 cell 318: Child page depth differs
Page 62341: btreeInitPage() returns error code 11
Page 62344: btreeInitPage() returns error code 11
Page 62346: btreeInitPage() returns error code 11
Page 62349: btreeInitPage() returns error code 11
On tree page 62164 cell 323: invalid page number 62352
On tree page 62164 cell 324: invalid page number 62353
On page 62164 at right child: invalid page number 62355
Page 62342: btreeInitPage() returns error code 11
On tree page 28759 cell 72: Child page depth differs
On tree page 28759 cell 73: invalid page number 62351
On tree page 28759 cell 74: Child page depth differs
Page 62343: btreeInitPage() returns error code 11
Page 62336: btreeInitPage() returns error code 11
On tree page 58649 cell 447: Child page depth differs
Page 62345: btreeInitPage() returns error code 11
On page 58649 at right child: invalid page number 62350
Page 62347: btreeInitPage() returns error code 11
Page 62340: btreeInitPage() returns error code 11
On tree page 39691 cell 21: Child page depth differs
On tree page 39691 cell 22: Child page depth differs
Page 62337: btreeInitPage() returns error code 11
On tree page 11087 cell 65: Child page depth differs
On tree page 11087 cell 66: Child page depth differs
Page 62348: btreeInitPage() returns error code 11
On tree page 53634 cell 29: Child page depth differs
On tree page 53634 cell 30: Child page depth differs
On tree page 51222 cell 46: invalid page number 62356
On tree page 51222 cell 46: Child page depth differs
On tree page 51222 cell 47: Child page depth differs
On tree page 9745 cell 14: invalid page number 62354
On tree page 9745 cell 14: Child page depth differs
On tree page 9745 cell 15: Child page depth differs
Page 62338: btreeInitPage() returns error code 11
On tree page 20195 cell 44: Child page depth differs
On tree page 20195 cell 45: Child page depth differs
Error: database disk image is malformed


Can the damaged Storage.db3 file be repaired or recreated, or must I delete all of that newsgroup's files, and download headers from scratch?

If the Storage.db3 file can be repaired or recreated, how would I do so?

Thank you.

[Quade]

It's toast. I don't believe it can be repaired. You might be able to "dump" is and get some of the data out of it. You're better off just downloading headers.

if you just purge and set a shortish "download age" you won't have to download that much.

[Moondawgie]

Darn it!

Thank you.