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:
      Team A
    • Sprint:
      Sprint 20
    • Story Points:
      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

            Assignee:
            vso Vladislavs Sokurenko
            Reporter:
            dmitrijs.lamberts Dmitrijs Lamberts
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: