Page MenuHomePhabricator

"Lock timeout exceeded" at Bugzilla/Search/Recent.pm line 72
Closed, ResolvedPublic

Description

While trying to get a list of all bugs marked as RESOLVED FIXED for some specific components from a specific date[1], I got the following software error message:

Software error:

DBD::mysql::db do failed: Lock wait timeout exceeded; 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(0x454fa18)') called at Bugzilla/Search/Recent.pm line 81
Bugzilla::Search::Recent::create_placeholder('Bugzilla::Search::Recent') called at Bugzilla/CGI.pm line 467
Bugzilla::CGI::redirect_search_url('Bugzilla::CGI=HASH(0x478a380)') called at /srv/org/wikimedia/bugzilla/buglist.cgi line 70

For help, please send mail to the webmaster (webmaster@wikimedia.org), giving this error message and the time and date of the error.

I was able to avoid this happening again by refreshing the page (Ctrl + R).

References


Version: wmf-deployment
Severity: normal
See Also:
https://bugzilla.mozilla.org/show_bug.cgi?id=749540

Details

Reference
bz60727

Related Objects

Event Timeline

bzimport raised the priority of this task from to Low.Nov 22 2014, 3:03 AM
bzimport set Reference to bz60727.
bzimport added a subscriber: Unknown Object (MLST).

Probably needs upstreaming

Might also be worth swapping mysql out for mariadb on the misc db host that bugzilla etc use

For "DELETE FROM profile_search WHERE user_id = ? AND id <= ?"" I found https://bugzilla.mozilla.org/show_bug.cgi?id=749540 to be fixed in 4.4.

Presumably fixed by our Bugzilla upgrade to 4.4 which took place earlier today