Macro evaluation problem
I have an action that is mostly working, but does not seem to be expanding the {Hostname} macro properly. I'm using {TRIGGER.NAME}: {STATUS}, and the trigger contains the {Hostname} macro. After looking through the debug log, it looks like there is some sort of corruption. Here's the suspicious section of the log:
In check_action_condition [actionid:2,conditionid:4:cond.value:Not Available for 5 minutes]
008392:20060605:132133 Condition is TRUE
008392:20060605:132133 In check_action_condition [actionid:2,conditionid:3:cond.value:1]
008392:20060605:132133 Condition is TRUE
008392:20060605:132133 Conditions are TRUE
008392:20060605:132133 Conditions match our trigger. Do apply actions.
008392:20060605:132133 In substitute_macros([{TRIGGER.NAME}: {STATUS}])
008392:20060605:132133 In substitute_simple_macros [{TRIGGER.NAME}: {STATUS}]
008392:20060605:132133 Result expression [{Hostname} Not Available for 5 minutes: ON]
008392:20060605:132133 Macro:Hostname
008392:20060605:132133 Host:
008392:20060605:132133 Key:Zv|2î¿÷ž
008392:20060605:132133 Function:x*î¿Hž
008392:20060605:132133 Parameter:
008392:20060605:132133 In evaluate_FUNCTION2()
008392:20060605:132133 Executing query:select i.itemid,i.key_,h.host,h.port,i.delay,i.descriptio n,i.nextcheck,i.type,i.snmp_community,i.snmp_oid,h .useip,h.ip,i.history,i.lastvalue,i.prevvalue,i.ho stid,h.status,i.value_type,h.errors_from,i.snmp_po rt,i.delta,i.prevorgvalue,i.lastclock,i.units,i.mu ltiplier,i.snmpv3_securityname,i.snmpv3_securityle vel,i.snmpv3_authpassphrase,i.snmpv3_privpassphras e,i.formula,h.available,i.status,i.trapper_hosts,i .logtimefmt,i.valuemapid from hosts h, items i where h.host='' and h.hostid=i.hostid and i.key_='Zv|2î¿÷ž'
008392:20060605:132133 Query [select i.itemid,i.key_,h.host,h.port,i.delay,i.descriptio n,i.nextcheck,i.type,i.snmp_community,i.snmp_oid,h .useip,h.ip,i.history,i.lastvalue,i.prevvalue,i.ho stid,h.status,i.value_type,h.errors_from,i.snmp_po rt,i.delta,i.prevorgvalue,i.lastclock,i.units,i.mu ltiplier,i.snmpv3_securityname,i.snmpv3_securityle vel,i.snmpv3_authpassphrase,i.snmpv3_privpassphras e,i.formula,h.available,i.status,i.trapper_hosts,i .logtimefmt,i.valuemapid from hosts h, items i where h.host='' and h.hostid=i.hostid and i.key_='Zv|2î¿÷ž'] returned empty result
008392:20060605:132133 In zabbix_log()
008392:20060605:132133 Executing query:select i.itemid,i.key_,h.host,h.port,i.delay,i.descriptio n,i.nextcheck,i.type,i.snmp_community,i.snmp_oid,h .useip,h.ip,i.history,i.lastvalue,i.prevvalue,i.ho stid,h.status,i.value_type,h.errors_from,i.snmp_po rt,i.delta,i.prevorgvalue,i.lastclock,i.units,i.mu ltiplier,i.snmpv3_securityname,i.snmpv3_securityle vel,i.snmpv3_authpassphrase,i.snmpv3_privpassphras e,i.formula,h.available,i.status,i.trapper_hosts,i .logtimefmt,i.valuemapid from hosts h, items i where h.hostid=i.hostid and i.key_='zabbix[log]' and i.value_type=1
008392:20060605:132133 Value3 []
008392:20060605:132133 Value4 [{Hostname} Not Available for 5 minutes: ON]
008392:20060605:132133 Value41 [ostname} Not Available for 5 minutes: ON]
008392:20060605:132133 Value42 [ Not Available for 5 minutes: ON]
008392:20060605:132133 Value5 [%s Not Available for 5 minutes: ON]
008392:20060605:132133 Expression4:[ Not Available for 5 minutes: ON]
008392:20060605:132133 Result expression: Not Available for 5 minutes: ON
008392:20060605:132133 In substitute_macros([{TRIGGER.NAME}: {STATUS}])
008392:20060605:132133 In substitute_simple_macros [{TRIGGER.NAME}: {STATUS}]
008392:20060605:132133 Result expression [{Hostname} Not Available for 5 minutes: ON]
008392:20060605:132133 Macro:Hostname
008392:20060605:132133 Host:
008392:20060605:132133 Key:Zv|2î¿÷ž
008392:20060605:132133 Function:x*î¿Hž
008392:20060605:132133 Parameter:
008392:20060605:132133 In evaluate_FUNCTION2()
008392:20060605:132133 Executing query:select i.itemid,i.key_,h.host,h.port,i.delay,i.descriptio n,i.nextcheck,i.type,i.snmp_community,i.snmp_oid,h .useip,h.ip,i.history,i.lastvalue,i.prevvalue,i.ho stid,h.status,i.value_type,h.errors_from,i.snmp_po rt,i.delta,i.prevorgvalue,i.lastclock,i.units,i.mu ltiplier,i.snmpv3_securityname,i.snmpv3_securityle vel,i.snmpv3_authpassphrase,i.snmpv3_privpassphras e,i.formula,h.available,i.status,i.trapper_hosts,i .logtimefmt,i.valuemapid from hosts h, items i where h.host='' and h.hostid=i.hostid and i.key_='Zv|2î¿÷ž'
008392:20060605:132133 Query [select i.itemid,i.key_,h.host,h.port,i.delay,i.descriptio n,i.nextcheck,i.type,i.snmp_community,i.snmp_oid,h .useip,h.ip,i.history,i.lastvalue,i.prevvalue,i.ho stid,h.status,i.value_type,h.errors_from,i.snmp_po rt,i.delta,i.prevorgvalue,i.lastclock,i.units,i.mu ltiplier,i.snmpv3_securityname,i.snmpv3_securityle vel,i.snmpv3_authpassphrase,i.snmpv3_privpassphras e,i.formula,h.available,i.status,i.trapper_hosts,i .logtimefmt,i.valuemapid from hosts h, items i where h.host='' and h.hostid=i.hostid and i.key_='Zv|2î¿÷ž'] returned empty result
Any help is appreciated.
-B
In check_action_condition [actionid:2,conditionid:4:cond.value:Not Available for 5 minutes]
008392:20060605:132133 Condition is TRUE
008392:20060605:132133 In check_action_condition [actionid:2,conditionid:3:cond.value:1]
008392:20060605:132133 Condition is TRUE
008392:20060605:132133 Conditions are TRUE
008392:20060605:132133 Conditions match our trigger. Do apply actions.
008392:20060605:132133 In substitute_macros([{TRIGGER.NAME}: {STATUS}])
008392:20060605:132133 In substitute_simple_macros [{TRIGGER.NAME}: {STATUS}]
008392:20060605:132133 Result expression [{Hostname} Not Available for 5 minutes: ON]
008392:20060605:132133 Macro:Hostname
008392:20060605:132133 Host:
008392:20060605:132133 Key:Zv|2î¿÷ž
008392:20060605:132133 Function:x*î¿Hž
008392:20060605:132133 Parameter:
008392:20060605:132133 In evaluate_FUNCTION2()
008392:20060605:132133 Executing query:select i.itemid,i.key_,h.host,h.port,i.delay,i.descriptio n,i.nextcheck,i.type,i.snmp_community,i.snmp_oid,h .useip,h.ip,i.history,i.lastvalue,i.prevvalue,i.ho stid,h.status,i.value_type,h.errors_from,i.snmp_po rt,i.delta,i.prevorgvalue,i.lastclock,i.units,i.mu ltiplier,i.snmpv3_securityname,i.snmpv3_securityle vel,i.snmpv3_authpassphrase,i.snmpv3_privpassphras e,i.formula,h.available,i.status,i.trapper_hosts,i .logtimefmt,i.valuemapid from hosts h, items i where h.host='' and h.hostid=i.hostid and i.key_='Zv|2î¿÷ž'
008392:20060605:132133 Query [select i.itemid,i.key_,h.host,h.port,i.delay,i.descriptio n,i.nextcheck,i.type,i.snmp_community,i.snmp_oid,h .useip,h.ip,i.history,i.lastvalue,i.prevvalue,i.ho stid,h.status,i.value_type,h.errors_from,i.snmp_po rt,i.delta,i.prevorgvalue,i.lastclock,i.units,i.mu ltiplier,i.snmpv3_securityname,i.snmpv3_securityle vel,i.snmpv3_authpassphrase,i.snmpv3_privpassphras e,i.formula,h.available,i.status,i.trapper_hosts,i .logtimefmt,i.valuemapid from hosts h, items i where h.host='' and h.hostid=i.hostid and i.key_='Zv|2î¿÷ž'] returned empty result
008392:20060605:132133 In zabbix_log()
008392:20060605:132133 Executing query:select i.itemid,i.key_,h.host,h.port,i.delay,i.descriptio n,i.nextcheck,i.type,i.snmp_community,i.snmp_oid,h .useip,h.ip,i.history,i.lastvalue,i.prevvalue,i.ho stid,h.status,i.value_type,h.errors_from,i.snmp_po rt,i.delta,i.prevorgvalue,i.lastclock,i.units,i.mu ltiplier,i.snmpv3_securityname,i.snmpv3_securityle vel,i.snmpv3_authpassphrase,i.snmpv3_privpassphras e,i.formula,h.available,i.status,i.trapper_hosts,i .logtimefmt,i.valuemapid from hosts h, items i where h.hostid=i.hostid and i.key_='zabbix[log]' and i.value_type=1
008392:20060605:132133 Value3 []
008392:20060605:132133 Value4 [{Hostname} Not Available for 5 minutes: ON]
008392:20060605:132133 Value41 [ostname} Not Available for 5 minutes: ON]
008392:20060605:132133 Value42 [ Not Available for 5 minutes: ON]
008392:20060605:132133 Value5 [%s Not Available for 5 minutes: ON]
008392:20060605:132133 Expression4:[ Not Available for 5 minutes: ON]
008392:20060605:132133 Result expression: Not Available for 5 minutes: ON
008392:20060605:132133 In substitute_macros([{TRIGGER.NAME}: {STATUS}])
008392:20060605:132133 In substitute_simple_macros [{TRIGGER.NAME}: {STATUS}]
008392:20060605:132133 Result expression [{Hostname} Not Available for 5 minutes: ON]
008392:20060605:132133 Macro:Hostname
008392:20060605:132133 Host:
008392:20060605:132133 Key:Zv|2î¿÷ž
008392:20060605:132133 Function:x*î¿Hž
008392:20060605:132133 Parameter:
008392:20060605:132133 In evaluate_FUNCTION2()
008392:20060605:132133 Executing query:select i.itemid,i.key_,h.host,h.port,i.delay,i.descriptio n,i.nextcheck,i.type,i.snmp_community,i.snmp_oid,h .useip,h.ip,i.history,i.lastvalue,i.prevvalue,i.ho stid,h.status,i.value_type,h.errors_from,i.snmp_po rt,i.delta,i.prevorgvalue,i.lastclock,i.units,i.mu ltiplier,i.snmpv3_securityname,i.snmpv3_securityle vel,i.snmpv3_authpassphrase,i.snmpv3_privpassphras e,i.formula,h.available,i.status,i.trapper_hosts,i .logtimefmt,i.valuemapid from hosts h, items i where h.host='' and h.hostid=i.hostid and i.key_='Zv|2î¿÷ž'
008392:20060605:132133 Query [select i.itemid,i.key_,h.host,h.port,i.delay,i.descriptio n,i.nextcheck,i.type,i.snmp_community,i.snmp_oid,h .useip,h.ip,i.history,i.lastvalue,i.prevvalue,i.ho stid,h.status,i.value_type,h.errors_from,i.snmp_po rt,i.delta,i.prevorgvalue,i.lastclock,i.units,i.mu ltiplier,i.snmpv3_securityname,i.snmpv3_securityle vel,i.snmpv3_authpassphrase,i.snmpv3_privpassphras e,i.formula,h.available,i.status,i.trapper_hosts,i .logtimefmt,i.valuemapid from hosts h, items i where h.host='' and h.hostid=i.hostid and i.key_='Zv|2î¿÷ž'] returned empty result
Any help is appreciated.
-B