Page 1 of 1
All hosts/services in pending state after upgrade to 5.7
Posted: Wed Jun 10, 2020 11:18 am
by 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.
Re: All hosts/services in pending state after upgrade to 5.7
Posted: Wed Jun 10, 2020 2:27 pm
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.
Re: All hosts/services in pending state after upgrade to 5.7
Posted: Wed Jun 10, 2020 5:18 pm
by 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
Re: All hosts/services in pending state after upgrade to 5.7
Posted: Thu Jun 11, 2020 12:07 am
by 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
Re: All hosts/services in pending state after upgrade to 5.7
Posted: Thu Jun 11, 2020 5:07 am
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
Re: All hosts/services in pending state after upgrade to 5.7
Posted: Thu Jun 11, 2020 8:15 am
by ajwilliamson
updating the tables as suggested appears to have corrected my issue....thank you!
Re: All hosts/services in pending state after upgrade to 5.7
Posted: Thu Jun 11, 2020 5:06 pm
by 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.
Re: All hosts/services in pending state after upgrade to 5.7
Posted: Fri Jun 12, 2020 10:20 am
by ajwilliamson
yes, feel free to lock and mark as resolved. thanks