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 sqlalchemy@googlegroups.com 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 -~----------~----~----~----~------~----~------~--~---
