Page 1 of 2

Users really slow page loading

Posted: Thu Mar 25, 2021 3:37 pm
by niebais
Redhat Enterprise 7.9
Nagios XI Version 5.8.2

When we try to login to the system after this last upgrade, most users are experiencing really slow page loading. At first I thought it was load average or network, but the system load is 0.82. The second item we looked at is network ping times, etc and those look good.

The nagiosadmin user appears to be just fine and everything pulls up, but if we use other accounts (local or AD) the pages can take about 5 minutes to pull up. Any ideas what I can look at?

Re: Users really slow page loading

Posted: Fri Mar 26, 2021 10:40 am
by niebais
I've narrowed down the issues to when it makes the calls to ajaxhandler and it's creating a lot of open apache processes.

Re: Users really slow page loading

Posted: Fri Mar 26, 2021 1:05 pm
by benjaminsmith
HI @niebais,

Can you share the Apache logs along with a fresh system profile and we'll take a closer look at the logs. It's very helpful to tail the apache logs while you are loading the slow page to help capture relevant errors.

Code: Select all

tail -Fn0 /var/log/httpd/error_log /var/log/httpd/ssl_error_log
Thanks!
Benjamin

To send us your system profile.

Login to the Nagios XI GUI using a web browser.
Click the "Admin" > "System Profile" Menu
Click the "Download Profile" button

Re: Users really slow page loading

Posted: Fri Mar 26, 2021 4:09 pm
by benjaminsmith
Hi,

Update. Do you know if this system has ndo downgrade to the previous version ( ndo2db )? If not I can check this in the profile.

--Benjamin

Re: Users really slow page loading

Posted: Mon Mar 29, 2021 12:30 pm
by niebais
I'm looking into that. I'll get you the apache logs. I'm not seeing any good reason in the apache logs right now either.

Re: Users really slow page loading

Posted: Mon Mar 29, 2021 12:36 pm
by niebais
Here's an example page that is loading way slow if I'm logged in as a regular user:
https://nagiosxi.ntta.local/nagiosxi/aj ... 91c69a6e93

The nagiosadmin user loads everything really quickly. I'm still working on getting the profile for you.

Re: Users really slow page loading

Posted: Mon Mar 29, 2021 12:40 pm
by niebais
Attached is the uploaded profile

Moderator's Note: The profile has been shared with the support team but has been removed from the public forum.

Re: Users really slow page loading

Posted: Mon Mar 29, 2021 12:50 pm
by niebais
Even logging out it taking a really long time for regular users.

Re: Users really slow page loading

Posted: Mon Mar 29, 2021 3:22 pm
by benjaminsmith
Hi,

Thanks for retrieving the system profile.

I believe we have identified the issue and this will be corrected in the next maintenance release. Please take a backup, then run the following command and let me know if the issue is resolved.

Code: Select all

mysql -h 127.0.0.1 -uroot -pnagiosxi nagios -e "update nagios_dbversion set version = '2.1.3';"
Best Regards,
Benjamin

Re: Users really slow page loading

Posted: Tue Mar 30, 2021 10:02 am
by niebais
I'd of never guessed that one. Thanks and that did fix it!