Bug 1465146 - fetching list of applicable errata is slow with if lots of hosts need lots of errata
Summary: fetching list of applicable errata is slow with if lots of hosts need lots of...
Keywords:
Status: CLOSED ERRATA
Alias: None
Product: Red Hat Satellite
Classification: Red Hat
Component: Errata Management
Version: 6.2.10
Hardware: Unspecified
OS: Unspecified
unspecified
high
Target Milestone: Unspecified
Assignee: Justin Sherrill
QA Contact: jcallaha
URL:
Whiteboard:
Depends On: 1419139 1480355
Blocks: 1482208
TreeView+ depends on / blocked
 
Reported: 2017-06-26 19:00 UTC by Chris Duryee
Modified: 2022-07-09 09:22 UTC (History)
11 users (show)

Fixed In Version: rubygem-katello-3.0.0.161-1
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
: 1530699 (view as bug list)
Environment:
Last Closed: 2018-02-05 13:54:34 UTC
Target Upstream Version:
Embargoed:

Attachments (Terms of Use)
6.2.11 patch (4.26 KB, patch)
2017-08-16 15:50 UTC, Justin Sherrill 		no flags Details | Diff
rhel7_hotfix (3.56 MB, application/x-xz)
2017-09-06 21:29 UTC, Adam Price 		no flags Details
rhel6_hotfix (4.23 MB, application/x-xz)
2017-09-06 21:30 UTC, Adam Price 		no flags Details
verification screenshot 1 (241.49 KB, image/png)
2018-01-13 22:44 UTC, jcallaha 		no flags Details
View All


Links
System ID Private Priority Status Summary Last Updated
Foreman Issue Tracker 20167 0 Normal Closed fetching list of applicable errata is slow with if lots of hosts need lots of errata 2020-07-02 14:33:56 UTC
Red Hat Product Errata RHSA-2018:0273 0 normal SHIPPED_LIVE Important: Red Hat Satellite 6 security, bug fix, and enhancement update 2018-02-08 00:35:29 UTC

Description Chris Duryee 2017-06-26 19:00:32 UTC 
Description of problem:

If you have lots of hosts that need errata, fetching the "applicable" errata can be very slow.

Version-Release number of selected component (if applicable): 6.2.10

How reproducible: every time


Steps to Reproduce:
1. create lots of hosts that have applicable errata, or load up a database with this data
2. go to errata page

Actual results: waiting for minutes if either "applicable" or "installable" are checked

Expected results: page should load within 5-10 seconds
Comment 2 Justin Sherrill 2017-06-29 15:47:03 UTC 
Created redmine issue http://projects.theforeman.org/issues/20167 from this bug
Comment 3 Satellite Program 2017-06-29 18:18:21 UTC 
Upstream bug assigned to jsherril
Comment 4 Satellite Program 2017-06-29 18:18:24 UTC 
Upstream bug assigned to jsherril
Comment 6 Satellite Program 2017-07-13 02:17:04 UTC 
Moving this bug to POST for triage into Satellite 6 since the upstream issue http://projects.theforeman.org/issues/20167 has been resolved.
Comment 7 Satellite Program 2017-08-03 22:20:16 UTC 
Moving this bug to POST for triage into Satellite 6 since the upstream issue http://projects.theforeman.org/issues/20167 has been resolved.
Comment 8 Justin Sherrill 2017-08-16 15:50:00 UTC 
Created attachment 1314237 [details]
6.2.11 patch
Comment 9 Justin Sherrill 2017-08-16 15:52:55 UTC 
applying to 6.2.11:

download the patch to /tmp/
cd /opt/theforeman/tfm/root/usr/share/gems/gems/katello-3.0.0.144/
patch -p1 < /tmp/filename.patch

then restart httpd and foreman-tasks
Comment 11 Adam Price 2017-09-06 21:29:36 UTC 
Created attachment 1322818 [details]
rhel7_hotfix
Comment 12 Adam Price 2017-09-06 21:30:13 UTC 
Created attachment 1322819 [details]
rhel6_hotfix
Comment 13 Adam Price 2017-09-06 21:35:51 UTC 
=== HOTFIX INSTRUCTIONS FOR SATELLITE 6.2.11 ONLY ===

1. Download attached file bz1465146-hotfix-rpms-el7sat.tar.xz or bz1465146-hotfix-rpms-el6sat.tar.xz depending on your Satellite host OS version
2. Stop Satellite
  katello-service stop
3. Extract the tarball and install the packages
4. Start Satellite
  katello-service start
Comment 14 jcallaha 2018-01-13 19:37:18 UTC 
Verified in Satellite 6.2.14 Snap 1.

Registered over 5300 content hosts to the satellite, each with 102 applicable errata. Repeated reloads of the errata page took no more than 9 seconds, including refresh time. Average page load time appears to be around 4-4.5 seconds. 

See attached screenshot for load time confirmation.
Comment 15 jcallaha 2018-01-13 22:44:47 UTC 
Created attachment 1380829 [details]
verification screenshot 1
Comment 18 errata-xmlrpc 2018-02-05 13:54:34 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/RHSA-2018:0273
Note You need to log in before you can comment on or make changes to this bug.