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

    • 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.

            dgoloscapov Dmitrijs Goloscapovs
            elina.kuzyutkina Elina Kuzyutkina (Inactive)
            Team A
            Votes:
            2 Vote for this issue
            Watchers:
            6 Start watching this issue

              Created:
              Updated:
              Resolved: