PEC "database is locked" in roadmap

[Alec Thomas]

I think Christian wanted this backtrace? If not, duly ignore.

Oops...

Trac detected an internal error:

database is locked
Traceback (most recent call last):
  File "/usr/lib/python2.3/site-packages/trac/web/modpython_frontend.py", line 206, in handler
    dispatch_request(mpr.path_info, mpr, env)
  File "/usr/lib/python2.3/site-packages/trac/web/main.py", line 139, in dispatch_request
    dispatcher.dispatch(req)
  File "/usr/lib/python2.3/site-packages/trac/web/main.py", line 79, in dispatch
    req.authname = self.authenticate(req)
  File "/usr/lib/python2.3/site-packages/trac/web/main.py", line 66, in authenticate
    authname = authenticator.authenticate(req)
  File "/usr/lib/python2.3/site-packages/trac/web/auth.py", line 49, in authenticate
    authname = self._get_name_for_cookie(req, req.incookie['trac_auth'])
  File "/usr/lib/python2.3/site-packages/trac/web/auth.py", line 156, in _get_name_for_cookie
    (cookie.value, req.remote_addr))
  File "/usr/lib/python2.3/site-packages/trac/db.py", line 219, in execute
    args or [])
  File "/usr/lib/python2.3/site-packages/trac/db.py", line 211, in _rollback_on_error
    return function(self, *args, **kwargs)
OperationalError: database is locked

[Christian Boos]

Thanks Alec, that's indeed what I was looking for!

We should definitely try to minimize further the causes of database locks.

[Alec Thomas]

Here's another during a ticket submission:

Traceback (most recent call last):
  File "/usr/lib/python2.3/site-packages/trac/web/modpython_frontend.py", line 206, in handler
    dispatch_request(mpr.path_info, mpr, env)
  File "/usr/lib/python2.3/site-packages/trac/web/main.py", line 139, in dispatch_request
    dispatcher.dispatch(req)
  File "/usr/lib/python2.3/site-packages/trac/web/main.py", line 107, in dispatch
    resp = chosen_handler.process_request(req)
  File "/usr/lib/python2.3/site-packages/trac/ticket/web_ui.py", line 83, in process_request
    self._do_create(req, db)
  File "/usr/lib/python2.3/site-packages/trac/ticket/web_ui.py", line 138, in _do_create
    ticket.insert(db=db)
  File "/usr/lib/python2.3/site-packages/trac/ticket/model.py", line 157, in insert
    [self[name] for name in std_fields] +
  File "/usr/lib/python2.3/site-packages/trac/db.py", line 219, in execute
    args or [])
  File "/usr/lib/python2.3/site-packages/trac/db.py", line 211, in _rollback_on_error
    return function(self, *args, **kwargs)
OperationalError: database is locked

[Christian Boos]

See:

• #3446, which focus on the reasons and long-term solutions
• #3503, which deals with the symptoms and a short-term solution