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

Task manager constantly busy with close_problem task if trigger no longer exists but event still exist.

    XMLWordPrintable

Details

    • Team A
    • Sprint 78 (Jul 2021), Sprint 79 (Aug 2021), Sprint 80 (Sep 2021)
    • 0.25

    Description

      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.

      Attachments

        Issue Links

          Activity

            People

              dgoloscapov Dmitrijs Goloscapovs
              elina.kuzyutkina Elina Kuzyutkina
              Votes:
              2 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: