Project

General

Profile

Bug #19394

subscription page unusable with many hosts registered

Added by Brad Buckingham over 4 years ago. Updated about 3 years ago.

Status:
Closed
Priority:
High
Assignee:
Category:
Subscriptions
Target version:
Difficulty:
Triaged:
Bugzilla link:
Fixed in Releases:
Found in Releases:

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

Blocks Katello - Bug #20587: change import subscriptions to a more general taskClosed2017-08-14

Associated revisions

Revision 1886eef5 (diff)
Added by John Mitsch about 4 years ago

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.

History

#1 Updated by Brad Buckingham over 4 years ago

  • 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 over 4 years ago

  • Assignee set to Andrew Kofink

#3 Updated by Brad Buckingham over 4 years ago

  • Target version changed from 187 to 193

#4 Updated by Justin Sherrill over 4 years ago

  • Assignee deleted (Andrew Kofink)

#5 Updated by Justin Sherrill over 4 years ago

  • Priority changed from Urgent to High
  • Legacy Backlogs Release (now unused) changed from 228 to 258

#6 Updated by Brad Buckingham over 4 years ago

  • Target version changed from 193 to 196

#7 Updated by John Mitsch over 4 years ago

  • Assignee set to John Mitsch

#8 Updated by Justin Sherrill over 4 years ago

  • Legacy Backlogs Release (now unused) changed from 258 to 267

#9 Updated by Brad Buckingham about 4 years ago

  • Target version changed from 196 to 202

#10 Updated by Justin Sherrill about 4 years ago

  • Legacy Backlogs Release (now unused) changed from 267 to 281

#11 Updated by Brad Buckingham about 4 years ago

  • Target version changed from 202 to 205

#12 Updated by The Foreman Bot about 4 years ago

  • Status changed from New to Ready For Testing
  • Pull request https://github.com/Katello/katello/pull/6885 added

#13 Updated by Justin Sherrill about 4 years ago

  • Legacy Backlogs Release (now unused) changed from 281 to 286

#14 Updated by Brad Buckingham about 4 years ago

  • Target version changed from 205 to 208

#15 Updated by Justin Sherrill about 4 years ago

  • Legacy Backlogs Release (now unused) changed from 286 to 250

#16 Updated by John Mitsch about 4 years ago

  • Blocks Bug #20587: change import subscriptions to a more general task added

#17 Updated by Brad Buckingham about 4 years ago

  • Target version changed from 208 to 213

#18 Updated by John Mitsch about 4 years ago

  • Status changed from Ready For Testing to Closed
  • % Done changed from 0 to 100

Also available in: Atom PDF