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

XMLWordPrintable

    • Sprint 53 (Jun 2019), Sprint 54 (Jul 2019)
    • 0.125

      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

            vso Vladislavs Sokurenko
            vso Vladislavs Sokurenko
            Team A
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: