Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-10761

clean wrong values in "triggers" table (for trigger prototypes) using db patches

    Details

      Description

      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)
      

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              zalex_ua Oleksiy Zagorskyi
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: