OperationalError: database is locked

[bjakovcic]

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'6f7c58a96a6d79e049abb751',
 'field_browser_used': u'Firefox',
 'field_cc': u'',
 'field_component': u'ATS/Browser',
 'field_custom_category': u'',
 'field_custom_timeestimate': u'1',
 'field_custom_uid': u'',
 'field_description': u"When you actually click Apply on any job posting; you go to that company's job posting. On top all you will see is a text that says UVISOR; Jon has designed the header, located in Imaged Pages\\Job Posting.\r\n\r\nHTML that for the header.",
 'field_error_location': u'stage.uvisor.com',
 'field_finalization_status': u'0)None',
 'field_holds': u'None',
 'field_keywords': u'',
 'field_milestone': u'Beta',
 'field_owner': u'jolley',
 'field_priority': u'High',
 'field_reporter': u'bjakovcic',
 'field_severity': u'Notice',
 'field_summary': u'Add Banner for ATS Job Posting Page',
 'field_type': u'defect',
 'submit': u'Create ticket'}

User agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.2.6) Gecko/20100625 Firefox/3.6.6

System Information

Trac	0.12
CustomFieldAdmin	0.2.2
Genshi	0.6
mod_python	3.3.1
Pygments	1.3.1
pysqlite	2.3.2
Python	2.5.4 (r254:67916, Dec 23 2008, 15:10:54) [MSC v.1310 32 bit (Intel)]
RPC	1.0.6
setuptools	0.6c11
SQLite	3.3.4
Subversion	1.6.5 (r38866)
jQuery	1.4.2

Enabled Plugins

lightgreentheme	0.1
traccustomfieldadmin	0.2.2
tracrevtreeplugin	0.6.4dev
tracthemeengine	2.0.1
tracxmlrpc	1.0.6

Python Traceback

Traceback (most recent call last):
  File "c:\users\admini~1\appdata\local\temp\1\easy_install-pxxc08\Trac-0.12-py2.5-win32.egg.tmp\trac\web\main.py", line 513, in _dispatch_request
    dispatcher.dispatch(req)
  File "c:\users\admini~1\appdata\local\temp\1\easy_install-pxxc08\Trac-0.12-py2.5-win32.egg.tmp\trac\web\main.py", line 235, in dispatch
    resp = chosen_handler.process_request(req)
  File "c:\users\admini~1\appdata\local\temp\1\easy_install-pxxc08\Trac-0.12-py2.5-win32.egg.tmp\trac\ticket\web_ui.py", line 170, in process_request
    return self._process_newticket_request(req)
  File "c:\users\admini~1\appdata\local\temp\1\easy_install-pxxc08\Trac-0.12-py2.5-win32.egg.tmp\trac\ticket\web_ui.py", line 395, in _process_newticket_request
    self._do_create(req, ticket) # (redirected if successful)
  File "c:\users\admini~1\appdata\local\temp\1\easy_install-pxxc08\Trac-0.12-py2.5-win32.egg.tmp\trac\ticket\web_ui.py", line 1190, in _do_create
    ticket.insert()
  File "c:\users\admini~1\appdata\local\temp\1\easy_install-pxxc08\Trac-0.12-py2.5-win32.egg.tmp\trac\ticket\model.py", line 214, in insert
    @self.env.with_transaction(db)
  File "c:\users\admini~1\appdata\local\temp\1\easy_install-pxxc08\Trac-0.12-py2.5-win32.egg.tmp\trac\db\api.py", line 77, in transaction_wrapper
    fn(ldb)
  File "c:\users\admini~1\appdata\local\temp\1\easy_install-pxxc08\Trac-0.12-py2.5-win32.egg.tmp\trac\ticket\model.py", line 220, in do_insert
    [values[name] for name in std_fields])
  File "c:\users\admini~1\appdata\local\temp\1\easy_install-pxxc08\Trac-0.12-py2.5-win32.egg.tmp\trac\db\util.py", line 65, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "c:\users\admini~1\appdata\local\temp\1\easy_install-pxxc08\Trac-0.12-py2.5-win32.egg.tmp\trac\db\sqlite_backend.py", line 78, in execute
    result = PyFormatCursor.execute(self, *args)
  File "c:\users\admini~1\appdata\local\temp\1\easy_install-pxxc08\Trac-0.12-py2.5-win32.egg.tmp\trac\db\sqlite_backend.py", line 56, in execute
    args or [])
  File "c:\users\admini~1\appdata\local\temp\1\easy_install-pxxc08\Trac-0.12-py2.5-win32.egg.tmp\trac\db\sqlite_backend.py", line 48, in _rollback_on_error
    return function(self, *args, **kwargs)
OperationalError: database is locked

[Remy Blank]

This is one of our MostFrequentDuplicates (#3446), but that ticket is closed, and this is using 0.12.

Do you get that error systematically? Sometimes? Once?

[Christian Boos]

No feedback, closing.