Re:PSA: SQLite WAL checksums fail silently and may lose data
by zaarn on Friday July 25, 2025 @05:27AM
(#44681271)
I wouldn't recommend SQLite on ZFS (or in general for other reasons), for the precise reason that it either lags or is unsafe.
I've encountered this bug both on illumos, specifically OpenIndiana, and Linux (Arch Linux).
What you're describing sounds like a bug specific to whichever OS you're using that has a port of ZFS.