Ticket #735 (closed Defect: worksforme)

Opened 6 years ago

Last modified 6 years ago

sqlite database is locked

Reported by: dgf Owned by: dgf
Priority: Major Milestone:
Component: Trac Version:
Keywords: Cc:
Complexity: 3 Area: Runtime Environment
Module:

Description

since the trac server migration we have increased memory errors

Traceback (most recent call last):
  File "/usr/lib/python2.7/dist-packages/trac/web/api.py", line 458, in
send_error
    data, 'text/html')
  File "/usr/lib/python2.7/dist-packages/trac/web/chrome.py", line 831,
in render_template
    message = req.session.pop('chrome.%s.%d' % (type_, i))
  File "/usr/lib/python2.7/dist-packages/trac/web/api.py", line 228, in
__getattr__
    value = self.callbacks[name](self)
  File "/usr/lib/python2.7/dist-packages/trac/web/main.py", line 306, in
_get_session
    return Session(self.env, req)
  File "/usr/lib/python2.7/dist-packages/trac/web/session.py", line 213,
in __init__
    if req.authname == 'anonymous':
  File "/usr/lib/python2.7/dist-packages/trac/web/api.py", line 228, in
__getattr__
    value = self.callbacks[name](self)
  File "/usr/lib/python2.7/dist-packages/trac/web/main.py", line 165, in
authenticate
    authname = authenticator.authenticate(req)
  File "/usr/lib/pymodules/python2.7/acct_mgr/web_ui.py", line 389, in
wrap
    return func(self, *args, **kwds)
  File "/usr/lib/pymodules/python2.7/acct_mgr/web_ui.py", line 400, in
authenticate
    return auth.LoginModule.authenticate(self, req)
  File "/usr/lib/python2.7/dist-packages/trac/web/auth.py", line 83, in
authenticate
    authname = self._get_name_for_cookie(req, req.incookie['trac_auth'])
  File "/usr/lib/pymodules/python2.7/acct_mgr/web_ui.py", line 432, in
_get_name_for_cookie
    name = auth.LoginModule._get_name_for_cookie(self, req, cookie)
  File "/usr/lib/python2.7/dist-packages/trac/web/auth.py", line 217, in
_get_name_for_cookie
    (cookie.value,))
  File "/usr/lib/python2.7/dist-packages/trac/db/util.py", line 65, in
execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "/usr/lib/python2.7/dist-packages/trac/db/sqlite_backend.py",
line 78, in execute
    result = PyFormatCursor.execute(self, *args)
  File "/usr/lib/python2.7/dist-packages/trac/db/sqlite_backend.py",
line 56, in execute
    args or [])
  File "/usr/lib/python2.7/dist-packages/trac/db/sqlite_backend.py",
line 48, in _rollback_on_error
    return function(self, *args, **kwargs)
OperationalError: database is locked

one possible solution could be a database migration to postgres

Change History

comment:1 Changed 6 years ago by dgf

  • Status changed from new to accepted
  • Owner set to dgf

database is migrated to PostgreSQL

comment:2 Changed 6 years ago by jri

  • Status changed from accepted to closed
  • Resolution set to worksforme

Thank you, dgf!

Note: See TracTickets for help on using tickets.