12604:20120821:073930.945 resuming IPMI checks on host [server15]: connection restored 12621:20120821:074829.846 IPMI item [Serverboard_Temp] on host [server03] failed: first network error, wait for 15 seconds 12622:20120821:074832.093 IPMI item [Fan_2A] on host [server15] failed: first network error, wait for 15 seconds 12622:20120821:074846.321 IPMI item [Serverboard_Temp] on host [server12] failed: first network error, wait for 15 seconds 12604:20120821:074902.873 resuming IPMI checks on host [server03]: connection restored 12604:20120821:074910.947 resuming IPMI checks on host [server15]: connection restored 12604:20120821:074918.825 resuming IPMI checks on host [server12]: connection restored 12625:20120821:075829.339 IPMI item [Serverboard_Temp] on host [server03] failed: first network error, wait for 15 seconds 12624:20120821:075831.962 IPMI item [Fan_2A] on host [server15] failed: first network error, wait for 15 seconds 12604:20120821:075901.770 resuming IPMI checks on host [server03]: connection restored 12604:20120821:075928.756 resuming IPMI checks on host [server15]: connection restored 12624:20120821:080829.320 IPMI item [Serverboard_Temp] on host [server03] failed: first network error, wait for 15 seconds 12624:20120821:080830.371 IPMI item [Fan_5A] on host [server15] failed: first network error, wait for 15 seconds 12624:20120821:080846.537 IPMI item [Serverboard_Temp] on host [server12] failed: first network error, wait for 15 seconds 12604:20120821:080900.781 resuming IPMI checks on host [server03]: connection restored 12604:20120821:080910.126 resuming IPMI checks on host [server15]: connection restored 12604:20120821:080917.808 resuming IPMI checks on host [server12]: connection restored 12625:20120821:081317.709 IPMI item [Fan_3A] on host [server03] failed: first network error, wait for 15 seconds 12625:20120821:081330.295 IPMI item [Serverboard_Temp] on host [server15] failed: first network error, wait for 15 seconds 12604:20120821:081347.507 resuming IPMI checks on host [server03]: connection restored 12604:20120821:081355.936 resuming IPMI checks on host [server15]: connection restored 12624:20120821:081829.459 IPMI item [Serverboard_Temp] on host [server03] failed: first network error, wait for 15 seconds 12604:20120821:081902.038 resuming IPMI checks on host [server03]: connection restored 12611:20120821:082108.913 Executing housekeeper 12611:20120821:082119.141 Deleted 17211 records from history [10.040941 seconds] 12587:20120821:082236.427 Received configuration data from server. Datalen 213145 12587:20120821:082237.524 [Z3005] query failed: [1062] Duplicate entry '100100000010053-' for key 'applications_2' [update applications set hostid=100100000010053 where applicationid=100100000000463; insert into applications (applicationid,hostid) values (100100000000665,100100000010053); ] 12587:20120821:082237.554 [Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`zabbix_proxy`.`httptest`, CONSTRAINT `c_httptest_1` FOREIGN KEY (`applicationid`) REFERENCES `applications` (`applicationid`) ON DELETE CASCADE) [update httptest set name='Cinema München',applicationid=100100000000463,delay=300,macros='',agent='gigatec Monitoring',authentication=0,http_user='',http_password='' where httptestid=100100000000010; update httptest set name='Wissenswertes',applicationid=100100000000463,delay=300,macros='',agent='gigatec Monitoring',authentication=0,http_user='',http_password='' where httptestid=100100000000011; update httptest set name='Roncalli Kolleg',applicationid=100100000000463,delay=300,macros='',agent='gigatec Monitoring',authentication=0,http_user='',http_password='' where httptestid=100100000000013; insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000014,'Folien Gigant',100100000000665,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000015,'LED Gigant',100100000000665,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000016,'gigatec GmbH',100100000000463,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000017,'Erlebniswelt Fliegenfischen',100100000000463,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000018,'Whatsyourplace',100100000000463,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000019,'Elast',100100000000463,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000020,'Hardenberg-Gymnasium',100100000000463,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000021,'Paca Coaching',100100000000463,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000022,'Förderverein HGF',100100000000463,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000023,'SteckerChecker',100100000000463,300,'','gigatec Monitoring',0,'',''); ] 12587:20120821:082237.573 [Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`zabbix_proxy`.`httptestitem`, CONSTRAINT `c_httptestitem_1` FOREIGN KEY (`httptestid`) REFERENCES `httptest` (`httptestid`) ON DELETE CASCADE) [update httptestitem set httptestid=100100000000010,itemid=100100000024852,type=2 where httptestitemid=100100000000003; update httptestitem set httptestid=100100000000010,itemid=100100000024853,type=3 where httptestitemid=100100000000004; update httptestitem set httptestid=100100000000010,itemid=100100000024854,type=4 where httptestitemid=100100000000005; update httptestitem set httptestid=100100000000011,itemid=100100000024858,type=2 where httptestitemid=100100000000006; update httptestitem set httptestid=100100000000011,itemid=100100000024859,type=3 where httptestitemid=100100000000007; update httptestitem set httptestid=100100000000011,itemid=100100000024860,type=4 where httptestitemid=100100000000008; update httptestitem set httptestid=100100000000013,itemid=100100000024870,type=2 where httptestitemid=100100000000012; update httptestitem set httptestid=100100000000013,itemid=100100000024871,type=3 where httptestitemid=100100000000013; update httptestitem set httptestid=100100000000013,itemid=100100000024872,type=4 where httptestitemid=100100000000014; insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000015,100100000000014,100100000024876,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000016,100100000000014,100100000024877,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000017,100100000000014,100100000024878,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000018,100100000000015,100100000024882,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000019,100100000000015,100100000024883,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000020,100100000000015,100100000024884,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000021,100100000000016,100100000024888,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000022,100100000000016,100100000024889,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000023,100100000000016,100100000024890,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000024,100100000000017,100100000024894,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000025,100100000000017,100100000024895,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000026,100100000000017,100100000024896,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000027,100100000000018,100100000024900,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000028,100100000000018,100100000024901,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000029,100100000000018,100100000024902,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000030,100100000000019,100100000024909,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000031,100100000000019,100100000024910,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000032,100100000000019,100100000024911,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000033,100100000000020,100100000024924,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000034,100100000000020,100100000024925,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000035,100100000000020,100100000024926,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000036,100100000000021,100100000024930,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000037,100100000000021,100100000024931,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000038,100100000000021,100100000024932,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000039,100100000000022,100100000024936,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000040,100100000000022,100100000024937,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000041,100100000000022,100100000024938,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000042,100100000000023,100100000025238,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000043,100100000000023,100100000025239,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000044,100100000000023,100100000025240,4); ] 12587:20120821:082237.604 [Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`zabbix_proxy`.`httpstep`, CONSTRAINT `c_httpstep_1` FOREIGN KEY (`httptestid`) REFERENCES `httptest` (`httptestid`) ON DELETE CASCADE) [update httpstep set httptestid=100100000000010,name='Cinema München',no=1,url='http://www.cinema-muenchen.de/',timeout=15,posts='',required='Impressum',status_codes='200' where httpstepid=100100000000019; update httpstep set httptestid=100100000000011,name='Startseite',no=1,url='http://www.wissenswertes.biz',timeout=15,posts='',required='Copyright',status_codes='200' where httpstepid=100100000000020; update httpstep set httptestid=100100000000013,name='Roncalli Kolleg',no=1,url='http://www.roncalli-kolleg.de/',timeout=15,posts='',required='Kosten',status_codes='200' where httpstepid=100100000000022; insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000023,100100000000014,'Startseite DE',1,'http://www.folien-gigant.de/',15,'','Impressum','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000024,100100000000015,'Startseite DE',1,'http://www.led-gigant.de/',15,'','Impressum','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000025,100100000000016,'gigatec GmbH',1,'http://www.gigatec.de/',15,'','Impressum','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000026,100100000000017,'Startseite DE',1,'http://www.erlebniswelt-fliegenfischen.de/',15,'','Copyright','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000027,100100000000018,'Startseite DE',1,'http://www.whatsyourplace.de/de/',15,'','Außerdem','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000028,100100000000018,'WYP - Erlebnisse',2,'http://www.whatsyourplace.de/de/events/search',15,'','Copyright','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000029,100100000000019,'Startseite DE',1,'http://www.elast.de/',15,'','Copyright','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000030,100100000000020,'Startseite DE',1,'http://www.hardenberg-gymnasium.de/index.php/startseite-top',15,'','Hosting','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000031,100100000000021,'Paca Coaching',1,'http://paca-coaching.de/',15,'','Outdoor-Training','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000032,100100000000022,'Startseite DE',1,'http://www.foerderverein-hgf.de/',15,'','Valid','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000033,100100000000011,'Customer Login',2,'https://secure.wissenswertes.biz/customer/account/login/',15,'','vergessen','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000034,100100000000023,'Startseite DE',1,'http://www.steckerchecker.de',15,'','Atrada','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000035,100100000000023,'Startseite EN',2,'http://www.steckerchecker.com',15,'','Atrada','200'); ] 12587:20120821:082237.628 [Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`zabbix_proxy`.`httpstepitem`, CONSTRAINT `c_httpstepitem_1` FOREIGN KEY (`httpstepid`) REFERENCES `httpstep` (`httpstepid`) ON DELETE CASCADE) [update httpstepitem set httpstepid=100100000000019,itemid=100100000024855,type=2 where httpstepitemid=100100000000088; update httpstepitem set httpstepid=100100000000019,itemid=100100000024856,type=1 where httpstepitemid=100100000000089; update httpstepitem set httpstepid=100100000000019,itemid=100100000024857,type=0 where httpstepitemid=100100000000090; update httpstepitem set httpstepid=100100000000020,itemid=100100000024861,type=2 where httpstepitemid=100100000000091; update httpstepitem set httpstepid=100100000000020,itemid=100100000024862,type=1 where httpstepitemid=100100000000092; update httpstepitem set httpstepid=100100000000020,itemid=100100000024863,type=0 where httpstepitemid=100100000000093; update httpstepitem set httpstepid=100100000000022,itemid=100100000024873,type=2 where httpstepitemid=100100000000097; update httpstepitem set httpstepid=100100000000022,itemid=100100000024874,type=1 where httpstepitemid=100100000000098; update httpstepitem set httpstepid=100100000000022,itemid=100100000024875,type=0 where httpstepitemid=100100000000099; insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000100,100100000000023,100100000024879,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000101,100100000000023,100100000024880,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000102,100100000000023,100100000024881,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000103,100100000000024,100100000024885,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000104,100100000000024,100100000024886,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000105,100100000000024,100100000024887,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000106,100100000000025,100100000024891,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000107,100100000000025,100100000024892,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000108,100100000000025,100100000024893,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000109,100100000000026,100100000024897,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000110,100100000000026,100100000024898,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000111,100100000000026,100100000024899,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000112,100100000000027,100100000024903,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000113,100100000000027,100100000024904,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000114,100100000000027,100100000024905,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000115,100100000000028,100100000024906,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000116,100100000000028,100100000024907,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000117,100100000000028,100100000024908,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000118,100100000000029,100100000024912,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000119,100100000000029,100100000024913,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000120,100100000000029,100100000024914,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000121,100100000000030,100100000024927,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000122,100100000000030,100100000024928,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000123,100100000000030,100100000024929,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000124,100100000000031,100100000024933,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000125,100100000000031,100100000024934,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000126,100100000000031,100100000024935,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000127,100100000000032,100100000024939,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000128,100100000000032,100100000024940,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000129,100100000000032,100100000024941,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000130,100100000000033,100100000024942,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000131,100100000000033,100100000024943,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000132,100100000000033,100100000024944,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000133,100100000000034,100100000025241,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000134,100100000000034,100100000025242,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000135,100100000000034,100100000025243,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000136,100100000000035,100100000025244,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000137,100100000000035,100100000025245,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000138,100100000000035,100100000025246,0); ] 12623:20120821:082829.562 IPMI item [Serverboard_Temp] on host [server03] failed: first network error, wait for 15 seconds 12622:20120821:082830.697 IPMI item [Fan_1A] on host [server15] failed: first network error, wait for 15 seconds 12604:20120821:082903.192 resuming IPMI checks on host [server03]: connection restored 12604:20120821:082910.665 resuming IPMI checks on host [server15]: connection restored 12622:20120821:083316.977 IPMI item [Fan_2A] on host [server03] failed: first network error, wait for 15 seconds 12625:20120821:083335.908 IPMI item [Serverboard_Temp] on host [server15] failed: first network error, wait for 15 seconds 12604:20120821:083346.755 resuming IPMI checks on host [server03]: connection restored 12604:20120821:083357.624 resuming IPMI checks on host [server15]: connection restored 12621:20120821:084320.653 IPMI item [Fan_1B] on host [server03] failed: first network error, wait for 15 seconds 12621:20120821:084330.169 IPMI item [Serverboard_Temp] on host [server15] failed: first network error, wait for 15 seconds 12604:20120821:084350.174 resuming IPMI checks on host [server03]: connection restored 12604:20120821:084357.745 resuming IPMI checks on host [server15]: connection restored 12624:20120821:084829.112 IPMI item [Serverboard_Temp] on host [server03] failed: first network error, wait for 15 seconds 12604:20120821:084902.077 resuming IPMI checks on host [server03]: connection restored 12621:20120821:085829.167 IPMI item [Serverboard_Temp] on host [server03] failed: first network error, wait for 15 seconds 12622:20120821:085833.068 IPMI item [Fan_3A] on host [server15] failed: first network error, wait for 15 seconds 12622:20120821:085846.517 IPMI item [Serverboard_Temp] on host [server12] failed: first network error, wait for 15 seconds 12604:20120821:085900.837 resuming IPMI checks on host [server03]: connection restored 12604:20120821:085908.558 resuming IPMI checks on host [server15]: connection restored 12604:20120821:085930.318 resuming IPMI checks on host [server12]: connection restored 12624:20120821:090829.433 IPMI item [Serverboard_Temp] on host [server03] failed: first network error, wait for 15 seconds 12621:20120821:090834.103 IPMI item [Fan_4A] on host [server15] failed: first network error, wait for 15 seconds 12621:20120821:090846.296 IPMI item [Serverboard_Temp] on host [server12] failed: first network error, wait for 15 seconds 12604:20120821:090902.011 resuming IPMI checks on host [server03]: connection restored 12604:20120821:090910.492 resuming IPMI checks on host [server15]: connection restored 12604:20120821:090932.442 resuming IPMI checks on host [server12]: connection restored 12623:20120821:091829.140 IPMI item [Serverboard_Temp] on host [server03] failed: first network error, wait for 15 seconds 12625:20120821:091832.757 IPMI item [Fan_3A] on host [server15] failed: first network error, wait for 15 seconds 12604:20120821:091902.072 resuming IPMI checks on host [server03]: connection restored 12604:20120821:091926.787 resuming IPMI checks on host [server15]: connection restored 12611:20120821:092108.370 Executing housekeeper 12611:20120821:092115.696 Deleted 17245 records from history [6.922581 seconds] 12587:20120821:092239.366 Received configuration data from server. Datalen 213145 12587:20120821:092239.893 [Z3005] query failed: [1062] Duplicate entry '100100000010053-' for key 'applications_2' [update applications set hostid=100100000010053 where applicationid=100100000000463; insert into applications (applicationid,hostid) values (100100000000665,100100000010053); ] 12587:20120821:092239.919 [Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`zabbix_proxy`.`httptest`, CONSTRAINT `c_httptest_1` FOREIGN KEY (`applicationid`) REFERENCES `applications` (`applicationid`) ON DELETE CASCADE) [update httptest set name='Cinema München',applicationid=100100000000463,delay=300,macros='',agent='gigatec Monitoring',authentication=0,http_user='',http_password='' where httptestid=100100000000010; update httptest set name='Wissenswertes',applicationid=100100000000463,delay=300,macros='',agent='gigatec Monitoring',authentication=0,http_user='',http_password='' where httptestid=100100000000011; update httptest set name='Roncalli Kolleg',applicationid=100100000000463,delay=300,macros='',agent='gigatec Monitoring',authentication=0,http_user='',http_password='' where httptestid=100100000000013; insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000014,'Folien Gigant',100100000000665,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000015,'LED Gigant',100100000000665,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000016,'gigatec GmbH',100100000000463,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000017,'Erlebniswelt Fliegenfischen',100100000000463,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000018,'Whatsyourplace',100100000000463,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000019,'Elast',100100000000463,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000020,'Hardenberg-Gymnasium',100100000000463,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000021,'Paca Coaching',100100000000463,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000022,'Förderverein HGF',100100000000463,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000023,'SteckerChecker',100100000000463,300,'','gigatec Monitoring',0,'',''); ] 12587:20120821:092239.922 [Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`zabbix_proxy`.`httptestitem`, CONSTRAINT `c_httptestitem_1` FOREIGN KEY (`httptestid`) REFERENCES `httptest` (`httptestid`) ON DELETE CASCADE) [update httptestitem set httptestid=100100000000010,itemid=100100000024852,type=2 where httptestitemid=100100000000003; update httptestitem set httptestid=100100000000010,itemid=100100000024853,type=3 where httptestitemid=100100000000004; update httptestitem set httptestid=100100000000010,itemid=100100000024854,type=4 where httptestitemid=100100000000005; update httptestitem set httptestid=100100000000011,itemid=100100000024858,type=2 where httptestitemid=100100000000006; update httptestitem set httptestid=100100000000011,itemid=100100000024859,type=3 where httptestitemid=100100000000007; update httptestitem set httptestid=100100000000011,itemid=100100000024860,type=4 where httptestitemid=100100000000008; update httptestitem set httptestid=100100000000013,itemid=100100000024870,type=2 where httptestitemid=100100000000012; update httptestitem set httptestid=100100000000013,itemid=100100000024871,type=3 where httptestitemid=100100000000013; update httptestitem set httptestid=100100000000013,itemid=100100000024872,type=4 where httptestitemid=100100000000014; insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000015,100100000000014,100100000024876,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000016,100100000000014,100100000024877,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000017,100100000000014,100100000024878,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000018,100100000000015,100100000024882,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000019,100100000000015,100100000024883,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000020,100100000000015,100100000024884,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000021,100100000000016,100100000024888,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000022,100100000000016,100100000024889,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000023,100100000000016,100100000024890,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000024,100100000000017,100100000024894,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000025,100100000000017,100100000024895,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000026,100100000000017,100100000024896,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000027,100100000000018,100100000024900,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000028,100100000000018,100100000024901,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000029,100100000000018,100100000024902,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000030,100100000000019,100100000024909,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000031,100100000000019,100100000024910,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000032,100100000000019,100100000024911,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000033,100100000000020,100100000024924,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000034,100100000000020,100100000024925,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000035,100100000000020,100100000024926,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000036,100100000000021,100100000024930,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000037,100100000000021,100100000024931,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000038,100100000000021,100100000024932,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000039,100100000000022,100100000024936,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000040,100100000000022,100100000024937,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000041,100100000000022,100100000024938,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000042,100100000000023,100100000025238,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000043,100100000000023,100100000025239,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000044,100100000000023,100100000025240,4); ] 12587:20120821:092239.933 [Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`zabbix_proxy`.`httpstep`, CONSTRAINT `c_httpstep_1` FOREIGN KEY (`httptestid`) REFERENCES `httptest` (`httptestid`) ON DELETE CASCADE) [update httpstep set httptestid=100100000000010,name='Cinema München',no=1,url='http://www.cinema-muenchen.de/',timeout=15,posts='',required='Impressum',status_codes='200' where httpstepid=100100000000019; update httpstep set httptestid=100100000000011,name='Startseite',no=1,url='http://www.wissenswertes.biz',timeout=15,posts='',required='Copyright',status_codes='200' where httpstepid=100100000000020; update httpstep set httptestid=100100000000013,name='Roncalli Kolleg',no=1,url='http://www.roncalli-kolleg.de/',timeout=15,posts='',required='Kosten',status_codes='200' where httpstepid=100100000000022; insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000023,100100000000014,'Startseite DE',1,'http://www.folien-gigant.de/',15,'','Impressum','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000024,100100000000015,'Startseite DE',1,'http://www.led-gigant.de/',15,'','Impressum','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000025,100100000000016,'gigatec GmbH',1,'http://www.gigatec.de/',15,'','Impressum','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000026,100100000000017,'Startseite DE',1,'http://www.erlebniswelt-fliegenfischen.de/',15,'','Copyright','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000027,100100000000018,'Startseite DE',1,'http://www.whatsyourplace.de/de/',15,'','Außerdem','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000028,100100000000018,'WYP - Erlebnisse',2,'http://www.whatsyourplace.de/de/events/search',15,'','Copyright','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000029,100100000000019,'Startseite DE',1,'http://www.elast.de/',15,'','Copyright','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000030,100100000000020,'Startseite DE',1,'http://www.hardenberg-gymnasium.de/index.php/startseite-top',15,'','Hosting','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000031,100100000000021,'Paca Coaching',1,'http://paca-coaching.de/',15,'','Outdoor-Training','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000032,100100000000022,'Startseite DE',1,'http://www.foerderverein-hgf.de/',15,'','Valid','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000033,100100000000011,'Customer Login',2,'https://secure.wissenswertes.biz/customer/account/login/',15,'','vergessen','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000034,100100000000023,'Startseite DE',1,'http://www.steckerchecker.de',15,'','Atrada','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000035,100100000000023,'Startseite EN',2,'http://www.steckerchecker.com',15,'','Atrada','200'); ] 12587:20120821:092240.733 [Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`zabbix_proxy`.`httpstepitem`, CONSTRAINT `c_httpstepitem_1` FOREIGN KEY (`httpstepid`) REFERENCES `httpstep` (`httpstepid`) ON DELETE CASCADE) [update httpstepitem set httpstepid=100100000000019,itemid=100100000024855,type=2 where httpstepitemid=100100000000088; update httpstepitem set httpstepid=100100000000019,itemid=100100000024856,type=1 where httpstepitemid=100100000000089; update httpstepitem set httpstepid=100100000000019,itemid=100100000024857,type=0 where httpstepitemid=100100000000090; update httpstepitem set httpstepid=100100000000020,itemid=100100000024861,type=2 where httpstepitemid=100100000000091; update httpstepitem set httpstepid=100100000000020,itemid=100100000024862,type=1 where httpstepitemid=100100000000092; update httpstepitem set httpstepid=100100000000020,itemid=100100000024863,type=0 where httpstepitemid=100100000000093; update httpstepitem set httpstepid=100100000000022,itemid=100100000024873,type=2 where httpstepitemid=100100000000097; update httpstepitem set httpstepid=100100000000022,itemid=100100000024874,type=1 where httpstepitemid=100100000000098; update httpstepitem set httpstepid=100100000000022,itemid=100100000024875,type=0 where httpstepitemid=100100000000099; insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000100,100100000000023,100100000024879,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000101,100100000000023,100100000024880,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000102,100100000000023,100100000024881,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000103,100100000000024,100100000024885,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000104,100100000000024,100100000024886,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000105,100100000000024,100100000024887,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000106,100100000000025,100100000024891,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000107,100100000000025,100100000024892,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000108,100100000000025,100100000024893,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000109,100100000000026,100100000024897,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000110,100100000000026,100100000024898,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000111,100100000000026,100100000024899,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000112,100100000000027,100100000024903,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000113,100100000000027,100100000024904,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000114,100100000000027,100100000024905,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000115,100100000000028,100100000024906,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000116,100100000000028,100100000024907,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000117,100100000000028,100100000024908,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000118,100100000000029,100100000024912,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000119,100100000000029,100100000024913,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000120,100100000000029,100100000024914,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000121,100100000000030,100100000024927,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000122,100100000000030,100100000024928,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000123,100100000000030,100100000024929,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000124,100100000000031,100100000024933,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000125,100100000000031,100100000024934,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000126,100100000000031,100100000024935,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000127,100100000000032,100100000024939,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000128,100100000000032,100100000024940,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000129,100100000000032,100100000024941,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000130,100100000000033,100100000024942,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000131,100100000000033,100100000024943,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000132,100100000000033,100100000024944,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000133,100100000000034,100100000025241,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000134,100100000000034,100100000025242,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000135,100100000000034,100100000025243,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000136,100100000000035,100100000025244,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000137,100100000000035,100100000025245,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000138,100100000000035,100100000025246,0); ] 12625:20120821:092829.510 IPMI item [Serverboard_Temp] on host [server03] failed: first network error, wait for 15 seconds 12624:20120821:092832.464 IPMI item [Fan_2A] on host [server15] failed: first network error, wait for 15 seconds 12604:20120821:092900.895 resuming IPMI checks on host [server03]: connection restored 12604:20120821:092920.858 resuming IPMI checks on host [server15]: connection restored 12624:20120821:093317.451 IPMI item [Fan_2B] on host [server03] failed: first network error, wait for 15 seconds 12604:20120821:093400.996 resuming IPMI checks on host [server03]: connection restored 12621:20120821:093829.565 IPMI item [Serverboard_Temp] on host [server03] failed: first network error, wait for 15 seconds 12624:20120821:093832.493 IPMI item [Fan_3A] on host [server15] failed: first network error, wait for 15 seconds 12604:20120821:093901.035 resuming IPMI checks on host [server03]: connection restored 12604:20120821:093909.269 resuming IPMI checks on host [server15]: connection restored 12622:20120821:094823.145 IPMI item [Serverboard_Temp] on host [server03] failed: first network error, wait for 15 seconds 12622:20120821:094830.415 IPMI item [Fan_2A] on host [server15] failed: first network error, wait for 15 seconds 12622:20120821:094846.989 IPMI item [Serverboard_Temp] on host [server12] failed: first network error, wait for 15 seconds 12604:20120821:094856.816 resuming IPMI checks on host [server03]: connection restored 12604:20120821:094906.246 resuming IPMI checks on host [server15]: connection restored 12604:20120821:094913.619 resuming IPMI checks on host [server12]: connection restored 12623:20120821:095314.785 IPMI item [Fan_1B] on host [server03] failed: first network error, wait for 15 seconds 12621:20120821:095336.218 IPMI item [Serverboard_Temp] on host [server15] failed: first network error, wait for 15 seconds 12604:20120821:095348.150 resuming IPMI checks on host [server03]: connection restored 12604:20120821:095358.314 resuming IPMI checks on host [server15]: connection restored 12623:20120821:095845.265 IPMI item [Serverboard_Temp] on host [server12] failed: first network error, wait for 15 seconds 12604:20120821:095908.226 resuming IPMI checks on host [server12]: connection restored 12625:20120821:100319.282 IPMI item [Fan_1A] on host [server03] failed: first network error, wait for 15 seconds 12625:20120821:100330.093 IPMI item [Serverboard_Temp] on host [server15] failed: first network error, wait for 15 seconds 12604:20120821:100450.865 resuming IPMI checks on host [server03]: connection restored 12604:20120821:100458.555 resuming IPMI checks on host [server15]: connection restored 12623:20120821:100829.239 IPMI item [Serverboard_Temp] on host [server03] failed: first network error, wait for 15 seconds 12604:20120821:100913.001 resuming IPMI checks on host [server03]: connection restored 12624:20120821:101829.169 IPMI item [Serverboard_Temp] on host [server03] failed: first network error, wait for 15 seconds 12622:20120821:101834.173 IPMI item [Fan_4A] on host [server15] failed: first network error, wait for 15 seconds 12622:20120821:101846.774 IPMI item [Serverboard_Temp] on host [server12] failed: first network error, wait for 15 seconds 12604:20120821:101904.090 resuming IPMI checks on host [server03]: connection restored 12604:20120821:101941.772 resuming IPMI checks on host [server15]: connection restored 12604:20120821:101950.009 resuming IPMI checks on host [server12]: connection restored 12611:20120821:102108.933 Executing housekeeper 12611:20120821:102119.057 Deleted 17295 records from history [9.691705 seconds] 12587:20120821:102241.866 Received configuration data from server. Datalen 213145 12587:20120821:102242.657 [Z3005] query failed: [1062] Duplicate entry '100100000010053-' for key 'applications_2' [update applications set hostid=100100000010053 where applicationid=100100000000463; insert into applications (applicationid,hostid) values (100100000000665,100100000010053); ] 12587:20120821:102242.686 [Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`zabbix_proxy`.`httptest`, CONSTRAINT `c_httptest_1` FOREIGN KEY (`applicationid`) REFERENCES `applications` (`applicationid`) ON DELETE CASCADE) [update httptest set name='Cinema München',applicationid=100100000000463,delay=300,macros='',agent='gigatec Monitoring',authentication=0,http_user='',http_password='' where httptestid=100100000000010; update httptest set name='Wissenswertes',applicationid=100100000000463,delay=300,macros='',agent='gigatec Monitoring',authentication=0,http_user='',http_password='' where httptestid=100100000000011; update httptest set name='Roncalli Kolleg',applicationid=100100000000463,delay=300,macros='',agent='gigatec Monitoring',authentication=0,http_user='',http_password='' where httptestid=100100000000013; insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000014,'Folien Gigant',100100000000665,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000015,'LED Gigant',100100000000665,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000016,'gigatec GmbH',100100000000463,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000017,'Erlebniswelt Fliegenfischen',100100000000463,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000018,'Whatsyourplace',100100000000463,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000019,'Elast',100100000000463,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000020,'Hardenberg-Gymnasium',100100000000463,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000021,'Paca Coaching',100100000000463,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000022,'Förderverein HGF',100100000000463,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000023,'SteckerChecker',100100000000463,300,'','gigatec Monitoring',0,'',''); ] 12587:20120821:102242.696 [Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`zabbix_proxy`.`httptestitem`, CONSTRAINT `c_httptestitem_1` FOREIGN KEY (`httptestid`) REFERENCES `httptest` (`httptestid`) ON DELETE CASCADE) [update httptestitem set httptestid=100100000000010,itemid=100100000024852,type=2 where httptestitemid=100100000000003; update httptestitem set httptestid=100100000000010,itemid=100100000024853,type=3 where httptestitemid=100100000000004; update httptestitem set httptestid=100100000000010,itemid=100100000024854,type=4 where httptestitemid=100100000000005; update httptestitem set httptestid=100100000000011,itemid=100100000024858,type=2 where httptestitemid=100100000000006; update httptestitem set httptestid=100100000000011,itemid=100100000024859,type=3 where httptestitemid=100100000000007; update httptestitem set httptestid=100100000000011,itemid=100100000024860,type=4 where httptestitemid=100100000000008; update httptestitem set httptestid=100100000000013,itemid=100100000024870,type=2 where httptestitemid=100100000000012; update httptestitem set httptestid=100100000000013,itemid=100100000024871,type=3 where httptestitemid=100100000000013; update httptestitem set httptestid=100100000000013,itemid=100100000024872,type=4 where httptestitemid=100100000000014; insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000015,100100000000014,100100000024876,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000016,100100000000014,100100000024877,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000017,100100000000014,100100000024878,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000018,100100000000015,100100000024882,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000019,100100000000015,100100000024883,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000020,100100000000015,100100000024884,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000021,100100000000016,100100000024888,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000022,100100000000016,100100000024889,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000023,100100000000016,100100000024890,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000024,100100000000017,100100000024894,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000025,100100000000017,100100000024895,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000026,100100000000017,100100000024896,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000027,100100000000018,100100000024900,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000028,100100000000018,100100000024901,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000029,100100000000018,100100000024902,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000030,100100000000019,100100000024909,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000031,100100000000019,100100000024910,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000032,100100000000019,100100000024911,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000033,100100000000020,100100000024924,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000034,100100000000020,100100000024925,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000035,100100000000020,100100000024926,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000036,100100000000021,100100000024930,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000037,100100000000021,100100000024931,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000038,100100000000021,100100000024932,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000039,100100000000022,100100000024936,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000040,100100000000022,100100000024937,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000041,100100000000022,100100000024938,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000042,100100000000023,100100000025238,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000043,100100000000023,100100000025239,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000044,100100000000023,100100000025240,4); ] 12587:20120821:102242.818 [Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`zabbix_proxy`.`httpstep`, CONSTRAINT `c_httpstep_1` FOREIGN KEY (`httptestid`) REFERENCES `httptest` (`httptestid`) ON DELETE CASCADE) [update httpstep set httptestid=100100000000010,name='Cinema München',no=1,url='http://www.cinema-muenchen.de/',timeout=15,posts='',required='Impressum',status_codes='200' where httpstepid=100100000000019; update httpstep set httptestid=100100000000011,name='Startseite',no=1,url='http://www.wissenswertes.biz',timeout=15,posts='',required='Copyright',status_codes='200' where httpstepid=100100000000020; update httpstep set httptestid=100100000000013,name='Roncalli Kolleg',no=1,url='http://www.roncalli-kolleg.de/',timeout=15,posts='',required='Kosten',status_codes='200' where httpstepid=100100000000022; insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000023,100100000000014,'Startseite DE',1,'http://www.folien-gigant.de/',15,'','Impressum','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000024,100100000000015,'Startseite DE',1,'http://www.led-gigant.de/',15,'','Impressum','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000025,100100000000016,'gigatec GmbH',1,'http://www.gigatec.de/',15,'','Impressum','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000026,100100000000017,'Startseite DE',1,'http://www.erlebniswelt-fliegenfischen.de/',15,'','Copyright','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000027,100100000000018,'Startseite DE',1,'http://www.whatsyourplace.de/de/',15,'','Außerdem','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000028,100100000000018,'WYP - Erlebnisse',2,'http://www.whatsyourplace.de/de/events/search',15,'','Copyright','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000029,100100000000019,'Startseite DE',1,'http://www.elast.de/',15,'','Copyright','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000030,100100000000020,'Startseite DE',1,'http://www.hardenberg-gymnasium.de/index.php/startseite-top',15,'','Hosting','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000031,100100000000021,'Paca Coaching',1,'http://paca-coaching.de/',15,'','Outdoor-Training','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000032,100100000000022,'Startseite DE',1,'http://www.foerderverein-hgf.de/',15,'','Valid','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000033,100100000000011,'Customer Login',2,'https://secure.wissenswertes.biz/customer/account/login/',15,'','vergessen','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000034,100100000000023,'Startseite DE',1,'http://www.steckerchecker.de',15,'','Atrada','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000035,100100000000023,'Startseite EN',2,'http://www.steckerchecker.com',15,'','Atrada','200'); ] 12587:20120821:102242.953 [Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`zabbix_proxy`.`httpstepitem`, CONSTRAINT `c_httpstepitem_1` FOREIGN KEY (`httpstepid`) REFERENCES `httpstep` (`httpstepid`) ON DELETE CASCADE) [update httpstepitem set httpstepid=100100000000019,itemid=100100000024855,type=2 where httpstepitemid=100100000000088; update httpstepitem set httpstepid=100100000000019,itemid=100100000024856,type=1 where httpstepitemid=100100000000089; update httpstepitem set httpstepid=100100000000019,itemid=100100000024857,type=0 where httpstepitemid=100100000000090; update httpstepitem set httpstepid=100100000000020,itemid=100100000024861,type=2 where httpstepitemid=100100000000091; update httpstepitem set httpstepid=100100000000020,itemid=100100000024862,type=1 where httpstepitemid=100100000000092; update httpstepitem set httpstepid=100100000000020,itemid=100100000024863,type=0 where httpstepitemid=100100000000093; update httpstepitem set httpstepid=100100000000022,itemid=100100000024873,type=2 where httpstepitemid=100100000000097; update httpstepitem set httpstepid=100100000000022,itemid=100100000024874,type=1 where httpstepitemid=100100000000098; update httpstepitem set httpstepid=100100000000022,itemid=100100000024875,type=0 where httpstepitemid=100100000000099; insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000100,100100000000023,100100000024879,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000101,100100000000023,100100000024880,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000102,100100000000023,100100000024881,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000103,100100000000024,100100000024885,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000104,100100000000024,100100000024886,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000105,100100000000024,100100000024887,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000106,100100000000025,100100000024891,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000107,100100000000025,100100000024892,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000108,100100000000025,100100000024893,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000109,100100000000026,100100000024897,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000110,100100000000026,100100000024898,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000111,100100000000026,100100000024899,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000112,100100000000027,100100000024903,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000113,100100000000027,100100000024904,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000114,100100000000027,100100000024905,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000115,100100000000028,100100000024906,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000116,100100000000028,100100000024907,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000117,100100000000028,100100000024908,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000118,100100000000029,100100000024912,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000119,100100000000029,100100000024913,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000120,100100000000029,100100000024914,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000121,100100000000030,100100000024927,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000122,100100000000030,100100000024928,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000123,100100000000030,100100000024929,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000124,100100000000031,100100000024933,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000125,100100000000031,100100000024934,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000126,100100000000031,100100000024935,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000127,100100000000032,100100000024939,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000128,100100000000032,100100000024940,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000129,100100000000032,100100000024941,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000130,100100000000033,100100000024942,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000131,100100000000033,100100000024943,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000132,100100000000033,100100000024944,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000133,100100000000034,100100000025241,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000134,100100000000034,100100000025242,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000135,100100000000034,100100000025243,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000136,100100000000035,100100000025244,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000137,100100000000035,100100000025245,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000138,100100000000035,100100000025246,0); ] 12623:20120821:102829.591 IPMI item [Serverboard_Temp] on host [server03] failed: first network error, wait for 15 seconds 12625:20120821:102834.411 IPMI item [Fan_4A] on host [server15] failed: first network error, wait for 15 seconds 12604:20120821:102901.773 resuming IPMI checks on host [server03]: connection restored 12604:20120821:102909.718 resuming IPMI checks on host [server15]: connection restored 12625:20120821:103314.694 IPMI item [Fan_1B] on host [server03] failed: first network error, wait for 15 seconds 12622:20120821:103335.454 IPMI item [Serverboard_Temp] on host [server15] failed: first network error, wait for 15 seconds 12623:20120821:103344.604 IPMI item [Fan_2A] on host [server12] failed: first network error, wait for 15 seconds 12604:20120821:103357.185 resuming IPMI checks on host [server03]: connection restored 12604:20120821:103405.136 resuming IPMI checks on host [server15]: connection restored 12604:20120821:103438.115 resuming IPMI checks on host [server12]: connection restored 12624:20120821:103824.316 IPMI item [Fan_1A] on host [server15] failed: first network error, wait for 15 seconds 12604:20120821:103847.452 resuming IPMI checks on host [server15]: connection restored 12625:20120821:103852.359 IPMI item [Serverboard_Temp] on host [server12] failed: first network error, wait for 15 seconds 12604:20120821:103915.628 resuming IPMI checks on host [server12]: connection restored 12622:20120821:104322.792 IPMI item [Fan_2B] on host [server03] failed: first network error, wait for 15 seconds 12621:20120821:104324.296 IPMI item [Fan_3A] on host [server03] failed: another network error, wait for 15 seconds 12604:20120821:104433.865 resuming IPMI checks on host [server03]: connection restored 12624:20120821:104829.415 IPMI item [Serverboard_Temp] on host [server03] failed: first network error, wait for 15 seconds 12621:20120821:104834.127 IPMI item [Fan_4A] on host [server15] failed: first network error, wait for 15 seconds 12621:20120821:104846.449 IPMI item [Serverboard_Temp] on host [server12] failed: first network error, wait for 15 seconds 12604:20120821:104900.887 resuming IPMI checks on host [server03]: connection restored 12604:20120821:104908.716 resuming IPMI checks on host [server15]: connection restored 12604:20120821:104916.265 resuming IPMI checks on host [server12]: connection restored 12624:20120821:105830.036 IPMI item [Serverboard_Temp] on host [server03] failed: first network error, wait for 15 seconds 12623:20120821:105830.218 IPMI item [Fan_1A] on host [server15] failed: first network error, wait for 15 seconds 12623:20120821:105846.317 IPMI item [Serverboard_Temp] on host [server12] failed: first network error, wait for 15 seconds 12604:20120821:105901.493 resuming IPMI checks on host [server03]: connection restored 12604:20120821:105909.434 resuming IPMI checks on host [server15]: connection restored 12604:20120821:105916.682 resuming IPMI checks on host [server12]: connection restored 12622:20120821:110829.256 IPMI item [Serverboard_Temp] on host [server03] failed: first network error, wait for 15 seconds 12625:20120821:110830.195 IPMI item [Fan_1A] on host [server15] failed: first network error, wait for 15 seconds 12625:20120821:110846.897 IPMI item [Serverboard_Temp] on host [server12] failed: first network error, wait for 15 seconds 12604:20120821:110901.855 resuming IPMI checks on host [server03]: connection restored 12604:20120821:110909.844 resuming IPMI checks on host [server15]: connection restored 12604:20120821:110917.663 resuming IPMI checks on host [server12]: connection restored 12625:20120821:111829.399 IPMI item [Serverboard_Temp] on host [server03] failed: first network error, wait for 15 seconds 12622:20120821:111834.589 IPMI item [Fan_4A] on host [server15] failed: first network error, wait for 15 seconds 12604:20120821:111901.641 resuming IPMI checks on host [server03]: connection restored 12604:20120821:111910.333 resuming IPMI checks on host [server15]: connection restored 12611:20120821:112108.284 Executing housekeeper 12611:20120821:112117.412 Deleted 17258 records from history [8.788785 seconds] 12587:20120821:112243.523 Received configuration data from server. Datalen 213145 12587:20120821:112246.271 [Z3005] query failed: [1062] Duplicate entry '100100000010053-' for key 'applications_2' [update applications set hostid=100100000010053 where applicationid=100100000000463; insert into applications (applicationid,hostid) values (100100000000665,100100000010053); ] 12587:20120821:112246.317 [Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`zabbix_proxy`.`httptest`, CONSTRAINT `c_httptest_1` FOREIGN KEY (`applicationid`) REFERENCES `applications` (`applicationid`) ON DELETE CASCADE) [update httptest set name='Cinema München',applicationid=100100000000463,delay=300,macros='',agent='gigatec Monitoring',authentication=0,http_user='',http_password='' where httptestid=100100000000010; update httptest set name='Wissenswertes',applicationid=100100000000463,delay=300,macros='',agent='gigatec Monitoring',authentication=0,http_user='',http_password='' where httptestid=100100000000011; update httptest set name='Roncalli Kolleg',applicationid=100100000000463,delay=300,macros='',agent='gigatec Monitoring',authentication=0,http_user='',http_password='' where httptestid=100100000000013; insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000014,'Folien Gigant',100100000000665,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000015,'LED Gigant',100100000000665,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000016,'gigatec GmbH',100100000000463,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000017,'Erlebniswelt Fliegenfischen',100100000000463,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000018,'Whatsyourplace',100100000000463,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000019,'Elast',100100000000463,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000020,'Hardenberg-Gymnasium',100100000000463,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000021,'Paca Coaching',100100000000463,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000022,'Förderverein HGF',100100000000463,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000023,'SteckerChecker',100100000000463,300,'','gigatec Monitoring',0,'',''); ] 12587:20120821:112246.339 [Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`zabbix_proxy`.`httptestitem`, CONSTRAINT `c_httptestitem_1` FOREIGN KEY (`httptestid`) REFERENCES `httptest` (`httptestid`) ON DELETE CASCADE) [update httptestitem set httptestid=100100000000010,itemid=100100000024852,type=2 where httptestitemid=100100000000003; update httptestitem set httptestid=100100000000010,itemid=100100000024853,type=3 where httptestitemid=100100000000004; update httptestitem set httptestid=100100000000010,itemid=100100000024854,type=4 where httptestitemid=100100000000005; update httptestitem set httptestid=100100000000011,itemid=100100000024858,type=2 where httptestitemid=100100000000006; update httptestitem set httptestid=100100000000011,itemid=100100000024859,type=3 where httptestitemid=100100000000007; update httptestitem set httptestid=100100000000011,itemid=100100000024860,type=4 where httptestitemid=100100000000008; update httptestitem set httptestid=100100000000013,itemid=100100000024870,type=2 where httptestitemid=100100000000012; update httptestitem set httptestid=100100000000013,itemid=100100000024871,type=3 where httptestitemid=100100000000013; update httptestitem set httptestid=100100000000013,itemid=100100000024872,type=4 where httptestitemid=100100000000014; insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000015,100100000000014,100100000024876,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000016,100100000000014,100100000024877,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000017,100100000000014,100100000024878,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000018,100100000000015,100100000024882,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000019,100100000000015,100100000024883,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000020,100100000000015,100100000024884,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000021,100100000000016,100100000024888,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000022,100100000000016,100100000024889,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000023,100100000000016,100100000024890,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000024,100100000000017,100100000024894,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000025,100100000000017,100100000024895,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000026,100100000000017,100100000024896,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000027,100100000000018,100100000024900,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000028,100100000000018,100100000024901,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000029,100100000000018,100100000024902,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000030,100100000000019,100100000024909,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000031,100100000000019,100100000024910,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000032,100100000000019,100100000024911,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000033,100100000000020,100100000024924,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000034,100100000000020,100100000024925,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000035,100100000000020,100100000024926,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000036,100100000000021,100100000024930,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000037,100100000000021,100100000024931,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000038,100100000000021,100100000024932,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000039,100100000000022,100100000024936,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000040,100100000000022,100100000024937,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000041,100100000000022,100100000024938,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000042,100100000000023,100100000025238,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000043,100100000000023,100100000025239,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000044,100100000000023,100100000025240,4); ] 12587:20120821:112246.340 [Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`zabbix_proxy`.`httpstep`, CONSTRAINT `c_httpstep_1` FOREIGN KEY (`httptestid`) REFERENCES `httptest` (`httptestid`) ON DELETE CASCADE) [update httpstep set httptestid=100100000000010,name='Cinema München',no=1,url='http://www.cinema-muenchen.de/',timeout=15,posts='',required='Impressum',status_codes='200' where httpstepid=100100000000019; update httpstep set httptestid=100100000000011,name='Startseite',no=1,url='http://www.wissenswertes.biz',timeout=15,posts='',required='Copyright',status_codes='200' where httpstepid=100100000000020; update httpstep set httptestid=100100000000013,name='Roncalli Kolleg',no=1,url='http://www.roncalli-kolleg.de/',timeout=15,posts='',required='Kosten',status_codes='200' where httpstepid=100100000000022; insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000023,100100000000014,'Startseite DE',1,'http://www.folien-gigant.de/',15,'','Impressum','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000024,100100000000015,'Startseite DE',1,'http://www.led-gigant.de/',15,'','Impressum','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000025,100100000000016,'gigatec GmbH',1,'http://www.gigatec.de/',15,'','Impressum','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000026,100100000000017,'Startseite DE',1,'http://www.erlebniswelt-fliegenfischen.de/',15,'','Copyright','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000027,100100000000018,'Startseite DE',1,'http://www.whatsyourplace.de/de/',15,'','Außerdem','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000028,100100000000018,'WYP - Erlebnisse',2,'http://www.whatsyourplace.de/de/events/search',15,'','Copyright','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000029,100100000000019,'Startseite DE',1,'http://www.elast.de/',15,'','Copyright','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000030,100100000000020,'Startseite DE',1,'http://www.hardenberg-gymnasium.de/index.php/startseite-top',15,'','Hosting','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000031,100100000000021,'Paca Coaching',1,'http://paca-coaching.de/',15,'','Outdoor-Training','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000032,100100000000022,'Startseite DE',1,'http://www.foerderverein-hgf.de/',15,'','Valid','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000033,100100000000011,'Customer Login',2,'https://secure.wissenswertes.biz/customer/account/login/',15,'','vergessen','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000034,100100000000023,'Startseite DE',1,'http://www.steckerchecker.de',15,'','Atrada','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000035,100100000000023,'Startseite EN',2,'http://www.steckerchecker.com',15,'','Atrada','200'); ] 12587:20120821:112246.342 [Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`zabbix_proxy`.`httpstepitem`, CONSTRAINT `c_httpstepitem_1` FOREIGN KEY (`httpstepid`) REFERENCES `httpstep` (`httpstepid`) ON DELETE CASCADE) [update httpstepitem set httpstepid=100100000000019,itemid=100100000024855,type=2 where httpstepitemid=100100000000088; update httpstepitem set httpstepid=100100000000019,itemid=100100000024856,type=1 where httpstepitemid=100100000000089; update httpstepitem set httpstepid=100100000000019,itemid=100100000024857,type=0 where httpstepitemid=100100000000090; update httpstepitem set httpstepid=100100000000020,itemid=100100000024861,type=2 where httpstepitemid=100100000000091; update httpstepitem set httpstepid=100100000000020,itemid=100100000024862,type=1 where httpstepitemid=100100000000092; update httpstepitem set httpstepid=100100000000020,itemid=100100000024863,type=0 where httpstepitemid=100100000000093; update httpstepitem set httpstepid=100100000000022,itemid=100100000024873,type=2 where httpstepitemid=100100000000097; update httpstepitem set httpstepid=100100000000022,itemid=100100000024874,type=1 where httpstepitemid=100100000000098; update httpstepitem set httpstepid=100100000000022,itemid=100100000024875,type=0 where httpstepitemid=100100000000099; insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000100,100100000000023,100100000024879,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000101,100100000000023,100100000024880,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000102,100100000000023,100100000024881,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000103,100100000000024,100100000024885,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000104,100100000000024,100100000024886,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000105,100100000000024,100100000024887,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000106,100100000000025,100100000024891,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000107,100100000000025,100100000024892,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000108,100100000000025,100100000024893,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000109,100100000000026,100100000024897,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000110,100100000000026,100100000024898,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000111,100100000000026,100100000024899,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000112,100100000000027,100100000024903,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000113,100100000000027,100100000024904,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000114,100100000000027,100100000024905,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000115,100100000000028,100100000024906,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000116,100100000000028,100100000024907,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000117,100100000000028,100100000024908,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000118,100100000000029,100100000024912,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000119,100100000000029,100100000024913,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000120,100100000000029,100100000024914,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000121,100100000000030,100100000024927,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000122,100100000000030,100100000024928,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000123,100100000000030,100100000024929,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000124,100100000000031,100100000024933,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000125,100100000000031,100100000024934,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000126,100100000000031,100100000024935,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000127,100100000000032,100100000024939,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000128,100100000000032,100100000024940,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000129,100100000000032,100100000024941,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000130,100100000000033,100100000024942,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000131,100100000000033,100100000024943,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000132,100100000000033,100100000024944,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000133,100100000000034,100100000025241,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000134,100100000000034,100100000025242,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000135,100100000000034,100100000025243,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000136,100100000000035,100100000025244,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000137,100100000000035,100100000025245,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000138,100100000000035,100100000025246,0); ] 12622:20120821:112316.645 IPMI item [Fan_2B] on host [server03] failed: first network error, wait for 15 seconds 12604:20120821:112416.509 resuming IPMI checks on host [server03]: connection restored 12621:20120821:112825.588 IPMI item [Fan_2A] on host [server15] failed: first network error, wait for 15 seconds 12621:20120821:112846.772 IPMI item [Serverboard_Temp] on host [server12] failed: first network error, wait for 15 seconds 12604:20120821:112848.455 resuming IPMI checks on host [server15]: connection restored 12604:20120821:112910.111 resuming IPMI checks on host [server12]: connection restored 12623:20120821:113318.594 IPMI item [Fan_3A] on host [server03] failed: first network error, wait for 15 seconds 12625:20120821:113321.076 IPMI item [Fan_1B] on host [server03] failed: another network error, wait for 15 seconds 12622:20120821:113321.992 IPMI item [Fan_2A] on host [server03] failed: another network error, wait for 15 seconds 12624:20120821:113323.188 IPMI item [Fan_2B] on host [server03] failed: another network error, wait for 15 seconds 12604:20120821:113353.848 resuming IPMI checks on host [server03]: connection restored 12625:20120821:114319.235 IPMI item [Fan_1A] on host [server03] failed: first network error, wait for 15 seconds 12625:20120821:114329.497 IPMI item [Serverboard_Temp] on host [server15] failed: first network error, wait for 15 seconds 12604:20120821:114434.060 resuming IPMI checks on host [server03]: connection restored 12604:20120821:114441.632 resuming IPMI checks on host [server15]: connection restored 12625:20120821:115323.044 IPMI item [Fan_2B] on host [server03] failed: first network error, wait for 15 seconds 12625:20120821:115329.069 IPMI item [Serverboard_Temp] on host [server15] failed: first network error, wait for 15 seconds 12604:20120821:115354.119 resuming IPMI checks on host [server03]: connection restored 12604:20120821:115402.422 resuming IPMI checks on host [server15]: connection restored 12623:20120821:115830.029 IPMI item [Serverboard_Temp] on host [server03] failed: first network error, wait for 15 seconds 12604:20120821:115900.977 resuming IPMI checks on host [server03]: connection restored 12621:20120821:120829.722 IPMI item [Serverboard_Temp] on host [server03] failed: first network error, wait for 15 seconds 12621:20120821:120831.043 IPMI item [Fan_5A] on host [server15] failed: first network error, wait for 15 seconds 12621:20120821:120846.341 IPMI item [Serverboard_Temp] on host [server12] failed: first network error, wait for 15 seconds 12604:20120821:120903.205 resuming IPMI checks on host [server03]: connection restored 12604:20120821:120911.126 resuming IPMI checks on host [server15]: connection restored 12604:20120821:120918.347 resuming IPMI checks on host [server12]: connection restored 12623:20120821:121317.273 IPMI item [Fan_2B] on host [server03] failed: first network error, wait for 15 seconds 12623:20120821:121329.630 IPMI item [Serverboard_Temp] on host [server15] failed: first network error, wait for 15 seconds 12604:20120821:121348.644 resuming IPMI checks on host [server03]: connection restored 12604:20120821:121356.716 resuming IPMI checks on host [server15]: connection restored 12624:20120821:121825.247 IPMI item [Fan_2A] on host [server15] failed: first network error, wait for 15 seconds 12621:20120821:121829.664 IPMI item [Serverboard_Temp] on host [server03] failed: first network error, wait for 15 seconds 12624:20120821:121846.573 IPMI item [Serverboard_Temp] on host [server12] failed: first network error, wait for 15 seconds 12604:20120821:121848.218 resuming IPMI checks on host [server15]: connection restored 12604:20120821:121906.850 resuming IPMI checks on host [server03]: connection restored 12604:20120821:121914.359 resuming IPMI checks on host [server12]: connection restored 12611:20120821:122108.641 Executing housekeeper 12611:20120821:122118.481 Deleted 17214 records from history [9.425265 seconds] 12587:20120821:122247.118 Received configuration data from server. Datalen 213145 12587:20120821:122249.260 [Z3005] query failed: [1062] Duplicate entry '100100000010053-' for key 'applications_2' [update applications set hostid=100100000010053 where applicationid=100100000000463; insert into applications (applicationid,hostid) values (100100000000665,100100000010053); ] 12587:20120821:122249.309 [Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`zabbix_proxy`.`httptest`, CONSTRAINT `c_httptest_1` FOREIGN KEY (`applicationid`) REFERENCES `applications` (`applicationid`) ON DELETE CASCADE) [update httptest set name='Cinema München',applicationid=100100000000463,delay=300,macros='',agent='gigatec Monitoring',authentication=0,http_user='',http_password='' where httptestid=100100000000010; update httptest set name='Wissenswertes',applicationid=100100000000463,delay=300,macros='',agent='gigatec Monitoring',authentication=0,http_user='',http_password='' where httptestid=100100000000011; update httptest set name='Roncalli Kolleg',applicationid=100100000000463,delay=300,macros='',agent='gigatec Monitoring',authentication=0,http_user='',http_password='' where httptestid=100100000000013; insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000014,'Folien Gigant',100100000000665,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000015,'LED Gigant',100100000000665,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000016,'gigatec GmbH',100100000000463,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000017,'Erlebniswelt Fliegenfischen',100100000000463,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000018,'Whatsyourplace',100100000000463,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000019,'Elast',100100000000463,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000020,'Hardenberg-Gymnasium',100100000000463,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000021,'Paca Coaching',100100000000463,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000022,'Förderverein HGF',100100000000463,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000023,'SteckerChecker',100100000000463,300,'','gigatec Monitoring',0,'',''); ] 12587:20120821:122249.319 [Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`zabbix_proxy`.`httptestitem`, CONSTRAINT `c_httptestitem_1` FOREIGN KEY (`httptestid`) REFERENCES `httptest` (`httptestid`) ON DELETE CASCADE) [update httptestitem set httptestid=100100000000010,itemid=100100000024852,type=2 where httptestitemid=100100000000003; update httptestitem set httptestid=100100000000010,itemid=100100000024853,type=3 where httptestitemid=100100000000004; update httptestitem set httptestid=100100000000010,itemid=100100000024854,type=4 where httptestitemid=100100000000005; update httptestitem set httptestid=100100000000011,itemid=100100000024858,type=2 where httptestitemid=100100000000006; update httptestitem set httptestid=100100000000011,itemid=100100000024859,type=3 where httptestitemid=100100000000007; update httptestitem set httptestid=100100000000011,itemid=100100000024860,type=4 where httptestitemid=100100000000008; update httptestitem set httptestid=100100000000013,itemid=100100000024870,type=2 where httptestitemid=100100000000012; update httptestitem set httptestid=100100000000013,itemid=100100000024871,type=3 where httptestitemid=100100000000013; update httptestitem set httptestid=100100000000013,itemid=100100000024872,type=4 where httptestitemid=100100000000014; insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000015,100100000000014,100100000024876,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000016,100100000000014,100100000024877,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000017,100100000000014,100100000024878,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000018,100100000000015,100100000024882,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000019,100100000000015,100100000024883,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000020,100100000000015,100100000024884,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000021,100100000000016,100100000024888,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000022,100100000000016,100100000024889,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000023,100100000000016,100100000024890,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000024,100100000000017,100100000024894,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000025,100100000000017,100100000024895,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000026,100100000000017,100100000024896,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000027,100100000000018,100100000024900,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000028,100100000000018,100100000024901,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000029,100100000000018,100100000024902,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000030,100100000000019,100100000024909,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000031,100100000000019,100100000024910,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000032,100100000000019,100100000024911,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000033,100100000000020,100100000024924,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000034,100100000000020,100100000024925,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000035,100100000000020,100100000024926,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000036,100100000000021,100100000024930,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000037,100100000000021,100100000024931,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000038,100100000000021,100100000024932,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000039,100100000000022,100100000024936,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000040,100100000000022,100100000024937,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000041,100100000000022,100100000024938,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000042,100100000000023,100100000025238,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000043,100100000000023,100100000025239,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000044,100100000000023,100100000025240,4); ] 12587:20120821:122249.340 [Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`zabbix_proxy`.`httpstep`, CONSTRAINT `c_httpstep_1` FOREIGN KEY (`httptestid`) REFERENCES `httptest` (`httptestid`) ON DELETE CASCADE) [update httpstep set httptestid=100100000000010,name='Cinema München',no=1,url='http://www.cinema-muenchen.de/',timeout=15,posts='',required='Impressum',status_codes='200' where httpstepid=100100000000019; update httpstep set httptestid=100100000000011,name='Startseite',no=1,url='http://www.wissenswertes.biz',timeout=15,posts='',required='Copyright',status_codes='200' where httpstepid=100100000000020; update httpstep set httptestid=100100000000013,name='Roncalli Kolleg',no=1,url='http://www.roncalli-kolleg.de/',timeout=15,posts='',required='Kosten',status_codes='200' where httpstepid=100100000000022; insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000023,100100000000014,'Startseite DE',1,'http://www.folien-gigant.de/',15,'','Impressum','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000024,100100000000015,'Startseite DE',1,'http://www.led-gigant.de/',15,'','Impressum','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000025,100100000000016,'gigatec GmbH',1,'http://www.gigatec.de/',15,'','Impressum','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000026,100100000000017,'Startseite DE',1,'http://www.erlebniswelt-fliegenfischen.de/',15,'','Copyright','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000027,100100000000018,'Startseite DE',1,'http://www.whatsyourplace.de/de/',15,'','Außerdem','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000028,100100000000018,'WYP - Erlebnisse',2,'http://www.whatsyourplace.de/de/events/search',15,'','Copyright','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000029,100100000000019,'Startseite DE',1,'http://www.elast.de/',15,'','Copyright','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000030,100100000000020,'Startseite DE',1,'http://www.hardenberg-gymnasium.de/index.php/startseite-top',15,'','Hosting','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000031,100100000000021,'Paca Coaching',1,'http://paca-coaching.de/',15,'','Outdoor-Training','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000032,100100000000022,'Startseite DE',1,'http://www.foerderverein-hgf.de/',15,'','Valid','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000033,100100000000011,'Customer Login',2,'https://secure.wissenswertes.biz/customer/account/login/',15,'','vergessen','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000034,100100000000023,'Startseite DE',1,'http://www.steckerchecker.de',15,'','Atrada','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000035,100100000000023,'Startseite EN',2,'http://www.steckerchecker.com',15,'','Atrada','200'); ] 12587:20120821:122249.381 [Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`zabbix_proxy`.`httpstepitem`, CONSTRAINT `c_httpstepitem_1` FOREIGN KEY (`httpstepid`) REFERENCES `httpstep` (`httpstepid`) ON DELETE CASCADE) [update httpstepitem set httpstepid=100100000000019,itemid=100100000024855,type=2 where httpstepitemid=100100000000088; update httpstepitem set httpstepid=100100000000019,itemid=100100000024856,type=1 where httpstepitemid=100100000000089; update httpstepitem set httpstepid=100100000000019,itemid=100100000024857,type=0 where httpstepitemid=100100000000090; update httpstepitem set httpstepid=100100000000020,itemid=100100000024861,type=2 where httpstepitemid=100100000000091; update httpstepitem set httpstepid=100100000000020,itemid=100100000024862,type=1 where httpstepitemid=100100000000092; update httpstepitem set httpstepid=100100000000020,itemid=100100000024863,type=0 where httpstepitemid=100100000000093; update httpstepitem set httpstepid=100100000000022,itemid=100100000024873,type=2 where httpstepitemid=100100000000097; update httpstepitem set httpstepid=100100000000022,itemid=100100000024874,type=1 where httpstepitemid=100100000000098; update httpstepitem set httpstepid=100100000000022,itemid=100100000024875,type=0 where httpstepitemid=100100000000099; insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000100,100100000000023,100100000024879,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000101,100100000000023,100100000024880,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000102,100100000000023,100100000024881,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000103,100100000000024,100100000024885,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000104,100100000000024,100100000024886,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000105,100100000000024,100100000024887,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000106,100100000000025,100100000024891,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000107,100100000000025,100100000024892,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000108,100100000000025,100100000024893,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000109,100100000000026,100100000024897,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000110,100100000000026,100100000024898,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000111,100100000000026,100100000024899,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000112,100100000000027,100100000024903,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000113,100100000000027,100100000024904,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000114,100100000000027,100100000024905,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000115,100100000000028,100100000024906,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000116,100100000000028,100100000024907,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000117,100100000000028,100100000024908,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000118,100100000000029,100100000024912,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000119,100100000000029,100100000024913,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000120,100100000000029,100100000024914,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000121,100100000000030,100100000024927,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000122,100100000000030,100100000024928,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000123,100100000000030,100100000024929,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000124,100100000000031,100100000024933,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000125,100100000000031,100100000024934,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000126,100100000000031,100100000024935,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000127,100100000000032,100100000024939,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000128,100100000000032,100100000024940,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000129,100100000000032,100100000024941,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000130,100100000000033,100100000024942,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000131,100100000000033,100100000024943,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000132,100100000000033,100100000024944,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000133,100100000000034,100100000025241,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000134,100100000000034,100100000025242,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000135,100100000000034,100100000025243,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000136,100100000000035,100100000025244,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000137,100100000000035,100100000025245,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000138,100100000000035,100100000025246,0); ] 12625:20120821:122313.257 IPMI item [Fan_1A] on host [server03] failed: first network error, wait for 15 seconds 12625:20120821:122330.281 IPMI item [Serverboard_Temp] on host [server15] failed: first network error, wait for 15 seconds 12623:20120821:122340.269 IPMI item [Fan_2B] on host [server12] failed: first network error, wait for 15 seconds 12604:20120821:122345.455 resuming IPMI checks on host [server03]: connection restored 12604:20120821:122352.975 resuming IPMI checks on host [server15]: connection restored 12604:20120821:122401.514 resuming IPMI checks on host [server12]: connection restored 12623:20120821:122826.504 IPMI item [Fan_3A] on host [server15] failed: first network error, wait for 15 seconds 12622:20120821:122829.603 IPMI item [Serverboard_Temp] on host [server03] failed: first network error, wait for 15 seconds 12604:20120821:122848.983 resuming IPMI checks on host [server15]: connection restored 12604:20120821:122906.641 resuming IPMI checks on host [server03]: connection restored 12622:20120821:123314.040 IPMI item [Fan_1B] on host [server03] failed: first network error, wait for 15 seconds 12621:20120821:123339.836 IPMI item [Fan_2B] on host [server12] failed: first network error, wait for 15 seconds 12623:20120821:123344.920 IPMI item [Fan_2A] on host [server12] failed: another network error, wait for 15 seconds 12604:20120821:123348.572 resuming IPMI checks on host [server03]: connection restored 12604:20120821:123406.902 resuming IPMI checks on host [server12]: connection restored 12621:20120821:123825.219 IPMI item [Fan_1A] on host [server15] failed: first network error, wait for 15 seconds 12604:20120821:123847.116 resuming IPMI checks on host [server15]: connection restored 12622:20120821:124320.618 IPMI item [Fan_1B] on host [server03] failed: first network error, wait for 15 seconds 12625:20120821:124321.965 IPMI item [Fan_2A] on host [server03] failed: another network error, wait for 15 seconds 12622:20120821:124329.905 IPMI item [Serverboard_Temp] on host [server15] failed: first network error, wait for 15 seconds 12625:20120821:124339.791 IPMI item [Fan_2A] on host [server12] failed: first network error, wait for 15 seconds 12604:20120821:124351.047 resuming IPMI checks on host [server03]: connection restored 12604:20120821:124358.653 resuming IPMI checks on host [server15]: connection restored 12604:20120821:124405.932 resuming IPMI checks on host [server12]: connection restored 12621:20120821:124829.476 IPMI item [Serverboard_Temp] on host [server03] failed: first network error, wait for 15 seconds 12604:20120821:124900.952 resuming IPMI checks on host [server03]: connection restored 12623:20120821:125829.205 IPMI item [Serverboard_Temp] on host [server03] failed: first network error, wait for 15 seconds 12624:20120821:125834.084 IPMI item [Fan_4A] on host [server15] failed: first network error, wait for 15 seconds 12624:20120821:125846.498 IPMI item [Serverboard_Temp] on host [server12] failed: first network error, wait for 15 seconds 12604:20120821:125902.286 resuming IPMI checks on host [server03]: connection restored 12604:20120821:125928.174 resuming IPMI checks on host [server15]: connection restored 12604:20120821:125949.620 resuming IPMI checks on host [server12]: connection restored 12624:20120821:130829.544 IPMI item [Serverboard_Temp] on host [server03] failed: first network error, wait for 15 seconds 12623:20120821:130830.985 IPMI item [Fan_1A] on host [server15] failed: first network error, wait for 15 seconds 12604:20120821:130901.873 resuming IPMI checks on host [server03]: connection restored 12604:20120821:130909.684 resuming IPMI checks on host [server15]: connection restored 12623:20120821:131313.463 IPMI item [Fan_1A] on host [server03] failed: first network error, wait for 15 seconds 12622:20120821:131335.301 IPMI item [Serverboard_Temp] on host [server15] failed: first network error, wait for 15 seconds 12604:20120821:131345.023 resuming IPMI checks on host [server03]: connection restored 12621:20120821:131345.812 IPMI item [Fan_2B] on host [server12] failed: first network error, wait for 15 seconds 12604:20120821:131357.650 resuming IPMI checks on host [server15]: connection restored 12604:20120821:131440.213 resuming IPMI checks on host [server12]: connection restored 12621:20120821:131827.993 IPMI item [Fan_4A] on host [server15] failed: first network error, wait for 15 seconds 12604:20120821:131920.464 resuming IPMI checks on host [server15]: connection restored 12611:20120821:132108.712 Executing housekeeper 12611:20120821:132115.564 Deleted 17258 records from history [6.531696 seconds] 12587:20120821:132250.780 Received configuration data from server. Datalen 213145 12587:20120821:132252.891 [Z3005] query failed: [1062] Duplicate entry '100100000010053-' for key 'applications_2' [update applications set hostid=100100000010053 where applicationid=100100000000463; insert into applications (applicationid,hostid) values (100100000000665,100100000010053); ] 12587:20120821:132252.926 [Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`zabbix_proxy`.`httptest`, CONSTRAINT `c_httptest_1` FOREIGN KEY (`applicationid`) REFERENCES `applications` (`applicationid`) ON DELETE CASCADE) [update httptest set name='Cinema München',applicationid=100100000000463,delay=300,macros='',agent='gigatec Monitoring',authentication=0,http_user='',http_password='' where httptestid=100100000000010; update httptest set name='Wissenswertes',applicationid=100100000000463,delay=300,macros='',agent='gigatec Monitoring',authentication=0,http_user='',http_password='' where httptestid=100100000000011; update httptest set name='Roncalli Kolleg',applicationid=100100000000463,delay=300,macros='',agent='gigatec Monitoring',authentication=0,http_user='',http_password='' where httptestid=100100000000013; insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000014,'Folien Gigant',100100000000665,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000015,'LED Gigant',100100000000665,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000016,'gigatec GmbH',100100000000463,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000017,'Erlebniswelt Fliegenfischen',100100000000463,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000018,'Whatsyourplace',100100000000463,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000019,'Elast',100100000000463,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000020,'Hardenberg-Gymnasium',100100000000463,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000021,'Paca Coaching',100100000000463,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000022,'Förderverein HGF',100100000000463,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000023,'SteckerChecker',100100000000463,300,'','gigatec Monitoring',0,'',''); ] 12587:20120821:132252.965 [Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`zabbix_proxy`.`httptestitem`, CONSTRAINT `c_httptestitem_1` FOREIGN KEY (`httptestid`) REFERENCES `httptest` (`httptestid`) ON DELETE CASCADE) [update httptestitem set httptestid=100100000000010,itemid=100100000024852,type=2 where httptestitemid=100100000000003; update httptestitem set httptestid=100100000000010,itemid=100100000024853,type=3 where httptestitemid=100100000000004; update httptestitem set httptestid=100100000000010,itemid=100100000024854,type=4 where httptestitemid=100100000000005; update httptestitem set httptestid=100100000000011,itemid=100100000024858,type=2 where httptestitemid=100100000000006; update httptestitem set httptestid=100100000000011,itemid=100100000024859,type=3 where httptestitemid=100100000000007; update httptestitem set httptestid=100100000000011,itemid=100100000024860,type=4 where httptestitemid=100100000000008; update httptestitem set httptestid=100100000000013,itemid=100100000024870,type=2 where httptestitemid=100100000000012; update httptestitem set httptestid=100100000000013,itemid=100100000024871,type=3 where httptestitemid=100100000000013; update httptestitem set httptestid=100100000000013,itemid=100100000024872,type=4 where httptestitemid=100100000000014; insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000015,100100000000014,100100000024876,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000016,100100000000014,100100000024877,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000017,100100000000014,100100000024878,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000018,100100000000015,100100000024882,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000019,100100000000015,100100000024883,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000020,100100000000015,100100000024884,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000021,100100000000016,100100000024888,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000022,100100000000016,100100000024889,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000023,100100000000016,100100000024890,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000024,100100000000017,100100000024894,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000025,100100000000017,100100000024895,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000026,100100000000017,100100000024896,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000027,100100000000018,100100000024900,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000028,100100000000018,100100000024901,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000029,100100000000018,100100000024902,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000030,100100000000019,100100000024909,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000031,100100000000019,100100000024910,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000032,100100000000019,100100000024911,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000033,100100000000020,100100000024924,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000034,100100000000020,100100000024925,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000035,100100000000020,100100000024926,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000036,100100000000021,100100000024930,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000037,100100000000021,100100000024931,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000038,100100000000021,100100000024932,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000039,100100000000022,100100000024936,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000040,100100000000022,100100000024937,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000041,100100000000022,100100000024938,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000042,100100000000023,100100000025238,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000043,100100000000023,100100000025239,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000044,100100000000023,100100000025240,4); ] 12587:20120821:132252.992 [Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`zabbix_proxy`.`httpstep`, CONSTRAINT `c_httpstep_1` FOREIGN KEY (`httptestid`) REFERENCES `httptest` (`httptestid`) ON DELETE CASCADE) [update httpstep set httptestid=100100000000010,name='Cinema München',no=1,url='http://www.cinema-muenchen.de/',timeout=15,posts='',required='Impressum',status_codes='200' where httpstepid=100100000000019; update httpstep set httptestid=100100000000011,name='Startseite',no=1,url='http://www.wissenswertes.biz',timeout=15,posts='',required='Copyright',status_codes='200' where httpstepid=100100000000020; update httpstep set httptestid=100100000000013,name='Roncalli Kolleg',no=1,url='http://www.roncalli-kolleg.de/',timeout=15,posts='',required='Kosten',status_codes='200' where httpstepid=100100000000022; insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000023,100100000000014,'Startseite DE',1,'http://www.folien-gigant.de/',15,'','Impressum','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000024,100100000000015,'Startseite DE',1,'http://www.led-gigant.de/',15,'','Impressum','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000025,100100000000016,'gigatec GmbH',1,'http://www.gigatec.de/',15,'','Impressum','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000026,100100000000017,'Startseite DE',1,'http://www.erlebniswelt-fliegenfischen.de/',15,'','Copyright','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000027,100100000000018,'Startseite DE',1,'http://www.whatsyourplace.de/de/',15,'','Außerdem','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000028,100100000000018,'WYP - Erlebnisse',2,'http://www.whatsyourplace.de/de/events/search',15,'','Copyright','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000029,100100000000019,'Startseite DE',1,'http://www.elast.de/',15,'','Copyright','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000030,100100000000020,'Startseite DE',1,'http://www.hardenberg-gymnasium.de/index.php/startseite-top',15,'','Hosting','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000031,100100000000021,'Paca Coaching',1,'http://paca-coaching.de/',15,'','Outdoor-Training','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000032,100100000000022,'Startseite DE',1,'http://www.foerderverein-hgf.de/',15,'','Valid','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000033,100100000000011,'Customer Login',2,'https://secure.wissenswertes.biz/customer/account/login/',15,'','vergessen','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000034,100100000000023,'Startseite DE',1,'http://www.steckerchecker.de',15,'','Atrada','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000035,100100000000023,'Startseite EN',2,'http://www.steckerchecker.com',15,'','Atrada','200'); ] 12587:20120821:132253.070 [Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`zabbix_proxy`.`httpstepitem`, CONSTRAINT `c_httpstepitem_1` FOREIGN KEY (`httpstepid`) REFERENCES `httpstep` (`httpstepid`) ON DELETE CASCADE) [update httpstepitem set httpstepid=100100000000019,itemid=100100000024855,type=2 where httpstepitemid=100100000000088; update httpstepitem set httpstepid=100100000000019,itemid=100100000024856,type=1 where httpstepitemid=100100000000089; update httpstepitem set httpstepid=100100000000019,itemid=100100000024857,type=0 where httpstepitemid=100100000000090; update httpstepitem set httpstepid=100100000000020,itemid=100100000024861,type=2 where httpstepitemid=100100000000091; update httpstepitem set httpstepid=100100000000020,itemid=100100000024862,type=1 where httpstepitemid=100100000000092; update httpstepitem set httpstepid=100100000000020,itemid=100100000024863,type=0 where httpstepitemid=100100000000093; update httpstepitem set httpstepid=100100000000022,itemid=100100000024873,type=2 where httpstepitemid=100100000000097; update httpstepitem set httpstepid=100100000000022,itemid=100100000024874,type=1 where httpstepitemid=100100000000098; update httpstepitem set httpstepid=100100000000022,itemid=100100000024875,type=0 where httpstepitemid=100100000000099; insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000100,100100000000023,100100000024879,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000101,100100000000023,100100000024880,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000102,100100000000023,100100000024881,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000103,100100000000024,100100000024885,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000104,100100000000024,100100000024886,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000105,100100000000024,100100000024887,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000106,100100000000025,100100000024891,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000107,100100000000025,100100000024892,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000108,100100000000025,100100000024893,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000109,100100000000026,100100000024897,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000110,100100000000026,100100000024898,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000111,100100000000026,100100000024899,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000112,100100000000027,100100000024903,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000113,100100000000027,100100000024904,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000114,100100000000027,100100000024905,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000115,100100000000028,100100000024906,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000116,100100000000028,100100000024907,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000117,100100000000028,100100000024908,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000118,100100000000029,100100000024912,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000119,100100000000029,100100000024913,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000120,100100000000029,100100000024914,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000121,100100000000030,100100000024927,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000122,100100000000030,100100000024928,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000123,100100000000030,100100000024929,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000124,100100000000031,100100000024933,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000125,100100000000031,100100000024934,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000126,100100000000031,100100000024935,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000127,100100000000032,100100000024939,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000128,100100000000032,100100000024940,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000129,100100000000032,100100000024941,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000130,100100000000033,100100000024942,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000131,100100000000033,100100000024943,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000132,100100000000033,100100000024944,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000133,100100000000034,100100000025241,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000134,100100000000034,100100000025242,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000135,100100000000034,100100000025243,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000136,100100000000035,100100000025244,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000137,100100000000035,100100000025245,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000138,100100000000035,100100000025246,0); ] 12624:20120821:132320.168 IPMI item [Fan_1B] on host [server03] failed: first network error, wait for 15 seconds 12604:20120821:132352.812 resuming IPMI checks on host [server03]: connection restored 12624:20120821:133322.914 IPMI item [Fan_2B] on host [server03] failed: first network error, wait for 15 seconds 12624:20120821:133330.205 IPMI item [Serverboard_Temp] on host [server15] failed: first network error, wait for 15 seconds 12604:20120821:133354.144 resuming IPMI checks on host [server03]: connection restored 12604:20120821:133401.752 resuming IPMI checks on host [server15]: connection restored 12624:20120821:134320.145 IPMI item [Fan_1A] on host [server03] failed: first network error, wait for 15 seconds 12624:20120821:134329.476 IPMI item [Serverboard_Temp] on host [server15] failed: first network error, wait for 15 seconds 12604:20120821:134350.450 resuming IPMI checks on host [server03]: connection restored 12604:20120821:134358.288 resuming IPMI checks on host [server15]: connection restored 12625:20120821:134829.414 IPMI item [Serverboard_Temp] on host [server03] failed: first network error, wait for 15 seconds 12604:20120821:134902.773 resuming IPMI checks on host [server03]: connection restored 12624:20120821:135829.336 IPMI item [Serverboard_Temp] on host [server03] failed: first network error, wait for 15 seconds 12621:20120821:135834.361 IPMI item [Fan_4A] on host [server15] failed: first network error, wait for 15 seconds 12621:20120821:135847.188 IPMI item [Serverboard_Temp] on host [server12] failed: first network error, wait for 15 seconds 12604:20120821:135900.839 resuming IPMI checks on host [server03]: connection restored 12604:20120821:135909.404 resuming IPMI checks on host [server15]: connection restored 12604:20120821:135916.617 resuming IPMI checks on host [server12]: connection restored 12621:20120821:140829.276 IPMI item [Serverboard_Temp] on host [server03] failed: first network error, wait for 15 seconds 12624:20120821:140830.552 IPMI item [Fan_1A] on host [server15] failed: first network error, wait for 15 seconds 12624:20120821:140846.645 IPMI item [Serverboard_Temp] on host [server12] failed: first network error, wait for 15 seconds 12604:20120821:140902.798 resuming IPMI checks on host [server03]: connection restored 12604:20120821:140910.917 resuming IPMI checks on host [server15]: connection restored 12604:20120821:140918.104 resuming IPMI checks on host [server12]: connection restored 12625:20120821:141829.148 IPMI item [Serverboard_Temp] on host [server03] failed: first network error, wait for 15 seconds 12621:20120821:141830.705 IPMI item [Fan_1A] on host [server15] failed: first network error, wait for 15 seconds 12604:20120821:141901.872 resuming IPMI checks on host [server03]: connection restored 12604:20120821:141909.531 resuming IPMI checks on host [server15]: connection restored 12611:20120821:142108.795 Executing housekeeper 12611:20120821:142116.969 Deleted 17251 records from history [7.479843 seconds] 12587:20120821:142254.331 Received configuration data from server. Datalen 213145 12587:20120821:142255.250 [Z3005] query failed: [1062] Duplicate entry '100100000010053-' for key 'applications_2' [update applications set hostid=100100000010053 where applicationid=100100000000463; insert into applications (applicationid,hostid) values (100100000000665,100100000010053); ] 12587:20120821:142255.293 [Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`zabbix_proxy`.`httptest`, CONSTRAINT `c_httptest_1` FOREIGN KEY (`applicationid`) REFERENCES `applications` (`applicationid`) ON DELETE CASCADE) [update httptest set name='Cinema München',applicationid=100100000000463,delay=300,macros='',agent='gigatec Monitoring',authentication=0,http_user='',http_password='' where httptestid=100100000000010; update httptest set name='Wissenswertes',applicationid=100100000000463,delay=300,macros='',agent='gigatec Monitoring',authentication=0,http_user='',http_password='' where httptestid=100100000000011; update httptest set name='Roncalli Kolleg',applicationid=100100000000463,delay=300,macros='',agent='gigatec Monitoring',authentication=0,http_user='',http_password='' where httptestid=100100000000013; insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000014,'Folien Gigant',100100000000665,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000015,'LED Gigant',100100000000665,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000016,'gigatec GmbH',100100000000463,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000017,'Erlebniswelt Fliegenfischen',100100000000463,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000018,'Whatsyourplace',100100000000463,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000019,'Elast',100100000000463,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000020,'Hardenberg-Gymnasium',100100000000463,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000021,'Paca Coaching',100100000000463,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000022,'Förderverein HGF',100100000000463,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000023,'SteckerChecker',100100000000463,300,'','gigatec Monitoring',0,'',''); ] 12587:20120821:142255.311 [Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`zabbix_proxy`.`httptestitem`, CONSTRAINT `c_httptestitem_1` FOREIGN KEY (`httptestid`) REFERENCES `httptest` (`httptestid`) ON DELETE CASCADE) [update httptestitem set httptestid=100100000000010,itemid=100100000024852,type=2 where httptestitemid=100100000000003; update httptestitem set httptestid=100100000000010,itemid=100100000024853,type=3 where httptestitemid=100100000000004; update httptestitem set httptestid=100100000000010,itemid=100100000024854,type=4 where httptestitemid=100100000000005; update httptestitem set httptestid=100100000000011,itemid=100100000024858,type=2 where httptestitemid=100100000000006; update httptestitem set httptestid=100100000000011,itemid=100100000024859,type=3 where httptestitemid=100100000000007; update httptestitem set httptestid=100100000000011,itemid=100100000024860,type=4 where httptestitemid=100100000000008; update httptestitem set httptestid=100100000000013,itemid=100100000024870,type=2 where httptestitemid=100100000000012; update httptestitem set httptestid=100100000000013,itemid=100100000024871,type=3 where httptestitemid=100100000000013; update httptestitem set httptestid=100100000000013,itemid=100100000024872,type=4 where httptestitemid=100100000000014; insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000015,100100000000014,100100000024876,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000016,100100000000014,100100000024877,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000017,100100000000014,100100000024878,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000018,100100000000015,100100000024882,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000019,100100000000015,100100000024883,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000020,100100000000015,100100000024884,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000021,100100000000016,100100000024888,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000022,100100000000016,100100000024889,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000023,100100000000016,100100000024890,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000024,100100000000017,100100000024894,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000025,100100000000017,100100000024895,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000026,100100000000017,100100000024896,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000027,100100000000018,100100000024900,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000028,100100000000018,100100000024901,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000029,100100000000018,100100000024902,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000030,100100000000019,100100000024909,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000031,100100000000019,100100000024910,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000032,100100000000019,100100000024911,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000033,100100000000020,100100000024924,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000034,100100000000020,100100000024925,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000035,100100000000020,100100000024926,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000036,100100000000021,100100000024930,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000037,100100000000021,100100000024931,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000038,100100000000021,100100000024932,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000039,100100000000022,100100000024936,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000040,100100000000022,100100000024937,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000041,100100000000022,100100000024938,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000042,100100000000023,100100000025238,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000043,100100000000023,100100000025239,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000044,100100000000023,100100000025240,4); ] 12587:20120821:142255.332 [Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`zabbix_proxy`.`httpstep`, CONSTRAINT `c_httpstep_1` FOREIGN KEY (`httptestid`) REFERENCES `httptest` (`httptestid`) ON DELETE CASCADE) [update httpstep set httptestid=100100000000010,name='Cinema München',no=1,url='http://www.cinema-muenchen.de/',timeout=15,posts='',required='Impressum',status_codes='200' where httpstepid=100100000000019; update httpstep set httptestid=100100000000011,name='Startseite',no=1,url='http://www.wissenswertes.biz',timeout=15,posts='',required='Copyright',status_codes='200' where httpstepid=100100000000020; update httpstep set httptestid=100100000000013,name='Roncalli Kolleg',no=1,url='http://www.roncalli-kolleg.de/',timeout=15,posts='',required='Kosten',status_codes='200' where httpstepid=100100000000022; insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000023,100100000000014,'Startseite DE',1,'http://www.folien-gigant.de/',15,'','Impressum','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000024,100100000000015,'Startseite DE',1,'http://www.led-gigant.de/',15,'','Impressum','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000025,100100000000016,'gigatec GmbH',1,'http://www.gigatec.de/',15,'','Impressum','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000026,100100000000017,'Startseite DE',1,'http://www.erlebniswelt-fliegenfischen.de/',15,'','Copyright','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000027,100100000000018,'Startseite DE',1,'http://www.whatsyourplace.de/de/',15,'','Außerdem','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000028,100100000000018,'WYP - Erlebnisse',2,'http://www.whatsyourplace.de/de/events/search',15,'','Copyright','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000029,100100000000019,'Startseite DE',1,'http://www.elast.de/',15,'','Copyright','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000030,100100000000020,'Startseite DE',1,'http://www.hardenberg-gymnasium.de/index.php/startseite-top',15,'','Hosting','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000031,100100000000021,'Paca Coaching',1,'http://paca-coaching.de/',15,'','Outdoor-Training','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000032,100100000000022,'Startseite DE',1,'http://www.foerderverein-hgf.de/',15,'','Valid','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000033,100100000000011,'Customer Login',2,'https://secure.wissenswertes.biz/customer/account/login/',15,'','vergessen','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000034,100100000000023,'Startseite DE',1,'http://www.steckerchecker.de',15,'','Atrada','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000035,100100000000023,'Startseite EN',2,'http://www.steckerchecker.com',15,'','Atrada','200'); ] 12587:20120821:142255.334 [Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`zabbix_proxy`.`httpstepitem`, CONSTRAINT `c_httpstepitem_1` FOREIGN KEY (`httpstepid`) REFERENCES `httpstep` (`httpstepid`) ON DELETE CASCADE) [update httpstepitem set httpstepid=100100000000019,itemid=100100000024855,type=2 where httpstepitemid=100100000000088; update httpstepitem set httpstepid=100100000000019,itemid=100100000024856,type=1 where httpstepitemid=100100000000089; update httpstepitem set httpstepid=100100000000019,itemid=100100000024857,type=0 where httpstepitemid=100100000000090; update httpstepitem set httpstepid=100100000000020,itemid=100100000024861,type=2 where httpstepitemid=100100000000091; update httpstepitem set httpstepid=100100000000020,itemid=100100000024862,type=1 where httpstepitemid=100100000000092; update httpstepitem set httpstepid=100100000000020,itemid=100100000024863,type=0 where httpstepitemid=100100000000093; update httpstepitem set httpstepid=100100000000022,itemid=100100000024873,type=2 where httpstepitemid=100100000000097; update httpstepitem set httpstepid=100100000000022,itemid=100100000024874,type=1 where httpstepitemid=100100000000098; update httpstepitem set httpstepid=100100000000022,itemid=100100000024875,type=0 where httpstepitemid=100100000000099; insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000100,100100000000023,100100000024879,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000101,100100000000023,100100000024880,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000102,100100000000023,100100000024881,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000103,100100000000024,100100000024885,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000104,100100000000024,100100000024886,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000105,100100000000024,100100000024887,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000106,100100000000025,100100000024891,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000107,100100000000025,100100000024892,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000108,100100000000025,100100000024893,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000109,100100000000026,100100000024897,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000110,100100000000026,100100000024898,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000111,100100000000026,100100000024899,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000112,100100000000027,100100000024903,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000113,100100000000027,100100000024904,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000114,100100000000027,100100000024905,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000115,100100000000028,100100000024906,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000116,100100000000028,100100000024907,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000117,100100000000028,100100000024908,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000118,100100000000029,100100000024912,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000119,100100000000029,100100000024913,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000120,100100000000029,100100000024914,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000121,100100000000030,100100000024927,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000122,100100000000030,100100000024928,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000123,100100000000030,100100000024929,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000124,100100000000031,100100000024933,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000125,100100000000031,100100000024934,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000126,100100000000031,100100000024935,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000127,100100000000032,100100000024939,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000128,100100000000032,100100000024940,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000129,100100000000032,100100000024941,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000130,100100000000033,100100000024942,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000131,100100000000033,100100000024943,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000132,100100000000033,100100000024944,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000133,100100000000034,100100000025241,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000134,100100000000034,100100000025242,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000135,100100000000034,100100000025243,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000136,100100000000035,100100000025244,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000137,100100000000035,100100000025245,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000138,100100000000035,100100000025246,0); ] 12621:20120821:142318.176 IPMI item [Fan_3A] on host [server03] failed: first network error, wait for 15 seconds 12604:20120821:142347.696 resuming IPMI checks on host [server03]: connection restored 12623:20120821:142829.686 IPMI item [Serverboard_Temp] on host [server03] failed: first network error, wait for 15 seconds 12621:20120821:142832.732 IPMI item [Fan_3A] on host [server15] failed: first network error, wait for 15 seconds 12621:20120821:142846.959 IPMI item [Serverboard_Temp] on host [server12] failed: first network error, wait for 15 seconds 12604:20120821:142903.164 resuming IPMI checks on host [server03]: connection restored 12604:20120821:142938.016 resuming IPMI checks on host [server15]: connection restored 12604:20120821:142945.465 resuming IPMI checks on host [server12]: connection restored 12623:20120821:143829.378 IPMI item [Serverboard_Temp] on host [server03] failed: first network error, wait for 15 seconds 12624:20120821:143833.887 IPMI item [Fan_4A] on host [server15] failed: first network error, wait for 15 seconds 12604:20120821:143903.164 resuming IPMI checks on host [server03]: connection restored 12604:20120821:143935.192 resuming IPMI checks on host [server15]: connection restored 12624:20120821:144318.191 IPMI item [Fan_3A] on host [server03] failed: first network error, wait for 15 seconds 12604:20120821:144348.640 resuming IPMI checks on host [server03]: connection restored 12625:20120821:144829.405 IPMI item [Serverboard_Temp] on host [server03] failed: first network error, wait for 15 seconds 12624:20120821:144830.500 IPMI item [Fan_1A] on host [server15] failed: first network error, wait for 15 seconds 12604:20120821:144901.383 resuming IPMI checks on host [server03]: connection restored 12604:20120821:144909.966 resuming IPMI checks on host [server15]: connection restored 12623:20120821:145829.467 IPMI item [Serverboard_Temp] on host [server03] failed: first network error, wait for 15 seconds 12623:20120821:145830.753 IPMI item [Fan_5A] on host [server15] failed: first network error, wait for 15 seconds 12604:20120821:145902.087 resuming IPMI checks on host [server03]: connection restored 12604:20120821:145927.047 resuming IPMI checks on host [server15]: connection restored 12623:20120821:150316.041 IPMI item [Fan_2A] on host [server03] failed: first network error, wait for 15 seconds 12604:20120821:150414.346 resuming IPMI checks on host [server03]: connection restored 12623:20120821:151324.517 IPMI item [Fan_3A] on host [server03] failed: first network error, wait for 15 seconds 12604:20120821:151352.425 resuming IPMI checks on host [server03]: connection restored 12624:20120821:151829.290 IPMI item [Serverboard_Temp] on host [server03] failed: first network error, wait for 15 seconds 12623:20120821:151831.435 IPMI item [Fan_2A] on host [server15] failed: first network error, wait for 15 seconds 12623:20120821:151846.677 IPMI item [Serverboard_Temp] on host [server12] failed: first network error, wait for 15 seconds 12604:20120821:151902.003 resuming IPMI checks on host [server03]: connection restored 12604:20120821:151909.738 resuming IPMI checks on host [server15]: connection restored 12604:20120821:151917.023 resuming IPMI checks on host [server12]: connection restored 12611:20120821:152109.195 Executing housekeeper 12611:20120821:152117.249 Deleted 17258 records from history [8.053394 seconds] 12587:20120821:152256.452 Received configuration data from server. Datalen 213145 12587:20120821:152257.130 [Z3005] query failed: [1062] Duplicate entry '100100000010053-' for key 'applications_2' [update applications set hostid=100100000010053 where applicationid=100100000000463; insert into applications (applicationid,hostid) values (100100000000665,100100000010053); ] 12587:20120821:152257.167 [Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`zabbix_proxy`.`httptest`, CONSTRAINT `c_httptest_1` FOREIGN KEY (`applicationid`) REFERENCES `applications` (`applicationid`) ON DELETE CASCADE) [update httptest set name='Cinema München',applicationid=100100000000463,delay=300,macros='',agent='gigatec Monitoring',authentication=0,http_user='',http_password='' where httptestid=100100000000010; update httptest set name='Wissenswertes',applicationid=100100000000463,delay=300,macros='',agent='gigatec Monitoring',authentication=0,http_user='',http_password='' where httptestid=100100000000011; update httptest set name='Roncalli Kolleg',applicationid=100100000000463,delay=300,macros='',agent='gigatec Monitoring',authentication=0,http_user='',http_password='' where httptestid=100100000000013; insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000014,'Folien Gigant',100100000000665,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000015,'LED Gigant',100100000000665,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000016,'gigatec GmbH',100100000000463,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000017,'Erlebniswelt Fliegenfischen',100100000000463,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000018,'Whatsyourplace',100100000000463,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000019,'Elast',100100000000463,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000020,'Hardenberg-Gymnasium',100100000000463,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000021,'Paca Coaching',100100000000463,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000022,'Förderverein HGF',100100000000463,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000023,'SteckerChecker',100100000000463,300,'','gigatec Monitoring',0,'',''); ] 12587:20120821:152257.178 [Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`zabbix_proxy`.`httptestitem`, CONSTRAINT `c_httptestitem_1` FOREIGN KEY (`httptestid`) REFERENCES `httptest` (`httptestid`) ON DELETE CASCADE) [update httptestitem set httptestid=100100000000010,itemid=100100000024852,type=2 where httptestitemid=100100000000003; update httptestitem set httptestid=100100000000010,itemid=100100000024853,type=3 where httptestitemid=100100000000004; update httptestitem set httptestid=100100000000010,itemid=100100000024854,type=4 where httptestitemid=100100000000005; update httptestitem set httptestid=100100000000011,itemid=100100000024858,type=2 where httptestitemid=100100000000006; update httptestitem set httptestid=100100000000011,itemid=100100000024859,type=3 where httptestitemid=100100000000007; update httptestitem set httptestid=100100000000011,itemid=100100000024860,type=4 where httptestitemid=100100000000008; update httptestitem set httptestid=100100000000013,itemid=100100000024870,type=2 where httptestitemid=100100000000012; update httptestitem set httptestid=100100000000013,itemid=100100000024871,type=3 where httptestitemid=100100000000013; update httptestitem set httptestid=100100000000013,itemid=100100000024872,type=4 where httptestitemid=100100000000014; insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000015,100100000000014,100100000024876,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000016,100100000000014,100100000024877,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000017,100100000000014,100100000024878,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000018,100100000000015,100100000024882,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000019,100100000000015,100100000024883,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000020,100100000000015,100100000024884,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000021,100100000000016,100100000024888,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000022,100100000000016,100100000024889,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000023,100100000000016,100100000024890,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000024,100100000000017,100100000024894,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000025,100100000000017,100100000024895,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000026,100100000000017,100100000024896,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000027,100100000000018,100100000024900,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000028,100100000000018,100100000024901,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000029,100100000000018,100100000024902,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000030,100100000000019,100100000024909,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000031,100100000000019,100100000024910,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000032,100100000000019,100100000024911,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000033,100100000000020,100100000024924,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000034,100100000000020,100100000024925,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000035,100100000000020,100100000024926,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000036,100100000000021,100100000024930,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000037,100100000000021,100100000024931,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000038,100100000000021,100100000024932,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000039,100100000000022,100100000024936,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000040,100100000000022,100100000024937,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000041,100100000000022,100100000024938,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000042,100100000000023,100100000025238,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000043,100100000000023,100100000025239,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000044,100100000000023,100100000025240,4); ] 12587:20120821:152257.200 [Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`zabbix_proxy`.`httpstep`, CONSTRAINT `c_httpstep_1` FOREIGN KEY (`httptestid`) REFERENCES `httptest` (`httptestid`) ON DELETE CASCADE) [update httpstep set httptestid=100100000000010,name='Cinema München',no=1,url='http://www.cinema-muenchen.de/',timeout=15,posts='',required='Impressum',status_codes='200' where httpstepid=100100000000019; update httpstep set httptestid=100100000000011,name='Startseite',no=1,url='http://www.wissenswertes.biz',timeout=15,posts='',required='Copyright',status_codes='200' where httpstepid=100100000000020; update httpstep set httptestid=100100000000013,name='Roncalli Kolleg',no=1,url='http://www.roncalli-kolleg.de/',timeout=15,posts='',required='Kosten',status_codes='200' where httpstepid=100100000000022; insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000023,100100000000014,'Startseite DE',1,'http://www.folien-gigant.de/',15,'','Impressum','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000024,100100000000015,'Startseite DE',1,'http://www.led-gigant.de/',15,'','Impressum','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000025,100100000000016,'gigatec GmbH',1,'http://www.gigatec.de/',15,'','Impressum','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000026,100100000000017,'Startseite DE',1,'http://www.erlebniswelt-fliegenfischen.de/',15,'','Copyright','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000027,100100000000018,'Startseite DE',1,'http://www.whatsyourplace.de/de/',15,'','Außerdem','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000028,100100000000018,'WYP - Erlebnisse',2,'http://www.whatsyourplace.de/de/events/search',15,'','Copyright','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000029,100100000000019,'Startseite DE',1,'http://www.elast.de/',15,'','Copyright','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000030,100100000000020,'Startseite DE',1,'http://www.hardenberg-gymnasium.de/index.php/startseite-top',15,'','Hosting','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000031,100100000000021,'Paca Coaching',1,'http://paca-coaching.de/',15,'','Outdoor-Training','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000032,100100000000022,'Startseite DE',1,'http://www.foerderverein-hgf.de/',15,'','Valid','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000033,100100000000011,'Customer Login',2,'https://secure.wissenswertes.biz/customer/account/login/',15,'','vergessen','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000034,100100000000023,'Startseite DE',1,'http://www.steckerchecker.de',15,'','Atrada','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000035,100100000000023,'Startseite EN',2,'http://www.steckerchecker.com',15,'','Atrada','200'); ] 12587:20120821:152257.209 [Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`zabbix_proxy`.`httpstepitem`, CONSTRAINT `c_httpstepitem_1` FOREIGN KEY (`httpstepid`) REFERENCES `httpstep` (`httpstepid`) ON DELETE CASCADE) [update httpstepitem set httpstepid=100100000000019,itemid=100100000024855,type=2 where httpstepitemid=100100000000088; update httpstepitem set httpstepid=100100000000019,itemid=100100000024856,type=1 where httpstepitemid=100100000000089; update httpstepitem set httpstepid=100100000000019,itemid=100100000024857,type=0 where httpstepitemid=100100000000090; update httpstepitem set httpstepid=100100000000020,itemid=100100000024861,type=2 where httpstepitemid=100100000000091; update httpstepitem set httpstepid=100100000000020,itemid=100100000024862,type=1 where httpstepitemid=100100000000092; update httpstepitem set httpstepid=100100000000020,itemid=100100000024863,type=0 where httpstepitemid=100100000000093; update httpstepitem set httpstepid=100100000000022,itemid=100100000024873,type=2 where httpstepitemid=100100000000097; update httpstepitem set httpstepid=100100000000022,itemid=100100000024874,type=1 where httpstepitemid=100100000000098; update httpstepitem set httpstepid=100100000000022,itemid=100100000024875,type=0 where httpstepitemid=100100000000099; insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000100,100100000000023,100100000024879,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000101,100100000000023,100100000024880,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000102,100100000000023,100100000024881,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000103,100100000000024,100100000024885,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000104,100100000000024,100100000024886,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000105,100100000000024,100100000024887,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000106,100100000000025,100100000024891,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000107,100100000000025,100100000024892,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000108,100100000000025,100100000024893,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000109,100100000000026,100100000024897,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000110,100100000000026,100100000024898,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000111,100100000000026,100100000024899,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000112,100100000000027,100100000024903,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000113,100100000000027,100100000024904,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000114,100100000000027,100100000024905,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000115,100100000000028,100100000024906,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000116,100100000000028,100100000024907,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000117,100100000000028,100100000024908,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000118,100100000000029,100100000024912,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000119,100100000000029,100100000024913,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000120,100100000000029,100100000024914,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000121,100100000000030,100100000024927,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000122,100100000000030,100100000024928,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000123,100100000000030,100100000024929,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000124,100100000000031,100100000024933,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000125,100100000000031,100100000024934,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000126,100100000000031,100100000024935,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000127,100100000000032,100100000024939,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000128,100100000000032,100100000024940,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000129,100100000000032,100100000024941,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000130,100100000000033,100100000024942,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000131,100100000000033,100100000024943,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000132,100100000000033,100100000024944,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000133,100100000000034,100100000025241,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000134,100100000000034,100100000025242,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000135,100100000000034,100100000025243,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000136,100100000000035,100100000025244,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000137,100100000000035,100100000025245,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000138,100100000000035,100100000025246,0); ] 12623:20120821:152829.445 IPMI item [Serverboard_Temp] on host [server03] failed: first network error, wait for 15 seconds 12624:20120821:152830.329 IPMI item [Fan_1A] on host [server15] failed: first network error, wait for 15 seconds 12604:20120821:152903.155 resuming IPMI checks on host [server03]: connection restored 12604:20120821:152948.352 resuming IPMI checks on host [server15]: connection restored 12624:20120821:153829.162 IPMI item [Serverboard_Temp] on host [server03] failed: first network error, wait for 15 seconds 12621:20120821:153831.837 IPMI item [Fan_2A] on host [server15] failed: first network error, wait for 15 seconds 12621:20120821:153847.033 IPMI item [Serverboard_Temp] on host [server12] failed: first network error, wait for 15 seconds 12604:20120821:153902.008 resuming IPMI checks on host [server03]: connection restored 12604:20120821:153909.948 resuming IPMI checks on host [server15]: connection restored 12604:20120821:153917.568 resuming IPMI checks on host [server12]: connection restored 12621:20120821:154829.372 IPMI item [Serverboard_Temp] on host [server03] failed: first network error, wait for 15 seconds 12624:20120821:154832.924 IPMI item [Fan_3A] on host [server15] failed: first network error, wait for 15 seconds 12604:20120821:154901.867 resuming IPMI checks on host [server03]: connection restored 12604:20120821:154910.464 resuming IPMI checks on host [server15]: connection restored 12624:20120821:155318.112 IPMI item [Fan_3A] on host [server03] failed: first network error, wait for 15 seconds 12604:20120821:155350.329 resuming IPMI checks on host [server03]: connection restored 12624:20120821:160323.854 IPMI item [Fan_3A] on host [server03] failed: first network error, wait for 15 seconds 12624:20120821:160329.892 IPMI item [Serverboard_Temp] on host [server15] failed: first network error, wait for 15 seconds 12604:20120821:160425.823 resuming IPMI checks on host [server03]: connection restored 12604:20120821:160433.376 resuming IPMI checks on host [server15]: connection restored 12621:20120821:160829.279 IPMI item [Serverboard_Temp] on host [server03] failed: first network error, wait for 15 seconds 12604:20120821:160901.553 resuming IPMI checks on host [server03]: connection restored 12603:20120821:161558.931 [Z3005] query failed: [2006] MySQL server has gone away [begin;] 12603:20120821:161559.329 Zabbix agent item [debian_updates[SYSTEM]] on host [server15] failed: first network error, wait for 15 seconds 12604:20120821:161613.634 resuming Zabbix agent checks on host [server15]: connection restored 12625:20120821:161829.221 IPMI item [Serverboard_Temp] on host [server03] failed: first network error, wait for 15 seconds 12624:20120821:161831.882 IPMI item [Fan_2A] on host [server15] failed: first network error, wait for 15 seconds 12604:20120821:161900.862 resuming IPMI checks on host [server03]: connection restored 12604:20120821:161940.128 resuming IPMI checks on host [server15]: connection restored 12611:20120821:162109.481 Executing housekeeper 12611:20120821:162114.419 Deleted 17273 records from history [4.937315 seconds] 12587:20120821:162258.593 Received configuration data from server. Datalen 213145 12587:20120821:162300.356 [Z3005] query failed: [1062] Duplicate entry '100100000010053-' for key 'applications_2' [update applications set hostid=100100000010053 where applicationid=100100000000463; insert into applications (applicationid,hostid) values (100100000000665,100100000010053); ] 12587:20120821:162300.669 [Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`zabbix_proxy`.`httptest`, CONSTRAINT `c_httptest_1` FOREIGN KEY (`applicationid`) REFERENCES `applications` (`applicationid`) ON DELETE CASCADE) [update httptest set name='Cinema München',applicationid=100100000000463,delay=300,macros='',agent='gigatec Monitoring',authentication=0,http_user='',http_password='' where httptestid=100100000000010; update httptest set name='Wissenswertes',applicationid=100100000000463,delay=300,macros='',agent='gigatec Monitoring',authentication=0,http_user='',http_password='' where httptestid=100100000000011; update httptest set name='Roncalli Kolleg',applicationid=100100000000463,delay=300,macros='',agent='gigatec Monitoring',authentication=0,http_user='',http_password='' where httptestid=100100000000013; insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000014,'Folien Gigant',100100000000665,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000015,'LED Gigant',100100000000665,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000016,'gigatec GmbH',100100000000463,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000017,'Erlebniswelt Fliegenfischen',100100000000463,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000018,'Whatsyourplace',100100000000463,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000019,'Elast',100100000000463,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000020,'Hardenberg-Gymnasium',100100000000463,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000021,'Paca Coaching',100100000000463,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000022,'Förderverein HGF',100100000000463,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000023,'SteckerChecker',100100000000463,300,'','gigatec Monitoring',0,'',''); ] 12587:20120821:162301.026 [Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`zabbix_proxy`.`httptestitem`, CONSTRAINT `c_httptestitem_1` FOREIGN KEY (`httptestid`) REFERENCES `httptest` (`httptestid`) ON DELETE CASCADE) [update httptestitem set httptestid=100100000000010,itemid=100100000024852,type=2 where httptestitemid=100100000000003; update httptestitem set httptestid=100100000000010,itemid=100100000024853,type=3 where httptestitemid=100100000000004; update httptestitem set httptestid=100100000000010,itemid=100100000024854,type=4 where httptestitemid=100100000000005; update httptestitem set httptestid=100100000000011,itemid=100100000024858,type=2 where httptestitemid=100100000000006; update httptestitem set httptestid=100100000000011,itemid=100100000024859,type=3 where httptestitemid=100100000000007; update httptestitem set httptestid=100100000000011,itemid=100100000024860,type=4 where httptestitemid=100100000000008; update httptestitem set httptestid=100100000000013,itemid=100100000024870,type=2 where httptestitemid=100100000000012; update httptestitem set httptestid=100100000000013,itemid=100100000024871,type=3 where httptestitemid=100100000000013; update httptestitem set httptestid=100100000000013,itemid=100100000024872,type=4 where httptestitemid=100100000000014; insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000015,100100000000014,100100000024876,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000016,100100000000014,100100000024877,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000017,100100000000014,100100000024878,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000018,100100000000015,100100000024882,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000019,100100000000015,100100000024883,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000020,100100000000015,100100000024884,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000021,100100000000016,100100000024888,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000022,100100000000016,100100000024889,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000023,100100000000016,100100000024890,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000024,100100000000017,100100000024894,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000025,100100000000017,100100000024895,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000026,100100000000017,100100000024896,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000027,100100000000018,100100000024900,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000028,100100000000018,100100000024901,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000029,100100000000018,100100000024902,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000030,100100000000019,100100000024909,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000031,100100000000019,100100000024910,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000032,100100000000019,100100000024911,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000033,100100000000020,100100000024924,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000034,100100000000020,100100000024925,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000035,100100000000020,100100000024926,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000036,100100000000021,100100000024930,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000037,100100000000021,100100000024931,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000038,100100000000021,100100000024932,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000039,100100000000022,100100000024936,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000040,100100000000022,100100000024937,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000041,100100000000022,100100000024938,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000042,100100000000023,100100000025238,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000043,100100000000023,100100000025239,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000044,100100000000023,100100000025240,4); ] 12587:20120821:162301.027 [Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`zabbix_proxy`.`httpstep`, CONSTRAINT `c_httpstep_1` FOREIGN KEY (`httptestid`) REFERENCES `httptest` (`httptestid`) ON DELETE CASCADE) [update httpstep set httptestid=100100000000010,name='Cinema München',no=1,url='http://www.cinema-muenchen.de/',timeout=15,posts='',required='Impressum',status_codes='200' where httpstepid=100100000000019; update httpstep set httptestid=100100000000011,name='Startseite',no=1,url='http://www.wissenswertes.biz',timeout=15,posts='',required='Copyright',status_codes='200' where httpstepid=100100000000020; update httpstep set httptestid=100100000000013,name='Roncalli Kolleg',no=1,url='http://www.roncalli-kolleg.de/',timeout=15,posts='',required='Kosten',status_codes='200' where httpstepid=100100000000022; insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000023,100100000000014,'Startseite DE',1,'http://www.folien-gigant.de/',15,'','Impressum','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000024,100100000000015,'Startseite DE',1,'http://www.led-gigant.de/',15,'','Impressum','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000025,100100000000016,'gigatec GmbH',1,'http://www.gigatec.de/',15,'','Impressum','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000026,100100000000017,'Startseite DE',1,'http://www.erlebniswelt-fliegenfischen.de/',15,'','Copyright','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000027,100100000000018,'Startseite DE',1,'http://www.whatsyourplace.de/de/',15,'','Außerdem','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000028,100100000000018,'WYP - Erlebnisse',2,'http://www.whatsyourplace.de/de/events/search',15,'','Copyright','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000029,100100000000019,'Startseite DE',1,'http://www.elast.de/',15,'','Copyright','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000030,100100000000020,'Startseite DE',1,'http://www.hardenberg-gymnasium.de/index.php/startseite-top',15,'','Hosting','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000031,100100000000021,'Paca Coaching',1,'http://paca-coaching.de/',15,'','Outdoor-Training','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000032,100100000000022,'Startseite DE',1,'http://www.foerderverein-hgf.de/',15,'','Valid','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000033,100100000000011,'Customer Login',2,'https://secure.wissenswertes.biz/customer/account/login/',15,'','vergessen','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000034,100100000000023,'Startseite DE',1,'http://www.steckerchecker.de',15,'','Atrada','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000035,100100000000023,'Startseite EN',2,'http://www.steckerchecker.com',15,'','Atrada','200'); ] 12587:20120821:162301.029 [Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`zabbix_proxy`.`httpstepitem`, CONSTRAINT `c_httpstepitem_1` FOREIGN KEY (`httpstepid`) REFERENCES `httpstep` (`httpstepid`) ON DELETE CASCADE) [update httpstepitem set httpstepid=100100000000019,itemid=100100000024855,type=2 where httpstepitemid=100100000000088; update httpstepitem set httpstepid=100100000000019,itemid=100100000024856,type=1 where httpstepitemid=100100000000089; update httpstepitem set httpstepid=100100000000019,itemid=100100000024857,type=0 where httpstepitemid=100100000000090; update httpstepitem set httpstepid=100100000000020,itemid=100100000024861,type=2 where httpstepitemid=100100000000091; update httpstepitem set httpstepid=100100000000020,itemid=100100000024862,type=1 where httpstepitemid=100100000000092; update httpstepitem set httpstepid=100100000000020,itemid=100100000024863,type=0 where httpstepitemid=100100000000093; update httpstepitem set httpstepid=100100000000022,itemid=100100000024873,type=2 where httpstepitemid=100100000000097; update httpstepitem set httpstepid=100100000000022,itemid=100100000024874,type=1 where httpstepitemid=100100000000098; update httpstepitem set httpstepid=100100000000022,itemid=100100000024875,type=0 where httpstepitemid=100100000000099; insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000100,100100000000023,100100000024879,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000101,100100000000023,100100000024880,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000102,100100000000023,100100000024881,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000103,100100000000024,100100000024885,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000104,100100000000024,100100000024886,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000105,100100000000024,100100000024887,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000106,100100000000025,100100000024891,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000107,100100000000025,100100000024892,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000108,100100000000025,100100000024893,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000109,100100000000026,100100000024897,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000110,100100000000026,100100000024898,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000111,100100000000026,100100000024899,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000112,100100000000027,100100000024903,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000113,100100000000027,100100000024904,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000114,100100000000027,100100000024905,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000115,100100000000028,100100000024906,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000116,100100000000028,100100000024907,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000117,100100000000028,100100000024908,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000118,100100000000029,100100000024912,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000119,100100000000029,100100000024913,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000120,100100000000029,100100000024914,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000121,100100000000030,100100000024927,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000122,100100000000030,100100000024928,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000123,100100000000030,100100000024929,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000124,100100000000031,100100000024933,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000125,100100000000031,100100000024934,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000126,100100000000031,100100000024935,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000127,100100000000032,100100000024939,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000128,100100000000032,100100000024940,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000129,100100000000032,100100000024941,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000130,100100000000033,100100000024942,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000131,100100000000033,100100000024943,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000132,100100000000033,100100000024944,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000133,100100000000034,100100000025241,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000134,100100000000034,100100000025242,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000135,100100000000034,100100000025243,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000136,100100000000035,100100000025244,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000137,100100000000035,100100000025245,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000138,100100000000035,100100000025246,0); ] 12624:20120821:162316.965 IPMI item [Fan_2B] on host [server03] failed: first network error, wait for 15 seconds 12623:20120821:162336.221 IPMI item [Serverboard_Temp] on host [server15] failed: first network error, wait for 15 seconds 12604:20120821:162428.785 resuming IPMI checks on host [server03]: connection restored 12604:20120821:162436.416 resuming IPMI checks on host [server15]: connection restored 12622:20120821:162829.313 IPMI item [Serverboard_Temp] on host [server03] failed: first network error, wait for 15 seconds 12604:20120821:162902.347 resuming IPMI checks on host [server03]: connection restored 12622:20120821:163829.762 IPMI item [Serverboard_Temp] on host [server03] failed: first network error, wait for 15 seconds 12625:20120821:163830.773 IPMI item [Fan_1A] on host [server15] failed: first network error, wait for 15 seconds 12604:20120821:163901.060 resuming IPMI checks on host [server03]: connection restored 12604:20120821:163909.011 resuming IPMI checks on host [server15]: connection restored 12623:20120821:164829.457 IPMI item [Serverboard_Temp] on host [server03] failed: first network error, wait for 15 seconds 12623:20120821:164831.102 IPMI item [Fan_5A] on host [server15] failed: first network error, wait for 15 seconds 12623:20120821:164846.338 IPMI item [Serverboard_Temp] on host [server12] failed: first network error, wait for 15 seconds 12604:20120821:164900.847 resuming IPMI checks on host [server03]: connection restored 12604:20120821:164909.416 resuming IPMI checks on host [server15]: connection restored 12604:20120821:164917.203 resuming IPMI checks on host [server12]: connection restored 12624:20120821:165317.864 IPMI item [Fan_3A] on host [server03] failed: first network error, wait for 15 seconds 12624:20120821:165330.220 IPMI item [Serverboard_Temp] on host [server15] failed: first network error, wait for 15 seconds 12604:20120821:165437.723 resuming IPMI checks on host [server03]: connection restored 12604:20120821:165445.591 resuming IPMI checks on host [server15]: connection restored 12623:20120821:165829.140 IPMI item [Serverboard_Temp] on host [server03] failed: first network error, wait for 15 seconds 12604:20120821:165901.369 resuming IPMI checks on host [server03]: connection restored 12624:20120821:170829.964 IPMI item [Serverboard_Temp] on host [server03] failed: first network error, wait for 15 seconds 12625:20120821:170834.020 IPMI item [Fan_4A] on host [server15] failed: first network error, wait for 15 seconds 12625:20120821:170846.108 IPMI item [Serverboard_Temp] on host [server12] failed: first network error, wait for 15 seconds 12604:20120821:170900.934 resuming IPMI checks on host [server03]: connection restored 12604:20120821:170909.320 resuming IPMI checks on host [server15]: connection restored 12604:20120821:170916.688 resuming IPMI checks on host [server12]: connection restored 12621:20120821:171829.579 IPMI item [Serverboard_Temp] on host [server03] failed: first network error, wait for 15 seconds 12622:20120821:171834.200 IPMI item [Fan_4A] on host [server15] failed: first network error, wait for 15 seconds 12622:20120821:171846.267 IPMI item [Serverboard_Temp] on host [server12] failed: first network error, wait for 15 seconds 12604:20120821:171900.780 resuming IPMI checks on host [server03]: connection restored 12604:20120821:171908.635 resuming IPMI checks on host [server15]: connection restored 12604:20120821:171915.810 resuming IPMI checks on host [server12]: connection restored 12611:20120821:172109.652 Executing housekeeper 12611:20120821:172116.389 Deleted 17232 records from history [6.552665 seconds] 12587:20120821:172301.948 Received configuration data from server. Datalen 213145 12587:20120821:172303.117 [Z3005] query failed: [1062] Duplicate entry '100100000010053-' for key 'applications_2' [update applications set hostid=100100000010053 where applicationid=100100000000463; insert into applications (applicationid,hostid) values (100100000000665,100100000010053); ] 12587:20120821:172303.178 [Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`zabbix_proxy`.`httptest`, CONSTRAINT `c_httptest_1` FOREIGN KEY (`applicationid`) REFERENCES `applications` (`applicationid`) ON DELETE CASCADE) [update httptest set name='Cinema München',applicationid=100100000000463,delay=300,macros='',agent='gigatec Monitoring',authentication=0,http_user='',http_password='' where httptestid=100100000000010; update httptest set name='Wissenswertes',applicationid=100100000000463,delay=300,macros='',agent='gigatec Monitoring',authentication=0,http_user='',http_password='' where httptestid=100100000000011; update httptest set name='Roncalli Kolleg',applicationid=100100000000463,delay=300,macros='',agent='gigatec Monitoring',authentication=0,http_user='',http_password='' where httptestid=100100000000013; insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000014,'Folien Gigant',100100000000665,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000015,'LED Gigant',100100000000665,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000016,'gigatec GmbH',100100000000463,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000017,'Erlebniswelt Fliegenfischen',100100000000463,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000018,'Whatsyourplace',100100000000463,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000019,'Elast',100100000000463,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000020,'Hardenberg-Gymnasium',100100000000463,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000021,'Paca Coaching',100100000000463,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000022,'Förderverein HGF',100100000000463,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000023,'SteckerChecker',100100000000463,300,'','gigatec Monitoring',0,'',''); ] 12587:20120821:172303.262 [Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`zabbix_proxy`.`httptestitem`, CONSTRAINT `c_httptestitem_1` FOREIGN KEY (`httptestid`) REFERENCES `httptest` (`httptestid`) ON DELETE CASCADE) [update httptestitem set httptestid=100100000000010,itemid=100100000024852,type=2 where httptestitemid=100100000000003; update httptestitem set httptestid=100100000000010,itemid=100100000024853,type=3 where httptestitemid=100100000000004; update httptestitem set httptestid=100100000000010,itemid=100100000024854,type=4 where httptestitemid=100100000000005; update httptestitem set httptestid=100100000000011,itemid=100100000024858,type=2 where httptestitemid=100100000000006; update httptestitem set httptestid=100100000000011,itemid=100100000024859,type=3 where httptestitemid=100100000000007; update httptestitem set httptestid=100100000000011,itemid=100100000024860,type=4 where httptestitemid=100100000000008; update httptestitem set httptestid=100100000000013,itemid=100100000024870,type=2 where httptestitemid=100100000000012; update httptestitem set httptestid=100100000000013,itemid=100100000024871,type=3 where httptestitemid=100100000000013; update httptestitem set httptestid=100100000000013,itemid=100100000024872,type=4 where httptestitemid=100100000000014; insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000015,100100000000014,100100000024876,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000016,100100000000014,100100000024877,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000017,100100000000014,100100000024878,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000018,100100000000015,100100000024882,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000019,100100000000015,100100000024883,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000020,100100000000015,100100000024884,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000021,100100000000016,100100000024888,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000022,100100000000016,100100000024889,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000023,100100000000016,100100000024890,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000024,100100000000017,100100000024894,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000025,100100000000017,100100000024895,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000026,100100000000017,100100000024896,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000027,100100000000018,100100000024900,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000028,100100000000018,100100000024901,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000029,100100000000018,100100000024902,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000030,100100000000019,100100000024909,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000031,100100000000019,100100000024910,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000032,100100000000019,100100000024911,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000033,100100000000020,100100000024924,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000034,100100000000020,100100000024925,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000035,100100000000020,100100000024926,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000036,100100000000021,100100000024930,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000037,100100000000021,100100000024931,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000038,100100000000021,100100000024932,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000039,100100000000022,100100000024936,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000040,100100000000022,100100000024937,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000041,100100000000022,100100000024938,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000042,100100000000023,100100000025238,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000043,100100000000023,100100000025239,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000044,100100000000023,100100000025240,4); ] 12587:20120821:172303.263 [Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`zabbix_proxy`.`httpstep`, CONSTRAINT `c_httpstep_1` FOREIGN KEY (`httptestid`) REFERENCES `httptest` (`httptestid`) ON DELETE CASCADE) [update httpstep set httptestid=100100000000010,name='Cinema München',no=1,url='http://www.cinema-muenchen.de/',timeout=15,posts='',required='Impressum',status_codes='200' where httpstepid=100100000000019; update httpstep set httptestid=100100000000011,name='Startseite',no=1,url='http://www.wissenswertes.biz',timeout=15,posts='',required='Copyright',status_codes='200' where httpstepid=100100000000020; update httpstep set httptestid=100100000000013,name='Roncalli Kolleg',no=1,url='http://www.roncalli-kolleg.de/',timeout=15,posts='',required='Kosten',status_codes='200' where httpstepid=100100000000022; insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000023,100100000000014,'Startseite DE',1,'http://www.folien-gigant.de/',15,'','Impressum','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000024,100100000000015,'Startseite DE',1,'http://www.led-gigant.de/',15,'','Impressum','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000025,100100000000016,'gigatec GmbH',1,'http://www.gigatec.de/',15,'','Impressum','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000026,100100000000017,'Startseite DE',1,'http://www.erlebniswelt-fliegenfischen.de/',15,'','Copyright','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000027,100100000000018,'Startseite DE',1,'http://www.whatsyourplace.de/de/',15,'','Außerdem','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000028,100100000000018,'WYP - Erlebnisse',2,'http://www.whatsyourplace.de/de/events/search',15,'','Copyright','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000029,100100000000019,'Startseite DE',1,'http://www.elast.de/',15,'','Copyright','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000030,100100000000020,'Startseite DE',1,'http://www.hardenberg-gymnasium.de/index.php/startseite-top',15,'','Hosting','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000031,100100000000021,'Paca Coaching',1,'http://paca-coaching.de/',15,'','Outdoor-Training','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000032,100100000000022,'Startseite DE',1,'http://www.foerderverein-hgf.de/',15,'','Valid','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000033,100100000000011,'Customer Login',2,'https://secure.wissenswertes.biz/customer/account/login/',15,'','vergessen','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000034,100100000000023,'Startseite DE',1,'http://www.steckerchecker.de',15,'','Atrada','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000035,100100000000023,'Startseite EN',2,'http://www.steckerchecker.com',15,'','Atrada','200'); ] 12587:20120821:172303.265 [Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`zabbix_proxy`.`httpstepitem`, CONSTRAINT `c_httpstepitem_1` FOREIGN KEY (`httpstepid`) REFERENCES `httpstep` (`httpstepid`) ON DELETE CASCADE) [update httpstepitem set httpstepid=100100000000019,itemid=100100000024855,type=2 where httpstepitemid=100100000000088; update httpstepitem set httpstepid=100100000000019,itemid=100100000024856,type=1 where httpstepitemid=100100000000089; update httpstepitem set httpstepid=100100000000019,itemid=100100000024857,type=0 where httpstepitemid=100100000000090; update httpstepitem set httpstepid=100100000000020,itemid=100100000024861,type=2 where httpstepitemid=100100000000091; update httpstepitem set httpstepid=100100000000020,itemid=100100000024862,type=1 where httpstepitemid=100100000000092; update httpstepitem set httpstepid=100100000000020,itemid=100100000024863,type=0 where httpstepitemid=100100000000093; update httpstepitem set httpstepid=100100000000022,itemid=100100000024873,type=2 where httpstepitemid=100100000000097; update httpstepitem set httpstepid=100100000000022,itemid=100100000024874,type=1 where httpstepitemid=100100000000098; update httpstepitem set httpstepid=100100000000022,itemid=100100000024875,type=0 where httpstepitemid=100100000000099; insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000100,100100000000023,100100000024879,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000101,100100000000023,100100000024880,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000102,100100000000023,100100000024881,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000103,100100000000024,100100000024885,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000104,100100000000024,100100000024886,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000105,100100000000024,100100000024887,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000106,100100000000025,100100000024891,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000107,100100000000025,100100000024892,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000108,100100000000025,100100000024893,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000109,100100000000026,100100000024897,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000110,100100000000026,100100000024898,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000111,100100000000026,100100000024899,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000112,100100000000027,100100000024903,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000113,100100000000027,100100000024904,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000114,100100000000027,100100000024905,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000115,100100000000028,100100000024906,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000116,100100000000028,100100000024907,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000117,100100000000028,100100000024908,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000118,100100000000029,100100000024912,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000119,100100000000029,100100000024913,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000120,100100000000029,100100000024914,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000121,100100000000030,100100000024927,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000122,100100000000030,100100000024928,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000123,100100000000030,100100000024929,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000124,100100000000031,100100000024933,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000125,100100000000031,100100000024934,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000126,100100000000031,100100000024935,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000127,100100000000032,100100000024939,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000128,100100000000032,100100000024940,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000129,100100000000032,100100000024941,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000130,100100000000033,100100000024942,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000131,100100000000033,100100000024943,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000132,100100000000033,100100000024944,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000133,100100000000034,100100000025241,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000134,100100000000034,100100000025242,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000135,100100000000034,100100000025243,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000136,100100000000035,100100000025244,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000137,100100000000035,100100000025245,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000138,100100000000035,100100000025246,0); ] 12623:20120821:172830.168 IPMI item [Serverboard_Temp] on host [server03] failed: first network error, wait for 15 seconds 12623:20120821:172831.432 IPMI item [Fan_5A] on host [server15] failed: first network error, wait for 15 seconds 12623:20120821:172846.820 IPMI item [Serverboard_Temp] on host [server12] failed: first network error, wait for 15 seconds 12604:20120821:172901.775 resuming IPMI checks on host [server03]: connection restored 12604:20120821:172924.704 resuming IPMI checks on host [server15]: connection restored 12604:20120821:172932.270 resuming IPMI checks on host [server12]: connection restored 12624:20120821:173314.476 IPMI item [Fan_1A] on host [server03] failed: first network error, wait for 15 seconds 12624:20120821:173329.697 IPMI item [Serverboard_Temp] on host [server15] failed: first network error, wait for 15 seconds 12604:20120821:173347.162 resuming IPMI checks on host [server03]: connection restored 12604:20120821:173355.780 resuming IPMI checks on host [server15]: connection restored 12624:20120821:173845.600 IPMI item [Serverboard_Temp] on host [server12] failed: first network error, wait for 15 seconds 12604:20120821:173907.338 resuming IPMI checks on host [server12]: connection restored 12625:20120821:174150.176 Got signal [signal:15(SIGTERM),sender_pid:17278,sender_uid:0,reason:0]. Exiting ... 12624:20120821:174150.176 Got signal [signal:15(SIGTERM),sender_pid:17278,sender_uid:0,reason:0]. Exiting ... 12623:20120821:174150.176 Got signal [signal:15(SIGTERM),sender_pid:17278,sender_uid:0,reason:0]. Exiting ... 12622:20120821:174150.176 Got signal [signal:15(SIGTERM),sender_pid:17278,sender_uid:0,reason:0]. Exiting ... 12621:20120821:174150.177 Got signal [signal:15(SIGTERM),sender_pid:17278,sender_uid:0,reason:0]. Exiting ... 12620:20120821:174150.177 Got signal [signal:15(SIGTERM),sender_pid:17278,sender_uid:0,reason:0]. Exiting ... 12619:20120821:174150.177 Got signal [signal:15(SIGTERM),sender_pid:17278,sender_uid:0,reason:0]. Exiting ... 12617:20120821:174150.177 Got signal [signal:15(SIGTERM),sender_pid:17278,sender_uid:0,reason:0]. Exiting ... 12614:20120821:174150.177 Got signal [signal:15(SIGTERM),sender_pid:17278,sender_uid:0,reason:0]. Exiting ... 12613:20120821:174150.177 Got signal [signal:15(SIGTERM),sender_pid:17278,sender_uid:0,reason:0]. Exiting ... 12612:20120821:174150.177 Got signal [signal:15(SIGTERM),sender_pid:17278,sender_uid:0,reason:0]. Exiting ... 12611:20120821:174150.177 Got signal [signal:15(SIGTERM),sender_pid:17278,sender_uid:0,reason:0]. Exiting ... 12610:20120821:174150.177 Got signal [signal:15(SIGTERM),sender_pid:17278,sender_uid:0,reason:0]. Exiting ... 12609:20120821:174150.177 Got signal [signal:15(SIGTERM),sender_pid:17278,sender_uid:0,reason:0]. Exiting ... 12608:20120821:174150.177 Got signal [signal:15(SIGTERM),sender_pid:17278,sender_uid:0,reason:0]. Exiting ... 12607:20120821:174150.177 Got signal [signal:15(SIGTERM),sender_pid:17278,sender_uid:0,reason:0]. Exiting ... 12606:20120821:174150.177 Got signal [signal:15(SIGTERM),sender_pid:17278,sender_uid:0,reason:0]. Exiting ... 12605:20120821:174150.177 Got signal [signal:15(SIGTERM),sender_pid:17278,sender_uid:0,reason:0]. Exiting ... 12604:20120821:174150.178 Got signal [signal:15(SIGTERM),sender_pid:17278,sender_uid:0,reason:0]. Exiting ... 12603:20120821:174150.178 Got signal [signal:15(SIGTERM),sender_pid:17278,sender_uid:0,reason:0]. Exiting ... 12602:20120821:174150.178 Got signal [signal:15(SIGTERM),sender_pid:17278,sender_uid:0,reason:0]. Exiting ... 12592:20120821:174150.178 Got signal [signal:15(SIGTERM),sender_pid:17278,sender_uid:0,reason:0]. Exiting ... 12591:20120821:174150.178 Got signal [signal:15(SIGTERM),sender_pid:17278,sender_uid:0,reason:0]. Exiting ... 12590:20120821:174150.178 Got signal [signal:15(SIGTERM),sender_pid:17278,sender_uid:0,reason:0]. Exiting ... 12589:20120821:174150.178 Got signal [signal:15(SIGTERM),sender_pid:17278,sender_uid:0,reason:0]. Exiting ... 12588:20120821:174150.178 Got signal [signal:15(SIGTERM),sender_pid:17278,sender_uid:0,reason:0]. Exiting ... 12587:20120821:174150.178 Got signal [signal:15(SIGTERM),sender_pid:17278,sender_uid:0,reason:0]. Exiting ... 12581:20120821:174150.178 Got signal [signal:15(SIGTERM),sender_pid:17278,sender_uid:0,reason:0]. Exiting ... 12581:20120821:174152.984 syncing history data... 12581:20120821:174152.984 syncing history data done 12581:20120821:174152.984 Zabbix Proxy stopped. Zabbix 2.0.2 (revision 29214). 17287:20120821:174153.662 Starting Zabbix Proxy (active) [proxy-server18]. Zabbix 2.0.2 (revision 29214). 17287:20120821:174153.662 **** Enabled features **** 17287:20120821:174153.662 SNMP monitoring: YES 17287:20120821:174153.662 IPMI monitoring: YES 17287:20120821:174153.662 WEB monitoring: YES 17287:20120821:174153.662 ODBC: NO 17287:20120821:174153.662 SSH2 support: NO 17287:20120821:174153.662 IPv6 support: YES 17287:20120821:174153.662 ************************** 17293:20120821:174153.781 proxy #1 started [configuration syncer #1] 17302:20120821:174153.784 proxy #10 started [trapper #1] 17294:20120821:174153.784 proxy #2 started [heartbeat sender #1] 17304:20120821:174153.784 proxy #12 started [trapper #3] 17295:20120821:174153.785 proxy #3 started [data sender #1] 17305:20120821:174153.785 proxy #13 started [trapper #4] 17306:20120821:174153.786 proxy #14 started [trapper #5] 17307:20120821:174153.786 proxy #15 started [icmp pinger #1] 17311:20120821:174153.788 proxy #19 started [history syncer #1] 17312:20120821:174153.789 proxy #20 started [history syncer #2] 17287:20120821:174153.789 proxy #0 started [main process] 17313:20120821:174153.789 proxy #21 started [history syncer #3] 17303:20120821:174153.789 proxy #11 started [trapper #2] 17314:20120821:174153.790 proxy #22 started [history syncer #4] 17308:20120821:174153.790 proxy #16 started [housekeeper #1] 17308:20120821:174153.790 Executing housekeeper 17309:20120821:174153.790 proxy #17 started [http poller #1] 17317:20120821:174153.790 proxy #25 started [ipmi poller #3] 17315:20120821:174153.790 proxy #23 started [ipmi poller #1] 17316:20120821:174153.791 proxy #24 started [ipmi poller #2] 17318:20120821:174153.791 proxy #26 started [ipmi poller #4] 17320:20120821:174153.791 proxy #27 started [ipmi poller #5] 17293:20120821:174153.951 Received configuration data from server. Datalen 213145 17293:20120821:174154.386 [Z3005] query failed: [1062] Duplicate entry '100100000010053-' for key 'applications_2' [update applications set hostid=100100000010053 where applicationid=100100000000463; insert into applications (applicationid,hostid) values (100100000000665,100100000010053); ] 17293:20120821:174154.417 [Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`zabbix_proxy`.`httptest`, CONSTRAINT `c_httptest_1` FOREIGN KEY (`applicationid`) REFERENCES `applications` (`applicationid`) ON DELETE CASCADE) [update httptest set name='Cinema München',applicationid=100100000000463,delay=300,macros='',agent='gigatec Monitoring',authentication=0,http_user='',http_password='' where httptestid=100100000000010; update httptest set name='Wissenswertes',applicationid=100100000000463,delay=300,macros='',agent='gigatec Monitoring',authentication=0,http_user='',http_password='' where httptestid=100100000000011; update httptest set name='Roncalli Kolleg',applicationid=100100000000463,delay=300,macros='',agent='gigatec Monitoring',authentication=0,http_user='',http_password='' where httptestid=100100000000013; insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000014,'Folien Gigant',100100000000665,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000015,'LED Gigant',100100000000665,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000016,'gigatec GmbH',100100000000463,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000017,'Erlebniswelt Fliegenfischen',100100000000463,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000018,'Whatsyourplace',100100000000463,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000019,'Elast',100100000000463,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000020,'Hardenberg-Gymnasium',100100000000463,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000021,'Paca Coaching',100100000000463,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000022,'Förderverein HGF',100100000000463,300,'','gigatec Monitoring',0,'',''); insert into httptest (httptestid,name,applicationid,delay,macros,agent,authentication,http_user,http_password) values (100100000000023,'SteckerChecker',100100000000463,300,'','gigatec Monitoring',0,'',''); ] 17293:20120821:174154.891 [Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`zabbix_proxy`.`httptestitem`, CONSTRAINT `c_httptestitem_1` FOREIGN KEY (`httptestid`) REFERENCES `httptest` (`httptestid`) ON DELETE CASCADE) [update httptestitem set httptestid=100100000000010,itemid=100100000024852,type=2 where httptestitemid=100100000000003; update httptestitem set httptestid=100100000000010,itemid=100100000024853,type=3 where httptestitemid=100100000000004; update httptestitem set httptestid=100100000000010,itemid=100100000024854,type=4 where httptestitemid=100100000000005; update httptestitem set httptestid=100100000000011,itemid=100100000024858,type=2 where httptestitemid=100100000000006; update httptestitem set httptestid=100100000000011,itemid=100100000024859,type=3 where httptestitemid=100100000000007; update httptestitem set httptestid=100100000000011,itemid=100100000024860,type=4 where httptestitemid=100100000000008; update httptestitem set httptestid=100100000000013,itemid=100100000024870,type=2 where httptestitemid=100100000000012; update httptestitem set httptestid=100100000000013,itemid=100100000024871,type=3 where httptestitemid=100100000000013; update httptestitem set httptestid=100100000000013,itemid=100100000024872,type=4 where httptestitemid=100100000000014; insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000015,100100000000014,100100000024876,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000016,100100000000014,100100000024877,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000017,100100000000014,100100000024878,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000018,100100000000015,100100000024882,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000019,100100000000015,100100000024883,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000020,100100000000015,100100000024884,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000021,100100000000016,100100000024888,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000022,100100000000016,100100000024889,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000023,100100000000016,100100000024890,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000024,100100000000017,100100000024894,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000025,100100000000017,100100000024895,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000026,100100000000017,100100000024896,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000027,100100000000018,100100000024900,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000028,100100000000018,100100000024901,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000029,100100000000018,100100000024902,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000030,100100000000019,100100000024909,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000031,100100000000019,100100000024910,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000032,100100000000019,100100000024911,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000033,100100000000020,100100000024924,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000034,100100000000020,100100000024925,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000035,100100000000020,100100000024926,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000036,100100000000021,100100000024930,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000037,100100000000021,100100000024931,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000038,100100000000021,100100000024932,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000039,100100000000022,100100000024936,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000040,100100000000022,100100000024937,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000041,100100000000022,100100000024938,4); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000042,100100000000023,100100000025238,2); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000043,100100000000023,100100000025239,3); insert into httptestitem (httptestitemid,httptestid,itemid,type) values (100100000000044,100100000000023,100100000025240,4); ] 17293:20120821:174154.948 [Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`zabbix_proxy`.`httpstep`, CONSTRAINT `c_httpstep_1` FOREIGN KEY (`httptestid`) REFERENCES `httptest` (`httptestid`) ON DELETE CASCADE) [update httpstep set httptestid=100100000000010,name='Cinema München',no=1,url='http://www.cinema-muenchen.de/',timeout=15,posts='',required='Impressum',status_codes='200' where httpstepid=100100000000019; update httpstep set httptestid=100100000000011,name='Startseite',no=1,url='http://www.wissenswertes.biz',timeout=15,posts='',required='Copyright',status_codes='200' where httpstepid=100100000000020; update httpstep set httptestid=100100000000013,name='Roncalli Kolleg',no=1,url='http://www.roncalli-kolleg.de/',timeout=15,posts='',required='Kosten',status_codes='200' where httpstepid=100100000000022; insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000023,100100000000014,'Startseite DE',1,'http://www.folien-gigant.de/',15,'','Impressum','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000024,100100000000015,'Startseite DE',1,'http://www.led-gigant.de/',15,'','Impressum','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000025,100100000000016,'gigatec GmbH',1,'http://www.gigatec.de/',15,'','Impressum','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000026,100100000000017,'Startseite DE',1,'http://www.erlebniswelt-fliegenfischen.de/',15,'','Copyright','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000027,100100000000018,'Startseite DE',1,'http://www.whatsyourplace.de/de/',15,'','Außerdem','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000028,100100000000018,'WYP - Erlebnisse',2,'http://www.whatsyourplace.de/de/events/search',15,'','Copyright','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000029,100100000000019,'Startseite DE',1,'http://www.elast.de/',15,'','Copyright','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000030,100100000000020,'Startseite DE',1,'http://www.hardenberg-gymnasium.de/index.php/startseite-top',15,'','Hosting','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000031,100100000000021,'Paca Coaching',1,'http://paca-coaching.de/',15,'','Outdoor-Training','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000032,100100000000022,'Startseite DE',1,'http://www.foerderverein-hgf.de/',15,'','Valid','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000033,100100000000011,'Customer Login',2,'https://secure.wissenswertes.biz/customer/account/login/',15,'','vergessen','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000034,100100000000023,'Startseite DE',1,'http://www.steckerchecker.de',15,'','Atrada','200'); insert into httpstep (httpstepid,httptestid,name,no,url,timeout,posts,required,status_codes) values (100100000000035,100100000000023,'Startseite EN',2,'http://www.steckerchecker.com',15,'','Atrada','200'); ] 17293:20120821:174155.038 [Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`zabbix_proxy`.`httpstepitem`, CONSTRAINT `c_httpstepitem_1` FOREIGN KEY (`httpstepid`) REFERENCES `httpstep` (`httpstepid`) ON DELETE CASCADE) [update httpstepitem set httpstepid=100100000000019,itemid=100100000024855,type=2 where httpstepitemid=100100000000088; update httpstepitem set httpstepid=100100000000019,itemid=100100000024856,type=1 where httpstepitemid=100100000000089; update httpstepitem set httpstepid=100100000000019,itemid=100100000024857,type=0 where httpstepitemid=100100000000090; update httpstepitem set httpstepid=100100000000020,itemid=100100000024861,type=2 where httpstepitemid=100100000000091; update httpstepitem set httpstepid=100100000000020,itemid=100100000024862,type=1 where httpstepitemid=100100000000092; update httpstepitem set httpstepid=100100000000020,itemid=100100000024863,type=0 where httpstepitemid=100100000000093; update httpstepitem set httpstepid=100100000000022,itemid=100100000024873,type=2 where httpstepitemid=100100000000097; update httpstepitem set httpstepid=100100000000022,itemid=100100000024874,type=1 where httpstepitemid=100100000000098; update httpstepitem set httpstepid=100100000000022,itemid=100100000024875,type=0 where httpstepitemid=100100000000099; insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000100,100100000000023,100100000024879,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000101,100100000000023,100100000024880,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000102,100100000000023,100100000024881,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000103,100100000000024,100100000024885,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000104,100100000000024,100100000024886,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000105,100100000000024,100100000024887,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000106,100100000000025,100100000024891,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000107,100100000000025,100100000024892,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000108,100100000000025,100100000024893,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000109,100100000000026,100100000024897,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000110,100100000000026,100100000024898,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000111,100100000000026,100100000024899,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000112,100100000000027,100100000024903,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000113,100100000000027,100100000024904,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000114,100100000000027,100100000024905,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000115,100100000000028,100100000024906,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000116,100100000000028,100100000024907,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000117,100100000000028,100100000024908,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000118,100100000000029,100100000024912,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000119,100100000000029,100100000024913,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000120,100100000000029,100100000024914,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000121,100100000000030,100100000024927,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000122,100100000000030,100100000024928,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000123,100100000000030,100100000024929,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000124,100100000000031,100100000024933,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000125,100100000000031,100100000024934,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000126,100100000000031,100100000024935,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000127,100100000000032,100100000024939,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000128,100100000000032,100100000024940,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000129,100100000000032,100100000024941,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000130,100100000000033,100100000024942,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000131,100100000000033,100100000024943,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000132,100100000000033,100100000024944,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000133,100100000000034,100100000025241,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000134,100100000000034,100100000025242,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000135,100100000000034,100100000025243,0); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000136,100100000000035,100100000025244,2); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000137,100100000000035,100100000025245,1); insert into httpstepitem (httpstepitemid,httpstepid,itemid,type) values (100100000000138,100100000000035,100100000025246,0); ] 17296:20120821:174155.848 proxy #4 started [poller #1] 17300:20120821:174155.848 proxy #8 started [poller #5] 17299:20120821:174155.848 proxy #7 started [poller #4] 17297:20120821:174155.849 proxy #5 started [poller #2] 17310:20120821:174155.849 proxy #18 started [discoverer #1] 17301:20120821:174155.849 proxy #9 started [unreachable poller #1] 17298:20120821:174155.849 proxy #6 started [poller #3] 17308:20120821:174200.257 Deleted 5920 records from history [6.464627 seconds] 17315:20120821:174829.110 IPMI item [Serverboard_Temp] on host [server03] failed: first network error, wait for 15 seconds 17316:20120821:174830.366 IPMI item [Fan_1A] on host [server15] failed: first network error, wait for 15 seconds 17316:20120821:174846.972 IPMI item [Serverboard_Temp] on host [server12] failed: first network error, wait for 15 seconds 17301:20120821:174903.767 resuming IPMI checks on host [server03]: connection restored 17301:20120821:174911.416 resuming IPMI checks on host [server15]: connection restored 17301:20120821:174918.706 resuming IPMI checks on host [server12]: connection restored