Notifications Page takes a long time to open

[abrist]

Can you open a ticket with [email protected] ? We may want to move to a remote session to resolve this.

[MSPk]

I'm using a trial version of the Nagios XI, Can I still open a ticket to get this issue checked remotely?

[abrist]

Unfortunately, no. BUT, you could take the opportunity to sign up for a quickstart session, though this is usually reserved for those seriously evaluating the product for purchase. So if you are, browse over to: http://www.nagios.com/services/quickstart/request

[MSPk]

Could this be an issue with notifications.php file? Can we replace that and check?

[abrist]

I doubt that it is the issue, as we have not had any other reports concerning this file. You could upgrade XI to the latest version, 2012r2.2 as that will most likely update the file.

[antorres]

Hi guys,
I had the same issue. It was driving me crazy!

Whenever I tried to access the Notifications report, the site crushed and could no longer access any other links.
I monitored every single log (httpd/error_log, nagios.log et al) but without clue.
Even tried every step you guys suggested, database repair, etcetera.

With the

Code: Select all

top

command on the CLI, I could see that the process mysqld consumed 100% of my CPU. Then, I googled something and I don't remember exactly how I got to this link:

http://exchange.nagios.org/directory/Ad ... ls/details

and specifically to the part that says:

Hi,

This addon consume 100% de cpu and disk i/o...
in this page explain how fix the problem...
http://www.iojo.net/nagios/ndo

only i need create index for tables, this:

CREATE INDEX start_time_idx ON nagios_hostchecks (start_time);
CREATE INDEX start_time_idx ON nagios_servicechecks (start_time);
CREATE INDEX scheduled_time_idx ON nagios_timedeventqueue (scheduled_time);

Well, I tried this method as well, but it didn't seem to work.
Desperately and without hopes, I updated my nagiosxi aaand... IT'S NOW WORKING!

Hope it helps.

[abrist]

Yep, the newer version deal with the notification table spam a bit better. If you experience similar issues with the newer versions of XI, you should:
1) Check your notification settings, are you experiencing notification overload? If so, you may want to tweak thresholds to reduce the amount of notification spam. You XI server and your mail relay will be happier for it.
2) You may have to truncate the notifications table. If you reach this step, we can help you do so on the forums here.

[MSPk]

Hi,

We are planning to upgrade the nagios XI sometime next week and have a question regarding the backup script. We have recently offloaded the database and we now wondering running a backup script will backup the contents of the offloaded DB as well?

[slansing]

Yes, with Nagios XI 2012 r 2.8 or newer the backup script will pull in offloaded DBs.