Page 2 of 2

Re: Monitoring engine event queue shows zero.

Posted: Mon Sep 14, 2020 12:15 pm
by RebeccaIlene
Hi Benjamin,

The event queue suddenly went down over the weekend for 12 hours.
We tried everything to bring it backup but nothing worked.
Finally on the fifth restart of all three ( Application and two worker servers) the event queue came up after 10 minutes of the service being up.

Today we applied the configuration and the event queue came up only after 20 minutes.

Is there a problem with the modgearmen services with the new version? Is that what is causing this?

I have also collected logs that I will PM you.

Can we please find a fix for this ASAP? It's impacting our monitoring and a high priority ticket was raised for the system being down over the weekend.

We tried to downgrade the version on the copy of this VM and when we downgraded the event queue worked fine but it came up with the below error.

SQL Error [nagiosxi] : You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE user_id = 5' at line 3

This error filled the screen and was causing problem to navigate on the GUI. Can you please let us know how this can be fixed?

Re: Monitoring engine event queue shows zero.

Posted: Mon Sep 14, 2020 12:24 pm
by RebeccaIlene
To add to my previous message, we have also observed that the https://nagios.monitoring/nagios works fine compared to https://nagio.monitoring/nagiosxi when the event queue is down.

Re: Monitoring engine event queue shows zero.

Posted: Tue Sep 15, 2020 1:12 pm
by ssax
We downgraded NDO3 back to NDO2DB on both PROD/UAT on the remote today, this is one of those same systems, correct? If so, please monitor and let us know if you see the issue again.

Re: Monitoring engine event queue shows zero.

Posted: Tue Sep 15, 2020 8:34 pm
by RebeccaIlene
Hi Sean,

Thanks for your help yesterday. We will monitor this and let you know if any issues come up.

Re: Monitoring engine event queue shows zero.

Posted: Wed Sep 16, 2020 5:48 pm
by cdienger
We'll wait for an update :)

Re: Monitoring engine event queue shows zero.

Posted: Thu Oct 01, 2020 9:04 pm
by RebeccaIlene
Hi Team,

Please close this thread for now.

Working on this in a support center ticket.

Re: Monitoring engine event queue shows zero.

Posted: Fri Oct 02, 2020 8:18 am
by scottwilkerson
RebeccaIlene wrote:Hi Team,

Please close this thread for now.

Working on this in a support center ticket.
Great!

Closing thread