Extremely high CPU usage after upgrade

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
mbowden
Posts: 93
Joined: Thu May 03, 2012 3:52 pm

Extremely high CPU usage after upgrade

Post by mbowden »

I upgraded to the latest Nagiosxi yesterday and noticed a pretty big delay when applying configuration. This morning the machine continued to be taxed with top readings of 100+ I was then presented with the following screen;
Message: A database connection error has been detected, we are attempting to repair the server, if the repair does not resolve the issue, please contact Nagios support.

Run the following from the CLI as root to attempt to repair the DB

/usr/local/nagiosxi/scripts/repair_databases.sh

SQL: SQL Error [nagiosxi] : Database connection failed SQL: SQL Error [nagiosxi] : Database connection failed SQL: SQL Error [nagiosxi] : Database connection failedMessage: A database connection error has been detected, we are attempting to repair the server, if the repair does not resolve the issue, please contact Nagios support.

Run the following from the CLI as root to attempt to repair the DB

/usr/local/nagiosxi/scripts/repair_databases.sh

I ran the command and the box is so CPU bound at this point its useless. The machine functioned appropriately prior to the upgrade, no additional monitors have been added.

RHEL 5.7
tmcdonald
Posts: 9117
Joined: Mon Sep 23, 2013 8:40 am

Re: Extremely high CPU usage after upgrade

Post by tmcdonald »

What version were you running prior to the upgrade?

If you're still able to use the interface, go to Configure -> Core Config Manager, then on the left under Tools click Write Config Files. Then click Delete, then Write, then Verify and post a screenshot.
Former Nagios employee
mbowden
Posts: 93
Joined: Thu May 03, 2012 3:52 pm

Re: Extremely high CPU usage after upgrade

Post by mbowden »

I will get your other screen shot momentarily, I thought I would share this one first
You do not have the required permissions to view the files attached to this post.
mbowden
Posts: 93
Joined: Thu May 03, 2012 3:52 pm

Re: Extremely high CPU usage after upgrade

Post by mbowden »

And the find processes still keep coming
You do not have the required permissions to view the files attached to this post.
mbowden
Posts: 93
Joined: Thu May 03, 2012 3:52 pm

Re: Extremely high CPU usage after upgrade

Post by mbowden »

requested screen shot, 16 find processes running now
You do not have the required permissions to view the files attached to this post.
mbowden
Posts: 93
Joined: Thu May 03, 2012 3:52 pm

Re: Extremely high CPU usage after upgrade

Post by mbowden »

ok last find screenshot
You do not have the required permissions to view the files attached to this post.
User avatar
tgriep
Madmin
Posts: 9190
Joined: Thu Oct 30, 2014 9:02 am

Re: Extremely high CPU usage after upgrade

Post by tgriep »

Can you run the following in a shell and post the output so we can see what the find command is running?

Code: Select all

ps aux --cols=300 |grep find
Be sure to check out our Knowledgebase for helpful articles and solutions!
mbowden
Posts: 93
Joined: Thu May 03, 2012 3:52 pm

Re: Extremely high CPU usage after upgrade

Post by mbowden »

I apologize about the delay in responding, The box basically continued spinning up find processes until it crashed. I rebooted and a minute or 2 later there was a single find process, then another..
You do not have the required permissions to view the files attached to this post.
mbowden
Posts: 93
Joined: Thu May 03, 2012 3:52 pm

Re: Extremely high CPU usage after upgrade

Post by mbowden »

wrong screen shot
You do not have the required permissions to view the files attached to this post.
mbowden
Posts: 93
Joined: Thu May 03, 2012 3:52 pm

Re: Extremely high CPU usage after upgrade

Post by mbowden »

The perfdata directory its looking at is 32G not sure if that is relevant or not

We don't necessarily care about the historical perfdata if that is the issue, we could dump it and start collecting data moving forward.
Locked