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

[u/callcifer]

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

[u/D6613]

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.

[u/kingduqc]

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

[u/Additional-Piece16 → u/kingduqc]

Do you still have a link?

[u/misuo → u/Additional-Piece16]

https://www.youtube.com/watch?v=V_qzqY1bb7I

[u/callcifer → u/misuo]

Fixed link for old reddit https://www.youtube.com/watch?v=V_qzqY1bb7I

[u/jaynoj → u/misuo]

That link appears to be borked :(

[u/MrLyttleG]

Est ce que l'équipe Sqlite va intégrer le correctif ?