Bug #19394
subscription page unusable with many hosts registered
Description
Cloned from https://bugzilla.redhat.com/show_bug.cgi?id=1422307
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.
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.
Related issues
Associated revisions
History
#1
Updated by Brad Buckingham about 5 years ago
Updated by - Subject changed from subscription page unusable with many hosts registered to subscription page unusable with many hosts registered
- Target version set to 187
- Legacy Backlogs Release (now unused) set to 228
#2
Updated by Brad Buckingham about 5 years ago
- Assignee set to Andrew Kofink
#3
Updated by Brad Buckingham about 5 years ago
- Target version changed from 187 to 193
#4
Updated by Justin Sherrill about 5 years ago
Updated by - Assignee deleted (
Andrew Kofink)
#5
Updated by Justin Sherrill about 5 years ago
- Priority changed from Urgent to High
- Legacy Backlogs Release (now unused) changed from 228 to 258
#6
Updated by Brad Buckingham about 5 years ago
- Target version changed from 193 to 196
#7
Updated by John Mitsch about 5 years ago
Updated by - Assignee set to John Mitsch
#8
Updated by Justin Sherrill about 5 years ago
- Legacy Backlogs Release (now unused) changed from 258 to 267
#9
Updated by Brad Buckingham almost 5 years ago
- Target version changed from 196 to 202
#10
Updated by Justin Sherrill almost 5 years ago
- Legacy Backlogs Release (now unused) changed from 267 to 281
#11
Updated by Brad Buckingham almost 5 years ago
- Target version changed from 202 to 205
#12
Updated by The Foreman Bot almost 5 years ago
Updated by - Status changed from New to Ready For Testing
- Pull request https://github.com/Katello/katello/pull/6885 added
#13
Updated by Justin Sherrill almost 5 years ago
- Legacy Backlogs Release (now unused) changed from 281 to 286
#14
Updated by Brad Buckingham almost 5 years ago
- Target version changed from 205 to 208
#15
Updated by Justin Sherrill almost 5 years ago
- Legacy Backlogs Release (now unused) changed from 286 to 250
#16
Updated by John Mitsch almost 5 years ago
- Blocks Bug #20587: change import subscriptions to a more general task added
#17
Updated by Brad Buckingham almost 5 years ago
- Target version changed from 208 to 213
#18
Updated by John Mitsch almost 5 years ago
- Status changed from Ready For Testing to Closed
- % Done changed from 0 to 100
Applied in changeset katello|1886eef588fc7f8a8df65fe8b59911afd1d20d54.
Fixes #19394 - Add host subscription association
Subscription endpoints will no longer return content host information.
This is now searchable through the host endpoint using
'subscription_name' key. This association is now stored in our
database. These changes will speed up subscription API call on
systems with alot of hosts registered.