News for hackers. Stuff that matters.
Re:PSA: SQLite WAL checksums fail silently and may lose data by throw0101b on Thursday July 24, 2025 @03:22PM (#44674933)
> SQLite on ZFS needs the Fsync behaviour to be off […]

    zfs set sync=disabled mydata/mydb001
* https://openzfs.github.io/openzfs-docs/man/master/7/zfsprops...
Re:PSA: SQLite WAL checksums fail silently and may lose data by zaarn on Friday July 25, 2025 @02:30AM (#44680195)
As noted in a sibling comment, this causes corruption on power failure.
Re:PSA: SQLite WAL checksums fail silently and may lose data by fread2281 on Sunday July 27, 2025 @03:45PM (#44704059)
This is a bug in zfs or in sqlite, sync=disabled should never cause actual corruption (it should at worst make existing corruption bugs in sqlite more likely & cause loss of committed sqlite transactions)
Re:PSA: SQLite WAL checksums fail silently and may lose data by fread2281 on Sunday July 27, 2025 @04:44PM (#44704540)
(see https://utcc.utoronto.ca/~cks/space/blog/solaris/ZFSTXGsAndZ... for an explanation of sync=disabled)
Re:PSA: SQLite WAL checksums fail silently and may lose data by zaarn on Monday July 28, 2025 @04:00AM (#44708422)
I highly doubt it's an SQLite bug, considering how thoroughly they test their code to behave correctly as long as their assumptions are filled. And those assumptions are clearly violated when SQLite runs on ZFS with sync=disabled (since writes may not be written to disk despite fsync).