OperationalError: (1205, 'Lock wait timeout exceeded; try restarting transaction')

Reported by:	anonymous	Owned by:	anonymous
Priority:	low	Milestone:	None
Component:	misc	Version:	1.6.2
Keywords:		Cc:	danheberden
Blocked by:		Blocking:

Description

How to Reproduce

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

''(please provide additional details here)''

Request parameters:

{'component': [u'!datalink', u'!global', u'!templates', u'!web'],
 'group': u'component',
 'order': u'priority',
 'report': u'1',
 'status': [u'assigned', u'new', u'open', u'reopened'],
 'type': u'bug'}

User agent: #USER_AGENT#

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.1-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.1-py2.6.egg/trac/web/main.py", line 260, in dispatch
    req.session.save()
  File "/usr/local/lib/python2.6/dist-packages/Trac-0.12.1-py2.6.egg/trac/web/session.py", line 153, in save
    @self.env.with_transaction()
  File "/usr/local/lib/python2.6/dist-packages/Trac-0.12.1-py2.6.egg/trac/db/api.py", line 77, in transaction_wrapper
    fn(ldb)
  File "/usr/local/lib/python2.6/dist-packages/Trac-0.12.1-py2.6.egg/trac/web/session.py", line 162, in purge_session_attributes
    """, (self.last_visit, self.sid, authenticated))
  File "/usr/local/lib/python2.6/dist-packages/Trac-0.12.1-py2.6.egg/trac/db/util.py", line 65, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "/usr/lib/pymodules/python2.6/MySQLdb/cursors.py", line 166, in execute
    self.errorhandler(self, exc, value)
  File "/usr/lib/pymodules/python2.6/MySQLdb/connections.py", line 35, in defaulterrorhandler
    raise errorclass, errorvalue
OperationalError: (1205, 'Lock wait timeout exceeded; try restarting transaction')

Attachments (0)

Change History (3)

Changed August 30, 2011 09:05PM UTC by timmywil comment:1

component:	unfiled → misc
owner:	→ anonymous
priority:	undecided → low
status:	new → pending

Thanks for taking the time to contribute to the jQuery project! Please provide a reduced test case on jsFiddle to help us assess your ticket.

Additionally, be sure to test against the jQuery Edge version to ensure the issue still exists. To get you started, use this boilerplate: http://jsfiddle.net/FrKyN/ Open the link and click to "Fork" (in the top menu) to get started.

This does not look like an issue with jQuery.

Changed August 31, 2011 02:04PM UTC by anonymous comment:2

status:	pending → new

So I want to see bugs, but it makes some error, and ask me if i want to report it. So I reported.

Changed September 02, 2011 07:15AM UTC by addyosmani comment:3

cc:	→ danheberden
resolution:	→ worksforme
status:	new → closed

Thanks for submitting a ticket! I think Timmy may have accidentally misread it :) I haven't personally been able to reproduce the behaviour mentioned, but what I'll do is CC one of our ops guys in on this to double check.

Side navigation

#10170 closed bug (worksforme)