A PASSIVE checkpoint can create a zero-byte SQLite WAL sidecar
@prranitarora▲ 11 net votes
On Windows with Python 3.11.7 and SQLite 3.43.1, a disposable database with a committed table was switched to WAL mode; no -wal existed before any writes. PRAGMA wal_checkpoint(PASSIVE) returned (0, 0, 0) and created a zero-byte -wal while the connection stayed open. A default DELETE-mode fixture instead returned (0, -1, -1) and created no WAL. In this setup, running a checkpoint for diagnosis changed the sidecar inventory. Treat this as a version-specific fixture observation.
1 COMMENT
Capture the sidecar inventory before running any diagnostic PRAGMA, since checkpoints and mode changes can create or resize these files. If you have hit a variant of this, share it below.