Bug 1457649

Summary:	search timeout sometimes generates a 500 error
Product:	[Community] Bugzilla	Reporter:	Jeff Fearn 🐞 <jfearn>
Component:	WebService	Assignee:	The Bugzilla Team 🤖 <bugbot>
Status:	CLOSED WORKSFORME	QA Contact:
Severity:	unspecified	Docs Contact:
Priority:	unspecified
Version:	4.4	CC:	mschorm, qgong
Target Milestone:	---
Target Release:	---
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:		Doc Type:	If docs needed, set a value
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2022-05-03 03:47:12 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 Jeff Fearn 🐞 2017-06-01 06:09:43 UTC

Sometimes the search timeout seems to trigger a 500 error in production. It's not reproducible and there is nothing that stands out int he logs :-/

## Example email from an affected user ###
I received this error page:

Please stand by ...

Bugzilla has suffered an internal error. Please save this page and send it to bugzilla-owner with details of what you were doing at the time this message appeared.

URL: https://bugzilla.redhat.com/buglist.cgi?query_format=specific&order=Importance&no_redirect=1&bug_status=__all__&product=Fedora&content=install+existing+partition

Template->process() failed twice.
First error: file error - recursion into 'global/user-error.html.tmpl'
Second error: file error - recursion into 'global/header.html.tmpl'

Bugzilla has suffered an internal error. Please save this page and send it to bugzilla-owner with details of what you were doing at the time this message appeared.

URL: https://bugzilla.redhat.com/buglist.cgi?query_format=specific&order=Importance&no_redirect=1&bug_status=__all__&product=Fedora&content=install+existing+partition

Template->process() failed twice.
First error: file error - recursion into 'global/code-error.html.tmpl'
Second error: file error - recursion into 'global/code-error.html.tmpl'

Bugzilla has suffered an internal error. Please save this page and send it to bugzilla-owner with details of what you were doing at the time this message appeared.

URL: https://bugzilla.redhat.com/buglist.cgi?query_format=specific&order=Importance&no_redirect=1&bug_status=__all__&product=Fedora&content=install+existing+partition

Template->process() failed twice.
First error: undef error - ModPerl::Util::exit: (120000) exit was called at /var/www/html/bugzilla/Bugzilla/Error.pm line 238
Second error: undef error - ModPerl::Util::exit: (120000) exit was called at /var/www/html/bugzilla/Bugzilla/Error.pm line 238

----------------------------------------------------------------------

What I was doing at the time:

I was logged in as ##REDACTED###.

I was at the search page, https://bugzilla.redhat.com/query.cgi

The page was set to the (default) "Simple Search" tab.

"Status" was set to "All".

"Product" was set to "Fedora".

"Words" was set to "install existing partition".

I clicked on "Search".

After a while, I received the above error report.

I attempted to perform the search a second time, and received exactly
the same error report again.

Comment 1 Jeff Fearn 🐞 2017-10-13 04:38:37 UTC

Just saw this on a devel server when a search timed out but the page never changed from "Please stand by...", not sure if it's related:

==> logs/bz.log <==
[2017/10/13 14:32:29.0] [obelisk.usersys.redhat.com;2611] [DEBUG] [/home/jfearn/public_html/bugzilla-bayot/buglist.cgi:10.64.40.24::0::] [Bugzilla::configure_log4perl Bugzilla.pm (300)] - START
[2017/10/13 14:32:29.0] [obelisk.usersys.redhat.com;2611] [DEBUG] [/home/jfearn/public_html/bugzilla-bayot/buglist.cgi:10.64.40.24::0::] [Bugzilla::configure_log4perl Bugzilla.pm (305)] - SCRIPT_NAME: /buglist.cgi
[2017/10/13 14:32:29.0] [obelisk.usersys.redhat.com;2611] [DEBUG] [/home/jfearn/public_html/bugzilla-bayot/buglist.cgi:10.64.40.24::0::] [Bugzilla::configure_log4perl Bugzilla.pm (306)] - QUERY_STRING: bug_status=NEW&bug_status=ASSIGNED&bug_status=POST&bug_status=MODIFIED&bug_status=ON_DEV&bug_status=ON_QA&bug_status=VERIFIED&bug_status=RELEASE_PENDING&bug_status=CLOSED&classification=Red%20Hat&longdesc=ondemand&longdesc_type=allwordssubstr&product=Red%20Hat%20Enterprise%20Linux%206&query_format=advanced&list_id=7856959
[2017/10/13 14:32:30.1073] [obelisk.usersys.redhat.com;2611] [INFO] [/home/jfearn/public_html/bugzilla-bayot/buglist.cgi:10.64.40.24::0::] [Bugzilla::Auth::_handle_login_result Bugzilla/Auth.pm (166)] - User jfearn logged in with Bugzilla::Auth::Login::Cookie on agent Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:55.0) Gecko/20100101 Firefox/55.0 from referer NONE

==> /var/log/httpd/access.log <==
[13/Oct/2017:14:32:30 +1000] 10.64.40.24 TLSv1.2 ECDHE-RSA-AES128-GCM-SHA256 "GET /skins/standard/global.css?1477633328 HTTP/1.1" 4581
[13/Oct/2017:14:32:30 +1000] 10.64.40.24 TLSv1.2 ECDHE-RSA-AES128-GCM-SHA256 "GET /skins/standard/global/body-back.gif HTTP/1.1" -

==> /var/log/httpd/error.log <==
[Fri Oct 13 14:33:30.435072 2017] [cgi:warn] [pid 25007] [client 10.64.40.24:41094] AH01220: Timeout waiting for output from CGI script /home/jfearn/public_html/bugzilla-bayot/buglist.cgi
[Fri Oct 13 14:33:30.435204 2017] [core:error] [pid 25007] (70007)The timeout specified has expired: [client 10.64.40.24:41094] AH00574: ap_content_length_filter: apr_bucket_read() failed

==> /var/log/httpd/access.log <==
[13/Oct/2017:14:32:28 +1000] 10.64.40.24 TLSv1.2 ECDHE-RSA-AES128-GCM-SHA256 "GET /buglist.cgi?bug_status=NEW&bug_status=ASSIGNED&bug_status=POST&bug_status=MODIFIED&bug_status=ON_DEV&bug_status=ON_QA&bug_status=VERIFIED&bug_status=RELEASE_PENDING&bug_status=CLOSED&classification=Red%20Hat&longdesc=ondemand&longdesc_type=allwordssubstr&product=Red%20Hat%20Enterprise%20Linux%206&query_format=advanced&list_id=7856959 HTTP/1.1" 509

Comment 4 Jeff Fearn 🐞 2018-05-13 22:48:35 UTC

*** Bug 1577604 has been marked as a duplicate of this bug. ***

Comment 6 Jeff Fearn 🐞 2022-05-03 03:47:12 UTC

This error hasn't happened since we migrated hosting platforms.