OperationalError: database is locked

[rfair404]

How to Reproduce

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

(please provide additional details here)

Request parameters:

{'id': u'24'}

System Information

Trac	0.11.6
Python	2.4.4 (#1, Oct 22 2008, 20:17:05) [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.6-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.6-py2.4.egg/trac/web/main.py", line 229, in dispatch
    req.session.save()
  File "/usr/lib/python2.4/site-packages/Trac-0.11.6-py2.4.egg/trac/web/session.py", line 100, in save
    (self.sid,))
  File "/usr/lib/python2.4/site-packages/Trac-0.11.6-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.6-py2.4.egg/trac/db/sqlite_backend.py", line 80, in execute
    PyFormatCursor.execute(self, *args)
  File "/usr/lib/python2.4/site-packages/Trac-0.11.6-py2.4.egg/trac/db/sqlite_backend.py", line 59, in execute
    args or [])
  File "/usr/lib/python2.4/site-packages/Trac-0.11.6-py2.4.egg/trac/db/sqlite_backend.py", line 51, in _rollback_on_error
    return function(self, *args, **kwargs)
OperationalError: database is locked

[rfair404]

Screenshot of error.

[nacin]

Yea, happens sometimes...

[ryan]

Fixing this requires switching DB backends, which is on the big to-do list.

[scribu]

done

[nacin]

Servers have been shifted, but we're still on sqlite, not mysql. It'll happen eventually though. No problems closing this.