OperationalError: database is locked

[gkruse@…]

How to Reproduce

Run a long bitten build and other trac operations fail saying DB is locked.

System Information

Trac	0.11.2.1
Python	2.5.2 (r252:60911, Jul 31 2008, 17:49:46) [GCC 4.2.3 (Ubuntu 4.2.3-2ubuntu7)]
setuptools	0.6c8
SQLite	3.4.2
pysqlite	2.3.2
Genshi	0.5
mod_python	3.3.1
Pygments	0.9
Subversion	1.4.6 (r28521)

Python Traceback

Traceback (most recent call last):
  File "/usr/lib/python2.5/site-packages/Trac-0.11.2.1-py2.5.egg/trac/web/main.py", line 432, in _dispatch_request
    dispatcher.dispatch(req)
  File "/usr/lib/python2.5/site-packages/Trac-0.11.2.1-py2.5.egg/trac/web/main.py", line 229, in dispatch
    req.session.save()
  File "/usr/lib/python2.5/site-packages/Trac-0.11.2.1-py2.5.egg/trac/web/session.py", line 97, in save
    (self.sid,))
  File "/usr/lib/python2.5/site-packages/Trac-0.11.2.1-py2.5.egg/trac/db/util.py", line 50, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "/usr/lib/python2.5/site-packages/Trac-0.11.2.1-py2.5.egg/trac/db/sqlite_backend.py", line 58, in execute
    args or [])
  File "/usr/lib/python2.5/site-packages/Trac-0.11.2.1-py2.5.egg/trac/db/sqlite_backend.py", line 50, in _rollback_on_error
    return function(self, *args, **kwargs)
OperationalError: database is locked

[Christian Boos]

Please report this in the Bitten Trac.

Connections shouldn't be kept alive for long periods of time, so hopefully there's something that can be improved on the Bitten side, on that respect.

[Emmanuel Blot]

See ​ticket:269 Link does not work yet, as InterTrac needs some update.