Bug #29970
closedReport Template "Applicable Errata" fails for large numbers of Content Hosts
Description
Cloned from https://bugzilla.redhat.com/show_bug.cgi?id=1745146
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)
Updated by Tomer Brisker over 4 years ago
- Category changed from Statistics to Reporting
- Priority changed from Urgent to Normal
Updated by The Foreman Bot about 4 years ago
- Status changed from New to Ready For Testing
- Assignee set to Ondřej Ezr
- Pull request https://github.com/theforeman/foreman/pull/8053 added
Updated by Justin Sherrill over 3 years ago
- Status changed from Ready For Testing to Closed
This is merged
Updated by Justin Sherrill over 3 years ago
- Status changed from Closed to Ready For Testing
Updated by Ondřej Ezr about 3 years ago
- Status changed from Ready For Testing to Closed
- Fixed in Releases 3.2.0 added
I'm closing this as it is as good as we can hope with the current funcionality.