On Oct 5, 2009, at 9:01 AM, Reusche, Andrew wrote:
> The "sales" table is the table in question. Sorry it took so long to
> respond, apparently sqlite.org gets flagged as spam.
>
> On Oct 2, 2009, at 9:13 AM, Reusche, Andrew wrote:
>>
>> I run reindex. Then another integrity_check:
>>
>> sqlite> pragma integrity_check
>> wrong # of entries in index sales_datetime
>>
>
>
> Can you send me your database? [email protected].
>
The "sales" table has a page of duplicate ROWIDs. This might have
come about when a transaction was interrupted by a crash or power
failure but the rollback journal was delete or renamed before the
rollback could occur.
You can see the duplications using this query:
SELECT * FROM sales WHERE sales_id BETWEEN 609210 AND 609211;
If you do a ".dump" and manually remove the duplication entries, then
reconstruct the database file from the dump, you should recover all
information.
D. Richard Hipp
[email protected]
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
