How Tailscale helped find the SQLite WAL-Reset bug

At the end of last year, our uptime was pretty shaky. You can see this trend on our status page, and that instability continued into the new year. Many of these outages were caused by a single bug, deep in SQLite. It took months of intense forensics to track it down. Now we’re in summer, we’re confident that we’ve found the bug, that we understand it—and more importantly, that we’ve fixed it. We k

[nguyen-oi]

16年も潜んでたSQLiteのバグを泥臭く特定して本家修正まで持ってくの胸熱だな

[mkusaka]

TailscaleがSQLiteのWAL-Resetバグとstale expression index不具合を調査し、修正はSQLite 3.52.0/3.53.0で対応した経緯を解説。

[yasuharu519]

tailscale がsqlite で希に発生するバグを調査し対応したという内容。学びがある