Nagios Support Forum

Posted: **Fri Mar 08, 2019 8:20 pm**

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
.................. <pre>SQL Error [nagiosql] : Duplicate entry '399-8805-2' for key 'PRIMARY'</pre>
<pre>SQL Error [nagiosql] : Duplicate entry '399-8804-2' for key 'PRIMARY'</pre>
<pre>SQL Error [nagiosql] : Duplicate entry '399-8806-2' for key 'PRIMARY'</pre>
<pre>SQL Error [nagiosql] : Duplicate entry '399-8807-2' for key 'PRIMARY'</pre>
<pre>SQL Error [nagiosql] : Duplicate entry '399-8808-2' for key 'PRIMARY'</pre>
<pre>SQL Error [nagiosql] : Duplicate entry '399-8809-2' for key 'PRIMARY'</pre>
. <pre>SQL Error [nagiosql] : Duplicate entry '399-8800-2' for key 'PRIMARY'</pre>
. <pre>SQL Error [nagiosql] : Duplicate entry '399-8895-2' for key 'PRIMARY'</pre>
... <pre>SQL Error [nagiosql] : Duplicate entry '399-8819-2' for key 'PRIMARY'</pre>
<pre>SQL Error [nagiosql] : Duplicate entry '399-8819-2' for key 'PRIMARY'</pre>

Please suggest.

Posted: **Mon Mar 11, 2019 9:01 am**

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?

Posted: **Mon Mar 11, 2019 1:42 pm**

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

Posted: **Mon Mar 11, 2019 2:16 pm**

Thanks for the information.

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

Nagios Support Forum

Apply Config on NagiosXI taking lot of time

Apply Config on NagiosXI taking lot of time

Re: Apply Config on NagiosXI taking lot of time

Re: Apply Config on NagiosXI taking lot of time

Re: Apply Config on NagiosXI taking lot of time