All hosts/services in pending state after upgrade to 5.7

[tpwebb]

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:

Pending Issue.png

Profile is also attached.

[tpwebb]

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'

[lmiltchev]

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/

[tpwebb]

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

[lmiltchev]

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!

[ajwilliamson]

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.

[lmiltchev]

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.

[tpwebb]

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

[lmiltchev]

Thanks for the info Terrence!

[tpwebb]

Hello,

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

Regards
Terrence