OperationalError: (1213, 'Deadlock found when trying to get lock; try restarting transaction')

[Anuarbek]

How to Reproduce

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

(please provide additional details here)

User Agent was: Mozilla/5.0 (Windows NT 5.1; rv:2.0.1) Gecko/20100101 Firefox/4.0.1

System Information

Trac	0.11b2
Python	2.5.1 (r251:54863, Sep 22 2007, 01:43:31) [GCC 4.2.1 (SUSE Linux)]
setuptools	0.6c3
MySQL	server: "5.0.45-log", client: "5.0.45", thread-safe: 0
MySQLdb	1.2.1_p2
Genshi	0.6dev-r895
Pygments	1.0
RPC	1.0.6
Subversion	1.4.4 (r25188)
jQuery:	1.2.3

Python Traceback

Traceback (most recent call last):
  File "/usr/lib/python2.5/site-packages/Trac-0.11b2-py2.5.egg/trac/web/main.py", line 419, in _dispatch_request
    dispatcher.dispatch(req)
  File "/usr/lib/python2.5/site-packages/Trac-0.11b2-py2.5.egg/trac/web/main.py", line 196, in dispatch
    resp = chosen_handler.process_request(req)
  File "/usr/lib/python2.5/site-packages/Trac-0.11b2-py2.5.egg/trac/web/auth.py", line 104, in process_request
    self._redirect_back(req)
  File "/usr/lib/python2.5/site-packages/Trac-0.11b2-py2.5.egg/trac/web/auth.py", line 205, in _redirect_back
    req.redirect(referer or req.abs_href())
  File "/usr/lib/python2.5/site-packages/Trac-0.11b2-py2.5.egg/trac/web/api.py", line 266, in redirect
    self.session.save() # has to be done before the redirect is sent
  File "/usr/lib/python2.5/site-packages/Trac-0.11b2-py2.5.egg/trac/web/session.py", line 209, in save
    (mintime,))
  File "/usr/lib/python2.5/site-packages/Trac-0.11b2-py2.5.egg/trac/db/util.py", line 50, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "/usr/lib/python2.5/site-packages/Trac-0.11b2-py2.5.egg/trac/db/util.py", line 50, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "/usr/lib/python2.5/site-packages/MySQLdb/cursors.py", line 163, in execute
    self.errorhandler(self, exc, value)
  File "/usr/lib/python2.5/site-packages/MySQLdb/connections.py", line 35, in defaulterrorhandler
    raise errorclass, errorvalue
OperationalError: (1213, 'Deadlock found when trying to get lock; try restarting transaction')

[Kitson Kelly]

Closing down a transitory infrastructure ticket...