1. Christopher Grebs
  2. lodgeit-main
Issue #7 new

"OperationalError: (OperationalError) database is locked"

Anonymous created an issue

Hello. When I try to reply to paste I got error 500.

After it if I try to view pastes I got this: {{{ [Fri Jan 28 15:54:59 2011] [error] [client 256.256.256.256] mod_wsgi (pid=13409): Exception occurred processing WSGI script '/home/ lodgeit/lodgeit/lodgeit.wsgi'. [Fri Jan 28 15:54:59 2011] [error] [client 256.256.256.256] Traceback (most recent call last): [Fri Jan 28 15:54:59 2011] [error] [client 256.256.256.256] File "/usr/lib/pymodules/python2.6/werkzeug/wsgi.py", line 406, in call [Fri Jan 28 15:54:59 2011] [error] [client 256.256.256.256] return self.app(environ, start_response) [Fri Jan 28 15:54:59 2011] [error] [client 256.256.256.256] File "/home/lodgeit/lodgeit/lodgeit/application.py", line 63, in ca ll [Fri Jan 28 15:54:59 2011] [error] [client 256.256.256.256] resp = handler(**args) [Fri Jan 28 15:54:59 2011] [error] [client 256.256.256.256] File "/home/lodgeit/lodgeit/lodgeit/controllers/pastes.py", line 82, in new_paste [Fri Jan 28 15:54:59 2011] [error] [client 256.256.256.256] private=private [Fri Jan 28 15:54:59 2011] [error] [client 256.256.256.256] File "/home/lodgeit/lodgeit/lodgeit/utils.py", line 114, in render_to_response [Fri Jan 28 15:54:59 2011] [error] [client 256.256.256.256] context['new_replies'] = Paste.fetch_replies() [Fri Jan 28 15:54:59 2011] [error] [client 256.256.256.256] File "/home/lodgeit/lodgeit/lodgeit/models.py", line 105, in fetch_replies [Fri Jan 28 15:54:59 2011] [error] [client 256.256.256.256] .update(values={'handled': True}) [Fri Jan 28 15:54:59 2011] [error] [client 256.256.256.256] File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 2160, in update [Fri Jan 28 15:54:59 2011] [error] [client 256.256.256.256] result = session.execute(update_stmt, params=self._params) [Fri Jan 28 15:54:59 2011] [error] [client 256.256.256.256] File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/session.py",, line 735, in execute [Fri Jan 28 15:54:59 2011] [error] [client 256.256.256.256] clause, params or {}) [Fri Jan 28 15:54:59 2011] [error] [client 256.256.256.256] File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1157, in execute [Fri Jan 28 15:54:59 2011] [error] [client 256.256.256.256] params) [Fri Jan 28 15:54:59 2011] [error] [client 256.256.256.256] File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1237, in _execute_clauseelement [Fri Jan 28 15:54:59 2011] [error] [client 256.256.256.256] return self.execute_context(context) [Fri Jan 28 15:54:59 2011] [error] [client 256.256.256.256] File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1268, in execute_context [Fri Jan 28 15:54:59 2011] [error] [client 256.256.256.256] context.parameters[0], context=context) [Fri Jan 28 15:54:59 2011] [error] [client 256.256.256.256] File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1367, in _cursor_execute [Fri Jan 28 15:54:59 2011] [error] [client 256.256.256.256] context) [Fri Jan 28 15:54:59 2011] [error] [client 256.256.256.256] File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1360, in _cursor_execute [Fri Jan 28 15:54:59 2011] [error] [client 256.256.256.256] context) [Fri Jan 28 15:54:59 2011] [error] [client 256.256.256.256] File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/default.py", line 288, in do_execute [Fri Jan 28 15:54:59 2011] [error] [client 256.256.256.256] cursor.execute(statement, parameters) [Fri Jan 28 15:54:59 2011] [error] [client 256.256.256.256] OperationalError: (OperationalError) database is locked u'UPDATE pastes SET handled=? WHERE pastes.paste_id != pastes.paste_id' (True,) [Fri Jan 28 15:55:00 2011] [error] [client 256.256.256.256] mod_wsgi (pid=13409): Exception occurred processing WSGI script '/home/lodgeit/lodgeit/lodgeit.wsgi'. [Fri Jan 28 15:55:00 2011] [error] [client 256.256.256.256] Traceback (most recent call last): [Fri Jan 28 15:55:00 2011] [error] [client 256.256.256.256] File "/usr/lib/pymodules/python2.6/werkzeug/wsgi.py", line 406, in call [Fri Jan 28 15:55:00 2011] [error] [client 256.256.256.256] return self.app(environ, start_response) [Fri Jan 28 15:55:00 2011] [error] [client 256.256.256.256] File "/home/lodgeit/lodgeit/lodgeit/application.py", line 66, in call [Fri Jan 28 15:55:00 2011] [error] [client 256.256.256.256] resp = handler() [Fri Jan 28 15:55:00 2011] [error] [client 256.256.256.256] File "/home/lodgeit/lodgeit/lodgeit/controllers/static.py", line 32, in not_found [Fri Jan 28 15:55:00 2011] [error] [client 256.256.256.256] return render_to_response('not_found.html') [Fri Jan 28 15:55:00 2011] [error] [client 256.256.256.256] File "/home/lodgeit/lodgeit/lodgeit/utils.py", line 114, in render_to_response [Fri Jan 28 15:55:00 2011] [error] [client 256.256.256.256] context['new_replies'] = Paste.fetch_replies() [Fri Jan 28 15:55:00 2011] [error] [client 256.256.256.256] File "/home/lodgeit/lodgeit/lodgeit/models.py", line 105, in fetch_replies [Fri Jan 28 15:55:00 2011] [error] [client 256.256.256.256] .update(values={'handled': True}) [Fri Jan 28 15:55:00 2011] [error] [client 256.256.256.256] File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 2160, in update [Fri Jan 28 15:55:00 2011] [error] [client 256.256.256.256] result = session.execute(update_stmt, params=self._params) [Fri Jan 28 15:55:00 2011] [error] [client 256.256.256.256] File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/session.py", line 735, in execute [Fri Jan 28 15:55:00 2011] [error] [client 256.256.256.256] clause, params or {}) [Fri Jan 28 15:55:00 2011] [error] [client 256.256.256.256] File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1157, in execute [Fri Jan 28 15:55:00 2011] [error] [client 256.256.256.256] params) [Fri Jan 28 15:55:00 2011] [error] [client 256.256.256.256] File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1237, in _execute_clauseelement [Fri Jan 28 15:55:00 2011] [error] [client 256.256.256.256] return self.execute_context(context) [Fri Jan 28 15:55:00 2011] [error] [client 256.256.256.256] File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1268, in execute_context [Fri Jan 28 15:55:00 2011] [error] [client 256.256.256.256] context.parameters[0], context=context) [Fri Jan 28 15:55:00 2011] [error] [client 256.256.256.256] File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1367, in _cursor_execute [Fri Jan 28 15:55:00 2011] [error] [client 256.256.256.256] context) [Fri Jan 28 15:55:00 2011] [error] [client 256.256.256.256] File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1360, in _cursor_execute [Fri Jan 28 15:55:00 2011] [error] [client 256.256.256.256] context) [Fri Jan 28 15:55:00 2011] [error] [client 256.256.256.256] File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/default.py", line 288, in do_execute [Fri Jan 28 15:55:00 2011] [error] [client 256.256.256.256] cursor.execute(statement, parameters) [Fri Jan 28 15:55:00 2011] [error] [client 256.256.256.256] OperationalError: (OperationalError) database is locked u'UPDATE pastes SET handled=? WHERE pastes.paste_id != pastes.paste_id' (True,)

}}}