News : The level of daily SPAM has reached insane proportions, all registrations are now manual. I ask you to send me an e-mail (john (at) murga (dot) org), to confirm that you want me to create an account for you.


Post Reply  Post Thread 
sqlite database is locked
Author Message
asafp
Member
***


Posts: 81
Group: Registered
Joined: Jan 2008
Status: Offline
Reputation: 0
Post: #1
sqlite database is locked

I've got programs that do simple inserts and updates on a single table. It all works fine if only one program is running at a time. I get the "database is locked" on the nrows iterator over a select statement if I start up a second program. I don't have any transactions, commits, rollbacks. Just working with one record at a time on a single table.

I've googled this, there is a lot written out there, but no clear simple solution that I could find.

Has anyone else encountered this? Is there a way to select a single row without using an iterator?

08-25-2008 06:51 AM
Visit this user's website Find all posts by this user Quote this message in a reply
JohnMurga
Administrator
*******


Posts: 381
Group: Administrators
Joined: Apr 2007
Status: Offline
Reputation: 2
Post: #2
RE: sqlite database is locked

Haven't tried this ...

Will put a test together, although sqLite locks are very coarse grained so the message could be true.

I am trying to finish a 0.6.9 right now ...

Cheers
John de Murga

08-25-2008 06:47 PM
Visit this user's website Find all posts by this user Quote this message in a reply
asafp
Member
***


Posts: 81
Group: Registered
Joined: Jan 2008
Status: Offline
Reputation: 0
Post: #3
RE: sqlite database is locked

db:busy_timeout might do the trick. It looks like the default value is zero, meaning it doesn't wait at all if there is a busy condition. I haven't been able to try it yet.

08-29-2008 08:44 AM
Visit this user's website Find all posts by this user Quote this message in a reply
Post Reply  Post Thread 

View a Printable Version
Send this Thread to a Friend
Subscribe to this Thread | Add Thread to Favorites

Forum Jump: