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
How reproducible:
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
3. Submit
Actual results:
Small numbers return in reasonable amount of time
Large searches take impossibly long to report
Expected results:
Reports generate or at least complete in reasonable amount of time. (i.e. not erroring after 12 hours of waiting to return)
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.