Serious Issues after upgrading to 5.7.1

[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.

[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.

[rbarbaro]

did you get this fixed? I have the same issue.

[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?

Code: Select all

MySQL -V

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

[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.

[tgriep]

I saw that you opened a ticket, we will continue to support the issue there.