Details
-
Problem report
-
Resolution: Fixed
-
Trivial
-
3.4.3
-
None
-
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);