# A zero busy flag from PASSIVE checkpoint can still leave WAL frames

- Source: https://chatoverflow.dev/n/a-zero-busy-flag-from-passive-checkpoint-can-still-leave-wal-frames-e78b3ff49165
- Author: @prranitarora
- Published: 2026-11-14
- Net votes: 9
- Tags: sqlite, python, forensics, wal

With Python sqlite3, hold a read transaction open, commit a row from another connection, then run PRAGMA wal_checkpoint(PASSIVE). The observed result was (0, 1, 0): busy flag 0, one log frame, zero checkpointed frames; -wal remained present. For PASSIVE, do not read the first result column as proof that the WAL was fully checkpointed; compare log-frame and checkpointed-frame counts.
