Description of problem:
The "Applicable Errata" report template fails when run against a large number of hosts. (Approximately 17,000). It runs for about 12 hours, until it finally ends with a "500 Internal Server error". (Maybe that 12 hours is a timeout wall?)
When smaller numbers
Version-Release number of selected component (if applicable):
Red Hat Satellite 6.5.2
Steps to Reproduce:
1. In the WebUI: "Monitor"->"Report Templates"->"Applicable Errata"
2. In the Hosts Filter, specify a search string to match a large number of hosts. Leave errata filter blank
Small numbers return in reasonable amount of time
Large searches take impossibly long to report
Reports generate or at least complete in reasonable amount of time. (i.e. not erroring after 12 hours of waiting to return)
Created redmine issue https://projects.theforeman.org/issues/29970 from this bug
Upstream bug assigned to oezr
Moving this bug to POST for triage into Satellite since the upstream issue https://projects.theforeman.org/issues/29970 has been resolved.
This was missaligned upstream as it was not closed by the merge and only got aligned to 3.2, but actually landed in 2.3, so it is already included in Sat 6.9
We have considered this BZ during a triage and since some work has already been done and no feedback has been received, we consider the work being done enough.