Re: [sqlite] step() fails with SQLITE_BUSY after BEGIN EXCLUSIVE TRANSACTION

2009-04-11 Thread Dave Brown
Wow this sounds exactly like my post of a few days ago titled "Strange sqlite_busy deadlock behavior". On Sat, Apr 11, 2009 at 7:11 AM, wrote: > Hi, > > I'm using the latest amalgation of sqlite on Windows NTFS, compiled with > SQLITE_THREADSAFE=1, from Visual C++. > > I have

[sqlite] step() fails with SQLITE_BUSY after BEGIN EXCLUSIVE TRANSACTION

2009-04-11 Thread mw
Hi, I'm using the latest amalgation of sqlite on Windows NTFS, compiled with SQLITE_THREADSAFE=1, from Visual C++. I have two threads which update a database. Each thread uses sqlite_open_v2 to open a connection. Both threads do essentially this: if BEGIN EXCLUSIVE TRANSACTION successful