-
Problem report
-
Resolution: Fixed
-
Trivial
-
4.0.29, 4.0.30, 5.4.2
-
Sprint 78 (Jul 2021), Sprint 79 (Aug 2021), Sprint 80 (Sep 2021)
-
0.25
continuation of the ZBX-18802 ticket
In case the trigger is removed, and the event still exists:
select a.userid,a.eventid,e.objectid from task_close_problem tcp left join acknowledges a on tcp.acknowledgeid=a.acknowledgeid left join events e on a.eventid=e.eventid where tcp.taskid=253336;
userid | eventid | objectid
-----------------------
3 | 1423346 | 20026
-----------------------
zabbix=# SELECT * from events where eventid=1423346;
eventid | source | object | objectid | clock | value | acknowledged | ns | name | severity
---------+--------+--------+----------+------------+-------+--------------+-----------+-------------------------------------------------------------------+----------
1423346 | 0 | 0 | 20026 | 1609410411 | 1 | 0 | 860568967 | Line "ORA-16038: log 1 sequence# 708 cannot be archived" detected | 4
select * from triggers where triggerid=20026;
triggerid | expression | description | url | status | value | priority | lastchange | comments | error | templateid | type | state | flags | recovery_mode | recovery_expression | corre
lation_mode | correlation_tag | manual_close
-----------+------------+-------------+-----+--------+-------+----------+------------+----------+-------+------------+------+-------+-------+---------------+---------------------+------
------------+-----------------+--------------
(0 rows)
Task manager will cyclically fail:
7912:20210405:124237.751 query [txnlev:0] [select a.userid,a.eventid,e.objectid from task_close_problem tcp left join acknowledges a on tcp.acknowledgeid=a.acknowledgeid left join events e on a.eventid=e.eventid where tcp.taskid=160427] 7912:20210405:124237.752 End of tm_try_task_close_problem():FAIL 7912:20210405:124237.752 In tm_try_task_close_problem() taskid:160428 7912:20210405:124237.752 query [txnlev:0] [select a.userid,a.eventid,e.objectid from task_close_problem tcp left join acknowledges a on tcp.acknowledgeid=a.acknowledgeid left join events e on a.eventid=e.eventid where tcp.taskid=160428] 7912:20210405:124237.752 End of tm_try_task_close_problem():FAIL
Usually, these events are deleted by the housekeeper, but we can check and exclude the situation when the housekeeper has not did that yet or is turned off altogether by sql query.
- duplicates
-
ZBX-18802 Task manager constantly busy with close_problem task if trigger or event no longer exists.
- Closed