Cannot find Host in service escalation

[JohnFLi]

I am trying to remove a Host from Nagios as it no longer exists.
When trying to remove teh service check for Ping, it says it can't becasue it has a service Escalation tied to it.
I go to the Service escalation that it named.....I don't see it in the 'included' side. I see it on the left side of the two columns.

I added it....applied config.....removed it...applied config.
THen when I try to remove the ping check fo that host.....it still says there is a service escalation tied to it.....

ANy ideas?

[jdalrymple]

Is it possible you have something lurking in the static or import directory that is causing you grief?

If not, click the disk icon next to the escalation and let us take a look at the text config.

[JohnFLi]

Everything was entered manually, so it wouldn't be stuck in an import.

I looked at the text version....it isn't in there.

[tgriep]

Can you click on the blue circle with the letter i next to the service to get a list of relationships for that service and post that here?

[JohnFLi]

yes, I go there and it shows me

Relation to Serviceescalations, entry: Service Ping Escalation - Dependent relationship

so I go to that location, and the host is not listed in there.
I added it, applied I removed it, applied

still same outcome



When I do that for the service escalation I see

Relation to Hosts, entry: G1PPTSS06
Relation to Hosts, entry: G1PPTSS07
Relation to Hosts, entry: G1VPTSS04
Relation to Services, entry: BearCam-Ping

it is the BearCam is what I'm trying to get rid of. I can't find out how to do that.

[tgriep]

If you go to the BearCam-Ping service in Core Config Manager, click on hosts, is it there?
If not, can you post all of the configs so we can review them?

Can you run this to rule out a database corruption? Please post the output.

Code: Select all

tail -50 /var/log/mysqld.log

[JohnFLi]

In Services, I do a search for Bear, and it comes up with the ping service check for that host. As I would expect.

tail -50 /var/log/mysqld.log
150731 14:15:02 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_servicestatus' is marked as crashed and should be repaired
150731 14:15:02 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_servicestatus' is marked as crashed and should be repaired
150731 14:15:02 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_servicestatus' is marked as crashed and should be repaired
150731 14:15:02 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_servicestatus' is marked as crashed and should be repaired
150731 14:15:02 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_servicestatus' is marked as crashed and should be repaired
150731 14:15:02 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_hoststatus' is marked as crashed and should be repaired
150731 14:15:02 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_servicestatus' is marked as crashed and should be repaired
150731 14:15:02 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_servicestatus' is marked as crashed and should be repaired
150731 14:15:02 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_customvariablestatus' is marked as crashed and should be repaired
150731 14:15:02 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_servicestatus' is marked as crashed and should be repaired
150731 14:15:02 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_customvariablestatus' is marked as crashed and should be repaired
150731 14:15:02 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_hoststatus' is marked as crashed and should be repaired
150731 14:15:02 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_customvariablestatus' is marked as crashed and should be repaired
150731 14:15:02 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_hoststatus' is marked as crashed and should be repaired
150731 14:15:02 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_customvariablestatus' is marked as crashed and should be repaired
150731 14:15:02 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_hoststatus' is marked as crashed and should be repaired
150731 14:15:02 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_customvariablestatus' is marked as crashed and should be repaired
150731 14:15:02 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_hoststatus' is marked as crashed and should be repaired
150731 14:15:02 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_customvariablestatus' is marked as crashed and should be repaired
150731 14:15:02 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_servicestatus' is marked as crashed and should be repaired
150731 14:15:02 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_customvariablestatus' is marked as crashed and should be repaired
150731 14:15:02 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_servicestatus' is marked as crashed and should be repaired
150731 14:15:02 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_customvariablestatus' is marked as crashed and should be repaired
150731 14:15:02 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_servicestatus' is marked as crashed and should be repaired
150731 14:15:02 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_customvariablestatus' is marked as crashed and should be repaired
150731 14:15:02 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_servicestatus' is marked as crashed and should be repaired
150731 14:15:02 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_customvariablestatus' is marked as crashed and should be repaired
150731 14:15:03 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_servicestatus' is marked as crashed and should be repaired
150731 14:15:03 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_customvariablestatus' is marked as crashed and should be repaired
150731 14:15:03 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_servicestatus' is marked as crashed and should be repaired
150731 14:15:03 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_customvariablestatus' is marked as crashed and should be repaired
150731 14:15:03 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_servicestatus' is marked as crashed and should be repaired
150731 14:15:03 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_customvariablestatus' is marked as crashed and should be repaired
150731 14:15:03 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_servicestatus' is marked as crashed and should be repaired
150731 14:15:03 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_customvariablestatus' is marked as crashed and should be repaired
150731 14:15:03 [Note] /usr/libexec/mysqld: Normal shutdown

150731 14:15:03 [Note] Event Scheduler: Purging the queue. 0 events
150731 14:15:05 InnoDB: Starting shutdown...
150731 14:15:09 InnoDB: Shutdown completed; log sequence number 0 44233
150731 14:15:09 [Note] /usr/libexec/mysqld: Shutdown complete

150731 14:15:09 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
150731 14:15:17 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150731 14:15:17 InnoDB: Initializing buffer pool, size = 8.0M
150731 14:15:17 InnoDB: Completed initialization of buffer pool
150731 14:15:17 InnoDB: Started; log sequence number 0 44233
150731 14:15:17 [Note] Event Scheduler: Loaded 0 events
150731 14:15:17 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution

[JohnFLi]

I followed the direction from https://deangrant.wordpress.com/tag/nagios/

Nagios XI: Host and Service details not being displayed

June 7, 2014Dean GrantLeave a comment
Recently, I was troubleshooting an issue with Nagios XI where host and service details where not being displayed from the web management console.

On investigating the log file at ‘/var/log/messages’ there was a number of errors identifying that a table in the MySQL database was crashed and was required to be repaired.

ndo2db: mysql_error: 'Table './nagios/nagios_timedeventqueue' is marked as crashed and should be repaired'
In order to repair the table marked as crashed, I ran the below on the Nagios XI monitoring server , reconnected to the web management console and both host and service details were displayed as expected.

myisamchk --safe-recover /var/lib/mysql/*/*.MYI

And now it only reads as errors

150731 14:15:03 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_customvariablestatus' is marked as crashed and should be repaired
150731 14:15:03 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_servicestatus' is marked as crashed and should be repaired
150731 14:15:03 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_customvariablestatus' is marked as crashed and should be repaired
150731 14:15:03 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_servicestatus' is marked as crashed and should be repaired
150731 14:15:03 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_customvariablestatus' is marked as crashed and should be repaired

[tgriep]

If the host is in that service check, delete it and apply the config.

[JohnFLi]

That's what I have been trying to do.