All hosts/services in pending state after upgrade to 5.7

[ajwilliamson]

Hi,

Performed an upgrade to our installation this morning and everything appeared to go well. However, all host and service checks seem to be in pending status.

I've tried to manually force an immediate check of hosts and services, but this doesn't appear to have any effect.

Also, it does appear that at least some of the checks are working, as I've received a few email alerts for status changes.

I will also include that upon login I do receive a notification about an "IP Address Mismatch in Internal Program URL", not sure if related or not.

Thanks in advance for your help.

[[email protected]]

One of our customers also noticed all checks had “pending” state after upgrading. Last check time and next check time reported 1970-01-01. upgrade log however looked fine.

Problem did not persist, restarting Nagios helped in getting service picked up by the scheduling queue.

[ssax]

So this is resolved? If not, please PM me a copy of your profile.

You can also try running these commands:

Code: Select all

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";
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;"

Or replacing this file with the one I've attached:

Code: Select all

/usr/local/nagiosxi/html/db/queries.inc.php

[jweijters]

I have also seen this,

also after a restart of the Nagios Server, At first I don't see any status of hosts or services.
After some minutes, Host and service slowly status get a pending fase with the last check 1970-01-01 00:00:01, also the amount of services is not correct, we should have approx 48000 Services.
After more time, it gets filled but it takes ~90 minutes

[[email protected]]

Everything appears to be in order when looking at the Core interface.
Only in the XI interface are all checks on pending.

The php file does not fix the problem, and the database commands give an error:

# mysql -uroot -p**** -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'

I will open a ticket for this problem and attach a system profile there.

Regards,
Antoine Beerens
Conclusion Xforce

[ajwilliamson]

updating the tables as suggested appears to have corrected my issue....thank you!

[ssax]

@ajwilliamson I'm glad your issue is resolved! Are we okay to lock this topic and mark it as resolved?

@[email protected] Did you create the ticket? I want to make sure you're getting support before closing this.

[ajwilliamson]

yes, feel free to lock and mark as resolved. thanks