-
Incident report
-
Resolution: Fixed
-
Major
-
2.0.17, 2.2.11, 2.4.8, 3.0.2
In ZBX-10759 I've described how columns "state" and "error" may get wrong values for trigger prototype, which may mislead zabbix users a lot.
I believe such wrong entries have to be fixed using upgrade patches.
It could be done in minor version upgrade, if not - then in next major version 3.2.
From a production installation:
mysql> select count(*) from triggers where flags=2; +----------+ | count(*) | +----------+ | 4512 | +----------+ 1 row in set (0.48 sec) mysql> select error, count(*) from triggers where flags=2 and error not like "" group by error; +----------------------------+----------+ | error | count(*) | +----------------------------+----------+ | Agent is unavailable. | 2481 | | SNMP agent is unavailable. | 53 | +----------------------------+----------+ 2 rows in set (0.58 sec) mysql> select state, count(*) from triggers where flags=2 group by state; +-------+----------+ | state | count(*) | +-------+----------+ | 0 | 1978 | | 1 | 2534 | +-------+----------+ 2 rows in set (0.49 sec)