Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Red Hat Satellite engineering is moving the tracking of its product development work on Satellite to Red Hat Jira (issues.redhat.com). If you're a Red Hat customer, please continue to file support cases via the Red Hat customer portal. If you're not, please head to the "Satellite project" in Red Hat Jira and file new tickets here. Individual Bugzilla bugs will be migrated starting at the end of May. If you cannot log in to RH Jira, please consult article #7032570. That failing, please send an e-mail to the RH Jira admins at rh-issues@redhat.com to troubleshoot your issue as a user management inquiry. The email creates a ServiceNow ticket with Red Hat. Individual Bugzilla bugs that are migrated will be moved to status "CLOSED", resolution "MIGRATED", and set with "MigratedToJIRA" in "Keywords". The link to the successor Jira issue will be found under "Links", have a little "two-footprint" icon next to it, and direct you to the "Satellite project" in Red Hat Jira (issue links are of type "https://issues.redhat.com/browse/SAT-XXXX", where "X" is a digit). This same link will be available in a blue banner at the top of the page informing you that that bug has been migrated.

Bug 1163740

Summary:	Performance issues while accessing "Sync Status" page
Product:	Red Hat Satellite	Reporter:	Ashish Humbe <ahumbe>
Component:	Performance	Assignee:	Adam Price <adprice>
Status:	CLOSED CURRENTRELEASE	QA Contact:	Katello QA List <katello-qa-list>
Severity:	medium	Docs Contact:
Priority:	medium
Version:	6.0.4	CC:	ahumbe, bbuckingham, bkearney, cduryee, chrobert, dmoessne, greartes, mmello, sthirugn, tspeetje, xdmoon
Target Milestone:	Unspecified	Keywords:	Performance, Triaged
Target Release:	Unused
Hardware:	All
OS:	Linux
URL:	https://projects.theforeman.org/issues/14088
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2016-11-12 15:57: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 Ashish Humbe 2014-11-13 11:41:17 UTC

Description of problem:

The customer is facing performance issues while accessing "Sync Status" and "Tasks" page, it takes long time to load, sometime 25sec, 47sec  etc.. They have enabled 44 repos on the satellite server. 

Completed 200 OK in 47936ms (Views: 32.6ms | ActiveRecord: 4435.0ms)
Completed 200 OK in 25067ms (Views: 3497.1ms | ActiveRecord: 129.7ms)
Completed 200 OK in 22547ms (Views: 2721.9ms | ActiveRecord: 99.5ms)

On local satellite server these pages take 7-8 seconds to load where ~40 repos are enabled.

Below is the complete log seen while accessing the sync status page,

Processing by Katello::SyncManagementController#index as HTML
  Rendered /opt/rh/ruby193/root/usr/share/gems/gems/katello-1.5.0/app/views/katello/sync_management/_controls.html.haml (0.5ms)
  Rendered /opt/rh/ruby193/root/usr/share/gems/gems/katello-1.5.0/app/views/katello/sync_management/_repo.html.haml (3.0ms)
  Rendered /opt/rh/ruby193/root/usr/share/gems/gems/katello-1.5.0/app/views/katello/sync_management/_children.html.haml (3.6ms)
  Rendered /opt/rh/ruby193/root/usr/share/gems/gems/katello-1.5.0/app/views/katello/sync_management/_repo.html.haml (1.5ms)
  Rendered /opt/rh/ruby193/root/usr/share/gems/gems/katello-1.5.0/app/views/katello/sync_management/_children.html.haml (2.0ms)
  Rendered /opt/rh/ruby193/root/usr/share/gems/gems/katello-1.5.0/app/views/katello/sync_management/_children.html.haml (6.6ms)
  Rendered /opt/rh/ruby193/root/usr/share/gems/gems/katello-1.5.0/app/views/katello/sync_management/_repo.html.haml (4.7ms)
  Rendered /opt/rh/ruby193/root/usr/share/gems/gems/katello-1.5.0/app/views/katello/sync_management/_children.html.haml (5.4ms)
  Rendered /opt/rh/ruby193/root/usr/share/gems/gems/katello-1.5.0/app/views/katello/sync_management/_repo.html.haml (3.1ms)
  Rendered /opt/rh/ruby193/root/usr/share/gems/gems/katello-1.5.0/app/views/katello/sync_management/_children.html.haml (3.7ms)
  Rendered /opt/rh/ruby193/root/usr/share/gems/gems/katello-1.5.0/app/views/katello/sync_management/_children.html.haml (10.0ms)
  Rendered /opt/rh/ruby193/root/usr/share/gems/gems/katello-1.5.0/app/views/katello/sync_management/_repo.html.haml (6.1ms)
  Rendered /opt/rh/ruby193/root/usr/share/gems/gems/katello-1.5.0/app/views/katello/sync_management/_repo.html.haml (15.7ms)
  Rendered /opt/rh/ruby193/root/usr/share/gems/gems/katello-1.5.0/app/views/katello/sync_management/_children.html.haml (16.5ms)
  Rendered /opt/rh/ruby193/root/usr/share/gems/gems/katello-1.5.0/app/views/katello/sync_management/_repo.html.haml (14.2ms)
  Rendered /opt/rh/ruby193/root/usr/share/gems/gems/katello-1.5.0/app/views/katello/sync_management/_children.html.haml (14.8ms)
  Rendered /opt/rh/ruby193/root/usr/share/gems/gems/katello-1.5.0/app/views/katello/sync_management/_children.html.haml (32.1ms)
  Rendered /opt/rh/ruby193/root/usr/share/gems/gems/katello-1.5.0/app/views/katello/sync_management/_repo.html.haml (16.9ms)
  Rendered /opt/rh/ruby193/root/usr/share/gems/gems/katello-1.5.0/app/views/katello/sync_management/_repo.html.haml (2.9ms)
  Rendered /opt/rh/ruby193/root/usr/share/gems/gems/katello-1.5.0/app/views/katello/sync_management/_product.html.haml (3097.1ms)
  Rendered /opt/rh/ruby193/root/usr/share/gems/gems/katello-1.5.0/app/views/katello/sync_management/_products.html.haml (3100.0ms)
  Rendered /opt/rh/ruby193/root/usr/share/gems/gems/katello-1.5.0/app/views/katello/sync_management/index.html.haml within katello/layouts/katello (3126.3ms)
  Rendered /opt/rh/ruby193/root/usr/share/gems/gems/katello-1.5.0/app/views/katello/common/_common_i18n.html.haml (2.7ms)
  Rendered home/_submenu.html.erb (5.2ms)
  Rendered home/_user_dropdown.html.erb (2.0ms)
Read fragment views/tabs_and_title_records-3 (0.2ms)
  Rendered home/_topbar.html.erb (9.9ms)
  Rendered layouts/base.html.erb (11.6ms)
Completed 200 OK in 47936ms (Views: 32.6ms | ActiveRecord: 4435.0ms)


The customer has a quad core processor and 8 GB ram on the satellite server. 

Version-Release number of selected component (if applicable):
Red Hat Satellite 6.0.4

How reproducible:
Always in customer environment.

Actual results:
"Sync Status" and "Tasks" page take a long time to load content.

Expected results:
"Sync Status" and "Tasks" page should not take long time to load.

Comment 1 RHEL Program Management 2014-11-13 11:43:57 UTC

Since this issue was entered in Red Hat Bugzilla, the release flag has been
set to ? to ensure that it is properly evaluated for this release.

Comment 6 Chris Duryee 2016-03-08 01:22:33 UTC

Tasks page is addressed in a different bz, https://bugzilla.redhat.com/show_bug.cgi?id=1196673. We are investigating the sync status page slowness.

Comment 8 Marcelo Moreira de Mello 2016-05-27 16:27:11 UTC

*** Bug 1330749 has been marked as a duplicate of this bug. ***

Comment 10 Adam Price 2016-07-05 18:47:05 UTC

I'm unable to reproduce slowness anywhere near 30+ seconds. I enabled 60+ Red Hat repositories and the "Sync Status" page is loading in about 3 seconds on average.

I started a sync of all those repos at once causing page load times to jump to an average of 11 seconds.

Comment 11 Bryan Kearney 2016-07-08 20:22:33 UTC

Per 6.3 planning, moving out non acked bugs to the backlog

Comment 13 Chris Duryee 2016-11-12 15:57:30 UTC

I believe this is addressed between 6.2.4 fixes and https://bugzilla.redhat.com/show_bug.cgi?id=1384548. Marking as closed/currentrelease, but feel free to re-open if this bug is still present.