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

No use of events having non-existing objectid (triggerid)

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Cannot Reproduce
    • Icon: Trivial Trivial
    • None
    • 3.0.28, 4.0.12, 4.2.6
    • Server (S)
    • Sprint 56 (Sep 2019), Sprint 57 (Oct 2019), Sprint 58 (Nov 2019), Sprint 59 (Dec 2019)

      It appears that following SQL is reporting back historical records which are impossible to browse through a graphical user interface.

      select objectid,name from events where source=0 and objectid not in (select triggerid from triggers) order by clock\G

      These records are representing events which come from triggers which do not exist anymore in the instance.

       

      Steps to reproduce:

      create a new "Zabbix trapper" item with the key name "number" in host "Zabbix server"

      link a trigger:

      {Zabbix server:number.last()}>0

      Send from the command line

      zabbix_sender -z 127.0.0.1 -s "Zabbix server" -k number -o 9

      Observe the trigger in problem state

      Send another trap:

      zabbix_sender -z 127.0.0.1 -s "Zabbix server" -k number -o 0

      Observe problem is gone.

      Delete trigger, leave the item.

      The historical records are still in the database:

      select objectid,name from events where source=0 and objectid not in (select triggerid from triggers) order by clock\G

      The housekeeper does not clean these records.

       

      Expectation:

      After removing trigger in Zabbix, related events in the database must be removed too.

        1. image-2019-09-27-11-10-47-438.png
          13 kB
          Aigars Kadikis
        2. Timeline.png
          22 kB
          Andrejs Tumilovics

            aigars.kadikis Aigars Kadikis
            aigars.kadikis Aigars Kadikis
            Votes:
            0 Vote for this issue
            Watchers:
            10 Start watching this issue

              Created:
              Updated:
              Resolved: