Re: all python threads hung

dcharno <[email protected]>
Newsgroups gmane.comp.python.db.pysqlite.user
Message-ID <[email protected]> 
> Are you using the latest version of pysqlite? 2.3.5 has improved concurrency a little.
> 
> Of course pysqlite does release the GIL (*) when calling the SQLite API, so that 
> can hardly be the cause for your problem. One writer, multiple readers sounds like it should not be a problem, though.

I inserted log messages around all accesses to the database so I can see 
that the long delay is indeed coming from the database portion of the code.

I did find that if I use "BEGIN EXCLUSIVE" I get the delay I described. 
  If I use "BEGIN" or "BEGIN IMMEDIATE" the entire app locks up 
completely and never times out.
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.