URGENT - Flush Pending Notifications?

[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

[scottwilkerson]

Code: Select all

echo "truncate table xi_events; truncate table xi_meta; truncate table xi_eventqueue;" | mysql -uroot -pnagiosxi nagiosxi

[rkane]

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?

[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

[rkane]

Appreciate it, want to close this thread and we can work through it on the other?

[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.