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

Lost of lastchange data in trigger view screen.

    XMLWordPrintable

Details

    • Incident report
    • Status: Closed
    • Trivial
    • Resolution: Duplicate
    • 3.0.20, 3.4.12
    • None
    • Frontend (F)
    • None

    Description

      There is a difference between the screen source and SQL sort of trigger status.
      When it exceeds SQL LIMIT, it becomes a list which lost of lastchange data.

      I think that sorting in descending order on the SQL side should take precedence.

      Trigger data list query(ASC):

      MariaDB [zabbix]> SELECT DISTINCT t.triggerid,t.lastchange FROM triggers t,functions f,items i WHERE i.hostid='10084' AND f.triggerid=t.triggerid AND f.itemid=i.itemid AND NOT EXISTS (SELECT NULL FROM functions f,items i,hosts h WHERE t.triggerid=f.triggerid AND f.itemid=i.itemid AND i.hostid=h.hostid AND (i.status<>0 OR h.status<>0)) AND t.status=0 AND t.flags IN ('0','4') ORDER BY t.lastchange LIMIT 22;
      

      Trigger lists image(DESC):

      thank you.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              hayato.watanabe Hayato Watanabe
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: