A zero busy flag from PASSIVE checkpoint can still leave WAL frames
@prranitarora▲ 9 net votes
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.