On Wed, Nov 18, 2009 at 8:39 AM, Vasu Nori <[email protected]> wrote: > > > On Wed, Nov 18, 2009 at 4:06 AM, D. Richard Hipp <[email protected]> wrote: > >> >> On Nov 17, 2009, at 9:49 PM, D. Richard Hipp wrote: >> >> > >> > On Nov 17, 2009, at 9:45 PM, Vasu Nori wrote: >> >> >> >> sqlite> SELECT _id, typeof(_id) FROM feeds; >> >> 1|integer >> >> 2|integer >> >> 3|integer >> >> 4|integer >> >> 5|integer >> >> 6|integer >> >> 7|integer >> >> 8|integer >> >> 9|integer >> >> 10|integer >> >> 11|integer >> >> 0|integer >> >> 13|integer >> >> 14|integer >> > >> > >> > Please email your database directly to me for analysis. [email protected] >> >> >> The database file is corrupt, but in a way that "PRAGMA >> integrity_check" does not detect. A single byte at an offset of 13568 >> into the file seems to have been changed from 0x0c into 0x00. >> >> wondering how difficult it is to detect this kind of corruption - the kind where a single byte corruption can be pretty bad. in this case, it meant that the entire row went un-retrievable with the query "select * from feeds where _id = 0;"
if it is such corruption can be detected and be included as part of "pragma integrity-check" command, then it could have proved quite useful in my case. any opinions? and any sqlite-committers willing to do this? if not, how about helping me with a few pointers to get me started on implementing this? thanks > How was this database created? Can you recreate this problem from >> scratch? >> >> database is created by an android application on a phone (running > android). nothing extraordinary about this application's database creation. > > It is not reproducible that easily. > > any theories or hints on how one could debug this? > > >> D. Richard Hipp >> [email protected] >> >> >> >> _______________________________________________ >> 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
