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

    • Problem report
    • Status: Confirmed
    • Trivial
    • Resolution: Unresolved
    • 5.0.17
    • None
    • Server (S)
    • None

    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

            zabbix.dev Zabbix Development Team
            Asunkin Stanislav
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated: