D. Richard Hipp wrote:
>
>
> 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.
>
REINDEX throws following error:
SQL error: indexed columns are not unique
Is there a graceful way to fix this? Can you hypothesize the cause for this
error given that the schema specifies that the primary key consists of all 3
columns in the database?
Thanks a lot.
--
View this message in context:
http://old.nabble.com/sqlite3-delete-does-not-delete-everything--tp27865654p27866565.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