Bug #24389
closed
Content Host Applicable Package List page can DOS Foreman server and Postgres
Description
This is very similar to https://projects.theforeman.org/issues/20167
Copied from https://bugzilla.redhat.com/show_bug.cgi?id=1608597
Description of problem:
If you have lots of hosts that need packages, fetching the "applicable" packages can be very slow.
1) Take large Katello installation with 20,000 content hosts
2) Navigate to Content Host -> Pick a host with applicable Errata
3) Click Packages -> Applicable Packages
4) On large installations this page will never return (query takes 4h+ to complete).
During execution of said query, Postgres will consume 20-40GB of disk swapping out the query results, consuming way more resources than it should and slowing overall operations of the Satellite.
Updated by The Foreman Bot over 5 years ago
- Status changed from New to Ready For Testing
- Assignee set to Mike McCune
- Pull request https://github.com/Katello/katello/pull/7568 added
Updated by Anonymous over 5 years ago
- Status changed from Ready For Testing to Closed
Applied in changeset katello|b9430c00c72c75511113e518d4f3bf94d3cf5ad0.
Updated by John Mitsch over 5 years ago
- Target version set to Katello 3.7.1
- Fixed in Releases deleted (
Katello 3.4.6)
Updated by John Mitsch over 5 years ago
- Triaged changed from No to Yes
- Found in Releases Katello 3.4.6 added