OperationalError: database is locked

[ctsttom]

How to Reproduce

While doing a GET operation on /report/16, Trac issued an internal error.

(please provide additional details here)

Request parameters:

{'asc': u'1', 'sort': u'priority', 'USER': u'ctsttom', 'id': u'16'}

System Information

Trac	0.11.7
Python	2.4.4 (#1, Jan 24 2010, 11:47:59) [GCC 4.1.2 20061115 (prerelease) (Debian 4.1.1-21)]
setuptools	0.6c9
SQLite	3.3.8
pysqlite	2.3.2
Genshi	0.5
Pygments	0.10
RPC	1.0.6
Subversion	1.4.2 (r22196)

Python Traceback

Traceback (most recent call last):
  File "/usr/lib/python2.4/site-packages/Trac-0.11.7-py2.4.egg/trac/web/main.py", line 450, in _dispatch_request
    dispatcher.dispatch(req)
  File "/usr/lib/python2.4/site-packages/Trac-0.11.7-py2.4.egg/trac/web/main.py", line 229, in dispatch
    req.session.save()
  File "/usr/lib/python2.4/site-packages/Trac-0.11.7-py2.4.egg/trac/web/session.py", line 101, in save
    (self.sid,))
  File "/usr/lib/python2.4/site-packages/Trac-0.11.7-py2.4.egg/trac/db/util.py", line 64, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "/usr/lib/python2.4/site-packages/Trac-0.11.7-py2.4.egg/trac/db/sqlite_backend.py", line 80, in execute
    result = PyFormatCursor.execute(self, *args)
  File "/usr/lib/python2.4/site-packages/Trac-0.11.7-py2.4.egg/trac/db/sqlite_backend.py", line 59, in execute
    args or [])
  File "/usr/lib/python2.4/site-packages/Trac-0.11.7-py2.4.egg/trac/db/sqlite_backend.py", line 51, in _rollback_on_error
    return function(self, *args, **kwargs)
OperationalError: database is locked

[nacin]

Just refresh the page and reissue the GET or POST request, and (eventually) it'll work.

We'll continue to see his sporadically until we move off sqllite, which is on the agenda but not high priority.