Description of problem: If you have a satellite with a large number of hosts (perhaps 40K or more), the subscriptions page becomes unusable. It is reasonably fast to view the list of subs, but if you click one of the subscriptions, it can take hours for the page to return. Additionally, a large amount of memory is used by the passenger worker after this happens. Version-Release number of selected component (if applicable): 6.2.7 Steps to Reproduce: 1. register a large number of hosts, and have them all use the same pool 2. click subscriptions page, then click any subscription (doesn't have to be the sub with all the hosts) Actual results: time for page to return is slower than pizza delivery, passenger worker uses multiple GB of memory when complete. Expected results: page loads in under 5 seconds Additional info: the refactor to the hosts method in https://github.com/Katello/katello/commit/440b51d54a020885d2680ce9edeef01b477a28b4#diff-457d74b9b2d0b6a2f062d4ea6b414d4b seems to help, in that it will only be slow when clicking the pool with all the hosts attached instead of any pool. However, if you click the pool with the hosts, it is very slow.
Created redmine issue http://projects.theforeman.org/issues/19394 from this bug
Upstream bug assigned to jomitsch
Opened up an MR to add a setting that can set a number of hosts returned when viewing a subscription. This defaults to all hosts being returned, but can be changed by the user to any number. This can be the workaround for 6.2.z as we work on the proper fix upstream that will be included in 6.3
what is the impact of setting the number to something low? for example, what would happen if I set it to 10?
Had a discussion with Chris off-thread about the fix. I updated the MR to use a setting that disables host data being returned when an individual subscription is called. When this is disabled, the subscriptions return much faster, but the associations > content hosts tab will not show anything. I'm updating the MR to reflect this in the UI message. This is just a workaround for blocked users in 6.2 until we fix this properly upstream and include the proper fix in 6.3
*** Bug 1409815 has been marked as a duplicate of this bug. ***
Moving this bug to POST for triage into Satellite 6 since the upstream issue http://projects.theforeman.org/issues/19394 has been resolved.
Hi, would it be at least possible to keep track of the number of the consumer hosts? Or does user has to iterate through all of them to get the numbers?
Hey Roman, I responded to your question on the PR here https://github.com/Katello/katello/pull/6885#issuecomment-339009910 Let me know if you need more information. -John
(In reply to John Mitsch from comment #13) > Hey Roman, > > I responded to your question on the PR here > https://github.com/Katello/katello/pull/6885#issuecomment-339009910 > > Let me know if you need more information. > > -John Hi John. Thanks for the reply. I think that perfectly answers my question.
VERIFIED on sat6.3.0-30 the page is now loaded instantly and the changes do not seem to negatively influence any other feature.
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:0336