Re: [sqlite] SQLITE_LOCKED behavior

2008-04-14 Thread Shawn Wilsher
> Did you call sqlite3_reset() before each retry? Doing this fixed the issue. Thanks! Cheers, Shawn ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLITE_LOCKED behavior

2008-04-14 Thread Shawn Wilsher
> Did you call sqlite3_reset() before each retry? Ah, I didn't realize I'd have to do that. When I get SQLITE_BUSY returned, I can just retry it, so I made the wrong assumption that that would work in this case as well. Cheers, Shawn ___ sqlite-users

Re: [sqlite] SQLITE_LOCKED behavior

2008-04-14 Thread D. Richard Hipp
On Apr 14, 2008, at 2:44 PM, Shawn Wilsher wrote: >> I am not aware of any reason why you cannot retry an SQLITE_LOCKED >> error after a delay, however. Have you actually tried doing that? >> Is it giving you trouble? > Attempting to retry after it being issues results in SQLITE_MISUSE > being re

Re: [sqlite] SQLITE_LOCKED behavior

2008-04-14 Thread Shawn Wilsher
> I am not aware of any reason why you cannot retry an SQLITE_LOCKED > error after a delay, however. Have you actually tried doing that? > Is it giving you trouble? Attempting to retry after it being issues results in SQLITE_MISUSE being returned. Cheers, Shawn ___

Re: [sqlite] SQLITE_LOCKED behavior

2008-04-14 Thread D . Richard Hipp
On Apr 14, 2008, at 12:57 PM, Shawn Wilsher wrote: >> Are you using a shared cache? You can get also get SQLITE_LOCKED >> when >> using a shared cache. See section 2.2 of >> . >> >> I've not used a shared cache myself. One day I was wondering if I >> ne

Re: [sqlite] SQLITE_LOCKED behavior

2008-04-14 Thread Shawn Wilsher
> Are you using a shared cache? You can get also get SQLITE_LOCKED when > using a shared cache. See section 2.2 of > . > > I've not used a shared cache myself. One day I was wondering if I > needed to worry about handling SQLITE_LOCKED errors and I ca

Re: [sqlite] SQLITE_LOCKED behavior

2008-04-13 Thread D. Richard Hipp
On Apr 13, 2008, at 3:01 AM, Tomas Lee wrote: > On 2008 April 12 (Sat) 05:44:53pm PDT, Shawn Wilsher <[EMAIL PROTECTED] > > wrote: >> When using SQLite 3.5.4.1 (a special branch cut for Mozilla, based >> mostly off of 3.5.4 with some OS/2 fixes), I'm getting SQLITE_LOCKED >> returned unexpectedly

Re: [sqlite] SQLITE_LOCKED behavior

2008-04-13 Thread Tomas Lee
On 2008 April 12 (Sat) 05:44:53pm PDT, Shawn Wilsher <[EMAIL PROTECTED]> wrote: > When using SQLite 3.5.4.1 (a special branch cut for Mozilla, based > mostly off of 3.5.4 with some OS/2 fixes), I'm getting SQLITE_LOCKED > returned unexpectedly. The documentation seems to indicate that I > should o

[sqlite] SQLITE_LOCKED behavior

2008-04-12 Thread Shawn Wilsher
Hey all, When using SQLite 3.5.4.1 (a special branch cut for Mozilla, based mostly off of 3.5.4 with some OS/2 fixes), I'm getting SQLITE_LOCKED returned unexpectedly. The documentation seems to indicate that I should only be getting SQLITE_LOCKED if I'm calling sqlite3_exec recursively writing t