On 7/14/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
That's interesting. What is "the F_FULLFSYNC syncing method" (since I am running on Mac OS X)? For what it's worth, PRAGMA FULLFSYNC returns 0 on my database.
I believe the F_FULLSYNC syncing method is a method implemented by Apple in Mac OS X that supposedly guarantees the data is actually written to disk before returning from the write. I believe 0 (or off) is the default. On OS X, you could, theoretically, turn it on. But that can't be the problem here if commits aren't hitting the disk even after days. I'd be curious to know if the journal file is always present (as it would be if a transaction opened but never closed), or, if the journal file disappears at times (as it would if COMMIT is getting called).
PRAGMA SYNCHRONOUS returns 2, which should be the safest mode. I am at a loss.
I believe that is also correct.
