Opened 7 years ago

Closed 7 years ago

#4974 closed defect (fixed)

OperationalError: database is locked

Reported by: amanshahi Owned by:
Priority: Unspecified by Maintainer Milestone: Unspecified
Component: Sugar Version: Unspecified
Severity: Unspecified Keywords:
Cc: Distribution/OS: Unspecified
Bug Status: Unconfirmed


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

Change History (1)

comment:1 Changed 7 years ago by quozl

  • Resolution set to fixed
  • Status changed from new to closed

so we have

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

please retry. it works for me now without error.

Note: See TracTickets for help on using tickets.