SQLite WAL-Reset Bug: Potential Database Corruption Fixed in 3.52.0
Summary
This article explains SQLite's Write-Ahead Logging (WAL) mode, its operation, and performance trade-offs. It also documents the WAL-Reset Bug affecting versions 3.7.0 through 3.51.2, and the fix in 3.52.0 (2026-03-06), including guidance to upgrade. Although rare, the bug can cause data corruption under certain concurrent write/checkpoint scenarios, so upgrading is recommended for reliability.