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

Task manager constantly busy with close_problem task if trigger or event no longer exists.

    XMLWordPrintable

Details

    • Team A
    • Sprint 71 (Dec 2020), Sprint 72 (Jan 2021)
    • 0.5

    Description

      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.

      Attachments

        Issue Links

          Activity

            People

              vso Vladislavs Sokurenko
              neogan Andrei Gushchin
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: