Ad Widget

Collapse

Clearing Email Sending Queue

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • TangentDelta
    Junior Member
    • Apr 2025
    • 2

    #1

    Clearing Email Sending Queue

    Hello.

    I have a Zabbix 7 server that receives SNMP traps from multiple switches and sends alerts for ports going down or up. Occasionally, a port will begin flapping and generate thousands of problems and clears, which triggers the mail-sending media to send an alert out for every one, once a second. There appears to be a queue of some sort that fills up with these alerts, and disabling the media, trigger, and host does not stop them from trickling out. If I kill the Zabbix server daemon, the email alerts stop sending. Starting the daemon back up will start the trickle of old alert emails again.

    Is there a way to manually clear whatever queue is filled with these alerts?

    Thanks
  • TangentDelta
    Junior Member
    • Apr 2025
    • 2

    #2
    I noticed that in the SQL database, the "status" column in the "alerts" table is 0 for all of the pending alerts that are queued up to be sent out. I ran a query that UPDATEd all of them from 0 (unsent) to 2 (timed out), and it stopped sending the old alerts out. Is there any potential problems with clearing these queued up alerts this way?

    Comment

    Working...