Skip to content

Receipts database can get corrupted #16

@scottyeager

Description

@scottyeager
$ sqlite3 receipts.db "PRAGMA integrity_check;"
row 1125 missing from index sqlite_autoindex_receipts_1
row 1511 missing from index sqlite_autoindex_receipts_1
row 1635 missing from index sqlite_autoindex_receipts_1
row 3102 missing from index sqlite_autoindex_receipts_1
row 3868 missing from index sqlite_autoindex_receipts_1
row 4080 missing from index sqlite_autoindex_receipts_1
row 4174 missing from index sqlite_autoindex_receipts_1
row 4920 missing from index sqlite_autoindex_receipts_1
row 5922 missing from index sqlite_autoindex_receipts_1
row 6141 missing from index sqlite_autoindex_receipts_1
row 6168 missing from index sqlite_autoindex_receipts_1
row 7975 missing from index sqlite_autoindex_receipts_1
row 8385 missing from index sqlite_autoindex_receipts_1
row 8386 missing from index sqlite_autoindex_receipts_1
row 8387 missing from index sqlite_autoindex_receipts_1
row 8388 missing from index sqlite_autoindex_receipts_1
row 8557 missing from index sqlite_autoindex_receipts_1
row 9774 missing from index sqlite_autoindex_receipts_1
row 9941 missing from index sqlite_autoindex_receipts_1
row 9942 missing from index sqlite_autoindex_receipts_1
row 9943 missing from index sqlite_autoindex_receipts_1
row 9944 missing from index sqlite_autoindex_receipts_1
row 9945 missing from index sqlite_autoindex_receipts_1
row 10163 missing from index sqlite_autoindex_receipts_1
row 10332 missing from index sqlite_autoindex_receipts_1
row 10436 missing from index sqlite_autoindex_receipts_1
row 10437 missing from index sqlite_autoindex_receipts_1
row 10438 missing from index sqlite_autoindex_receipts_1
row 10439 missing from index sqlite_autoindex_receipts_1
row 10440 missing from index sqlite_autoindex_receipts_1
row 10441 missing from index sqlite_autoindex_receipts_1
row 11973 missing from index sqlite_autoindex_receipts_1
row 11974 missing from index sqlite_autoindex_receipts_1
row 11975 missing from index sqlite_autoindex_receipts_1
row 11976 missing from index sqlite_autoindex_receipts_1
row 12049 missing from index sqlite_autoindex_receipts_1
row 12050 missing from index sqlite_autoindex_receipts_1
row 12051 missing from index sqlite_autoindex_receipts_1
row 12052 missing from index sqlite_autoindex_receipts_1
row 12053 missing from index sqlite_autoindex_receipts_1
row 12054 missing from index sqlite_autoindex_receipts_1
row 12308 missing from index sqlite_autoindex_receipts_1
row 12309 missing from index sqlite_autoindex_receipts_1
row 12310 missing from index sqlite_autoindex_receipts_1
row 12311 missing from index sqlite_autoindex_receipts_1
row 12312 missing from index sqlite_autoindex_receipts_1
row 12435 missing from index sqlite_autoindex_receipts_1
row 12436 missing from index sqlite_autoindex_receipts_1
row 12437 missing from index sqlite_autoindex_receipts_1
row 12438 missing from index sqlite_autoindex_receipts_1
row 12861 missing from index sqlite_autoindex_receipts_1
row 12862 missing from index sqlite_autoindex_receipts_1
row 12863 missing from index sqlite_autoindex_receipts_1
row 12864 missing from index sqlite_autoindex_receipts_1
row 16356 missing from index sqlite_autoindex_receipts_1
row 28351 missing from index sqlite_autoindex_receipts_1
row 28352 missing from index sqlite_autoindex_receipts_1
row 28353 missing from index sqlite_autoindex_receipts_1
row 28354 missing from index sqlite_autoindex_receipts_1
wrong # of entries in index sqlite_autoindex_receipts_1

$ sqlite3 receipts.db "REINDEX receipts;"
Error: stepping, UNIQUE constraint failed: receipts.hash (19)

Of course it's disposable, but this shouldn't happen.

Perhaps this can be solved by finishing the scraper implementation. Then we just have a single writer and fewer chances for issues.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions