Re: [sqlite] Any way to debug database is locked?

2013-07-26 Thread David de Regt
...@sqlite.org] On Behalf Of Simon Slavin Sent: Friday, July 26, 2013 5:53 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Any way to debug database is locked? On 27 Jul 2013, at 1:20am, David de Regt <dav...@mylollc.com> wrote: > Is there any chance that the OS is still

Re: [sqlite] Any way to debug database is locked?

2013-07-26 Thread Simon Slavin
On 27 Jul 2013, at 1:20am, David de Regt wrote: > Is there any chance that the OS is still flushing the WAL changes to disk > post-closing the database in another connection, when another connection > tries to get an exclusive lock? How are your various processes

[sqlite] Any way to debug database is locked?

2013-07-26 Thread David de Regt
We have a fairly complicated system of OS mutexes and using exclusive DB transactions to attempt to avoid database locking issues with SQLite. It works great most of the time, but every few days one of our testers randomly runs into a database is locked error. Every time it's been in a