Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-12970

Alert manager crashes if related event is already deleted

    XMLWordPrintable

Details

    • Team A
    • Sprint 20
    • 0.25

    Description

      Alert manager reads new alerts from the database, and because of left join if a related event is missing and the result is NULL then Zabbix server crashes without a chance to start before such alert is manually deleted from the database.

      There are constraints on alerts table that are not allowing such situation to happen, but in some cases, all of them are removed because of partitioning.

                              "select a.alertid,a.mediatypeid,a.sendto,a.subject,a.message,a.status,a.retries,"
                                      "e.source,e.object,e.objectid"
                              " from alerts a"
                              " left join events e"
                                      " on a.eventid=e.eventid"
                              " where alerttype=%d"
                              " and",
                              ALERT_TYPE_MESSAGE);
      

      Attachments

        Activity

          People

            vso Vladislavs Sokurenko
            dlamberts Dmitrijs Lamberts
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: