Project

General

Profile

Bug #29970

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

Added by Shira Maximov over 2 years ago. Updated about 1 year ago.

Status:
Closed
Priority:
Normal
Assignee:
Category:
Reporting
Target version:
-
Difficulty:
Triaged:
No
Bugzilla link:
Fixed in Releases:
Found in Releases:
Red Hat JIRA:

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)

Associated revisions

Revision ba3da753 (diff)
Added by Ondřej Ezr about 2 years 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.

History

#1 Updated by Tomer Brisker over 2 years ago

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

#2 Updated by The Foreman Bot about 2 years ago

  • Assignee set to Ondřej Ezr
  • Status changed from New to Ready For Testing
  • Pull request https://github.com/theforeman/foreman/pull/8053 added

#3 Updated by Justin Sherrill over 1 year ago

  • Status changed from Ready For Testing to Closed

This is merged

#4 Updated by Justin Sherrill over 1 year ago

  • Status changed from Closed to Ready For Testing

#5 Updated by Ondřej Ezr about 1 year 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