Ticket #735 (closed Defect: worksforme)
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
Note: See
TracTickets for help on using
tickets.
database is migrated to PostgreSQL