Remove/delete queued notifications

[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

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

[benjaminsmith]

Hello,

This case can be close.

Thanks for the update and glad you got this resolved. Closing.