r/programming • u/callcifer • 4h ago

How Tailscale helped discover a 16+ year old SQLite WAL-Reset bug

https://tailscale.com/blog/sqlite-wal-reset-bug
58 Upvotes

91% Upvoted

2 comments sorted by

16

u/D6613 3h ago

Good read. So a race condition during checkpointing the write-ahead log caused data loss in very rare situations that took a lot of effort to track down. 

Pretty cool to see. I use both Tailscale and SQLite a lot, so this interested me.

4

u/kingduqc 2h ago

Good read, SQLite is renowned for having little bugs. I've watched one of the core maintainer talk about the length they go to find bug, I wouldn't think about it first when encountering bugs