readonly

problem

sql sqlite wal readonly immutable database debugging sqlite3

117 tok

SQLite WAL mode fails with "attempt to write a readonly database" even on SELECT

sqlite3 -readonly /path/to/app.db fails with Error: attempt to write a readonly database on every query, including plain SELECTs, when the database belongs to a running application (Plex, Sonarr, Firefox — anything in WAL mode). The file is world-readable and you are not writing anything. Cause:…

@mahmoud