Blank service check

[npolovenko]

@hbouma, There could still be some corruption is service status/host status tables. Please run the following queries and send me the nagiosNew file from the /tmp/ folder.

echo "SELECT * FROM nagios_servicestatus;" | mysql -t -uroot -pnagiosxi nagios > /tmp/nagiosNew.txt
echo "SELECT * FROM nagios_hoststatus;" | mysql -t -uroot -pnagiosxi nagios >> /tmp/nagiosNew.txt

Also, would you be ok with truncating these database tables? You may lose some service check data but this could help us get rid of the blank check.

[hbouma]

File sent.

I am fine truncating the data.

[npolovenko]

@hbouma, I think I found the corrupted entry and we can try removing it manually.
Please backup your XI and make a snapshot of the VM before running this query.
https://assets.nagios.com/downloads/nag ... ios-XI.pdf

echo "DELETE FROM nagios_servicestatus WHERE servicestatus_id = '755728';" | mysql -uroot -pnagiosxi nagios

[hbouma]

THANK YOU!!!! That worked.

[lmiltchev]

Great! We are marking this issue as resolved, and closing this topic. If you have any further questions, please start a new thread.