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

"Escalation canceled" event is not working with Oracle DB

    XMLWordPrintable

Details

    • Team B
    • Sprint 83 (Dec 2021), Sprint 84 (Jan 2022)
    • 1

    Description

      Steps to reproduce:

      1. Create a test action with multiple steps (1-1, 2-2, 3-3)
      2. Trigger some trigger
      3. After first step, disable the trigger

      Result:

      An error in zabbix_server.log: 

      1965:20211122:164551.611 [Z3005] query failed: [-1] ORA-00932: inconsistent datatypes: expected - got NCLOB [select distinct userid,mediatypeid,subject,message,esc_step from alerts where actionid=267 and mediatypeid is not null and alerttype=0 and acknowledgeid is null and eventid=33214 order by userid,mediatypeid,esc_step desc]

      Expected:
      Zabbix should send a message about cancelled escalation

      Additional information:

      I have this problem in 5.0.17 after upgrading from 5.0.10.

      I tracked down query error to this code: https://git.zabbix.com/projects/ZBX/repos/zabbix/browse/src/zabbix_server/escalator/escalator.c?until=73f2457e27657bcd73bf433b819d0b23633d4424&untilPath=src%2Fzabbix_server%2Fescalator%2Fescalator.c&at=refs%2Fheads%2Frelease%2F5.0#715-724

      It's probably introduced by "ZBX-18912 fixed escalation message is using template message instead of custom message in actions"

      Attachments

        Activity

          People

            ssimonenko Sergey Simonenko
            Asunkin Stanislav
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: