Tailscale says deeply buried 16-year-old SQLite bug caused last year's outages
Think your bugs are a pain to track? WAL-Reset took six months of hunting and development of a new logging tool to identify
Tailscale, a peer-to-peer networking service, experienced unexpected outages in late 2024 due to a hidden 16-year-old SQLite bug. The team investigated the issue for six months before finally identifying the cause. The problem stemmed from SQLite's checkpointing process, which manages new database entries before adding them to the master database file.
Tailscale's team manually controlled this checkpoint process for fast and consistent backups, leading to the rare data race known as the WAL-Reset bug. This bug occurs when a write transaction conflicts with checkpointing, causing permanently lost data and database corruption. SQLite maintainers discovered the issue could be present since version 3.7.0, released in 2010.
Tailscale's software engineer, Alex Chan, emphasized that even reliable software can have risks when used in non-standard ways. SQLite now recommends users update to a fixed version to avoid the issue.
Written by urgent.news from The Register's reporting — not their text. Machine-written — may contain errors; check the original before relying on it.
This story
This is one outlet's version. Read the fullest account.
