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

query failed when proxy receives configuration from server

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Duplicate
    • Icon: Blocker Blocker
    • None
    • 4.2.5
    • Server (S)

      Having this key:

      zabbix[host,,maintenance]

      for a host, monitored by zabbix proxy and this item has a pre-processing step (don't ask me why).
      When proxy received configuration, it gets this errors:

       20473:20190806:235257.280 received configuration data from server at "127.0.0.1", datalen 3957
 20473:20190806:235257.282 [Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`proxy4.2`.`item_preproc`, CONSTRAINT `c_item_preproc_1` FOREIGN KEY (`itemid`) REFERENCES `items`
 (`itemid`) ON DELETE CASCADE) [insert into item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values (7461,29271,1,6,'',0,'');
]
 20473:20190806:235257.282 failed to update local proxy configuration copy: database error

      Reproducible in 4.2.5, so recent ZBX-16308 fix does not cover this case.

            wiper Andris Zeila
            zalex_ua Oleksii Zagorskyi
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

              Created:
              Updated:
              Resolved: