Bug 830545 - "Deadlock found when trying to get lock" when running multiple parallel queries
Summary: "Deadlock found when trying to get lock" when running multiple parallel queries
Keywords:
Status: CLOSED DUPLICATE of bug 840265
Alias: None
Product: Bugzilla
Classification: Community
Component: Performance
Version: 4.2
Hardware: Unspecified
OS: Unspecified
unspecified
unspecified
Target Milestone: ---
Assignee: Simon Green
QA Contact: tools-bugs
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2012-06-10 14:22 UTC by Itamar Heim
Modified: 2014-10-12 22:48 UTC (History)
1 user (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2012-10-09 05:38:32 UTC
Embargoed:


Attachments (Terms of Use)

Description Itamar Heim 2012-06-10 14:22:27 UTC
I have a set of queries i've been running weekly for the past few years (by opening multiple tabs in the browser)
since the upgrade, a few will fail on the below error and i need to run them again (then they work)


Software error:

DBD::mysql::db do failed: Deadlock found when trying to get lock; try restarting transaction [for Statement "DELETE FROM profile_search WHERE user_id = ? AND id <= ?"] at Bugzilla/Search/Recent.pm line 72
	Bugzilla::Search::Recent::create('Bugzilla::Search::Recent', 'HASH(0xf7ca680)') called at Bugzilla/Search/Recent.pm line 81
	Bugzilla::Search::Recent::create_placeholder('Bugzilla::Search::Recent') called at Bugzilla/CGI.pm line 449
	Bugzilla::CGI::redirect_search_url('Bugzilla::CGI=HASH(0x105bbcd0)') called at /var/www/html/bugzilla/buglist.cgi line 86

For help, please send mail to the webmaster (bugzilla-owner), giving this error message and the time and date of the error.

Comment 1 Simon Green 2012-10-09 05:38:32 UTC

*** This bug has been marked as a duplicate of bug 840265 ***


Note You need to log in before you can comment on or make changes to this bug.