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

Sometimes Zabbix proxy cannot update configuration due to foreign key constraint failure

    Details

    • Team:
      Team A
    • Sprint:
      Sprint 53 (Jun 2019), Sprint 54 (Jul 2019)
    • Story Points:
      0.125

      Description

      Steps to reproduce:
      Add new hosts to Zabbix proxy when Zabbix proxy configuration preparation is in progress, if host is added just before issuing select query for items then items without host are sent, resulting in error below, same can happen with preprocessing in 4.2

      Result:

      [Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`zabbix_proxy`.`items`, CONSTRAINT `c_items_1` FOREIGN KEY (`hostid`) REFERENCES `hosts` (`hostid`) ON DELETE CASCADE) [insert into items (itemid,type,snmp_community,snmp_oid,hostid,key_,delay,status,value_type,trapper_hosts,snmpv3_securityname,snmpv3_securitylevel,snmpv3_authpassphrase,snmpv3_privpassphrase,lastlogsize,logtimefmt,params,ipmi_sensor,authtype,username,password,publickey,privatekey,mtime,flags,interfaceid,port,snmpv3_authprotocol,snmpv3_privprotocol,snmpv3_contextname,jmx_endpoint,timeout,url,query_fields,posts,status_codes,follow_redirects,post_type,http_proxy,headers,retrieve_mode,request_method,output_format,ssl_cert_file,ssl_key_file,ssl_key_password,verify_peer,verify_host,allow_traps,description) values (28785,0,'','',10271,'net.if.discovery','1h',0,4,'','',0,'','',0,'','','',0,'','','','',0,1,8,'',0,0,'','','3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0,''),(28786,0,'','',10271,'vfs.fs.discovery','1h',0,4,'','',0,'','',0,'','','',0,'','','','',0,1,8,'',0,0,'','','3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0,''),(28787,0,'','',10271,'agent.hostname','1h',0,1,'','',0,'','',0,'','','',0,'','','','',0,0,8,'',0,0,'','','3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0,''),(28788,0,'','',10271,'agent.ping','1m',0,3,'','',0,'','',0,'','','',0,'','','','',0,0,8,'',0,0,'','','3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0,''),(28789,0,'','',10271,'agent.version','1h',0,1,'','',0,'','',0,'','','',0,'','','','',0,0,8,'',0,0,'','','3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0,''),(28790,0,'','',10271,'kernel.maxfiles','1h',0,3,'','',0,'','',0,'','','',0,'','','','',0,0,8,'',0,0,'','','3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0,''),(28791,0,'','',10271,'kernel.maxproc','1h',0,3,'','',0,'','',0,'','','',0,'','','','',0,0,8,'',0,0,'','','3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0,''),(28792,0,'','',10271,'proc.num[,,run]','1m',0,3,'','',0,'','',0,'','','',0,'','','','',0,0,8,'',0,0,'','','3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0,''),(28793,0,'','',10271,'proc.num[]','1m',0,3,'','',0,'','',0,'','','',0,'','','','',0,0,8,'',0,0,'','','3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0,''),(28794,0,'','',10271,'system.boottime','10m',0,3,'','',0,'','',0,'','','',0,'','','','',0,0,8,'',0,0,'','','3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0,''),(28795,0,'','',10271,'system.cpu.intr','1m',0,3,'','',0,'','',0,'','','',0,'','','','',0,0,8,'',0,0,'','','3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0,''),(28796,0,'','',10271,'system.cpu.load[percpu,avg15]','1m',0,0,'','',0,'','',0,'','','',0,'','','','',0,0,8,'',0,0,'','','3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0,''),(28797,0,'','',10271,'system.cpu.load[percpu,avg1]','1m',0,0,'','',0,'','',0,'','','',0,'','','','',0,0,8,'',0,0,'','','3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0,''),(28798,0,'','',10271,'system.cpu.load[percpu,avg5]','1m',0,0,'','',0,'','',0,'','','',0,'','','','',0,0,8,'',0,0,'','','3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0,''),(28799,0,'','',10271,'system.cpu.switches','1m',0,3,'','',0,'','',0,'','','',0,'','','','',0,0,8,'',0,0,'','','3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0,''),(28800,0,'','',10271,'system.cpu.util[,guest]','1m',0,0,'','',0,'','',0,'','','',0,'','','','',0,0,8,'',0,0,'','','3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0,''),(28801,0,'','',10271,'system.cpu.util[,guest_nice]','1m',0,0,'','',0,'','',0,'','','',0,'','','','',0,0,8,'',0,0,'','','3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0,''),(28802,0,'','',10271,'system.cpu.util[,idle]','1m',0,0,'','',0,'','',0,'','','',0,'','','','',0,0,8,'',0,0,'','','3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0,''),(28803,0,'','',10271,'system.cpu.util[,interrupt]','1m',0,0,'','',0,'','',0,'','','',0,'','','','',0,0,8,'',0,0,'','','3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0,''),(28804,0,'','',10271,'system.cpu.util[,iowait]','1m',0,0,'','',0,'','',0,'','','',0,'','','','',0,0,8,'',0,0,'','','3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0,''),(28805,0,'','',10271,'system.cpu.util[,nice]','1m',0,0,'','',0,'','',0,'','','',0,'','','','',0,0,8,'',0,0,'','','3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0,''),(28806,0,'','',10271,'system.cpu.util[,softirq]','1m',0,0,'','',0,'','',0,'','','',0,'','','','',0,0,8,'',0,0,'','','3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0,''),(28807,0,'','',10271,'system.cpu.util[,steal]','1m',0,0,'','',0,'','',0,'','','',0,'','','','',0,0,8,'',0,0,'','','3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0,''),(28808,0,'','',10271,'system.cpu.util[,system]','1m',0,0,'','',0,'','',0,'','','',0,'','','','',0,0,8,'',0,0,'','','3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0,''),(28809,0,'','',10271,'system.cpu.util[,user]','1m',0,0,'','',0,'','',0,'','','',0,'','','','',0,0,8,'',0,0,'','','3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0,''),(28810,0,'','',10271,'system.hostname','1h',0,1,'','',0,'','',0,'','','',0,'','','','',0,0,8,'',0,0,'','','3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0,''),(28811,0,'','',10271,'system.localtime','1m',0,3,'','',0,'','',0,'','','',0,'','','','',0,0,8,'',0,0,'','','3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0,''),(28812,0,'','',10271,'system.swap.size[,free]','1m',0,3,'','',0,'','',0,'','','',0,'','','','',0,0,8,'',0,0,'','','3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0,''),(28813,0,'','',10271,'system.swap.size[,pfree]','1m',0,0,'','',0,'','',0,'','','',0,'','','','',0,0,8,'',0,0,'','','3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0,''),(28814,0,'','',10271,'system.swap.size[,total]','1h',0,3,'','',0,'','',0,'','','',0,'','','','',0,0,8,'',0,0,'','','3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0,''),(28815,0,'','',10271,'system.uname','1h',0,1,'','',0,'','',0,'','','',0,'','','','',0,0,8,'',0,0,'','','3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0,''),(28816,0,'','',10271,'system.uptime','10m',0,3,'','',0,'','',0,'','','',0,'','','','',0,0,8,'',0,0,'','','3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0,''),(28817,0,'','',10271,'system.users.num','1m',0,3,'','',0,'','',0,'','','',0,'','','','',0,0,8,'',0,0,'','','3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0,''),(28818,0,'','',10271,'vfs.file.cksum[/etc/passwd]','1h',0,3,'','',0,'','',0,'','','',0,'','','','',0,0,8,'',0,0,'','','3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0,''),(28819,0,'','',10271,'vm.memory.size[available]','1m',0,3,'','',0,'','',0,'','','',0,'','','','',0,0,8,'',0,0,'','','3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0,''),(28820,0,'','',10271,'vm.memory.size[total]','1h',0,3,'','',0,'','',0,'','','',0,'','','','',0,0,8,'',0,0,'','','3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0,''),(28821,0,'','',10271,'net.if.in[{#IFNAME}]','1m',0,3,'','',0,'','',0,'','','',0,'','','','',0,2,8,'',0,0,'','','3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0,''),(28822,0,'','',10271,'net.if.out[{#IFNAME}]','1m',0,3,'','',0,'','',0,'','','',0,'','','','',0,2,8,'',0,0,'','','3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0,''),(28823,0,'','',10271,'vfs.fs.inode[{#FSNAME},pfree]','1m',0,0,'','',0,'','',0,'','','',0,'','','','',0,2,8,'',0,0,'','','3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0,''),(28824,0,'','',10271,'vfs.fs.size[{#FSNAME},free]','1m',0,3,'','',0,'','',0,'','','',0,'','','','',0,2,8,'',0,0,'','','3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0,''),(28825,0,'','',10271,'vfs.fs.size[{#FSNAME},pfree]','1m',0,0,'','',0,'','',0,'','','',0,'','','','',0,2,8,'',0,0,'','','3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0,''),(28826,0,'','',10271,'vfs.fs.size[{#FSNAME},total]','1h',0,3,'','',0,'','',0,'','','',0,'','','','',0,2,8,'',0,0,'','','3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0,''),(28827,0,'','',10271,'vfs.fs.size[{#FSNAME},used]','1m',0,3,'','',0,'','',0,'','','',0,'','','','',0,2,8,'',0,0,'','','3s','','','','200',1,0,'','',0,0,0,'','','',0,0,0,'');
      ]
        8243:20190628:103240.322 failed to update local proxy configuration copy: database error
      

      Similar error reported on 4.2

      8929:20190627:052604.744 [Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`zabbix_proxy`.`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
      

        Attachments

          Activity

            People

            • Assignee:
              vso Vladislavs Sokurenko
              Reporter:
              vso Vladislavs Sokurenko
            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: