Nagios XI secondary node not working after license expiry

[ericssonau]

Hello guys,

We have Nagios XI installed in 3 instances- Active,passive and test mode. It's license expired on 31st of August.

After a few days of the license expiry, the performance of the secondary instance has degraded badly (High CPU load, mysqld utlizing 100% CPU, GUI getting stuck).

Is this due to the license getting expired? Is there any such link?

Regards!

[benjaminsmith]

Is this a trial or the expiration of an existing license?

If you had an existing license that expired, you will not have access to ongoing maintenance updates. However, the expiration will not change system performance or software features.

[ericssonau]

It is an existing license.

Okay so you mean, the DR node will continue functioning like before? We are experiencing unusual behavior from our secondary nagios instance. Like the last chek time not being updated, service utlizing high CPU etc.

[scottwilkerson]

The license shouldn't affect performance at all.

Can you post the output of the following:

Code: Select all

ps -ef|grep nagios.cfg

[ericssonau]

Hello,

I have pasted the output of the above command:

[root@lon-com1-nagfm-00 ~]# ps -ef|grep nagios.cfg
root 28850 28819 0 17:06 pts/0 00:00:00 grep nagios.cfg
nagios 32964 1 0 Oct07 ? 00:01:17 /usr/local/nagios/bin/nagios -d /usr/local/nagios/etc/nagios.cfg
nagios 33028 32964 0 Oct07 ? 00:00:03 /usr/local/nagios/bin/nagios -d /usr/local/nagios/etc/nagios.cfg
nagios 38933 1 0 Oct06 ? 00:01:21 /usr/local/nagios/bin/nagios -d /usr/local/nagios/etc/nagios.cfg
nagios 38995 38933 0 Oct06 ? 00:00:23 /usr/local/nagios/bin/nagios -d /usr/local/nagios/etc/nagios.cfg
[root@lon-com1-nagfm-00 ~]#


I have killed all nagios processes and restarted the service a number of times and this issue has been happening since a long time.

The biggest challenge is, the "mysqld" process is utilizing 100% CPU all the time. As a result, the performance of the DR node has been degrading with time.

I have tried troubleshooting in every possible way but nothing seem to help the cause.

Can you please suggest something to get rid of it?

Any help would be appreciated.

Regards!

[scottwilkerson]

Nagios XI 5.5.5 was released yesterday which has some fixes for bugs, specifically a few that can cause mysql to spike to 100%

I would highly recommend upgrading to that version.

[ericssonau]

Hey Scott,

We have finally got our license renewed and then upgraded our XI instance to version 5.5.5.

Howerver, the mysqld process keeps on utilizing 100% CPU all the time.

Our DR node has been down due to this reason since a long long time. Is there any other remedy to it?

Regards!

[scottwilkerson]

Can you run the following on the system that has the CPU spiked at 100% for mysql and return the output so we can see if there is a long running process.

Code: Select all

echo "show processlist;"|mysql -pnagiosxi

Also, I would like to verify we aren't running into an issue with cron processes backing up, can you post the output of the following

Code: Select all

ps -ef|grep php