-
Problem report
-
Resolution: Fixed
-
Critical
-
4.0.27, 5.0.7
-
None
-
Sprint 71 (Dec 2020), Sprint 72 (Jan 2021)
-
0.5
Steps to reproduce:
1) Have some trigger based event fired and it can be closed manually
2) stop zabbix server
3) close event manually
4) delete trigger from host events also could be removed
5) start zabbix server
Result:
we have every task manager loop FAILED attempts for closing problem.
200770:20201223:145945.669 zbx_setproctitle() title:'task manager [processing tasks]' 200770:20201223:145945.670 query [txnlev:0] [select taskid,type,clock,ttl from task where status in (1,2) order by taskid] 200770:20201223:145945.671 In tm_try_task_close_problem() taskid:26 200770:20201223:145945.671 query [txnlev:0] [select a.userid,a.eventid,e.objectid from task_close_problem tcp,acknowledges a left join events e on a.eventid=e.eventid where tcp.taskid=26 and tcp.acknowledgeid=a.acknowledgeid] 200770:20201223:145945.672 End of tm_try_task_close_problem():FAIL 200770:20201223:145945.672 In tm_try_task_close_problem() taskid:29 200770:20201223:145945.672 query [txnlev:0] [select a.userid,a.eventid,e.objectid from task_close_problem tcp,acknowledges a left join events e on a.eventid=e.eventid where tcp.taskid=29 and tcp.acknowledgeid=a.acknowledgeid] 200770:20201223:145945.673 End of tm_try_task_close_problem():FAIL 200770:20201223:145945.673 In tm_try_task_close_problem() taskid:30 200770:20201223:145945.674 query [txnlev:0] [select a.userid,a.eventid,e.objectid from task_close_problem tcp,acknowledges a left join events e on a.eventid=e.eventid where tcp.taskid=30 and tcp.acknowledgeid=a.acknowledgeid] 200770:20201223:145945.675 End of tm_try_task_close_problem():FAIL 200770:20201223:145945.675 zbx_setproctitle() title:'task manager [processed 0 task(s) in 0.005409 sec, idle 5 sec]'
It leads to growing task_close_problem table and task manager process could be load all time in this case.
Expected:
Probably it should handles that event and trigger no longer exist.
- caused by
-
ZBXNEXT-104 switch trigger to OK based on acknowledgement by user
-
- Closed
-
