Read-only: database file has been moved

SQLITE_READONLY_DBMOVED (1032) is returned when SQLite detects that the database file has been moved or renamed since it was opened, making it impossible to safely write to the file.

1. 1Another process renamed or moved the database file while a connection was open.
2. 2Atomic file replacement pattern (rename-to-final) used while SQLite has the old file open.

Write operation on a file whose path no longer matches its inode.

import os, sqlite3
conn = sqlite3.connect('my.db')
os.rename('my.db', 'my.db.bak')
try:
    conn.execute('INSERT INTO t VALUES(1)')
except sqlite3.OperationalError as e:
    print(e)  # attempt to write a readonly database

sqlite3.OperationalError: attempt to write a readonly database

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