Re: [sqlite] Journal deletion: no directory fsync?

2008-07-28 Thread Glenn Maynard
On Mon, Jul 28, 2008 at 12:46:42PM -0500, Brian Smith wrote: > Glenn Maynard wrote: > > After finishing a transaction and deleting the rollback > > journal, no directory fsync is performed. If the system > > crashes immediately after a commit returns to the caller, the > > unlink may not have b

Re: [sqlite] Journal deletion: no directory fsync?

2008-07-28 Thread Brian Smith
Glenn Maynard wrote: > After finishing a transaction and deleting the rollback > journal, no directory fsync is performed. If the system > crashes immediately after a commit returns to the caller, the > unlink may not have been flushed to disk, causing the journal > to be rolled back and undoi

[sqlite] Journal deletion: no directory fsync?

2008-07-27 Thread Glenn Maynard
After finishing a transaction and deleting the rollback journal, no directory fsync is performed. If the system crashes immediately after a commit returns to the caller, the unlink may not have been flushed to disk, causing the journal to be rolled back and undoing a commit that had already return