Nagios Support Forum

Posted: **Mon Feb 20, 2017 5:19 am**

Hello,

I just did a fresh deploy a new Centos 7 server where I then restored from my old Nagios server that was and old 2014R1.2 updated to the last version of XI just before the restore. All seems to be working fine but I saw the following messages on my /var/log/messages just after I did an "apply configuration"

Code: Select all

Feb 20 10:09:43 MONAPP06 systemd: Cannot add dependency job for unit microcode.service, ignoring: Unit is not loaded properly: Invalid argument.
Feb 20 10:09:43 MONAPP06 systemd: Stopping LSB: Starts and stops the Nagios monitoring server...
Feb 20 10:09:43 MONAPP06 ndo2db: Error: mysql_query() failed for 'UPDATE nagios_conninfo SET disconnect_time=NOW(), last_checkin_time=NOW(), data_end_time=FROM_UNIXTIME(0), bytes_processed='0', lines_processed='0', entries_processed='0' WHERE conninfo_id='0''
Feb 20 10:09:43 MONAPP06 ndo2db: mysql_error: 'MySQL server has gone away'
Feb 20 10:09:43 MONAPP06 ndo2db: Error: Connection to MySQL database has been lost!
Feb 20 10:09:44 MONAPP06 nagios: Stopping nagios:. done.
Feb 20 10:09:44 MONAPP06 systemd: Starting LSB: Starts and stops the Nagios monitoring server...
Feb 20 10:09:44 MONAPP06 nagios: Starting nagios: done.
Feb 20 10:09:44 MONAPP06 systemd: Started LSB: Starts and stops the Nagios monitoring server.

Is this normal? I didn't recall seen this kind of error on my old server.
Maybe I have to make some modification on my mariadDB config?

Edit: Is kind of weird but now the messages just don't show anymore when I press again on "Apply configuration"

Posted: **Mon Feb 20, 2017 11:53 am**

ndo2db is restarted during an Apply Configuration. MySQL/MariaDB is not.

What is the output of

Code: Select all

ipcs -q

Posted: **Mon Feb 20, 2017 12:59 pm**

avandemore wrote:ndo2db is restarted during an Apply Configuration. MySQL/MariaDB is not.

What is the output of
Code: Select all
ipcs -q

I have MariaDB offloaded to a secondary server so maybe I missed some configuration file but as I said before, I haven't seen the error anymore. I think is because I missed to copy the following values to the /etc/my.cnf file because after that was done I no longer see the errors.

Code: Select all

max_allowed_packet = 64M
query_cache_size=16M
query_cache_limit=4M
tmp_table_size=64M
max_heap_table_size=64M
key_buffer_size=32M
table_open_cache=32

This is the output of the command you mention

[root@ESBARLMONAPP06 ~]# ipcs -q

------ Message Queues --------
key msqid owner perms used-bytes messages
0x99000080 32768 nagios 600 0 0

Posted: **Mon Feb 20, 2017 1:04 pm**

I don't think those setting are related to the issue you posted about originally. Perhaps you had some type of transitory networking error somewhere in between XI and the DB. Without more information or the ability to reproduce, it's hard to say. What's in the DB log on the remote system?

Nagios Support Forum

Strange error messages on log

Strange error messages on log

Re: Strange error messages on log

Re: Strange error messages on log

Re: Strange error messages on log