Good point... I have several different tasks(vxworks)....
Perhaps, this is why its working well for me... Tezo. ----- Original Message ----- From: "Dave Hayden" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, August 11, 2004 4:30 PM Subject: Re: [sqlite] Deadlock when doing threaded updates and inserts > On Aug 11, 2004, at 4:05 PM, tezozomoc wrote: > > > I have solved this problem by writing a wrappers around sql_exec and > > sql_query, sql_step, etc... > > In these wrappers I handle the waiting for busy and the lock file > > issue... > > I was doing the same, calling usleep() whenever I got a SQLITE_BUSY > return and trying the command again, but it doesn't help in the case > where two threads are both in a transaction and trying to write.. > > -D > >
