Bug 840265
Summary: | errors when opening multiple reports | ||
---|---|---|---|
Product: | [Community] Bugzilla | Reporter: | Itamar Heim <iheim> |
Component: | Query/Bug List | Assignee: | Simon Green <sgreen> |
Status: | CLOSED CANTFIX | QA Contact: | tools-bugs <tools-bugs> |
Severity: | unspecified | Docs Contact: | |
Priority: | unspecified | ||
Version: | 4.2 | CC: | ebaak, jingwang, jmcdonal |
Target Milestone: | --- | Keywords: | Regression, Reopened |
Target Release: | --- | ||
Hardware: | Unspecified | ||
OS: | Unspecified | ||
Whiteboard: | |||
Fixed In Version: | 4.2.4-6 | Doc Type: | Bug Fix |
Doc Text: | Story Points: | --- | |
Clone Of: | Environment: | ||
Last Closed: | 2013-07-25 01:47:13 UTC | Type: | Bug |
Regression: | --- | Mount Type: | --- |
Documentation: | --- | CRM: | |
Verified Versions: | Category: | --- | |
oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |
Cloudforms Team: | --- | Target Upstream Version: | |
Embargoed: |
Description
Itamar Heim
2012-07-15 06:55:45 UTC
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. |