[Tutor] SQLite database locked problem

[Che M]

Date: Tue, 20 Jul 2010 07:28:45 +0200
From: cwitts at compuscan.co.za
To: pine508 at hotmail.com
CC: tutor at python.org
Subject: Re: [Tutor] SQLite database locked problem






  
  


On 20/07/2010 06:48, Che M wrote:

  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. See how.
  
_______________________________________________
Tutor maillist  -  Tutor at python.org
To unsubscribe or change subscription options:
http://mail.python.org/mailman/listinfo/tutor
  



? SQLite is technically thread safe, but a write operation locks the
entire 

> database [1]:
> - Any resultset being step()'d through uses a shared read-only lock. 

> - Any insert/update being executed requires an exclusive write lock.





Thanks, that's fine to know, but what do I do in Python to address my concern?  



Che

 		 	   		  
_________________________________________________________________
The New Busy think 9 to 5 is a cute idea. Combine multiple calendars with Hotmail. 
http://www.windowslive.com/campaign/thenewbusy?tile=multicalendar&ocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_5
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/tutor/attachments/20100721/526bb112/attachment.html>