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.
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.
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.
*** Bug 1330749 has been marked as a duplicate of this bug. ***
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.
Per 6.3 planning, moving out non acked bugs to the backlog
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.