/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