800452 - MySQL deadlock when running multiple saved searched at exactly the same time

Status: RESOLVED DUPLICATE of bug 749540

(Bugzilla :: Query/Bug List, defect)

Description

[Denis Roy]

User Agent: Mozilla/5.0 (X11; Linux x86_64; rv:16.0) Gecko/20100101 Firefox/16.0
Build ID: 20121009125359

Steps to reproduce:

Four saved searches are launched at exactly the same time.  User has these queries in a Firefox folder.


Actual results:

Error 500 from Bugzilla.

Server reports:

[Thu Oct 11 13:37:53 2012] [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 /home/local/data/httpd/bugs.eclipse.org/html/bugzilla-2.20/Bugzilla/Search/Recent.pm line 71\n\tBugzilla::Search::Recent::create('Bugzilla::Search::Recent', 'HASH(0x5555598e3100)') called at /home/local/data/httpd/bugs.eclipse.org/html/bugzilla-2.20/Bugzilla/Search/Recent.pm line 81\n\tBugzilla::Search::Recent::create_placeholder('Bugzilla::Search::Recent') called at /home/local/data/httpd/bugs.eclipse.org/html/bugzilla-2.20/Bugzilla/CGI.pm line 449\n\tBugzilla::CGI::redirect_search_url('Bugzilla::CGI=HASH(0x555559938f50)') called at /home/local/data/httpd/bugs.eclipse.org/html/bugzilla-2.20/buglist.cgi line 71\n\tModPerl::ROOT::Bugzilla::ModPerl::ResponseHandler::home_local_data_httpd_bugs_2eeclipse_2eorg_html_bugzilla_2d2_2e20_buglist_2ecgi::handler('Apache2::RequestRec=SCALAR(0x5555597e3ab0)') called at /usr/lib/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/ModPerl/RegistryCooker.pm line 204\n\teval {...} called at /usr/lib/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/ModPerl/RegistryCooker.pm line 204\n\tModPerl::RegistryCooker::run('Bugzilla::ModPerl::ResponseHandler=HASH(0x55555989da80)') called at /usr/lib/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/ModPerl/RegistryCooker.pm line 170\n\tModPerl::RegistryCooker::default_handler('Bugzilla::ModPerl::ResponseHandler=HASH(0x55555989da80)') called at /usr/lib/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/ModPerl/Registry.pm line 31\n\tModPerl::Registry::handler('Bugzilla::ModPerl::ResponseHandler', 'Apache2::RequestRec=SCALAR(0x5555597e3ab0)') called at /home/local/data/httpd/bugs.eclipse.org/html/bugzilla-2.20/mod_perl.pl line 138\n\tBugzilla::ModPerl::ResponseHandler::handler('Bugzilla::ModPerl::ResponseHandler', 'Apache2::RequestRec=SCALAR(0x5555597e3ab0)') called at -e line 0\n\teval {...} called at -e line 0\n


Expected results:

Bugzilla 4.2.1 on mod_perl

Comment 1

[Denis Roy]

Please see: https://bugs.eclipse.org/bugs/show_bug.cgi?id=387269

Comment 3

[Denis Roy]

Not sure how I missed the dupe, but thanks.