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

Template can't be cloned due to invalid entry in database

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Duplicate
    • Icon: Major Major
    • None
    • 7.0.9, 7.0.10
    • Frontend (F)
    • None
    • VM install / containers

      Steps to reproduce:

      1. In the frontend, try to clone template "Remote Zabbix proxy health"

      Error message:

      Problem:

      preprocessinc item with error_handler type 0 can't have error_handler_params:

      mysql> SELECT * FROM item_preproc WHERE error_handler = 0 AND error_handler_params <> '' LIMIT 1;
      +----------------+--------+------+------+-------------------------------------------------+---------------+--------------------------------------------+
      | item_preprocid | itemid | step | type | params                                          | error_handler | error_handler_params                       |
      +----------------+--------+------+------+-------------------------------------------------+---------------+--------------------------------------------+
      |          81661 |  33012 |    1 |   12 | $.data.process['availability manager'].busy.avg |             0 | Processes availability manager not started |
      +----------------+--------+------+------+-------------------------------------------------+---------------+--------------------------------------------+

      Problem exists with clean install:

       

      [root@zabbix-srv mysql]# cat server.sql | grep 'Processes availability manager not started'
      ('81661','33012','1','12','$.data.process[\'availability manager\'].busy.avg','0','Processes availability manager not started'),
       
      

      Work-around: 
      Option 1: Open template item "Utilization of availability manager internal processes, in %", go to preprocessing step and click Update
      Option 2: In the database perform the query:

      UPDATE item_preproc  SET error_handler_params = ''  WHERE item_preprocid = 81661; 

      Check for other issues in the database:

      SELECT * FROM item_preproc WHERE error_handler = 0 AND error_handler_params <> '' LIMIT 1; 

      Please fix database scheme for new installations and eventually fix existing problems. 

            zabbix.dev Zabbix Development Team
            Albert-Jan A.J. Goedhart
            Votes:
            3 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved: