Bug 1608597

Summary: Content Host Applicable Package List page can DOS Satellite
Product: Red Hat Satellite Reporter: Mike McCune <mmccune>
Component: Content ManagementAssignee: Mike McCune <mmccune>
Status: CLOSED ERRATA QA Contact: jcallaha
Severity: high Docs Contact:
Priority: unspecified    
Version: 6.3.2CC: andrew.schofield, dchaudha, pcreech
Target Milestone: UnspecifiedKeywords: PrioBumpField, Triaged
Target Release: Unused   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: tfm-rubygem-katello-3.4.5.78-1 Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of:
: 1610424 (view as bug list) Environment:
Last Closed: 2018-08-22 20:07: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:
Attachments:
Description Flags
Proposed Patch 001
none
tfm-rubygem-katello-3.4.5.74-2.RHBZ1608597.tar
none
verification video none

Description Mike McCune 2018-07-25 22:31:08 UTC 
1) Take large Satellite installation with 20,000 content hosts
2) Navigate to Content Host -> Pick a host with applicable Errata
3) Click Packages -> Applicable Packages
4) On large installations this page will never return (query takes 4h+ to complete).

During execution of said query, Postgres will consume 20-40GB of disk swapping out the query results, consuming way more resources than it should and slowing overall operations of the Satellite.
Comment 1 Mike McCune 2018-07-25 22:34:04 UTC 
Created attachment 1470560 [details]
Proposed Patch 001
Comment 3 Satellite Program 2018-07-26 00:09:02 UTC 
Upstream bug assigned to mmccune
Comment 4 Satellite Program 2018-07-26 00:09:04 UTC 
Upstream bug assigned to mmccune
Comment 5 Mike McCune 2018-07-26 18:58:14 UTC 
You can test this even on a Satellite with ~1000-2000 Hosts with applicable errata. The page will take 30-40 seconds to load before this patch.

With this update it will render quickly in under a second.
Comment 6 Satellite Program 2018-07-26 20:08:54 UTC 
Moving this bug to POST for triage into Satellite 6 since the upstream issue http://projects.theforeman.org/issues/24389 has been resolved.
Comment 7 Mike McCune 2018-07-26 21:27:15 UTC 
*** Satellite 6.3.2 Hotfix Instructions ***

1) download tfm-rubygem-katello-3.4.5.74-2.RHBZ1608597.tar from bug to Satellite server

2) untar archive

3) rpm -Uvh *.rpm

4) katello-service restart

5) resume operations
Comment 8 Mike McCune 2018-07-26 21:27:50 UTC 
Created attachment 1470886 [details]
tfm-rubygem-katello-3.4.5.74-2.RHBZ1608597.tar
Comment 12 jcallaha 2018-08-03 18:30:08 UTC 
Created attachment 1473222 [details]
verification video

Verified in Satellite 6.3.3 Snap 2.

I setup over 4k content hosts, each with 376 applicable packages.

Following the steps outlined in the initial report, I saw that that load times, of the applicable packages page, only took a couple of seconds. This is significantly lower than the 30s load times expected with only 1000 content hosts.

See attached webm for verification
Comment 13 jcallaha 2018-08-14 17:43:20 UTC 
*** Bug 1614354 has been marked as a duplicate of this bug. ***
Comment 14 errata-xmlrpc 2018-08-22 20:07:12 UTC 
Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory, and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

https://access.redhat.com/errata/RHBA-2018:2550