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

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Blocker
    • Resolution: Duplicate
    • Affects Version/s: 4.2.5
    • Fix Version/s: None
    • Component/s: Server (S)

      Description

      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.

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                Created:
                Updated:
                Resolved: