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

Widget "Problems by severity" events are not displayed in the correct order.

XMLWordPrintable

    • S24-W26/27
    • 2

      Steps to reproduce:

      1. Generates a problem event in the order of host1, host2, and host3.
        host1, host2, and host3 belong to the same host group "test".
      2. The "problem event" that occurred.
        MariaDB [zabbix]> select e.eventid,from_unixtime(e.clock),h.host from events e join functions f on f.triggerid = e.objectid join items i on i.itemid=f.itemid join hosts h on h.hostid=i.hostid where e.source=0 and e.object=0 and e.name like 't1' order by e.eventid desc;
        +---------+------------------------+-------+
        | eventid | from_unixtime(e.clock) | host  |
        +---------+------------------------+-------+
        |      16 | 2024-05-28 11:47:49    | host3 |
        |      13 | 2024-05-28 11:47:47    | host2 |
        |       8 | 2024-05-28 11:47:44    | host1 |
        |       5 | 2024-05-28 11:47:42    | host3 |
        |       2 | 2024-05-28 11:47:38    | host2 |
        |       1 | 2024-05-28 11:46:59    | host1 |
        +---------+------------------------+-------+
        6 rows in set (0.001 sec)
        MariaDB [zabbix]> select e.eventid,from_unixtime(e.clock),h.host from problem e join functions f on f.triggerid = e.objectid join items i on i.itemid=f.itemid join hosts h on h.hostid=i.hostid where e.source=0 and e.object=0 and e.name like 't1' order by e.eventid desc;
        +---------+------------------------+-------+
        | eventid | from_unixtime(e.clock) | host  |
        +---------+------------------------+-------+
        |      16 | 2024-05-28 11:47:49    | host3 |
        |      13 | 2024-05-28 11:47:47    | host2 |
        |       8 | 2024-05-28 11:47:44    | host1 |
        |       5 | 2024-05-28 11:47:42    | host3 |
        |       2 | 2024-05-28 11:47:38    | host2 |
        |       1 | 2024-05-28 11:46:59    | host1 |
        +---------+------------------------+-------+
        6 rows in set (0.001 sec)
        
      1. Assuming that the time has returned to the past due to OS time synchronization, change the clock of eventid:2.
        2024-05-28 11:47:38 => 2024-05-28 11:47:43
        MariaDB [zabbix]> select e.eventid,from_unixtime(e.clock),h.host from events e join functions f on f.triggerid = e.objectid join items i on i.itemid=f.itemid join hosts h on h.hostid=i.hostid where e.source=0 and e.object=0 and e.name like 't1' order by e.eventid desc;
        +---------+------------------------+-------+
        | eventid | from_unixtime(e.clock) | host  |
        +---------+------------------------+-------+
        |      16 | 2024-05-28 11:47:49    | host3 |
        |      13 | 2024-05-28 11:47:47    | host2 |
        |       8 | 2024-05-28 11:47:44    | host1 |
        |       5 | 2024-05-28 11:47:42    | host3 |
        |       2 | 2024-05-28 11:47:43    | host2 |
        |       1 | 2024-05-28 11:46:59    | host1 |
        +---------+------------------------+-------+
        6 rows in set (0.001 sec)
        MariaDB [zabbix]> select e.eventid,from_unixtime(e.clock),h.host from problem e join functions f on f.triggerid = e.objectid join items i on i.itemid=f.itemid join hosts h on h.hostid=i.hostid where e.source=0 and e.object=0 and e.name like 't1' order by e.eventid desc;
        +---------+------------------------+-------+
        | eventid | from_unixtime(e.clock) | host  |
        +---------+------------------------+-------+
        |      16 | 2024-05-28 11:47:49    | host3 |
        |      13 | 2024-05-28 11:47:47    | host2 |
        |       8 | 2024-05-28 11:47:44    | host1 |
        |       5 | 2024-05-28 11:47:42    | host3 |
        |       2 | 2024-05-28 11:47:43    | host2 |
        |       1 | 2024-05-28 11:46:59    | host1 |
        +---------+------------------------+-------+
        6 rows in set (0.001 sec)
        

      Result:

      1. "Monitoring" => "Problems"
        11:47:49 host3
        11:47:47 host2
        11:47:44 host1
        11:47:43 host2
        11:47:42 host3
        11:46:59 host1

      Events are displayed in time order.

      1. "Monitoring" => "Dashboard" => "Problems by severity"
        11:47:49 host3
        11:47:47 host2
        11:47:44 host1
        11:47:42 host3
        11:47:43 host2
        11:46:59 host1

      Events are listed in descending order by eventid.

      1. Change "Show" to "Totals" in "Problems by severity".
        Change host group "zzz" on host3.
      2. "Monitoring" => "Problems" display order remains the same.
      3. "Monitoring" => "Dashboard" => "Problems by severity"
        11:47:47 host2
        11:47:44 host1
        11:47:43 host2
        11:46:59 host1
        11:47:49 host3
        11:47:42 host3
      4. Change host group "aaa" on host3.
        "Monitoring" => "Dashboard" => "Problems by severity"
        11:47:49 host3
        11:47:42 host3
        11:47:47 host2
        11:47:44 host1
        11:47:43 host2
        11:46:59 host1

      It appears that the host group name affects the display order.

      Expected:
      The "Time" is arrow-down on the screen.
      Shouldn't events be listed in time order?

            iivs Ivo Kurzemnieks
            kazuo.ito Kazuo Ito
            Team B
            Votes:
            1 Vote for this issue
            Watchers:
            10 Start watching this issue

              Created:
              Updated:
              Resolved:

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - Not Specified
                Not Specified
                Logged:
                Time Spent - 7h 49m
                7h 49m