Bug 1796259

Summary:	loading subscriptions page is very slow
Product:	Red Hat Satellite	Reporter:	matt jia <mjia>
Component:	Subscription Management	Assignee:	satellite6-bugs <satellite6-bugs>
Status:	CLOSED ERRATA	QA Contact:	Cole Higgins <chiggins>
Severity:	urgent	Docs Contact:
Priority:	unspecified
Version:	6.6.0	CC:	hyu, sadas
Target Milestone:	6.8.0	Keywords:	Triaged
Target Release:	Unused
Hardware:	All
OS:	Unspecified
Whiteboard:
Fixed In Version:		Doc Type:	If docs needed, set a value
Doc Text:		Story Points:	---
Clone Of:
Clones:	1851165 (view as bug list)		Environment:
Last Closed:	2020-10-27 13:00:15 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 matt jia 2020-01-30 01:31:20 UTC

Description of problem:

Due to this Bug 1796258, loading subscriptions page is very slow. In one customer's env, it takes 15 mins+ to load the page which leads a very bad user experience. 


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

6.6

How reproducible:

Normal

Steps to Reproduce:

Set up a Satellite server with 3k+ hypervisors which will create 3k+ pools in the candlepin.

Actual results:

Loading the subscription page is very slow.

Expected results:

It should be quick to load the subscriptions page.

Comment 4 Bryan Kearney 2020-02-02 21:02:04 UTC

Moving this bug to POST for triage into Satellite 6 since the upstream issue https://projects.theforeman.org/issues/28894 has been resolved.

Comment 9 errata-xmlrpc 2020-10-27 13:00:15 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 (Important: Satellite 6.8 release), 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-2020:4366