[pysqlite] connection timeout parameter
Bryan
belred at gmail.com
Thu Oct 26 01:00:20 CEST 2006
i seem to be having the same issue as was posted in a previous thread
"timeout parameter". i'm using pysqlite 2.3.2 and python 2.4.3 on
windows xp sp2.
i have a method that does the following:
get new connection
(timeout is 30 seconds, isolation_level is default)
get new cursor
insert
sleep 30 seconds
commit
the method is called in two threads. when the 2nd thread tries to do an
insert, it returns immediately with a "DatabaseError: database is
locked" exception. i expected the 2nd call to insert to be blocked for
up to 30 seconds (i also tried the default timeout of 5 seconds). it
seems that the connection timeout values is being ignored. is this a
bug or is there a work around for this?
thanks,
bryan
More information about the pysqlite
mailing list