Nagios Failover Issue

[tgriep]

Thanks for the MYSQL Log file. I didn't see any errors around the times that the server had the issue.
Usually when you see problems with ndo2db having issues is that it cannot write data to the MYSQL database at all or fast enough.
It looks like your MYSQL database files are hosted on a share, is that true?
If so, can you check that share to see if around that time to see if there was any errors for that share or the system that is hosting the data?

[rtsupport]

Our database file hosted locally on same server.

[tgriep]

I saw changed path in the log file and didn't know if it was a share or NFS mount.

You will have to enabling the DR logging to see why it failed over.

[rtsupport]

I have redirected failover logs to a file. Failover script runs after every minute and redirect output to a file. I have collected logs at the time when 2 failovers happend. I am sending it on PM.

[tgriep]

Thanks for the files. If the commands are setup like the example, it looks like the /usr/local/nagios/var/nagios.log file did not get updated within 20 minutes but the processes were still running.
You would have to look at that server when it failed and see if you can find errors.
Check the /usr/local/nagios/var/nagios.log file as well as the log files in the /var/log folder for any errors.

[rtsupport]

I did not find anything suspicious However old logs are not handy now. I will also save the log on next failover and share it with your if required.

[tgriep]

OK, thanks for the update.