Red Hat Bugzilla – Bug 1422690
viewing REX job in web UI is very slow as non-admin user
Last modified: 2017-06-20 13:22:17 EDT
Description of problem: If you have a non-admin user with rights to view REX jobs, it can be very slow to view the task output. For example: Rendered /opt/.../app/views/job_invocations/_tab_overview.html.erb (23.2ms) Rendered /opt/.../app/views/job_invocations/_host_name_td.html.erb (3065.9ms) Rendered /opt/.../app/views/job_invocations/_host_status_td.html.erb (0.5ms) Rendered /opt/.../app/views/job_invocations/_host_actions_td.html.erb (3587.1ms) Rendered /opt/.../app/views/job_invocations/_host_name_td.html.erb (2876.5ms) Rendered /opt/.../app/views/job_invocations/_host_status_td.html.erb (0.5ms) Rendered /opt/.../app/views/job_invocations/_host_actions_td.html.erb (2717.4ms) Rendered /opt/.../app/views/job_invocations/_host_name_td.html.erb (3664.2ms) Rendered /opt/.../app/views/job_invocations/_host_status_td.html.erb (0.4ms) Rendered /opt/.../app/views/job_invocations/_host_actions_td.html.erb (2913.4ms) Rendered /opt/.../app/views/job_invocations/_host_name_td.html.erb (2749.4ms) Rendered /opt/.../app/views/job_invocations/_host_status_td.html.erb (0.5ms) Rendered /opt/.../app/views/job_invocations/_host_actions_td.html.erb (3694.2ms) Rendered /opt/.../app/views/job_invocations/_host_name_td.html.erb (2884.7ms) Rendered /opt/.../app/views/job_invocations/_host_status_td.html.erb (0.5ms) Rendered /opt/.../app/views/job_invocations/_host_actions_td.html.erb (2732.3ms) Rendered /opt/.../app/views/job_invocations/_host_name_td.html.erb (3653.0ms) Rendered /opt/.../app/views/job_invocations/_host_status_td.html.erb (0.5ms) Rendered /opt/.../app/views/job_invocations/_host_actions_td.html.erb (2917.3ms) Rendered /opt/.../app/views/job_invocations/_tab_hosts.html.erb (37465.4ms) Rendered /opt/.../app/views/job_invocations/show.html.erb within layouts/application (37502.5ms) Rendered layouts/_application_content.html.erb (0.2ms) Rendered home/_submenu.html.erb (1.4ms) Rendered home/_user_dropdown.html.erb (2.5ms) Read fragment views/tabs_and_title_records-21 (0.1ms) Rendered home/_topbar.html.erb (6.4ms) Rendered layouts/base.html.erb (7.2ms) Completed 200 OK in 37539ms (Views: 37366.9ms | ActiveRecord: 148.5ms) If you are logged in as admin, this takes less than one second: Completed 200 OK in 67ms (Views: 47.9ms | ActiveRecord: 6.9ms) Version-Release number of selected component (if applicable): 6.2.7 Steps to Reproduce: 1. register a large number of hosts to the satellite (perhaps 40K or more) 2. view rex job. The job doesn't have to be on a large number of hosts, the example above was for 7 hosts. Actual results: page seems to take 3-5 seconds per host Expected results: page should be about the same speed as for admin user Additional info: attached patch seems to help significatly
Created attachment 1250733 [details] patch to skip authorizer cache in some cases
3 seconds per host can quickly make things unusable, marking as high severity
Upstream bug assigned to cduryee@redhat.com
Moving this bug to POST for triage into Satellite 6 since the upstream issue http://projects.theforeman.org/issues/18554 has been resolved.
The upstream patch was reverted. I marked the attached BZ patch as obsolete, and reset back to untriaged since it no longer has a fix in-hand.
Created redmine issue http://projects.theforeman.org/issues/18851 from this bug
Upstream bug assigned to inecas@redhat.com
Moving this bug to POST for triage into Satellite 6 since the upstream issue http://projects.theforeman.org/issues/18851 has been resolved.
Verified with 10k hosts on satellite-6.2.10-2.0.el7sat.noarch, no significant delay experienced
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/RHBA-2017:1553