Bug 1614063
Summary: | Improve MonitorEventQueue performance for large workloads | |||
---|---|---|---|---|
Product: | Red Hat Satellite | Reporter: | Mike McCune <mmccune> | |
Component: | Content Management | Assignee: | Justin Sherrill <jsherril> | |
Status: | CLOSED ERRATA | QA Contact: | sbadhwar | |
Severity: | high | Docs Contact: | ||
Priority: | unspecified | |||
Version: | 6.3.2 | CC: | andrew.schofield, jdickers, pmoravec, pm-sat, sbadhwar, zhunting | |
Target Milestone: | 6.4.0 | Keywords: | PrioBumpField, Triaged | |
Target Release: | Unused | |||
Hardware: | Unspecified | |||
OS: | Unspecified | |||
Whiteboard: | ||||
Fixed In Version: | tfm-rubygem-katello-3.7.0.14-1 | Doc Type: | If docs needed, set a value | |
Doc Text: | Story Points: | --- | ||
Clone Of: | ||||
: | 1622206 (view as bug list) | Environment: | ||
Last Closed: | 2018-10-16 19:04:30 UTC | Type: | Bug | |
Regression: | --- | Mount Type: | --- | |
Documentation: | --- | CRM: | ||
Verified Versions: | Category: | --- | ||
oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | ||
Cloudforms Team: | --- | Target Upstream Version: | ||
Embargoed: |
Description
Mike McCune
2018-08-08 22:35:42 UTC
Created redmine issue https://projects.theforeman.org/issues/24576 from this bug Upstream bug assigned to jsherril Upstream bug assigned to jsherril Moving this bug to POST for triage into Satellite 6 since the upstream issue https://projects.theforeman.org/issues/24576 has been resolved. To test a large amount of data for the MonitorEventQueue to process you can do the following:
1) Load data to be processed by the queue:
# foreman-rake console
> 1.times { Katello::Host::ContentFacet.pluck(:host_id).each { |id|::Katello::EventQueue.push_event(::Katello::Events::ImportHostApplicability::EVENT_TYPE, id)} }
Once this completes, monitor progress in the UI on the task details, it will indicate the # of rows processed
2) You can also monitor the count in the database:
# sudo -u postgres psql -d foreman -c 'select count(*) from katello_events;'
count
-------
9331
(1 row)
Once that reaches 0 the processing is complete.
We measured between 30-40% speed improvements in processing items in this queue before this bugfix and after.
*** Bug 1622206 has been marked as a duplicate of this bug. *** Since the problem described in this bug report should be resolved in a recent advisory, it has been closed with a resolution of ERRATA. For information on the advisory, and where to find the updated files, follow the link below. If the solution does not work for you, open a new bug report. https://access.redhat.com/errata/RHSA-2018:2927 |