Sprint 83 (Dec 2021), Sprint 84 (Jan 2022)
Steps to reproduce:
- Create a test action with multiple steps (1-1, 2-2, 3-3)
- Trigger some trigger
- After first step, disable the trigger
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]
Zabbix should send a message about cancelled escalation
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"