Find out problematic trigger name

[tommycz]

Hello,
is there an easy way to get which trigger cannot be evaluated?

In zabbix server log many similar errors appears:

21505:20110517:110813.075 Expression [{18178}>50&{18177}=0] cannot be evaluated: Evaluation failed for function: min

How can I find the name of problematic trigger?

Thanks Tom

[Bennie]

easiest way is to query the db for example like this:

select description from triggers where expression = '{18178}>50&{18177}=0';

[tommycz]

Thank you Bennie,
next question is: How to find the server causing the trigger error?
Thank you.
Tom

[Bennie]

Hey,

got a nice query here for you.

select distinct i.itemid,i.key_,h.host,h.port,i.delay,i.description,i.type,h.useip,h.ip,i.history,i.lastvalue,i.prevvalue,i.hostid,i.value_type,i.delta,i.prevorgvalue,i.lastclock,i.units,i.multiplier,i.formula,i.status,i.valuemapid,h.dns,i.trends,i.lastlogsize,i.data_type,i.mtime,f.function,f.parameter from hosts h,items i,functions f where i.hostid=h.hostid and i.itemid=f.itemid and f.functionid in (select functionid from functions where triggerid in (select triggerid from triggers where expression = '{15434}=1'));

Change the expression in the end to yours and you get the entire list with info you want. If it goes ok .

FYI; query is coming from the exessive logging from zabbix server with some extra queries to find our expression id's and such.

Let me know if it works.

[tommycz]

Hi Bennie,
thats exactly what I need.
Thank you for your effort and good luck.
Regards
Tom