I'm getting errors in my application. Error - sqlalchemy.exceptions.SQLError: (OperationalError) database is locked u'INSERT INTO carts (user_id, "lastModified") VALUES (?, ?)' [0, None] Error - sqlalchemy.exceptions.SQLError: (OperationalError) database is locked u'INSERT INTO carts (user_id, "lastModified") VALUES (?, ?)' [0, None]
I'm currently using sqlite with pylons 0.9.5, SQLAlchemy 0.3.9 + pysqlite2. Evidently this can occur on any database operation. When this occurs the user, of course, gets an error 500. What is the recommended way to deal with this? What could be done is to wrap all such database operations in a while(true) try ... catch sleep; retry block, however, that seems very tedious and error prone and far better handled by the frame work. Any sage words? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "pylons-discuss" 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/pylons-discuss?hl=en -~----------~----~----~----~------~----~------~--~---
