Bug 970473

Summary: visit page duplicates.cgi and 502 Proxy Error happened
Product: [Community] Bugzilla Reporter: wangjing <jingwang>
Component: PerformanceAssignee: PnT DevOps Devs <hss-ied-bugs>
Status: CLOSED CURRENTRELEASE QA Contact: tools-bugs <tools-bugs>
Severity: high Docs Contact:
Priority: high    
Version: 4.4CC: jmcdonal, rjoost
Target Milestone: 4.4   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2014-07-21 04:31:55 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:
Attachments:
Description Flags
screenshot for comment0 none

Description wangjing 2013-06-04 06:02:16 UTC
Created attachment 756625 [details]
screenshot for comment0

Description of problem:
visit page duplicates.cgi and 502 Proxy Error happened

Version-Release number of selected component (if applicable):
prod env version 4.4-3.3

How reproducible:
always

Steps to Reproduce:
1. click 'Most frequently reported bugs' in 'Most Common Actions' section on homepage. 
2. check the result.

Actual results:
502 Proxy Error

The proxy server received an invalid response from an upstream server.
The proxy server could not handle the request GET /duplicates.cgi.

Reason: Error reading from remote server

Expected results:
duplicates.cgi page would be shown up.

Additional info:
screenshot attched.

Comment 1 wangjing 2013-06-04 07:18:17 UTC
more infos for this bug:
tried for 4 times on prod env, always happened this problem as comment0.
tried for 3 times on QE test env, 2 times correct but one time met errors like:

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, sysadmin-engops and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

Comment 4 Jason McDonald 2013-10-15 07:16:15 UTC
This behaviour still happens on the production server, taking around two minutes to show the 502 error page, but does not cause a long query timeout notification to be sent to the admin list.

Comment 6 Jason McDonald 2014-07-21 04:31:55 UTC
This issue appears to have been fixed by the recent migration to the new webservers and mod_perl.

Now, visiting https://bugzilla.redhat.com/duplicates.cgi takes about 15 seconds the first time and about 5 seconds on subsequent visits (the speedup being due to the caching performed by both the database and mod_perl).

This suggests that the problem was on the webserver side, which would explain the previously noted lack of a long query timeout notification from the database (and the apparent lack of related entries in the slow query logs).

Tested using Fedora 20 and Firefox 30.0.