Bug 1418594

Summary:	update_subscription_facet_backend_data upgrade steps takes too long with 6k hosts registered
Product:	Red Hat Satellite	Reporter:	Jan Hutař <jhutar>
Component:	Upgrades	Assignee:	satellite6-bugs <satellite6-bugs>
Status:	CLOSED CURRENTRELEASE	QA Contact:	Katello QA List <katello-qa-list>
Severity:	medium	Docs Contact:
Priority:	unspecified
Version:	6.2.6	CC:	bbuckingham, egolov, fgarciad, inecas, jcallaha, jhutar, mbacovsk, sthirugn
Target Milestone:	Unspecified	Keywords:	Triaged
Target Release:	Unused
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:	2017-10-03 18:22:23 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 Jan Hutař 2017-02-02 09:53:05 UTC

Description of problem:
update_subscription_facet_backend_data upgrade steps takes too long with 6k hosts registered. It is still running, currently at >1 hour for 6k registered hosts on a HW: 24xIntel(R) Xeon(R) CPU X5650 @ 2.67GHz and 50GB RAM, load is slightly below 1.


Version-Release number of selected component (if applicable):
Upgrade from 6.2.6 to 6.2.7


How reproducible:
1 of 1


Steps to Reproduce:
1. Upgrade Satellite 6.2.6 with 6k content hosts registered (through
   4 capsules) to 6.2.7


Actual results:
It takes above 1 hour to execute step update_subscription_facet_backend_data, load is below 1.


Expected results:
Would be nice to have this step faster.

Comment 1 Jan Hutař 2017-02-02 16:24:11 UTC

At the end, it look 105 minutes to perform update_subscription_facet_backend_data upgrade step.

Comment 10 sthirugn@redhat.com 2017-10-03 18:22:23 UTC

Performance test team did not see this in recent runs with 6.2.11.  I am moving this to Closed CurrentRelease. Please feel free to reopen if this issue is seen again.