Page 1 of 1
Notifications Disabled/No Services mapped to nodes
Posted: Fri Mar 22, 2013 9:06 am
by kotterbein
Having an issue here:
Nagios XI 2012R1.6, Redhat el5 server.
Checks are occuring, and notifications on are showing up under "Problems" but are not being mapped to any nodes. when I click to look at services under nodes, it shows "No Matching Services Found"- I'm not sure how long this problem has been occuring, but I did run "repairmysql.sh" to see if this would remedy the issue, but to no avail. I have rebooted a couple of times to try and see if there was an issue, but again, nothing comes back as a service linked to a node.
looking for more possiblilities
Re: Notifications Disabled/No Services mapped to nodes
Posted: Fri Mar 22, 2013 9:08 am
by kotterbein
also notice that httpd is taking a HUGE amount of resources:
29410 apache 20 0 2428m 2.0g 13m R 99.5 8.6 1:05.07 httpd
4052 apache 15 0 1746m 1.4g 17m S 2.0 5.8 1:08.08 httpd
14835 apache 15 0 2406m 2.0g 14m S 2.0 8.5 1:27.52 httpd
4051 apache 15 0 1920m 1.5g 20m S 1.3 6.5 1:36.83 httpd
4056 apache 16 0 1920m 1.5g 17m S 1.3 6.5 1:52.48 httpd
4060 apache 15 0 1920m 1.5g 21m S 1.3 6.5 1:24.02 httpd
4053 apache 16 0 1920m 1.5g 20m S 1.0 6.5 1:23.10 httpd
4055 apache 15 0 2058m 1.7g 17m S 0.7 7.1 1:33.62 httpd
Re: Notifications Disabled/No Services mapped to nodes
Posted: Fri Mar 22, 2013 9:55 am
by scottwilkerson
please run
and report the output
Re: Notifications Disabled/No Services mapped to nodes
Posted: Fri Mar 22, 2013 10:00 am
by kotterbein
reboot (3rd time) worked after running the mysql repair again.
sorry for the inconvenience- just an fyi, the output you requested:
Code: Select all
130322 9:38:02 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_notifications' is marked as crashed and last (automatic?) repair failed
130322 9:38:02 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_notifications' is marked as crashed and last (automatic?) repair failed
130322 9:38:02 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_notifications' is marked as crashed and last (automatic?) repair failed
130322 9:38:20 [Note] /usr/libexec/mysqld: Normal shutdown
130322 9:38:22 InnoDB: Starting shutdown...
130322 9:38:23 InnoDB: Shutdown completed; log sequence number 0 43655
130322 9:38:23 [Note] /usr/libexec/mysqld: Shutdown complete
130322 09:38:23 mysqld ended
130322 09:44:13 mysqld started
130322 9:44:13 InnoDB: Started; log sequence number 0 43655
130322 9:44:13 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
130322 10:09:40 [Note] /usr/libexec/mysqld: Normal shutdown
130322 10:09:40 InnoDB: Starting shutdown...
130322 10:09:41 InnoDB: Shutdown completed; log sequence number 0 43655
130322 10:09:41 [Note] /usr/libexec/mysqld: Shutdown complete
130322 10:09:41 mysqld ended
130322 10:13:20 mysqld started
130322 10:13:20 InnoDB: Started; log sequence number 0 43655
130322 10:13:21 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
Re: Notifications Disabled/No Services mapped to nodes
Posted: Fri Mar 22, 2013 10:21 am
by nscott
Just to be overtly clear (you may have already read it), but the detailed documentation on this is here:
http://assets.nagios.com/downloads/nagi ... tabase.pdf
Please make sure you're following the details exactly. If that fails, you may need to do the repairs manually, which is outlined in this part of the doc:
Code: Select all
service mysqld stop
cd /var/lib/mysql/nagios
myisamchk -r -f nagios_notifications
service mysqld start
rm -f /usr/local/nagiosxi/var/dbmaint.lock
/usr/local/nagiosxi/cron/dbmaint.php
Where I have filled in the table that is marked as corrupted as indicated by your log entries.
Re: Notifications Disabled/No Services mapped to nodes
Posted: Fri Mar 22, 2013 11:48 am
by kotterbein
Thank you Nicholas- you can mark this as resolved!
K