[sqlite] SQLITE vs. OSX mmap == inevitable catalog corruption?

2015-11-18 Thread Dan Kennedy
On 11/18/2015 03:37 PM, T?r?k Edwin wrote: > On 11/17/2015 12:11 AM, Deon Brewis wrote: >> We found that using SQLITE memory mapped I/O (mmap_size > 0) in OSX isn't >> usable in any way shape or form. It will inevitably lead to catalog >> corruption if you hard-reboot OSX, even without the

[sqlite] SQLITE vs. OSX mmap == inevitable catalog corruption?

2015-11-18 Thread Török Edwin
On 11/17/2015 12:11 AM, Deon Brewis wrote: > We found that using SQLITE memory mapped I/O (mmap_size > 0) in OSX isn't > usable in any way shape or form. It will inevitably lead to catalog > corruption if you hard-reboot OSX, even without the database or application > open. > I tried to turn

[sqlite] SQLITE vs. OSX mmap == inevitable catalog corruption?

2015-11-18 Thread Howard Chu
Dan Kennedy wrote: > On 11/18/2015 03:37 PM, T?r?k Edwin wrote: >> On 11/17/2015 12:11 AM, Deon Brewis wrote: >>> We found that using SQLITE memory mapped I/O (mmap_size > 0) in OSX isn't >>> usable in any way shape or form. It will inevitably lead to catalog >>> corruption if you hard-reboot OSX,

[sqlite] SQLITE vs. OSX mmap == inevitable catalog corruption?

2015-11-18 Thread Richard Hipp
On 11/18/15, Howard Chu wrote: > Dan Kennedy wrote: >> >> As of yesterday, SQLite uses a read-only mapping in mmap mode. The db file >> is >> written using plain old write(), just as in non-mmap mode: > > That's the safest way to use mmap, but keep in mind that this requires a > unified buffer

[sqlite] SQLITE vs. OSX mmap == inevitable catalog corruption?

2015-11-16 Thread Deon Brewis
We found that using SQLITE memory mapped I/O (mmap_size > 0) in OSX isn't usable in any way shape or form. It will inevitably lead to catalog corruption if you hard-reboot OSX, even without the database or application open. We've tried FULLSYNC and F_FULLFSYNC, but it makes no difference.

[sqlite] SQLITE vs. OSX mmap == inevitable catalog corruption?

2015-11-16 Thread Richard Hipp
On 11/16/15, Deon Brewis wrote: > We found that using SQLITE memory mapped I/O (mmap_size > 0) in OSX isn't > usable in any way shape or form. It will inevitably lead to catalog > corruption if you hard-reboot OSX, even without the database or application > open. > > We've tried FULLSYNC and