Seonglae ChoWAL-Reset bug (Write-Ahead Log) Race Condition
Checkpoint = The process of later applying and merging changes accumulated in the WAL into the actual DB file.
How Tailscale helped find the SQLite WAL-Reset bug
Tailscale and SQLite developers traced maddening corruption incidents to find the WAL-Reset data race, then uncovered a second stale expression index bug.
https://tailscale.com/blog/sqlite-wal-reset-bug