Hi all,

        I?ve got a corrupt SQLite database, and I?m trying to figure out what 
produced the corruption.

        A ?pragma integrity_check? on it yielded the following. Does this trip 
anyone?s ?danger sense? of what may have happened?

        Thank you!

-FG

----------------
SQLite version 3.6.20
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> pragma integrity_check;
*** in database main ***
Page 10628: btreeInitPage() returns error code 11
On tree page 8410 cell 103: Child page depth differs
Page 10656: btreeInitPage() returns error code 11
Page 10686: btreeInitPage() returns error code 11
Page 10718: btreeInitPage() returns error code 11
Page 10641: btreeInitPage() returns error code 11
On tree page 10487 cell 32: Child page depth differs
Page 10683: btreeInitPage() returns error code 11
On page 10487 at right child: invalid page number 10732
Page 10642: btreeInitPage() returns error code 11
On tree page 10489 cell 32: Child page depth differs
Page 10684: btreeInitPage() returns error code 11
On page 10489 at right child: invalid page number 10733
Page 10643: btreeInitPage() returns error code 11
On tree page 10491 cell 32: Child page depth differs
Page 10685: btreeInitPage() returns error code 11
On page 10491 at right child: invalid page number 10734
Page 10640: btreeInitPage() returns error code 11
On tree page 6039 cell 19: Child page depth differs
Page 10691: btreeInitPage() returns error code 11
On tree page 6039 cell 21: Child page depth differs
Page 10692: btreeInitPage() returns error code 11
On tree page 5411 cell 36: Child page depth differs
On tree page 5411 cell 37: Child page depth differs
Page 10606: btreeInitPage() returns error code 11
On tree page 10314 cell 82: Child page depth differs
Page 10607: btreeInitPage() returns error code 11
Page 10614: btreeInitPage() returns error code 11
Page 10616: btreeInitPage() returns error code 11
Page 10621: btreeInitPage() returns error code 11
Page 10627: btreeInitPage() returns error code 11
Page 10629: btreeInitPage() returns error code 11
Page 10634: btreeInitPage() returns error code 11
Page 10639: btreeInitPage() returns error code 11
Page 10645: btreeInitPage() returns error code 11
Page 10649: btreeInitPage() returns error code 11
Page 10652: btreeInitPage() returns error code 11
Page 10657: btreeInitPage() returns error code 11
Page 10662: btreeInitPage() returns error code 11
Page 10664: btreeInitPage() returns error code 11
Page 10669: btreeInitPage() returns error code 11
Page 10673: btreeInitPage() returns error code 11
Page 10675: btreeInitPage() returns error code 11
Page 10680: btreeInitPage() returns error code 11
Page 10690: btreeInitPage() returns error code 11
Page 10694: btreeInitPage() returns error code 11
Page 10699: btreeInitPage() returns error code 11
Page 10701: btreeInitPage() returns error code 11
Page 10705: btreeInitPage() returns error code 11
Page 10710: btreeInitPage() returns error code 11
Page 10712: btreeInitPage() returns error code 11
Page 10716: btreeInitPage() returns error code 11
Page 10723: btreeInitPage() returns error code 11
On tree page 10314 cell 110: invalid page number 10725
On page 10314 at right child: invalid page number 10730
Page 10611: btreeInitPage() returns error code 11
On tree page 10409 cell 39: Child page depth differs
Page 10617: btreeInitPage() returns error code 11
Page 10623: btreeInitPage() returns error code 11
Page 10630: btreeInitPage() returns error code 11
Page 10636: btreeInitPage() returns error code 11
Page 10646: btreeInitPage() returns error code 11
Page 10653: btreeInitPage() returns error code 11
Page 10658: btreeInitPage() returns error code 11
Page 10665: btreeInitPage() returns error code 11
Page 10670: btreeInitPage() returns error code 11
Page 10677: btreeInitPage() returns error code 11
Page 10687: btreeInitPage() returns error code 11
Page 10695: btreeInitPage() returns error code 11
Page 10702: btreeInitPage() returns error code 11
Page 10707: btreeInitPage() returns error code 11
Page 10713: btreeInitPage() returns error code 11
Page 10720: btreeInitPage() returns error code 11
On page 10409 at right child: invalid page number 10726
Page 10612: btreeInitPage() returns error code 11
On tree page 10411 cell 39: Child page depth differs
Page 10618: btreeInitPage() returns error code 11
Page 10624: btreeInitPage() returns error code 11
Page 10631: btreeInitPage() returns error code 11
Page 10637: btreeInitPage() returns error code 11
Page 10647: btreeInitPage() returns error code 11
Page 10654: btreeInitPage() returns error code 11
Page 10659: btreeInitPage() returns error code 11
Page 10666: btreeInitPage() returns error code 11
Page 10671: btreeInitPage() returns error code 11
Page 10678: btreeInitPage() returns error code 11
Page 10688: btreeInitPage() returns error code 11
Page 10696: btreeInitPage() returns error code 11
Page 10703: btreeInitPage() returns error code 11
Page 10708: btreeInitPage() returns error code 11
Page 10714: btreeInitPage() returns error code 11
Page 10721: btreeInitPage() returns error code 11
On page 10411 at right child: invalid page number 10727
Page 10605: btreeInitPage() returns error code 11
On tree page 10413 cell 38: Child page depth differs
Page 10613: btreeInitPage() returns error code 11
Page 10619: btreeInitPage() returns error code 11
Page 10625: btreeInitPage() returns error code 11
Page 10632: btreeInitPage() returns error code 11
Page 10638: btreeInitPage() returns error code 11
---------------

Reply via email to