logo       

Database is locked error on 2nd conn: msg#00032

python.db.pysqlite.user

Subject: Database is locked error on 2nd conn

Hi. I am attempting to handle two separate named connections to the same
database in a class. Both are opened during initialization. The error
comes on the second time the second connection and attempts an update.

I think it is possible the second connection may have not committed
properly with the logic the first time so when I aquire the connection
object the second time(in the method that is reporting the error) it
throws the 'database is locked'. Does this make sense?

I increased the timeout to 10 sec on the connection, just to determine
whether this would affect this behaviour at all but it did not. I have
not set an isolation level at this point. Many thanks.

Regards
David


<Prev in Thread] Current Thread [Next in Thread>
Google Custom Search

News | FAQ | advertise