OperationalError: database is locked

[cll@…]

How to Reproduce

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

(please provide additional details here)

Request parameters:

{'__FORM_TOKEN': u'7f4095fcdb119882fca582d6',
 'field_cc': u'ofp@aalborg.dk',
 'field_checkbox_public': u'1',
 'field_description': u'Customer: Aalborg Kommune\r\nSupport Connection: 10.99.0.10\r\n\r\nWhen setting up AD integration, the system fails with No response from Server\r\nIt looks like an internal server timeout \r\nWe have verified CN string, password, and more. \r\n\r\nPlease contact Ole, at ofp (a) aalborg.dk. 99317945 - He will be in the office between 9am-3pm Danish time\r\nHe will be able to supply username and password etc. \r\n\r\nMed venlig hilsen / Best regards\r\nClaus L\xf8ppenthien\r\n',
 'field_reporter': u'cll@dubex.dk',
 'field_severity': u'normal',
 'field_summary': u'AD intergration failing',
 'field_type': u'defect',
 'submit': u'Create ticket'}

User agent: Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/42.0.2311.135 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 170, in process_request
    return self._process_newticket_request(req)
  File "/usr/local/lib/python2.7/dist-packages/Trac-0.12.2-py2.7.egg/trac/ticket/web_ui.py", line 443, in _process_newticket_request
    self._do_create(req, ticket) # (redirected if successful)
  File "/usr/local/lib/python2.7/dist-packages/Trac-0.12.2-py2.7.egg/trac/ticket/web_ui.py", line 1266, in _do_create
    ticket.insert()
  File "/usr/local/lib/python2.7/dist-packages/Trac-0.12.2-py2.7.egg/trac/ticket/model.py", line 233, in insert
    @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: #12061, #12070, #12071, #12072 and #12081 from the same environment. If rate of the issue is too high, we recommend to use PostgreSQL or MySQL rather than SQLite. Please don't create the same issue.