Users really slow page loading

[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?

[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.

[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

[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

[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.

[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.

[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.

[niebais]

Even logging out it taking a really long time for regular users.

[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

[niebais]

I'd of never guessed that one. Thanks and that did fix it!