trac error when adding a comment to a ticket

[lars.eggert@…]

Python Traceback

Traceback (most recent call last):
  File "/usr/local/lib/python2.4/site-packages/trac/web/main.py", line 315, in dispatch_request
    dispatcher.dispatch(req)
  File "/usr/local/lib/python2.4/site-packages/trac/web/main.py", line 200, in dispatch
    resp = chosen_handler.process_request(req)
  File "/usr/local/lib/python2.4/site-packages/trac/ticket/web_ui.py", line 259, in process_request
    self._do_save(req, db, ticket)
  File "/usr/local/lib/python2.4/site-packages/trac/ticket/web_ui.py", line 526, in _do_save
    cnum=internal_cnum)
  File "/usr/local/lib/python2.4/site-packages/trac/ticket/model.py", line 250, in save_changes
    (self.id, when, author, cnum, comment))
  File "/usr/local/lib/python2.4/site-packages/trac/db/util.py", line 47, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "/usr/local/lib/python2.4/site-packages/sqlite/main.py", line 237, in execute
    self.con._begin()
  File "/usr/local/lib/python2.4/site-packages/sqlite/main.py", line 503, in _begin
    self.db.execute("BEGIN")
OperationalError: database is locked

[Christian Boos]

Yeah, we know… Trac has still lots of progress to make regarding concurrent write access. See e.g. #3446.

However, by looking at the stacktrace, it seems you're still using an old version of PySqlite. Try to upgrade, it can help (latest stable is version 2.3.2).

[Christian Boos]

Funnily, I had also a lock at the first attempt I made to save the ticket comment above ;)

Traceback (most recent call last):
  File "/usr/lib/python2.3/site-packages/trac/web/main.py", line 316, in dispatch_request
    dispatcher.dispatch(req)
  File "/usr/lib/python2.3/site-packages/trac/web/main.py", line 201, in dispatch
    resp = chosen_handler.process_request(req)
  File "/usr/lib/python2.3/site-packages/trac/ticket/web_ui.py", line 259, in process_request
    self._do_save(req, db, ticket)
  File "/usr/lib/python2.3/site-packages/trac/ticket/web_ui.py", line 526, in _do_save
    cnum=internal_cnum)
  File "/usr/lib/python2.3/site-packages/trac/ticket/model.py", line 241, in save_changes
    (self[name], self.id))
  File "/usr/lib/python2.3/site-packages/trac/db/util.py", line 47, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "/usr/lib/python2.3/site-packages/trac/db/sqlite_backend.py", line 44, in execute
    args or [])
  File "/usr/lib/python2.3/site-packages/trac/db/sqlite_backend.py", line 36, in _rollback_on_error
    return function(self, *args, **kwargs)
OperationalError: database is locked