EmbeddingGemma 2: an open, lightweight multimodal embedding model
deepmind.google·6d ago
AI Engineering
Hacker News·Aug 12·5 min read
Tailscale Traces Database Corruption to 16y/o SQLite WAL-Reset Bug
TL;DR
Tailscale identified and fixed a long-standing bug in SQLite that caused significant service outages. This resolution restores reliability to their control plane infrastructure.
✦ Why It Matters
Review your database management practices to ensure reliability and prevent similar issues.
Key Takeaways
- Implement robust monitoring for database integrity checks.
- Consider using transaction logging for critical database operations.
- Collaborate with database developers for complex issues.
- Regularly review and update database management practices.
How It Works
Tailscale's control plane uses SQLite with Write-Ahead Logging (WAL) for performance. The WAL-Reset bug occurs when a write transaction overlaps with a checkpoint, causing data loss.
By implementing transaction logging, Tailscale could replay SQL statements to restore databases without losing data.