Can't delete Acknowledged comment

[TBT]

We have a host with an Acknowledgement that cannot be deleted. Current status is Up/Ok state, yet the comment remains, even when issuing a delete via GUI.

Please advise,

[npolovenko]

Hello, @TBT. Are you having this problem on the XI 5.4.13 server?

Please run the following commands and let me know if it fixes the problem:

mysqlcheck -r -f -uroot -pnagiosxi --all-databases
service nagios stop
service ndo2db stop
rm /usr/local/nagios/var/retention.dat
mv /usr/local/nagios/var/ndo2db.lock /usr/local/nagios/var/ndo2db.lock.bak
mv /usr/local/nagios/var/ndo.sock /usr/local/nagios/var/ndo.sock.bak
service ndo2db start
service nagios start

[TBT]

Hello, @TBT. Are you having this problem on the XI 5.4.13 server?

Please run the following commands and let me know if it fixes the problem:

mysqlcheck -r -f -uroot -pnagiosxi --all-databases
service nagios stop
service ndo2db stop
rm /usr/local/nagios/var/retention.dat
mv /usr/local/nagios/var/ndo2db.lock /usr/local/nagios/var/ndo2db.lock.bak
mv /usr/local/nagios/var/ndo.sock /usr/local/nagios/var/ndo.sock.bak
service ndo2db start
service nagios start

Yes, XI 5.4.13, one of nine. I'd need to schedule a maintenance window before running this as it is a production system. We plan on upgrading to XI 5.5.6 next month, is a check ran during that process?

[npolovenko]

@TBT, While XI is upgrading checks are not executed. However, the upgrade usually doesn't take longer than 5-10 minutes.
If your XI is based on a VM please make a snapshot beforehand. That way you can revert back if something goes wrong during the upgrade. Otherwise, you can test the upgrade on a non-production clone first.

[TBT]

Hello, @TBT. Are you having this problem on the XI 5.4.13 server?

Please run the following commands and let me know if it fixes the problem:

mysqlcheck -r -f -uroot -pnagiosxi --all-databases
service nagios stop
service ndo2db stop
rm /usr/local/nagios/var/retention.dat
mv /usr/local/nagios/var/ndo2db.lock /usr/local/nagios/var/ndo2db.lock.bak
mv /usr/local/nagios/var/ndo.sock /usr/local/nagios/var/ndo.sock.bak
service ndo2db start
service nagios start

Tried your suggestion, the acknowledgment cleared on the Host in question, however, I noticed ALL other legit acknowledgments (hosts is still in alarm state) were removed too. Is this expected?

[npolovenko]

@TBT , Yeah, that's because we removed the retention.dat file. I am suspecting that there was a corrupt entry and that's why you couldn't remove the acknowledgment. Can you try acknowledging some other host or a service problem and see if its easily removed?

[TBT]

@TBT , Yeah, that's because we removed the retention.dat file. I am suspecting that there was a corrupt entry and that's why you couldn't remove the acknowledgment. Can you try acknowledging some other host or a service problem and see if its easily removed?

Yes, acknowledge works. Issue resolved.