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 ---------------