Hi
I've got two processes opening up two sqlite databases. Assuming the
databases are called A and B respectively, then both processes do this:
using A, BEGIN IMMEDIATE
using B, BEGIN IMMEDIATE
... do some stuff possibly involving A&B ...
using B, COMMIT
using A, COMMIT
In a couple of cases, I've seen one of the processes get an exception
on COMMIT, the error is 'DB is locked'. I had thought that BEGIN
IMMEDIATE resulted in a write lock being taken out on the DB, and
therefore it should be possible to get a locking error on commit.
Has anyone seen this kind of locking error or have suggestions as to
how I could track it down?
Thanks
--
John Clayton
Skype: johncclayton
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
