Last modified: 2014-02-13 01:18:06 UTC
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 == * [1] https://bugzilla.wikimedia.org/buglist.cgi?list_id=203133&resolution=FIXED&chfieldto=Now&query_format=advanced&chfield=resolution&chfieldfrom=2014-01-30&product=MediaWiki
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
