notifications tab issue

[btemple]

So we have moved to a baremetal server and the notifications tab still causes issues.
mysqld hits 100% cpu and notifications query never finishes

[scottwilkerson]

How many records end up being displayed in the report for 24 hours?

What version of XI are you running

Do you show any errors in

Code: Select all

tail -50 /var/log/mysqld.log

[btemple]

Nagios XI 5.4.6
The query never finishes
Please see attached

[scottwilkerson]

can you run the following from the command line and report the output

Code: Select all

 echo "select count(*) from nagios_notifications;"|mysql -pnagiosxi nagios

[btemple]

echo "select count(*) from nagios_notifications;"|mysql -pnagiosxi nagios
count(*)
195653

[scottwilkerson]

btemple,

This is quite strange and I can't figure out why that might be.

I think we may have to go the support ticket route and have you send a profile to [email protected]

reference this thread. If the profile doesn't show anything that stands out, we may need to setup a remote to see if we can narrow down the query that is hanging.

[btemple]

Ok thank you. I was wondering do you know of a way to only backup and restore hosts and checks. I am pretty sure the issue is coming from a backup restore from our current production. Or a way to clear all notification data from current production then run back / restore ?

[scottwilkerson]

Ok thank you. I was wondering do you know of a way to only backup and restore hosts and checks. I am pretty sure the issue is coming from a backup restore from our current production. Or a way to clear all notification data from current production then run back / restore ?

After creating a current backup, I would run the following to remove the old notifications as well as remove any old objects that are no longer active:

Code: Select all

echo "TRUNCATE TABLE  nagios_notifications;"|mysql -pnagiosxi nagios
echo "echo "delete from nagios_objects where is_active=0;"|mysql -pnagiosxi nagios

[btemple]

great I will give this a shot

[scottwilkerson]

Let us know if you have further issues.