Page 1 of 1
notifications tab issue
Posted: Fri Jul 07, 2017 9:53 am
by 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
Re: notifications tab issue
Posted: Fri Jul 07, 2017 10:32 am
by 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
Re: notifications tab issue
Posted: Fri Jul 07, 2017 11:53 am
by btemple
Nagios XI 5.4.6
The query never finishes
Please see attached
Re: notifications tab issue
Posted: Fri Jul 07, 2017 1:42 pm
by 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
Re: notifications tab issue
Posted: Fri Jul 07, 2017 2:59 pm
by btemple
echo "select count(*) from nagios_notifications;"|mysql -pnagiosxi nagios
count(*)
195653
Re: notifications tab issue
Posted: Fri Jul 07, 2017 4:05 pm
by 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.
Re: notifications tab issue
Posted: Mon Jul 10, 2017 9:30 am
by 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 ?
Re: notifications tab issue
Posted: Mon Jul 10, 2017 10:07 am
by scottwilkerson
btemple wrote: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
Re: notifications tab issue
Posted: Mon Jul 10, 2017 10:25 am
by btemple
great I will give this a shot
Re: notifications tab issue
Posted: Mon Jul 10, 2017 11:43 am
by scottwilkerson
Let us know if you have further issues.