Re: [sqlite] blocking - busy_timeout vs database is locked(5)

2005-08-19 Thread Kurt Welgehausen
> Using ... Tcl ... how do I even obtain the value ... man n catch > If I use db timeout 2000 ... SQLite will retry for 2 seconds, then if the db is still locked, it should return an error code. Any SQLite command that can fail should be run within a catch command. Regards

Re: [sqlite] blocking - busy_timeout vs database is locked(5)

2005-08-19 Thread Ray Mosley
t can proceed? Thanks from a DB rookie. On 8/18/05, Robert Simpson <[EMAIL PROTECTED]> wrote: > > - Original Message - > From: "Jonathan H N Chin" <[EMAIL PROTECTED]> > To: > Sent: Thursday, August 18, 2005 8:00 AM > Subject: [sqlite] bl

Re: [sqlite] blocking - busy_timeout vs database is locked(5)

2005-08-18 Thread Robert Simpson
- Original Message - From: "Jonathan H N Chin" <[EMAIL PROTECTED]> To: Sent: Thursday, August 18, 2005 8:00 AM Subject: [sqlite] blocking - busy_timeout vs database is locked(5) [snip] but I still occasionally get failures: DBD::SQLite::db do failed: database

Re: [sqlite] blocking - busy_timeout vs database is locked(5)

2005-08-18 Thread Jonathan H N Chin
I should perhaps note that there are only around fifty accesses in any given five minute interval, so it is not as if anything is being overloaded. -jonathan -- Jonathan H N Chin, 2 dan | deputy computer | Newton Institute, Cambridge, UK <[EMAIL PROTECTED]> | systems mangler | tel/fax: +44 1223

[sqlite] blocking - busy_timeout vs database is locked(5)

2005-08-18 Thread Jonathan H N Chin
With debian packages: sqlite3 3.2.1-1 libsqlite3-03.2.1-1 libdbd-sqlite3-perl 1.08-1 (with looks_like_number test elided) I have an sqlite3 database that is accessed by a perl cgi script. I want accesses