Page 1 of 1

Remove/delete queued notifications

Posted: Thu Feb 07, 2019 2:20 am
by maoreyes76
We have old notifications in nagiosxi. The problem I am facing is that nagiosxi is consuming a lot of disk. What I can see is that we are still getting old notifications from a major work we did in our infrastructure. So my question is, is there any way to clean up the notifications queue somehow?

For all support requests, we need to know:
1. Linux CentOS release 6.4 (Final) 64Bit
2. Vmware image
3. Are there special configurations on your system, ie; is Gnome installed? Are you using a proxy? Are you using SSL? NO

Re: Remove/delete queued notifications

Posted: Thu Feb 07, 2019 9:56 am
by maoreyes76
Hello!

I finally could find a solution for it in https://support.nagios.com/forum/viewto ... 99#p225332

This is what needs to be done:

service nagios stop
service ndo2db stop
service crond stop
service postgresql restart
pkill -9 -u nagios
echo "truncate table xi_events; truncate table xi_meta; truncate table xi_eventqueue;" | psql nagiosxi nagiosxi
service crond start
service ndo2db start
service nagios start
service npcd restart

This case can be close.

Re: Remove/delete queued notifications

Posted: Thu Feb 07, 2019 1:20 pm
by benjaminsmith
Hello,
This case can be close.
Thanks for the update and glad you got this resolved. Closing.