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

    • Type: Problem report
    • Status: Confirmed
    • Priority: Trivial
    • Resolution: Unresolved
    • Affects Version/s: 4.0.29, 4.0.30
    • Fix Version/s: None
    • Component/s: Server (S)
    • Labels:
    • Story Points:
      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

              Assignee:
              zabbix.dev Zabbix Development Team
              Reporter:
              elina.kuzyutkina Elina Kuzyutkina
              Votes:
              2 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated: