id	summary	reporter	owner	description	type	status	priority	milestone	component	version	severity	resolution	keywords	cc
1488043	OperationalError: database is locked	tigerfoot		"==== How to Reproduce ====

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

''(please provide additional details here)''

Request parameters:
{{{
{'__FORM_TOKEN': u'2a917b7dd640890cfa894471',
 'action': u'leave',
 'cnum': u'10',
 'comment': u'Without the patch and imap = debug in rouncube I get in log \r\nIf I don\'t select message body and use Subject & from, it return a result of 12 messages, but if I select the body it fail\r\n{{{\r\n[17-Aug-2011 10:02:57 +0200]: S: * OK [CAPABILITY IMAP4rev1 LITERAL+ SASL-IR LOGIN-REFERRALS ID ENABLE IDLE AUTH=PLAIN] sigeom sa imap service ready.\r\n[17-Aug-2011 10:02:57 +0200]: C: A0001 ID (""name"" ""Roundcube Webmail"" ""version"" ""0.5.4"" ""php"" ""5.3.7RC6-dev"" ""os"" ""Linux"" ""command"" ""/?_task=mail&_remote=1&_action=search&_q=Sch%C3%BCl&_mbox=INBOX&_headers=subject,from,text&_filter=ALL&_=1313568177879&_unlock=loading1313568177878"")\r\n[17-Aug-2011 10:02:57 +0200]: S: * ID NIL\r\n[17-Aug-2011 10:02:57 +0200]: S: A0001 OK ID completed.\r\n[17-Aug-2011 10:02:57 +0200]: C: A0002 AUTHENTICATE PLAIN c2lnZW9tLnN2ZwBzaWdlb20uc3ZnAEdlY29tby4uQWRtaW4=\r\n[17-Aug-2011 10:02:57 +0200]: S: A0002 OK [CAPABILITY IMAP4rev1 LITERAL+ SASL-IR LOGIN-REFERRALS ID ENABLE IDLE SORT SORT=DISPLAY THREAD=REFERENCES THREAD=REFS MULTIAPPEND UNSELECT CHILDREN NAMESPACE UIDPLUS LIST-EXTENDED I18NLEVEL=1 CONDSTORE QRESYNC ESEARCH ESORT SEARCHRES WITHIN CONTEXT=SEARCH LIST-STATUS QUOTA] Logged in\r\n[17-Aug-2011 10:02:57 +0200]: C: A0003 SELECT INBOX\r\n[17-Aug-2011 10:02:57 +0200]: S: * FLAGS (\\Answered \\Flagged \\Deleted \\Seen \\Draft NonJunk Junk $Forwarded $MDNSent)\r\n[17-Aug-2011 10:02:57 +0200]: S: * OK [PERMANENTFLAGS (\\Answered \\Flagged \\Deleted \\Seen \\Draft NonJunk Junk $Forwarded $MDNSent \\*)] Flags permitted.\r\n[17-Aug-2011 10:02:57 +0200]: S: * 1161 EXISTS\r\n[17-Aug-2011 10:02:57 +0200]: S: * 0 RECENT\r\n[17-Aug-2011 10:02:57 +0200]: S: * OK [UNSEEN 1160] First unseen.\r\n[17-Aug-2011 10:02:57 +0200]: S: * OK [UIDVALIDITY 1308748582] UIDs valid\r\n[17-Aug-2011 10:02:57 +0200]: S: * OK [UIDNEXT 3442] Predicted next UID\r\n[17-Aug-2011 10:02:57 +0200]: S: * OK [HIGHESTMODSEQ 4781] Highest\r\n[17-Aug-2011 10:02:57 +0200]: S: A0003 OK [READ-WRITE] Select completed.\r\n[17-Aug-2011 10:02:57 +0200]: C: A0004 SORT (DATE) UTF-8 ALL OR OR HEADER SUBJECT {6+}\r\n[17-Aug-2011 10:02:57 +0200]: C: Sch\xfcl HEADER FROM {6+}\r\n[17-Aug-2011 10:02:57 +0200]: C: Sch\xfcl TEXT {6+}\r\n[17-Aug-2011 10:02:57 +0200]: C: Sch\xfcl\r\n[17-Aug-2011 10:02:59 +0200]: S: * SORT 17 31 32 42 43 429 497 514 575 576 588 589 688 689 894 904 905 997 998 1006 1008 1007 1009 1022 1087\r\n}}}\r\nbut I didn\'t get the A0007 returned in the jquery console\r\n{{{\r\nthis.display_message(""Erreur du serveur: Unable to send command: A0007 SEARCH CHARSET US-ASCII OR OR HEADER SUBJECT {5}<br \\/>\\r\\nSchl HEADER FROM {5}<br \\/>\\r\\nSchl TEXT {5}<br \\/>\\r\\nSchl"",""error"",0); this.set_rowcount(""Bo\\u00eete aux lettres vide"");\r\n}}}',
 'field_component': u'IMAP connection',
 'field_keywords': u'IMAP search',
 'field_milestone': u'later',
 'field_priority': u'5',
 'field_severity': u'major',
 'field_summary': u'Incorrect IMAP search command syntax',
 'field_type': u'Bugs',
 'field_version': u'0.5.4',
 'id': u'1488038',
 'replyto': u'',
 'submit': u'Submit changes',
 'ts': u'2011-08-17 07:51:42.611616+00:00'}
}}}

User agent: `Mozilla/5.0 (X11; Linux x86_64; rv:6.0) Gecko/20100101 Firefox/6.0`

==== System Information ====
''System information not available''

==== Enabled Plugins ====
''Plugin information not available''

==== Python Traceback ====
{{{
Traceback (most recent call last):
  File ""/usr/local/lib/python2.6/dist-packages/Trac-0.12.2-py2.6.egg/trac/web/main.py"", line 511, in _dispatch_request
    dispatcher.dispatch(req)
  File ""/usr/local/lib/python2.6/dist-packages/Trac-0.12.2-py2.6.egg/trac/web/main.py"", line 237, in dispatch
    resp = chosen_handler.process_request(req)
  File ""/usr/local/lib/python2.6/dist-packages/Trac-0.12.2-py2.6.egg/trac/ticket/web_ui.py"", line 169, in process_request
    return self._process_ticket_request(req)
  File ""/usr/local/lib/python2.6/dist-packages/Trac-0.12.2-py2.6.egg/trac/ticket/web_ui.py"", line 537, in _process_ticket_request
    valid = self._validate_ticket(req, ticket, not valid) and valid
  File ""/usr/local/lib/python2.6/dist-packages/Trac-0.12.2-py2.6.egg/trac/ticket/web_ui.py"", line 1182, in _validate_ticket
    for field, message in manipulator.validate_ticket(req, ticket):
  File ""/usr/local/lib/python2.6/dist-packages/TracSpamFilter-0.4.7dev_r10669-py2.6.egg/tracspamfilter/adapters.py"", line 77, in validate_ticket
    FilterSystem(self.env).test(req, author, changes, ip)
  File ""/usr/local/lib/python2.6/dist-packages/TracSpamFilter-0.4.7dev_r10669-py2.6.egg/tracspamfilter/api.py"", line 178, in test
    score, ['%s (%d): %s' % r for r in reasons]).insert()
  File ""/usr/local/lib/python2.6/dist-packages/TracSpamFilter-0.4.7dev_r10669-py2.6.egg/tracspamfilter/model.py"", line 138, in insert
    '\n'.join(self.reasons)))
  File ""/usr/local/lib/python2.6/dist-packages/Trac-0.12.2-py2.6.egg/trac/db/util.py"", line 65, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File ""/usr/local/lib/python2.6/dist-packages/Trac-0.12.2-py2.6.egg/trac/db/sqlite_backend.py"", line 78, in execute
    result = PyFormatCursor.execute(self, *args)
  File ""/usr/local/lib/python2.6/dist-packages/Trac-0.12.2-py2.6.egg/trac/db/sqlite_backend.py"", line 56, in execute
    args or [])
  File ""/usr/local/lib/python2.6/dist-packages/Trac-0.12.2-py2.6.egg/trac/db/sqlite_backend.py"", line 48, in _rollback_on_error
    return function(self, *args, **kwargs)
OperationalError: database is locked
}}}"	Bugs	closed	5	later	Addressbook	0.5.4	normal	duplicate