Project

General

Profile

Actions
Copy link

Bug #28957

closed

Foreman 1.24.2 - very slow hostgroup view and edit for non admin user

Added by Christian Fuchs over 4 years ago. Updated over 4 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Shira Maximov
Category:
Organizations and Locations
Target version:
-
Difficulty:
Triaged:
No
Bugzilla link:
Pull request:
https://github.com/theforeman/foreman/pull/7451
Fixed in Releases:
2.1.0
Found in Releases:
Red Hat JIRA:

Description

Hello everybody,
in foreman 1.24.2 opening the page for the hostgroup overview or editing hostgroups for non admin user is very slow. Unfortunately I can’t say if the problem came with the update to version 1.24 or if it already existed before.

My test setup contains about 60 servers, 114 host groups, 5 Environment, 136 puppet classes with total of 2594 smart class parameters (but not all are enabled for overwriting). We’re using Foreman as ENC for the puppetserver.

Test as Admin
In the first test i opend the page for the hostgroup overview as admin user. With debug log activated this results in ~ 115 SQL queries. The performance is quiet well (debug out in the attachment: foreman_hostgroup_view_admin.log). Opening the page for editing a hostgroup took some more time. It results in approximately 1200 sql queries. Much more than expected, but the performance was still ok (but noticeably slower) (debug out in the attachment: foreman_hostgroup_edit_admin.log).

Test as Non Admin
For the second test, i created a local testuser with the default role “Viewer”. Furthermore i assigned a role to the testuser, which gave him the possibility to edit all hostgroups. After that i signed into foreman with this user and open the page for the hostgroup overview. This request now took much longer and results in ~ 5000 SQL queries :face_with_monocle: …to show 50 hostgroups, thats quite a lot (debug out in the attachment: foreman_hostgroup_view_testuser.log).
Opening the page for editing a hostgroup took much longer to open. It results in ~ 11000 SQL queries :astonished: (debug out in the attachment: foreman_hostgroup_edit_testuser.log).

best regards

Files

foreman_hostgroup_edit_admin.log.gz foreman_hostgroup_edit_admin.log.gz 21.8 KB Christian Fuchs, 02/07/2020 10:37 AM
foreman_hostgroup_edit_testuser.log.gz foreman_hostgroup_edit_testuser.log.gz 144 KB Christian Fuchs, 02/07/2020 10:37 AM
foreman_hostgroup_view_admin.log.gz foreman_hostgroup_view_admin.log.gz 3.28 KB Christian Fuchs, 02/07/2020 10:37 AM
foreman_hostgroup_view_testuser.log.gz foreman_hostgroup_view_testuser.log.gz 51.7 KB Christian Fuchs, 02/07/2020 10:37 AM
foreman_hostgroup_view_debug_testuser.log.gz foreman_hostgroup_view_debug_testuser.log.gz 53.4 KB Christian Fuchs, 02/07/2020 02:22 PM
foreman_hostgroup_edit_debug_testuser.log.gz foreman_hostgroup_edit_debug_testuser.log.gz 252 KB Christian Fuchs, 02/07/2020 02:22 PM
Actions
Copy link

Also available in: Atom PDF