OperationalError: database is locked

[guischarf]

How to Reproduce

While doing a POST operation on /ticket/10712, Trac issued an internal error.

(please provide additional details here)

Request parameters:

{'__FORM_TOKEN': u'364b237a46778f1c79a01538',
 'action': u'leave',
 'cnum': u'6',
 'comment': u'Forgot to mention that this started to happen when we upgraded from 2.8.0 to 2.8.3',
 'field_component': u'General',
 'field_keywords': u'subcategories',
 'field_milestone': u'Unassigned',
 'field_priority': u'normal',
 'field_severity': u'normal',
 'field_summary': u'Sub categories automatically append a dash followed by the name of the parent',
 'field_type': u'defect (bug)',
 'field_version': u'2.8.3',
 'id': u'10712',
 'replyto': u'',
 'submit': u'Submit changes',
 'ts': u'2009-09-06 00:13:11+00:00'}

User Agent was: Mozilla/5.0 (Windows; U; Windows NT 5.1; es-ES; rv:1.9.1.2) Gecko/20090729 Firefox/3.5.2 (.NET CLR 3.5.30729)

System Information

Trac	0.11.4
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
Subversion	1.4.2 (r22196)
jQuery:	1.2.6

Python Traceback

Traceback (most recent call last):
  File "/usr/lib/python2.4/site-packages/Trac-0.11.4-py2.4.egg/trac/web/main.py", line 435, in _dispatch_request
    dispatcher.dispatch(req)
  File "/usr/lib/python2.4/site-packages/Trac-0.11.4-py2.4.egg/trac/web/main.py", line 205, in dispatch
    resp = chosen_handler.process_request(req)
  File "/usr/lib/python2.4/site-packages/Trac-0.11.4-py2.4.egg/trac/ticket/web_ui.py", line 182, in process_request
    return self._process_ticket_request(req)
  File "/usr/lib/python2.4/site-packages/Trac-0.11.4-py2.4.egg/trac/ticket/web_ui.py", line 508, in _process_ticket_request
    self._do_save(req, ticket, action)
  File "/usr/lib/python2.4/site-packages/Trac-0.11.4-py2.4.egg/trac/ticket/web_ui.py", line 1014, in _do_save
    cnum=internal_cnum):
  File "/usr/lib/python2.4/site-packages/Trac-0.11.4-py2.4.egg/trac/ticket/model.py", line 283, in save_changes
    (self.id, when_ts, author, cnum, comment))
  File "/usr/lib/python2.4/site-packages/Trac-0.11.4-py2.4.egg/trac/db/util.py", line 50, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "/usr/lib/python2.4/site-packages/Trac-0.11.4-py2.4.egg/trac/db/sqlite_backend.py", line 58, in execute
    args or [])
  File "/usr/lib/python2.4/site-packages/Trac-0.11.4-py2.4.egg/trac/db/sqlite_backend.py", line 50, in _rollback_on_error
    return function(self, *args, **kwargs)
OperationalError: database is locked

[dd32]

That error pops up occasionally when the database is locked by another write process i think.. Hitting back and attempting again will pretty much all the time resolve it.