SQLite WAL-reset database corruption bug
19 points by cve
19 points by cve
Based on available telemetry, the occurrence rate of this problem in the wild appears to be less than or equal to the expect occurrence rate of SSD malfunctions and/or cosmic-ray hits.
SQLite - statistically more reliable than the hardware you are running it on.
Unfortunately, there does not seem to be much documentation on this.
The merge commit fixing this is 7168988acbec2d8d. According to the test contained there, it seems to happen under a race condition with tight timing guarantees.
I guess we have different experiences with projects documenting bugs. This appears to be a whole page about the bug. While I get that it doesn't go very deep into the technical details and production steps, I feel like it's much more detailed than many open-source project bug reports.