21973:20190520:065312.404 [Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`Zabbix42`.`functions`, CONSTRAINT `c_functions_1` FOREIGN KEY (`itemid`) REFERENCES `items` (`itemid`) ON DELETE CASCADE) [insert into functions (functionid,itemid,triggerid,name,parameter) values (100100004663389,100100000609252,100100000254481,' last','0'),(100100004663390,100100000609253,100100 000254482,'last','0'),(100100004663391,10010000060 9254,100100000254483,'last','0'),(100100004663392, 100100000609255,100100000254484,'last','0'),(10010 0004663393,100100000609256,100100000254485,'last', '0'),(100100004663394,100100000609257,100100000254 486,'last','0'),(100100004663395,100100000609258,1 00100000254487,'last','0'),(100100004663396,100100 000609259,100100000254488,'last','0'),(10010000466 3397,100100000609260,100100000254489,'last','0'),( 100100004663398,100100000609261,100100000254490,'l ast','0'),(100100004663399,100100000609262,1001000 00254491,'last','0'),(100100004663400,100100000609 263,100100000254492,'last','0'),(100100004663401,1 00100000609264,100100000254493,'last','0'),(100100 004663402,100100000609265,100100000254494,'last',' 0'),(100100004663403,100100000609266,1001000002544 95,'last','0'),(100100004663404,100100000609267,10 0100000254496,'last','0'),(100100004663405,1001000 00609268,100100000254497,'last','0'),(100100004663 406,100100000609269,100100000254498,'last','0'),(1 00100004663407,100100000609270,100100000254499,'la st','0'),(100100004663408,100100000609271,10010000 0254500,'last','0'),(100100004663409,1001000006092 72,100100000254501,'last','0'),(100100004663410,10 0100000609273,100100000254502,'last','0'),(1001000 04663411,100100000609274,100100000254503,'last','0 '),(100100004663412,100100000609275,10010000025450 4,'last','0'),(100100004663413,100100000609276,100 100000254505,'last','0'),(100100004663414,10010000 0609277,100100000254506,'last','0'),(1001000046634 15,100100000609278,100100000254507,'last','0'),(10 0100004663416,100100000609279,100100000254508,'las t','0'),(100100004663417,100100000609280,100100000 254509,'last','0'),(100100004663418,10010000060928 1,100100000254510,'last','0'),(100100004663419,100 100000609282,100100000254511,'last','0'),(10010000 4663420,100100000609283,100100000254512,'last','0' ),(100100004663421,100100000609284,100100000254513 ,'last','0'),(100100004663422,100100000609285,1001 00000254514,'last','0'),(100100004663423,100100000 609286,100100000254515,'last','0'),(10010000466342 4,100100000609287,100100000254516,'last','0'),(100 100004663425,100100000609288,100100000254517,'last ','0'),(100100004663426,100100000609289,1001000002 54518,'last','0'),(100100004663427,100100000609290 ,100100000254519,'last','0'),(100100004663428,1001 00000609291,100100000254520,'last','0'),(100100004 663429,100100000609292,100100000254521,'last','0') ,(100100004663430,100100000609293,100100000254522, 'last','0'),(100100004663431,100100000609294,10010 0000254523,'last','0'),(100100004663432,1001000006 09295,100100000254524,'last','0'),(100100004663433 ,100100000609296,100100000254525,'last','0'),(1001 00004663434,100100000609297,100100000254526,'last' ,'0'),(100100004663435,100100000609298,10010000025 4527,'last','0'),(100100004663436,100100000609299, 100100000254528,'last','0'),(100100004663437,10010 0000609300,100100000254529,'last','0'),(1001000046 63438,100100000609301,100100000254530,'last','0'), (100100004663439,100100000609302,100100000254531,' last','0'),(100100004663440,100100000609303,100100 000254532,'last','0'),(100100004663441,10010000060 9304,100100000254533,'last','0'),(100100004663442, 100100000609305,100100000254534,'last','0'),(10010 0004663443,100100000609306,100100000254535,'last', '0'),(100100004663444,100100000609307,100100000254 536,'last','0'),(100100004663445,100100000609308,1 00100000254537,'last','0'),(100100004663446,100100 000609309,100100000254538,'last','0'),(10010000466 3447,100100000609310,100100000254539,'last','0'),( 100100004663448,100100000609311,100100000254540,'l ast','0'),(100100004663449,100100000609312,1001000 00254541,'last','0'),(100100004663450,100100000609 313,100100000254542,'last','0'),(100100004663451,1 00100000609314,100100000254543,'last','0'),(100100 004663452,100100000609315,100100000254544,'last',' 0'),(100100004663453,100100000609316,1001000002545 45,'last','0'),(100100004663454,100100000609317,10 0100000254546,'last','0'),(100100004663455,1001000 00609318,100100000254547,'last','0'),(100100004663 456,100100000609319,100100000254548,'last','0'),(1 00100004663457,100100000609320,100100000254549,'la st','0'),(100100004663458,100100000609321,10010000 0254550,'last','0'),(100100004663459,1001000006093 22,100100000254551,'last','0'),(100100004663460,10 0100000609323,100100000254552,'last','0'),(1001000 04663461,100100000609324,100100000254553,'last','0 '),(100100004663462,100100000609325,10010000025455 4,'last','0'),(100100004663463,100100000609326,100 100000254555,'last','0'),(100100004663464,10010000 0609327,100100000254556,'last','0'),(1001000046634 65,100100000609328,100100000254557,'last','0'),(10 0100004663466,100100000609329,100100000254558,'las t','0'),(100100004663467,100100000609330,100100000 254559,'last','0'),(100100004663468,10010000060933 1,100100000254560,'last','0'),(100100004663469,100 100000609332,100100000254561,'last','0'),(10010000 4663470,100100000609333,100100000254562,'last','0' ),(100100004663471,100100000609334,100100000254563 ,'last','0'),(100100004663472,100100000609335,1001 00000254564,'last','0'),(100100004663473,100100000 609336,100100000254565,'last','0'),(10010000466347 4,100100000609337,100100000254566,'last','0'),(100 100004663475,100100000609338,100100000254567,'last ','0'),(100100004663476,100100000609339,1001000002 54568,'last','0'),(100100004663477,100100000609340 ,100100000254569,'last','0'),(100100004663478,1001 00000609341,100100000254570,'last','0'),(100100004 663479,100100000609342,100100000254571,'last','0') ,(100100004663480,100100000609343,100100000254572, 'last','0'),(100100004663481,100100000609344,10010 0000254573,'last','0'),(100100004663482,1001000006 09345,100100000254574,'last','0'),(100100004663483 ,100100000609346,100100000254575,'last','0'),(1001 00004663484,100100000609347,100100000254576,'last' ,'0'),(100100004663485,100100000609348,10010000025 4577,'last','0'),(100100004663486,100100000609349, 100100000254578,'last','0'),(100100004663487,10010 0000609350,100100000254579,'last','0'),(1001000046 63488,100100000609351,100100000254580,'last','0'), (100100004663489,100100000609352,100100000254581,' last','0'),(100100004663490,100100000609353,100100 000254582,'last','0'),(100100004663491,10010000060 9354,100100000254583,'last','0'),(100100004663492, 100100000609355,100100000254584,'last','0'),(10010 0004663493,100100000609356,100100000254585,'last', '0'),(100100004663494,100100000609357,100100000254 586,'last','0'),(100100004663495,100100000609358,1 00100000254587,'last','0'),(100100004663496,100100 000609359,100100000254588,'last','0'),(10010000466 3497,100100000609360,100100000254589,'last','0'),( 100100004663498,100100000609361,100100000254590,'l ast','0'),(100100004663499,100100000609362,1001000 00254591,'last','0'),(100100004663500,100100000609 363,100100000254592,'last','0'),(100100004663501,1 00100000609364,100100000254593,'last','0'),(100100 004663502,100100000609365,100100000254594,'last',' 0'),(100100004663503,100100000609366,1001000002545 95,'last','0'),(100100004663504,100100000609367,10 0100000254596,'last','0'),(100100004663505,1001000 00609368,100100000254597,'last','0'),(100100004663 506,100100000609369,100100000254598,'last','0'),(1 00100004663507,100100000609370,100100000254599,'la st','0'),(100100004663508,100100000609371,10010000 0254600,'last','0'),(100100004663509,1001000006093 72,100100000254601,'last','0'),(100100004663510,10 0100000609373,100100000254602,'last','0'),(1001000 04663511,100100000609374,100100000254603,'last','0 '),(100100004663512,100100000609375,10010000025460 4,'last','0'),(100100004663513,100100000609376,100 100000254605,'last','0'),(100100004663514,10010000 0609377,100100000254606,'last','0'),(1001000046635 15,100100000609378,100100000254607,'last','0'),(10 0100004663516,100100000609379,100100000254608,'las t','0'),(100100004663517,100100000609380,100100000 254609,'last','0'),(100100004663518,10010000060938 1,100100000254610,'last','0'),(100100004663519,100 100000609382,100100000254611,'last','0'),(10010000 4663520,100100000609383,100100000254612,'last','0' ),(100100004663521,100100000609384,100100000254613 ,'last','0'),(100100004663522,100100000609385,1001 00000254614,'last','0'),(100100004663523,100100000 609386,100100000254615,'last','0'),(10010000466352 4,100100000609387,100100000254616,'last','0'),(100 100004663525,100100000609388,100100000254617,'last ','0'),(100100004663526,100100000609389,1001000002 54618,'last','0'),(100100004663527,100100000609390 ,100100000254619,'last','0'),(100100004663528,1001 00000609391,100100000254620,'last','0'),(100100004 663529,100100000609392,100100000254621,'last','0') ,(100100004663530,100100000609393,100100000254622, 'last','0'),(100100004663531,100100000609394,10010 0000254623,'last','0'),(100100004663532,1001000006 09395,100100000254624,'last','0'),(100100004663533 ,100100000609396,100100000254625,'last','0'),(1001 00004663534,100100000609397,100100000254626,'last' ,'0'),(100100004663535,100100000609398,10010000025 4627,'last','0'),(100100004663536,100100000609399, 100100000254628,'last','0'),(100100004663537,10010 0000609400,100100000254629,'last','0'),(1001000046 63538,100100000609401,100100000254630,'last','0'), (100100004663539,100100000609402,100100000254631,' last','0'),(100100004663540,100100000609403,100100 000254632,'last','0'),(100100004663541,10010000060 9404,100100000254633,'last','0'),(100100004663542, 100100000609405,100100000254634,'last','0'),(10010 0004663543,100100000609406,100100000254635,'last', '0'),(100100004663544,100100000609407,100100000254 636,'last','0'),(100100004663545,100100000609408,1 00100000254637,'last','0'),(100100004663546,100100 000609409,100100000254638,'last','0'),(10010000466 3547,100100000609410,100100000254639,'last','0'),( 100100004663548,100100000609411,100100000254640,'l ast','0'),(100100004663549,100100000609412,1001000 00254641,'last','0'),(100100004663550,100100000609 413,100100000254642,'last','0'),(100100004663551,1 00100000609414,100100000254643,'last','0'),(100100 004663552,100100000609415,100100000254644,'last',' 0'),(100100004663553,100100000609416,1001000002546 45,'last','0'),(100100004663554,100100000609417,10 0100000254646,'last','0'),(100100004663555,1001000 00609418,100100000254647,'last','0');
24653:20190520:074504.482 [Z3005] query failed: [1062] Duplicate entry '100100000010842-service_state[IISADMIN]' for key 'items_1' [insert into items (itemid,name,key_,hostid,type,value_type,delay,his tory,trends,status,trapper_hosts,units,formula,log timefmt,valuemapid,params,ipmi_sensor,snmp_communi ty,snmp_oid,port,snmpv3_securityname,snmpv3_securi tylevel,snmpv3_authprotocol,snmpv3_authpassphrase, snmpv3_privprotocol,snmpv3_privpassphrase,authtype ,username,password,publickey,privatekey,descriptio n,interfaceid,flags,snmpv3_contextname,jmx_endpoin t,master_itemid,timeout,url,query_fields,posts,sta tus_codes,follow_redirects,post_type,http_proxy,he aders,retrieve_mode,request_method,output_format,s sl_cert_file,ssl_key_file,ssl_k
There is 2 entries we can find in the items stack that is the same for both of the above issues, we are not sure if this is the cause for the Zabbix that stops responding or if it might be something else. This issue started at 3am this morning from what we can see
24653:20190520:074504.482 [Z3005] query failed: [1062] Duplicate entry '100100000010842-service_state[IISADMIN]' for key 'items_1' [insert into items (itemid,name,key_,hostid,type,value_type,delay,his tory,trends,status,trapper_hosts,units,formula,log timefmt,valuemapid,params,ipmi_sensor,snmp_communi ty,snmp_oid,port,snmpv3_securityname,snmpv3_securi tylevel,snmpv3_authprotocol,snmpv3_authpassphrase, snmpv3_privprotocol,snmpv3_privpassphrase,authtype ,username,password,publickey,privatekey,descriptio n,interfaceid,flags,snmpv3_contextname,jmx_endpoin t,master_itemid,timeout,url,query_fields,posts,sta tus_codes,follow_redirects,post_type,http_proxy,he aders,retrieve_mode,request_method,output_format,s sl_cert_file,ssl_key_file,ssl_k
There is 2 entries we can find in the items stack that is the same for both of the above issues, we are not sure if this is the cause for the Zabbix that stops responding or if it might be something else. This issue started at 3am this morning from what we can see