-
Type:
Incident report
-
Resolution: Won't fix
-
Priority:
Major
-
None
-
Affects Version/s: 2.2.1
-
Component/s: Server (S)
-
None
-
Environment:debian_version = 7.3
mysql-server-5.5
zabbix-server-mysql 1:2.2.1-1+wheezy
Hi
I have a problem with select not supported items from mysql databases.
When I query:
mysql> select items.name,host,key_ from items join hosts on items.hostid = hosts.hostid where items.status=3 order by items.hostid;
Empty set (0.00 sec)
Also when i query:
mysql> select name,key_,status from items where key_="test_key_not_supported" limit 1;
----------------------------------------
| name | key_ | status |
----------------------------------------
| Zabbixtest | test_key_not_supported | 0 |
----------------------------------------
1 row in set (0.00 sec)
I have status=0, but in zabbix GUI this item have status=Not supported (it shouldn't be status=3?). As an attachment I send you a screen shoot of the not supported example item.
Do you know what could cause the problem?
On zabbix version 2.0.10 it's works properly:
mysql> select items.name,host,key_ from items join hosts on items.hostid = hosts.hostid where items.status=3 order by items.hostid;
-------------------------------------------------------------------------------------------------------
| name | host | key_ |
-------------------------------------------------------------------------------------------------------
| Disk read operations per second | xxx1.ogicom.net | iops[read] |
| Disk read operations per second | xxx2.ogicom.net | iops[read] |
| Disk read operations per second | xxx3.ogicom.net | iops[read] |
| memcached.stats[curr_connections] | bbb.ogicom.net | memcached.stats[curr_connections] |
-------------------------------------------------------------------------------------------------------
4 rows in set (0.00 sec)
