> On Nov 15, 2016, at 10:57 AM, Simon Slavin <slav...@bigfraud.org> wrote: > > sqlite> PRAGMA checkpoint_fullfsync; > 1
I wasn’t aware of that pragma. Just tried it on my Mac (10.12.1), and its value is 1 even if I don’t first set pragma fullfsync; i.e. it defaults to 1. (Contradicting the docs.) So it appears that on macOS, SQLite does use F_FULLFSYNC when checkpointing, but not at other times that it fsyncs. What does that mean in actual use, assuming that I always use WAL mode? Is there still an opportunity for corruption in the face of power failures? (Sorry to be frothing at the mouth about this; but my team’s dealing with a few users/customers whose apps encounter db corruption, on Android as well as macOS, and we’re getting really frustrated trying to figure out what’s going on.) —Jens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
