replybot does not handle SQLite database locked concurrency well

Bug #382586 reported by Barry Warsaw
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Python Replybot
In Progress
High
Unassigned

Bug Description

Poorly formatted, but replybot can fail when committing the transaction if the
SQLite database is already locked.

Command died with
   status 1: "/usr/bin/replybot -s xxx". Command output: Traceback (most
   recent call last): File "/usr/bin/replybot", line 8, in <module>
   load_entry_point('replybot==5.0.0', 'console_scripts', 'replybot')() File
   "build/bdist.linux-i686/egg/botlib/main.py", line 71, in main File
   "build/bdist.linux-i686/egg/botlib/database.py", line 164, in __init__
   File
   "/usr/lib/python2.5/site-packages/storm-0.12-py2.5.egg/storm/store.py",
   line 105, in commit self.flush() File
   "/usr/lib/python2.5/site-packages/storm-0.12-py2.5.egg/storm/store.py",
   line 443, in flush self._flush_one(obj_info) File
   "/usr/lib/python2.5/site-packages/storm-0.12-py2.5.egg/storm/store.py",
   line 502, in _flush_one self._connection.execute(expr, noresult=True)
   File
   "//usr/lib/python2.5/site-packages/storm-0.12-py2.5.egg/storm/database.py",
   line 202, in execute self.raw_execute, statement, params) File
   "//usr/lib/python2.5/site-packages/storm-0.12-py2.5.egg/storm/database.py",
   line 317, in _check_disconnect return function(*args, **kwargs) File
   "/usr/lib/python2.5/site-packages/storm-0.12-py2.5.egg/storm/databases/sqlite.py",
   line 153, in raw_execute return Connection.raw_execute(self, statement,
   params) File
   "//usr/lib/python2.5/site-packages/storm-0.12-py2.5.egg/storm/database.py",
   line 283, in raw_execute raw_cursor.execute(statement, params)
   sqlite3.OperationalError: database is locked

Barry Warsaw (barry)
Changed in replybot:
importance: Undecided → High
status: New → Triaged
Barry Warsaw (barry)
Changed in replybot:
status: Triaged → In Progress
milestone: none → 5.1.0
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.