Project

General

Profile

Actions
Copy link

Bug #24389

closed

Content Host Applicable Package List page can DOS Foreman server and Postgres

Added by Mike McCune over 6 years ago. Updated over 6 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Mike McCune
Category:
Repositories
Target version:
Katello 3.7.1
Difficulty:
Triaged:
Yes
Bugzilla link:
Pull request:
https://github.com/Katello/katello/pull/7568
Fixed in Releases:
Found in Releases:
Katello 3.4.6
Red Hat JIRA:

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.

Actions
Copy link

Also available in: Atom PDF