Date: Tue, 20 Jul 2010 07:28:45 +0200
From: cwi...@compuscan.co.za
To: pine...@hotmail.com
CC: tutor@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@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_______________________________________________
Tutor maillist - Tutor@python.org
To unsubscribe or change subscription options:
http://mail.python.org/mailman/listinfo/tutor
