zabbix value map导致报警失效问题一例

select triggerid,expression,description,value,from_unixtime(lastchange ,‘%Y%m%d %H:%i:%S‘) from triggers where triggerid=‘6347‘;
+-----------+------------+----------------------------------------------------------+-------+----------------------------------------------+
| triggerid | expression | description                                              | value | from_unixtime(lastchange ,‘%Y%m%d %H:%i:%S‘) |
+-----------+------------+----------------------------------------------------------+-------+----------------------------------------------+
|      6347 | {10832}=1  | Zabbix agent on {HOST.NAME} is unreachable for1  minutes |     1 | 20140312 11:47:31                            |
+-----------+------------+----------------------------------------------------------+-------+----------------------------------------------+
select * from functions where  itemid=‘27731‘;                 
+------------+--------+-----------+----------+-----------+
| functionid | itemid | triggerid | function | parameter |
+------------+--------+-----------+----------+-----------+
|      10832 |  27731 |      6347 | nodata   | 1m        |
+------------+--------+-----------+----------+-----------+

/apps/svr/zabbix_server/scripts/zabbix_exec_command.py ip  27731 "Agent ping"  hostname agent.ping  Up (1)  PROBLEM
  -bash: syntax error near unexpected token `(‘

5009:20140312:113302.211 In zbx_format_value()
5009:20140312:113302.211 In replace_value_by_map() value:‘1‘ valuemapid:10
5009:20140312:113302.211 query [txnlev:1] [select newvalue from mappings where valuemapid=10 and value=‘1‘]
5009:20140312:113302.211 End of replace_value_by_map() value:‘Up (1)‘

说明还是和item的设置有关，再来看agent.ping的设置，在show value设置中，可以看到并不是as is，而是设置的zabbix agent ping status，这里面就是1->up的map：

再来看zabbix的doc中关于map value的描述，其实是为了返回更易理解的值：

For a more “human” representation of received values, you can use value maps that contain the mapping between numeric values and string representations.

rc找到了，把show value改成as is就ok了。

小结：

1.日志+数据库是解决zabbix问题的利器。

2.有时候需要设置多种报警方式，比如在这个例子中，由于有zabbix host update percent的报警，发现了这个问题。