On 31 January 2016 at 03:56, James K. Lowden <jklowden at schemamania.org> wrote:
> Surely SQLite does both -- fsync on file and directory -- as part of a > commit. That's not in doubt, is it? > No, SQLite does not. On COMMIT it fsyncs the database file and unlinks the journal[1], but does not fsync the directory. This is demonstrated by the logs in Stefan's initial post, and indeed the purpose of his patch was to introduce an fsync on the directory after unlinking the journal. [1] with the default PRAGMA journal_mode=delete, obviously -Rowan
