Re: SQLite Concurrency Issue

[email protected] ("David E. Wheeler")
Newsgroups perl.dbi.users
Message-ID <[email protected]> 
On Dec 22, 2010, at 3:30 PM, <[email protected]> <[email protected]> wrote:

> Maybe an obvious quesiton, but can you catch SQLITE_BUSY and just loop and 
> retry in your application code? Is there any reason not to retry after a 
> second or so? Such application retry logic is pretty standard for 
> transaction deadlock issues. 

I guess I could do that, but I'm going to have to do quite a bit of extra work to add the retry stuff. I might be able to use a lockfile, as well.

I'm hating both of these solutions.

David
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.