[Tutor] SQLite database locked problem

Che M pine508 at hotmail.com
Tue Jul 20 06:48:19 CEST 2010


I'm using an SQLite3 database (with Python 2.5) and every so often the application crashes or hangs because somewhere there is this error, or something like it:

OperationalError:  database is locked.

This is probably because I am viewing and sometimes changing the database through SQLite Database Browser while working on my app, and occasionally the app tries to access the db when the Database Browser is writing to it or something like that.    

I'd like to a) know how to reproduce the error (haven't seen it in a while, but want to be sure  know when it may happen for users and b) prevent it from being a problem in the running app.  

Any suggestions welcome.  Thank you,
Che
 		 	   		  
_________________________________________________________________
Hotmail is redefining busy with tools for the New Busy. Get more from your inbox.
http://www.windowslive.com/campaign/thenewbusy?ocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_2
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/tutor/attachments/20100720/cc89ff17/attachment.html>


More information about the Tutor mailing list