OperationalError: database is locked

[tzhirnova]

How to Reproduce

While doing a GET operation on /login, Trac issued an internal error.

(please provide additional details here)

Request parameters:

{}

User agent: Mozilla/5.0 (Windows NT 6.3; WOW64; rv:31.0) Gecko/20100101 Firefox/31.0

System Information

Trac	0.12.3
Trac	0.12.3
Babel	0.9.5
CustomFieldAdmin	0.2.5
Docutils	0.7
Genshi	0.6
mod_wsgi	2.5 (WSGIProcessGroup trac_wsgi_01 WSGIApplicationGroup %{GLOBAL})
Pygments	1.4dev-20110115
pysqlite	2.4.1
Python	2.5.2 (r252:60911, Jan 24 2010, 18:02:01) [GCC 4.3.2]
Python	2.5.2 (r252:60911, Jan 24 2010, 18:02:01) [GCC 4.3.2]
pytz	2008c
pytz	2008c
RPC	1.1.2
setuptools	0.6c12
setuptools	0.6c12
SQLite	3.7.3
Subversion	1.8.3 (r1516576)
jQuery	1.4.4

Enabled Plugins

BatchModify	0.8.0-trac0.12
customroadmap.webadminui	N/A
SecureSession	0.10dev-r1500
TracAnnouncer	0.12.1.dev
TracCustomFieldAdmin	0.2.5
TracCustomRoadmap	0.4
tracrpc.changeset	N/A
TracWysiwyg	0.12.0.3-r9676
TracXMLRPC	1.1.2
WorkflowEditorPlugin	1.0.4-r10056

Python Traceback

Traceback (most recent call last):
  File "/usr/local/lib/python2.5/site-packages/Trac-0.12.3-py2.5.egg/trac/web/main.py", line 522, in _dispatch_request
    dispatcher.dispatch(req)
  File "/usr/local/lib/python2.5/site-packages/Trac-0.12.3-py2.5.egg/trac/web/main.py", line 243, in dispatch
    resp = chosen_handler.process_request(req)
  File "/usr/local/lib/python2.5/site-packages/Trac-0.12.3-py2.5.egg/trac/web/auth.py", line 115, in process_request
    self._do_login(req)
  File "/usr/local/lib/python2.5/site-packages/Trac-0.12.3-py2.5.egg/trac/web/auth.py", line 153, in _do_login
    @self.env.with_transaction()
  File "/usr/local/lib/python2.5/site-packages/Trac-0.12.3-py2.5.egg/trac/db/api.py", line 78, in transaction_wrapper
    ldb.commit()
OperationalError: database is locked

[Jun Omae]

InstallationIssue.

See also

• search:'"OperationalError: database is locked"'
• MostFrequentDuplicates#a3446:Rateofdatabaseislockederrorsistoohighseeall
• PySqlite#OperationalError:databaseislocked

[Jun Omae]

Sorry for the mistake. A duplicate of #3446, one of MostFrequentDuplicates.

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

[Ryan J Ollos]

Replying to tzhirnova:

customroadmap.webadminui

N/A

…

TracCustomRoadmap

0.4

Side note: The ​CustomRoadmapPlugin is no longer needed since Trac 0.11. See the notice on the top of the ​CustomRoadmapPlugin page for more info.