On 2/2/16, Felipe Gasper <felipe at felipegasper.com> wrote: > 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? >
With few exceptions, analysis of a corrupt database does not normally help to determine what went wrong. A better approach to avoiding "danger", we have found, is to read and understand https://www.sqlite.org/howtocorrupt.html > *** in database main *** > Page 10628: btreeInitPage() returns error code 11 This indicates that the page header is so badly corrupted that SQLite cannot interpret this page at all. One possible reason: page 10628 has been zeroed. Can you look at a hex dump of that page? (Remember that SQLite numbers pages beginning with 1, so the start of the page is pgsz*10627 where pgsz is the page size.) -- D. Richard Hipp drh at sqlite.org
