On 1/15/15, Dave Dyer <ddyer-sql...@real-me.net> wrote: > The likely cause of corruption is that this is probably a > database being accessed on a networked disk. > > -- > > sqlite> select * from preference_table where preferenceset='foo'; > sqlite> drop index preferenceindex; > (11) database corruption at line 52020 of [2677848087] > (11) statement aborts at 24: [drop index preferenceindex;] > (11) database corruption at line 46321 of [2677848087] > (11) database corruption at line 46359 of [2677848087] > Error: database disk image is malformed > sqlite> pragma quick_check; > *** in database main *** > On tree page 5399 cell 16: Rowid 25142 out of order (max larger than parent > max of 25141) > On tree page 5520 cell 9: Rowid 25211 out of order (previous was 25745)
More than just index corruption.... Try doing: sqlite3 old-database .dump | sqlite3 fixed-database Then verify that "fixed-database" still contains all of your data. > On tree page... > sqlite> reindex; > (11) database corruption at line 52020 of [2677848087] > (11) statement aborts at 3: [reindex;] > (11) database corruption at line 46321 of [2677848087] > (11) database corruption at line 46359 of [2677848087] > Error: database disk image is malformed > sqlite> pragma integrety_check; > sqlite> pragma quick_check; > *** in database main *** > On tree page 5399 cell 16: Rowid 25142 out of order (max larger than parent > max of 25141) > On tree page 5520 cell 9: Rowid 25211 out of order (previous was 25745) > On tree page... > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
