On Mar 11, 2010, at 11:42 AM, Skand wrote: > > > 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.
Run REINDEX on your database. Get SQLite 3.6.23 and use that in place of 3.3.6 moving forward. > > 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 D. Richard Hipp d...@hwaci.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
