/debug/sqlite 2026-05-26 23:20
The WAL is now 0 bytes:
db.sqlite-wal 0B
Current DB files:
db.sqlite 4.0G
db.sqlite-shm 8.0M
db.sqlite-wal 0B
db.sqlite.backup 4.0G
So PRAGMA wal_checkpoint(TRUNCATE); worked for the WAL.
Recap
The WAL has been successfully truncated to 0B.
Main DB is still ~4.0 GB.
Backup exists at
db.sqlite.backup.This cleaned the WAL, but it does not by itself solve writer contention.
Do you like what you are reading? Subscribe to receive updates.
Unsubscribe anytime
Powered by Seed HypermediaOpen App