Re: [sqlite] Exclusive locking mode not working as expected?

2011-07-30 Thread Jonathan Little
> From: "Jay A. Kreibich" <j...@kreibi.ch> > Date: July 29, 2011 6:23:24 AM PDT > Subject: Re: [sqlite] Exclusive locking mode not working as expected? > > On many OSes and most filesystems, file locking is advisory, not > mandatory. File locks are esse

Re: [sqlite] Exclusive locking mode not working as expected?

2011-07-29 Thread Jonathan Little
On 7/29/2011 05:00, sqlite-users-requ...@sqlite.org wrote: > -- > > Date: Fri, 29 Jul 2011 10:41:59 +0100 > From: Kevin Martin<ke...@khn.org.uk> > Subject: Re: [sqlite] Exclusive locking mode not working as expected? > > However, if I s

Re: [sqlite] Exclusive locking mode not working as expected?

2011-07-29 Thread Pavel Ivanov
> Am I missing something here or if I want to prevent this, is my only option > to modify our build of SQLite to open the file for exclusive access? Yes, opening with exclusive access is the only option for you. But with latest SQLite version you don't have to modify SQLite sources for that. You

Re: [sqlite] Exclusive locking mode not working as expected?

2011-07-29 Thread Jay A. Kreibich
On Thu, Jul 28, 2011 at 11:49:34PM -0700, Jonathan Little scratched on the wall: > I've been tearing my hair out over this for a little while, but I feel > like there must be something simple I'm missing. Based on the behavior > I'm seeing, the EXCLUSIVE locking mode isn't working the way I'd >

Re: [sqlite] Exclusive locking mode not working as expected?

2011-07-29 Thread Jay A. Kreibich
On Fri, Jul 29, 2011 at 11:08:19AM +0100, Simon Slavin scratched on the wall: > On 29 Jul 2011, at 7:49am, Jonathan Little wrote: > > > Specifically, that page says that locking_mode = EXCLUSIVE is useful > An exclusive lock will be retained only long enough to write changes > to the database

Re: [sqlite] Exclusive locking mode not working as expected?

2011-07-29 Thread Max Vlasov
On Fri, Jul 29, 2011 at 10:49 AM, Jonathan Little wrote: > > This behavior seems undesirable to me -- we've got users of our application > copying the database file using Windows Explorer while it's being written > to, and ending up with inconsistent/corrupt databases. Am I

Re: [sqlite] Exclusive locking mode not working as expected?

2011-07-29 Thread Simon Slavin
On 29 Jul 2011, at 7:49am, Jonathan Little wrote: > Specifically, that page says that locking_mode = EXCLUSIVE is useful if "The > application wants to prevent other processes from accessing the database > file." However, if I start up a SQLite shell, set the locking_mode to > exclusive, and

Re: [sqlite] Exclusive locking mode not working as expected?

2011-07-29 Thread Kevin Martin
On 29 Jul 2011, at 07:49, Jonathan Little wrote: Hello, I am no expert in sqlite, but I do use it one of our projects. My interpretation of the documentation is slightly different to yours - see below > Specifically, that page says that locking_mode = EXCLUSIVE is useful > if "The