Apply Config on NagiosXI taking lot of time

[Sampath.Basireddy]

Hello There,

Each time I apply config in NagiosXI, it takes a lot of time to complete.

Let say I added a new check and apply config, but the the config apply is completed, I am able to see the check already.

Nagios XI 5.5.9

I am seeing below errors flooding in /usr/local/nagiosxi/var/cmdsubsys.log while the config is applied:

Total Warnings: 77
Total Errors: 0

Things look okay - No serious problems were detected during the pre-flight check
> Return Code: 0
--------------------------------------
..OUTPUT=--------------------------------------
RETURNCODE=0
.........................................
PROCESSED 0 COMMANDS
.................. <p><pre>SQL Error [nagiosql] : Duplicate entry '399-8805-2' for key 'PRIMARY'</pre></p>
<p><pre>SQL Error [nagiosql] : Duplicate entry '399-8804-2' for key 'PRIMARY'</pre></p>
<p><pre>SQL Error [nagiosql] : Duplicate entry '399-8806-2' for key 'PRIMARY'</pre></p>
<p><pre>SQL Error [nagiosql] : Duplicate entry '399-8807-2' for key 'PRIMARY'</pre></p>
<p><pre>SQL Error [nagiosql] : Duplicate entry '399-8808-2' for key 'PRIMARY'</pre></p>
<p><pre>SQL Error [nagiosql] : Duplicate entry '399-8809-2' for key 'PRIMARY'</pre></p>
. <p><pre>SQL Error [nagiosql] : Duplicate entry '399-8800-2' for key 'PRIMARY'</pre></p>
. <p><pre>SQL Error [nagiosql] : Duplicate entry '399-8895-2' for key 'PRIMARY'</pre></p>
... <p><pre>SQL Error [nagiosql] : Duplicate entry '399-8819-2' for key 'PRIMARY'</pre></p>
<p><pre>SQL Error [nagiosql] : Duplicate entry '399-8819-2' for key 'PRIMARY'</pre></p>

Please suggest.

[tgriep]

There was a bugfix in XI 5.5.10 that fixes the messages in the cmdsubsys log file when Applying the Config.

- Fixed MySQL nagiosql errors in cmdsubsys.log for regular users with limited CCM access [TPS#14045] -JO

Please upgrade to the latest version of XI to see if it fixes the issue.

How long does it take to Apply the Config?
Are you logged in as an admin or as a user?
How many Host and Services are defined on the server?

[Sampath.Basireddy]

How long does it take to Apply the Config?

Code: Select all

Today I checked and it took about 2min 45sec to finish applying configuration.

Are you logged in as an admin or as a user?

Code: Select all

Logged in as Admin

How many Host and Services are defined on the server?

Code: Select all

1100 Hosts & 11000 Services. We 3 Mod-Grearmans

[tgriep]

Thanks for the information.

Can you upgrade to the latest version of Nagios XI on the server?