-
Problem report
-
Resolution: Fixed
-
Minor
-
6.0.30
-
None
-
S24-W26/27
-
2
Steps to reproduce:
- Generates a problem event in the order of host1, host2, and host3.
host1, host2, and host3 belong to the same host group "test". - 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)
- 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:43MariaDB [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:
- "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.
- "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.
- Change "Show" to "Totals" in "Problems by severity".
Change host group "zzz" on host3. - "Monitoring" => "Problems" display order remains the same.
- "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 - 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?