Murga-Projects Forums

Full Version: sqlite database is locked
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
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?
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
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.
Reference URL's