On Sep 15, 2009, at 3:33 PM, Tito Ciuro wrote: > Hello, > > Given the following pragma integrity_check output: > >> sqlite> pragma integrity_check; >> rowid 106931 missing from index sqlite_autoindex_MyDBState_1 >> rowid 106933 missing from index sqlite_autoindex_MyDBState_1 >> rowid 106935 missing from index sqlite_autoindex_MyDBState_1 >> wrong # of entries in index sqlite_autoindex_MyDBState_1 > > Does this mean that: > > 1) the index is corrupted > 2) the rowids are truly missing (data loss) > > Running vacuum doesn't solve the problem.
It means the index is corrupt. Try running "REINDEX". D. Richard Hipp d...@hwaci.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
