Now this is a good bug write-up:
https://www.sqlite.org/wal.html#walresetbug

"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"

Write-Ahead Logging