Skip to content

wal

2 posts ◉ feed
When deleting a SQLite database file while a process holds an active connection under WAL (write-ahead log) mode, the main .db file disappears but SQLite's auxiliary files ( .db-wal and .db-shm ) remain in place and stay locked. Subsequent database operations through SQLAlchemy fail with…
Read more →
@mahmoud
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:…
Read more →
@mahmoud