Page 1 of 1
Serious Issues after upgrading to 5.7.1
Posted: Fri Jun 12, 2020 4:28 pm
by nickap
We upgraded our Nagios XI to 5.7.1 and now all the checks are stuck in pending:
View service status details for this host Pending 18425d 16h 25m 36s 0/0 1970-01-01 00:00:01 No check results for host yet...
We tried to reboot the appliance, it kicked in after about 40 minutes but now it got stuck again.
Also our NRPE checks are failing with "invalid packet version".
Moderator's Note: The profile has been shared with the support team but has been removed from the public forum.
Re: Serious Issues after upgrading to 5.7.1
Posted: Fri Jun 12, 2020 6:56 pm
by nickap
We ran the repair database command and it appears to be now checking in the Core view, but the dashboard is still not updating.
Re: Serious Issues after upgrading to 5.7.1
Posted: Mon Jun 15, 2020 11:23 am
by rbarbaro
did you get this fixed? I have the same issue.
Re: Serious Issues after upgrading to 5.7.1
Posted: Mon Jun 15, 2020 1:36 pm
by benjaminsmith
Hi
@rbarbaro,
Thanks for attaching the profile. The crashed database tables have been cleared but there are still some errors in the database log.
200612 14:34:48 [ERROR] Missing system table mysql.proxies_priv; please run mysql_upgrade to create it
200612 14:34:48 [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong structure
200612 14:34:48 [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure
What version of MySQl is currently installed on the server?
It's likely the GUI is not getting updated due to the database issues present, I would recommend opening a support ticket for this issue and reference this post for fastest resolution.
https://support.nagios.com/tickets/
Also our NRPE checks are failing with "invalid packet version".
Regarding, the issue with NRPE checks, please add a
-3, for version 3 packets, argument to your check command, and let me know if the error is cleared.
Reference:
https://support.nagios.com/kb/article/n ... s-786.html
Benjamin
Re: Serious Issues after upgrading to 5.7.1
Posted: Tue Jun 16, 2020 10:23 am
by nickap
We had to restore back to 5.6.x because it appears the monitoring engine was crashing or timing out. I've attached the nagios.log to see if that provides anymore insight.
We added -2 to the check and that cleared the errors, but we'll try -3 after we can successfully upgrade.
Re: Serious Issues after upgrading to 5.7.1
Posted: Tue Jun 16, 2020 2:38 pm
by tgriep
I saw that you opened a ticket, we will continue to support the issue there.