Index is inconsistent with table

SQLITE_CORRUPT_INDEX (779) is returned during an integrity check when an index entry does not match the corresponding table row — the index is out of sync with the data.

1. 1Partial write failure left index and table in an inconsistent state.
2. 2Bug in SQLite or a third-party storage layer.
3. 3Index rebuilt incorrectly by an external tool.

PRAGMA integrity_check or PRAGMA quick_check.

import sqlite3
conn = sqlite3.connect('my.db')
result = conn.execute('PRAGMA integrity_check').fetchall()
for row in result:
    print(row)  # may show "row X missing from index Y"

"row 42 missing from index idx_users_email on table users"

Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev