TLDR DevOps · MISCELLANEOUS
HOW WE TRACKED DOWN A 16-YEAR-OLD SQLITE BUG
Summary from the TLDR DevOps newsletter
A rare race condition between SQLite WAL checkpointing and concurrent writes could permanently lose committed pages and corrupt databases, a bug that had existed for at least 16 years. Tailscale uncovered it after months of production forensics and 19 corruption incidents, working with SQLite maintainers to build new VFS tracing that isolated the race and led to a fix released in SQLite 3.51.3.