"Update in progress .." still appearing ...

[PhilG]

Hello:
I updated our Nagios XI CentOS 7.7 server to 7.9, then was upgrading Nagios XI from version 5.6.7 to 5.8.1 from the web console and getting "
Update in progress. Please wait. Update may take a few minutes."
This message did not disappear after 20 minutes.
I found https://support.nagios.com/forum/viewto ... 16&t=50416
and ran "cat /usr/local/nagiosxi/var/xiversion" and the XI version on the server console was still 5.6.7.
I found "https://assets.nagios.com/downloads/nag ... ctions.pdf" and ran the Nagios XI "Quick" script command on the server CLI and waited until the upgrade completed.
After the upgrade completed, I restarted the server "shutdown -r now" and logged back in to the server after it came back up successfully.
I ran the following command from the server CLI "cat /usr/local/nagiosxi/var/xiversion" and this time the version was at 5.8.1.
I logged on the Nagios XI web console and checked for issues.
I noted that the "Update in progress. Please wait. Update may take a few minutes." message was still appearing in the "Check for Updates" window.
I found: https://support.nagios.com/forum/viewto ... 16&t=50416 and ran the following commands on the server console:
# echo "UPDATE xi_options SET value = 'yes' WHERE name = 'last_update_acknowledged';" | mysql -t -u root -pnagiosxi nagiosxi
# service httpd restart
# echo "DELETE FROM xi_commands WHERE command = 1120;" | mysql -t -u root -pnagiosxi nagiosxi
# service httpd restart

I restarted the server and waited for it to come back up with no issues.
I cleared my Firefox browser cache, logged back in to Nagios XI's web console, and noted that the same message keeps appearing. Everything else appears to be functioning with no issues, though, at this time.

How can I get the Nagios XI web interface upgrade session to no longer have this issue?

2nd issue identified: All my Hosts and Services are reporting this morning with "Host is in scheduled downtime", but shouldn't be (time is now 8:22 am CST). For several years I run a recurring scheduled "Maintenance Mode" for most Hosts and their respective Services (there is a percentage of Hosts and Services that are not scheduled for "Maintenance Mode" and alert 24 x 7) that starts every night around 6 pm CST and ends at 6 am CST the next morning. I don't see where that is coming from.

Thank you.

[PhilG]

Fixed.
I used "https://support.nagios.com/kb/article/n ... e-851.html" again, identified the correct database, and followed the rest of the information/solution.

After that, I had to rerun the "Check for Updates" again to clear the error/message.

You may lock this post.

I might be opening a different ticket for a different issue with the localhost CPU current load being critical (red) for almost an hour.
CRITICAL - load average: 4.31, 4.34, 4.38

[benjaminsmith]

HI @PhilG,

You may lock this post.

Sounds good. We'll lock this up. Glad you got cleared out.

Regards,
Benjamin