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