Is it a known behavior? Considering SQLite developers approach to reliability, I think it would count as a critical bug worth fixing.
> Reconstruct the named repository database from the core records. Run this command after updating the fossil executable in a way that changes the database schema.