OperationalError: database is locked

[amanshahi]

How to Reproduce

While doing a GET operation on /prefs/userinterface, Trac issued an internal error.

(please provide additional details here)

Request parameters:

{'panel_id': u'userinterface'}

User agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:41.0) Gecko/20100101 Firefox/41.0

System Information

System information not available

Enabled Plugins

Plugin information not available

Python Traceback

Traceback (most recent call last):
  File "build/bdist.linux-x86_64/egg/trac/web/main.py", line 554, in _dispatch_request
    dispatcher.dispatch(req)
  File "build/bdist.linux-x86_64/egg/trac/web/main.py", line 212, in dispatch
    self._pre_process_request(req, chosen_handler)
  File "build/bdist.linux-x86_64/egg/trac/web/main.py", line 375, in _pre_process_request
    chosen_handler = filter_.pre_process_request(req, chosen_handler)
  File "/usr/local/lib/python2.7/site-packages/acct_mgr/register.py", line 479, in pre_process_request
    if not req.session.authenticated:
  File "build/bdist.linux-x86_64/egg/trac/web/api.py", line 355, in __getattr__
    value = self.callbacks[name](self)
  File "build/bdist.linux-x86_64/egg/trac/web/main.py", line 302, in _get_session
    return Session(self.env, req)
  File "build/bdist.linux-x86_64/egg/trac/web/session.py", line 205, in __init__
    if req.authname == 'anonymous':
  File "build/bdist.linux-x86_64/egg/trac/web/api.py", line 355, in __getattr__
    value = self.callbacks[name](self)
  File "build/bdist.linux-x86_64/egg/trac/web/main.py", line 161, in authenticate
    authname = authenticator.authenticate(req)
  File "/usr/local/lib/python2.7/site-packages/acct_mgr/util.py", line 82, in wrap
    return func(self, *args, **kwds)
  File "/usr/local/lib/python2.7/site-packages/acct_mgr/web_ui.py", line 374, in authenticate
    return auth.LoginModule.authenticate(self, req)
  File "build/bdist.linux-x86_64/egg/trac/web/auth.py", line 91, in authenticate
    req.incookie['trac_auth'])
  File "/usr/local/lib/python2.7/site-packages/acct_mgr/web_ui.py", line 448, in _get_name_for_cookie
    name = auth.LoginModule._get_name_for_cookie(self, req, cookie)
  File "build/bdist.linux-x86_64/egg/trac/web/auth.py", line 244, in _get_name_for_cookie
    name = self._cookie_to_name(req, cookie)
  File "build/bdist.linux-x86_64/egg/trac/web/auth.py", line 240, in _cookie_to_name
    for name, in self.env.db_query(sql, args):
  File "build/bdist.linux-x86_64/egg/trac/db/api.py", line 124, in execute
    return db.execute(query, params)
  File "build/bdist.linux-x86_64/egg/trac/db/util.py", line 128, in execute
    cursor.execute(query, params if params is not None else [])
  File "build/bdist.linux-x86_64/egg/trac/db/util.py", line 72, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "build/bdist.linux-x86_64/egg/trac/db/sqlite_backend.py", line 82, in execute
    result = PyFormatCursor.execute(self, *args)
  File "build/bdist.linux-x86_64/egg/trac/db/sqlite_backend.py", line 60, in execute
    args or [])
  File "build/bdist.linux-x86_64/egg/trac/db/sqlite_backend.py", line 52, in _rollback_on_error
    return function(self, *args, **kwargs)
OperationalError: database is locked

[quozl]

so we have

• trac backed by sqlite,
• database was locked at the time of transaction.

please retry. it works for me now without error.