Description of problem: I've been doing a weekly report collection for last 3 years. my problem started since the upgrade (previous one, not the one last weekend - from 3.x to 4.x). when opening multiple reports in tabs in parallel i get two types of errors. refreshing the browser on each tab solves the problem. (error suggest to report to bugzilla-owner, which i did the week post the upgrade in an email dating june 4th 2012) How reproducible: allways Steps to Reproduce: 1. open a set of tabs (20-25) with a report in each Actual results: some tabs fail with[1] some tabs fail with [2] Expected results: all reports work, like they did prior to upgrade [1] The page isn't redirecting properly. Firefox has detected that the server is redirecting the request for this address in a way that will never complete. This problem can sometimes be caused by disabling or refusing to accept cookies. [2] 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(0x75a2760)') 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(0x6450810)') 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.
Can you give us some examples of the report URLs you are trying to access? And confirm that you are still having issues?
this is 100% reproducible for me still. this started only after the upgrade to 4.2 bugzilla btw. i have a folder of saved queries in firefox. i click 'open all in tabs'. this only happens for normal searches. reports don't have this issue. I'll send you the list of searches i use
(In reply to comment #0) > refreshing the browser on each tab solves the problem. Based on this statement, I'm closing the bug. It is clear there is no fault with the Bugzilla code itself. -- simon
*** Bug 830545 has been marked as a duplicate of this bug. ***
(In reply to comment #4) > (In reply to comment #0) > > refreshing the browser on each tab solves the problem. > > Based on this statement, I'm closing the bug. It is clear there is no fault > with the Bugzilla code itself. > > -- simon why is opening the queries in paralell, which worked 100% OK before bugzila upgrade is not an issue with bugzilla? it is clear the problem is not in the browser as well.
> why is opening the queries in paralell, which worked 100% OK before bugzila > upgrade is not an issue with bugzilla? > it is clear the problem is not in the browser as well. Because when you reload the page, it works fine. That means the problem isn't with the Bugzilla code. I also agree it's not a browser problem. See comment #5 for my recommended next step. -- simon
After further consideration of this issue, we believe we have found the cause of the deadlocking, and it is a change that was introduced in the upgrade to 4.2. We will fix this in the next release. This won't fix the redirection never completes issue however. I've never seen that happening before. If that happens after we make this change, can you please open a new bug for it, and if it applies to the same URLs all the time. -- simon
getting this again last few weeks in a similar scenario to comment 3: bugzilla version 4.2.5-8.3 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(0x1b82c190)') 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(0x1a5a7b10)') called at /var/www/html/bugzilla/buglist.cgi line 85 For help, please send mail to the webmaster (bugzilla-owner), giving this error message and the time and date of the error.
From what I can see, this should still work for up to 50 queries at the same time. The code has not changed.
Frankly, I'm not convinced that running 20+ queries in parallel should be a supported use-case for RH Bugzilla. Given the current system architecture (effectively 32 cores for running parallel database queries) and the well-publicized performance issues the system is experiencing, this behaviour strikes me as being rather inconsiderate to other users. This kind of heavy-weight report generation would be better directed to an offline data-warehousing system such as teiid. The queries above do not appear to change any data and therefore do not need to use the production Bugzilla system. Until further notice, please either run these queries in series rather than in parallel, or use an offline system (e.g. teiid) instead of the production system.
Closing, as per my previous comment.