Nagios Support Forum

@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.

File sent.

I am fine truncating the data.

@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

THANK YOU!!!! That worked.

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