Busy: another connection is recovering WAL

SQLITE_BUSY_RECOVERY (261) is an extended code returned when a database is in WAL mode and another connection is currently performing crash recovery (replaying the WAL). The caller should wait and retry.

1. 1Application restarted after a crash; first connection to open the WAL database is performing recovery.
2. 2Another process is replaying uncommitted WAL frames after an unclean shutdown.

WAL-mode database open after an unclean shutdown with concurrent connections.

import sqlite3, time
for attempt in range(5):
    try:
        conn = sqlite3.connect('my.db', timeout=5)
        conn.execute('SELECT 1')
        break
    except sqlite3.OperationalError as e:
        if 'database is locked' in str(e):
            time.sleep(0.5)

Transient; retries succeed once recovery completes.

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