The results:
integrity_check
"*** in database main ***
Main freelist: 1 of 153283 pages missing from overflow list
starting at 166541
On tree page 190802 cell 90: 2nd reference to page 166691
On tree page 190802 cell 90: Child page depth differs
On page 190802 at right child: 2nd reference to page 166690"
Greg
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Max Vlasov
Sent: Thursday, January 06, 2011 4:28 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Corrupted database file.
On Wed, Jan 5, 2011 at 10:05 PM, Greg Morehead
<[email protected]>wrote:
> I seem to have a corrupted DB which I was able to fix with a vacuum
> command. Any insights on how this could occur would be greatly
appreciated.
>
>
>
Greg, can you post full or partial (if full is big) result of pragma
intergrity_check; command on your corrupted db. I suppose there should
be some about indexes.
Max Vlasov
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
