Page 1 of 1
URGENT - Flush Pending Notifications?
Posted: Thu Sep 27, 2018 4:31 pm
by rkane
I have hundreds of messages backed up in the notification queue....how do I flush these. We're still receiving notifications from an outage a day ago. This is urgent, sorry for the new thread
Re: URGENT - Flush Pending Notifications?
Posted: Thu Sep 27, 2018 5:05 pm
by scottwilkerson
Code: Select all
echo "truncate table xi_events; truncate table xi_meta; truncate table xi_eventqueue;" | mysql -uroot -pnagiosxi nagiosxi
Re: URGENT - Flush Pending Notifications?
Posted: Thu Sep 27, 2018 5:27 pm
by rkane
scottwilkerson wrote:Code: Select all
echo "truncate table xi_events; truncate table xi_meta; truncate table xi_eventqueue;" | mysql -uroot -pnagiosxi nagiosxi
Thank you!! Any way to check the queue and make sure it is cleared?
Re: URGENT - Flush Pending Notifications?
Posted: Fri Sep 28, 2018 7:49 am
by scottwilkerson
There isn't a place to see them waiting other than looking at the database tables that command just deleted.
You can see any new ones being processed though by tailing the eventman.log
Code: Select all
tail -f /usr/local/nagiosxi/var/eventman.log
Re: URGENT - Flush Pending Notifications?
Posted: Fri Sep 28, 2018 9:45 am
by rkane
Appreciate it, want to close this thread and we can work through it on the other?
Re: URGENT - Flush Pending Notifications?
Posted: Fri Sep 28, 2018 10:17 am
by benjaminsmith
Appreciate it, want to close this thread and we can work through it on the other?
Ok. Sounds good, I will go ahead and lock this post, and if you're unable to resolve this issue please use the other post. Thanks.