Re: [sqlite] Sqlite locking issue with ATTACH'ed databases

Can someone knowledgeable in the ATTACH/DETACH behavior comment on this? > -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Loren Keagle > Sent: Monday, July 22, 2013 2:38 PM > To: sqlite-users@sqlite.org &g

Re: [sqlite] sqlite-users Digest, Vol 67, Issue 18

> > If you remove a busy check, does it output any statements? > > Do you have any custom functions/operations running so they could > > block sqlite in creating new statement? > > > > > > 2013/7/17 Loren Keagle <loren.kea...@braemarllc.com> > > > &g

Re: [sqlite] Sqlite locking issue with ATTACH'ed databases

..@bigfraud.org> >Content-Type: text/plain; charset=us-ascii >On 16 Jul 2013, at 11:24pm, Loren Keagle <loren.kea...@braemarllc.com> wrote: >> Begin EXCLUSIVE TRANSACTION; >> insert several rows of data; >> Commit transaction; >> >> Prepa

[sqlite] Sqlite locking issue with ATTACH'ed databases

Hi everyone, I have an interesting locking problem that I'm wondering if someone can help with some insight. I have a master database with some metadata, and several sub-databases to store logging events. I have one reader object and one writer object that attach to the sub-databases and