Nagios Support Forum

Hi,

This is anotehr ticket but it could be related to "Lost all what was in Scheduled Downtime after upgrade" ticket.
Because of some issues with 5.7 with new NDO3, I roolback to NDO2DB.
I did that 3 times in a row until version 5.7.4.
Because I was on CentOS6, I was required to upgrade to 7 to continue having support.
So I have download a new CentOS 7 nagiosXI images and I have work to migration nagiosxi on it (backup/restore). So now i'm on the new CentOS 7 with NDO2 but mysql is always running at 150% CPu and more et the console take 1-2 minutes delay to display the current status.
The behavior look like I'm on new NDO3, but I'm suppose to be on NDO2.

What I should check?

update

As soon as I apply the configuration in CCM, mysqld run all the time at 150%+ CPU utilization. And this cause a lot of delay displayed services/hosts status in the console. The monitoring seem working well when I look at the nagios.log but the console is almost not usable (very long delay to received status and very log to change view).

When I migrate from centos6 to centos7, it went on mariadb (and not mysql as it was on centos6). Should I tune something specific for mariadb after the upgrade?

Hi @step007,

Looks like you've opened a ticket for this issue at:

https://support.nagios.com/tickets/scp/ ... p?id=11992

We'll move this case over to that ticket and close out this thread so we can best focus our efforts.

Thanks,
Benjamin

I did few minutes ago. Ok, see you there.
Even if the ticket as just be opened few minutes ago, can you check it and give me some feedback? Since I opened that forum thread yesterday, maybe the ticket can be looked faster

Hi,

If you can attach a current system profile to the thread that would help us troubleshoot right away. If you have an offloaded database please retrieve the log from the remote server and post that to the ticket.

mysqld run all the time at 150%+ CPU utilization

Likely some db corruption, so go ahead and run the repair script as root from the CLI. Post any errors to the ticket as well or let us know if you notice any improvements after running that. Thanks, Benjamin

To send us your system profile.
Login to the Nagios XI GUI using a web browser.
Click the "Admin" > "System Profile" Menu
Click the "Download Profile" button
Save the profile.zip file and share in a private message or upload it to the post/ticket, and then reply to this post to bring it up in the queue.

Already run the /usr/local/nagiosxi/scripts/repair_databases.sh yesterday night. Change nothing.

Cannot download the system profile! got this error:
PROFILE BUILD FAILED
Array
(
)
CODE: 1

Hi @step007,

That error message is almost always the result of an incorrect sudoers ( this can cause other issues as well). Follow the steps in the KB article below to correct and try once more to download.

Nagios XI - Profile Build Failed

If it still fails, we can generate one from the command line.
Then attach the /usr/local/nagiosxi/var/components/profile.zip​ file to that ticket.

File upload

HI,

I see that Sean Saxx has replied to your ticket, please follow up in the open ticket.

Thanks,
Benjamin

Yes, np, thanks!