Bug #29970

Report Template "Applicable Errata" fails for large numbers of Content Hosts

Added by Shira Maximov almost 2 years ago. Updated 6 months ago.

Target version:
Bugzilla link:
Fixed in Releases:
Found in Releases:


Cloned from

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)

Associated revisions

Revision ba3da753 (diff)
Added by Ondřej Ezr over 1 year ago

Refs #29970 - speedup Applicable Errata report

Preloads are much faster as those load records only once per batch.
The SQL query is much simplier and transformation to the Rails models is simplier.


#1 Updated by Tomer Brisker almost 2 years ago

  • Priority changed from Urgent to Normal
  • Category changed from Statistics to Reporting

#2 Updated by The Foreman Bot over 1 year ago

  • Assignee set to Ondřej Ezr
  • Status changed from New to Ready For Testing
  • Pull request added

#3 Updated by Justin Sherrill about 1 year ago

  • Status changed from Ready For Testing to Closed

This is merged

#4 Updated by Justin Sherrill about 1 year ago

  • Status changed from Closed to Ready For Testing

#5 Updated by Ondřej Ezr 6 months 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.

Also available in: Atom PDF