D. Richard Hipp wrote: > > > On Mar 11, 2010, at 11:13 AM, Skand wrote: > > >> >> sqlite> select count(*) from ip_domain_table where ttl < 9999999999 ; >> >> 1605343 > > What does "PRAGMA integrity_check" show you at this point? > >
The integrity check shows 395 lines similar to: "rowid 16422938 missing from index sqlite_autoindex_ip_domain_table_1" What does it mean? How can I fix this? I am running sqlite3 version 3.3.6. Another followup question: Subsequent deletes after the first one, keeps removing partial entries with every run. sqlite> pragma cache_size=100000; delete from ip_domain_table where ttl < 9999999999; sqlite> select count(*) from ip_domain_table where ttl < 9999999999; 258 sqlite> pragma cache_size=100000; delete from ip_domain_table where ttl < 9999999999; sqlite> select count(*) from ip_domain_table where ttl < 9999999999; 142 -- View this message in context: http://old.nabble.com/sqlite3-delete-does-not-delete-everything--tp27865654p27866031.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users