1st step would be to ensure youre on the latest version of sqlite. second step would be to create a test program illustrating the behavior using pysqlite only (sqlalchemy doesn't have anything to do with sqlite lock timeout issues). if you can confirm that the timeout isnt working in that case, you can submit a bug report to pysqlite and/or sqlite. the sqlite devs are *very* responsive to issues.
On Nov 1, 2007, at 10:13 AM, Matthew Newhook wrote: > > I posted this message in the pylons group but as of yet have received > no response. > > http://groups.google.com/group/pylons-discuss/browse_frm/thread/ > 093ec04b48e49c3c?hl=en# > > I've been looking into this problem a little more. From my reading of > the SQLite documentation there should be a 5 second timeout by default > (I'm using pysqlite 2.3.2). Looking at the source this looks correct. > However, in testing my app when I get this exception there is > definitely no 5 second timeout! It happens immediately. I also tried > 500 seconds, and had no better luck. When I concurrently access my > webapp I immediately get this exception. > > Also the exception confuses me. The 'database is locked' text > indicates that the error is SQLITE_LOCKED which is documented as: > > SQLITE_LOCKED > > This return code is similar to SQLITE_BUSY in that it indicates > that the database is locked. But the source of the lock is a recursive > call to sqlite_exec. This return can only occur if you attempt to > invoke sqlite_exec from within a callback routine of a query from a > prior invocation of sqlite_exec. Recursive calls to sqlite_exec are > allowed as long as they do not attempt to write the same table. > > However, the documentation indicates that I should be getting > SQLITE_BUSY or IOERROR. > > Anyone have any ideas how to solve this problem? > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
