OperationalError: database is locked

[musa.al-ghazali@…]

How to Reproduce

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

(please provide additional details here)

Request parameters:

{'__FORM_TOKEN': u'f0a0245d1ecb9d90a759b9b5',
 'action': u'leave',
 'cnum': u'9',
 'comment': u'Hi Sanjaya, \r\n\r\nIs works perfectly now. \r\nYou can close the ticket. \r\nthx. ',
 'field_cc': u'',
 'field_checkbox_public': u'1',
 'field_description': u"Hi, \r\nwe do not receive data in labka dashboard's? \r\nIs not the first time, it happens often.",
 'field_reporter': u'musa.al-ghazali@regionh.dk',
 'field_severity': u'normal',
 'field_summary': u'CIMT: Labka dashboard',
 'field_type': u'defect',
 'id': u'3261',
 'replyto': u'',
 'submit': u'Submit changes',
 'ts': u'2015-05-14 08:30:32.146307+00:00'}

User agent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/42.0.2311.152 Safari/537.36

System Information

Trac	0.12.2
Docutils	0.8.1
Genshi	0.6
Pygments	1.4
pysqlite	2.6.0
Python	2.7.3 (default, Feb 27 2014, 19:58:35) [GCC 4.6.3]
setuptools	7.0
SQLite	3.7.9
jQuery	1.4.2

Enabled Plugins

CustomerIntegration	1.0
FlexibleAssignTo	0.8.13
TracAccountManager	0.2.1dev-r4679

Python Traceback

Traceback (most recent call last):
  File "/usr/local/lib/python2.7/dist-packages/Trac-0.12.2-py2.7.egg/trac/web/main.py", line 511, in _dispatch_request
    dispatcher.dispatch(req)
  File "/usr/local/lib/python2.7/dist-packages/Trac-0.12.2-py2.7.egg/trac/web/main.py", line 237, in dispatch
    resp = chosen_handler.process_request(req)
  File "/usr/local/lib/python2.7/dist-packages/Trac-0.12.2-py2.7.egg/trac/ticket/web_ui.py", line 169, in process_request
    return self._process_ticket_request(req)
  File "/usr/local/lib/python2.7/dist-packages/Trac-0.12.2-py2.7.egg/trac/ticket/web_ui.py", line 586, in _process_ticket_request
    self._do_save(req, ticket, action)
  File "/usr/local/lib/python2.7/dist-packages/Trac-0.12.2-py2.7.egg/trac/ticket/web_ui.py", line 1311, in _do_save
    cnum=internal_cnum):
  File "/usr/local/lib/python2.7/dist-packages/Trac-0.12.2-py2.7.egg/trac/ticket/model.py", line 296, in save_changes
    @self.env.with_transaction(db)
  File "/usr/local/lib/python2.7/dist-packages/Trac-0.12.2-py2.7.egg/trac/db/api.py", line 78, in transaction_wrapper
    ldb.commit()
OperationalError: database is locked

[Jun Omae]

MostFrequentDuplicates: You created the same of #12061 and #12071, again and again. Please stop it.

[Jun Omae]

Also, if rate of the issue is too high, we recommend to use PostgreSQL or MySQL rather than SQLite.