URGENT! Nagios flooding mail server but mailq is empty!

[dwhitfield]

Did you recently upgrade to 5.4.3? It seems like it did not install properly. If you did upgrade recently, can you post your upgrade.log?

[dfmco]

I did upgrade. Here is the log that I think you are looking for.

[avandemore]

Please try this instead:

Code: Select all

# psql -Unagiosxi nagiosxi -c "SELECT COUNT(*) FROM xi_eventqueue;"

[dfmco]

[root@bmcap-nagios01 ~]# psql -Unagiosxi nagiosxi -c "SELECT COUNT(*) FROM xi_eventqueue;"
count
-------
0
(1 row)

[avandemore]

How about:

Code: Select all

# psql -Unagiosxi nagiosxi -c "SELECT COUNT(*) FROM xi_events;"

[dfmco]

Same
[root@bmcap-nagios01 ~]# psql -Unagiosxi nagiosxi -c "SELECT COUNT(*) FROM xi_events;"
count
-------
0
(1 row)

[dfmco]

As an FYI, we were in violation of our contract (4 days down) so I had to turn on mail again. It seems that the queues have timed out as we have not gotten any alarms. I must understand what happened and it needs to be fixed as we now owe the customer an RFO due to the amount of time this has been down.

[dfmco]

You have me thinking about the upgrade. The last several upgrades had to be done manually from the CLI as the GUI upgrade would fail. Do you think that is related?

[avandemore]

Can you do the following?

Code: Select all

# tar cJvf /tmp/log.tar.xz /usr/local/nagios/var/nagios.log /usr/local/nagios/var/archives/nagios-04-* /usr/local/nagios/var/archives/nagios-03-3*

Then send me the file /tmp/log.tar.xz

I do not think this is related to an upgrade.

[dfmco]

log attached