Re: [sqlite] synchronization issue: no directory sync after unlink

The header is overwritten with some zeros only if I change the journal_mode to PERSIST : http://www.sqlite.org/pragma.html#pragma_journal_mode By default, the journal_mode is set to DELETE so the journal file is valid if the file is present after an unlink + power shutdown. (I have checked with

[sqlite] synchronization issue: no directory sync after unlink

Hi, I have a synchronization issue on an embedded device running Linux : if a power shutdown is done just after a commit, sqlite will restore the database to the previous state using the journal file. At the end of a transaction the unlink of the journal file is not enough, the journal could