Read-only: journal directory is not writable

SQLITE_READONLY_DIRECTORY (1544) is returned when the database file itself is writable but the directory containing it is not, preventing creation of the journal or WAL sidecar files.

1. 1Database file is writable but the parent directory is not (e.g., group permissions missing on directory).
2. 2Docker volume: file permissions differ from directory permissions.

First write to a database where the directory is not writable.

import os, sqlite3
os.chmod('/data/', 0o555)  # directory read/execute only
conn = sqlite3.connect('/data/my.db')
try:
    conn.execute('CREATE TABLE t(x)')
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