Nagios Support Forum

I have completed an upgrade to 5,7.0 and noticed I am getting a pending state for all hosts and services.

Thanks again for your help.

Attachment:

Profile is also attached.

Found this in another issue that appears similar

[root@nagios /]# mysql -uroot -pnagiosxi -h 127.0.0.1 nagios -e "ALTER TABLE nagios_hoststatus ADD check_options smallint(6) NOT NULL default '0' AFTER check_type";

ERROR 1060 (42S21) at line 1: Duplicate column name 'check_options'

[root@nagios /]# mysql -uroot -pnagiosxi -h 127.0.0.1 nagios -e "ALTER TABLE nagios_servicestatus ADD check_options smallint(6) NOT NULL default '0' AFTER check_type;"

ERROR 1060 (42S21) at line 1: Duplicate column name 'check_options'

Upgrading to Nagios XI 5.7.1, which was released yesterday, should fix your issue.

Here's the Nagios XI changelog:

https://www.nagios.com/downloads/nagios-xi/change-log/

Hello

I have upgraded to 5.7.1, this appears to have solve my issue for the pending state, although there is a lag before the information is presented on the dashboard.

I do have a new issue related to NRPE, I will log another request for this.

Thanks
Terry

Hi Terry,

I have upgraded to 5.7.1, this appears to have solve my issue for the pending state, although there is a lag before the information is presented on the dashboard.

How much of a lag are you talking about? How large is your system (number of hosts & services)? Any additional information would help our developers with identifying, and fixing the issue. Thank you!

I'm seeing the same 'lag'.

I just added a couple of devices/services and it took about nine minutes for the Host/Service Status panels to show data.

I have 530+ hosts and 2100+ services being monitored.

Our developers believe that the lag is caused by truncating the status tables, and they are working on a fix. The issue should be resolved in the next release of Nagios XI.

Hello,
for information sake, number of hosts is 975 and number of services are 8672
Thanks for looking into the issues
Regards
Terrence

Thanks for the info Terrence!

Hello,

Do you have a proposed date for release of the next version with this fix in it?

Regards
Terrence