hi
after running Zabbix for a few years (on 1.8.10 for the last six months or so) with MySQL, we're suddenly getting duplicate entry errors similar to those below. Any ideas why these are happening and what we can do about them?
thanks
Michael
1325:20130711:082323.151 [Z3005] query failed: [1062] Duplicate entry '23743-1373526000' for key 'PRIMARY' [insert into trends_uint (itemid,clock,num,value_min,value_avg,value_max) values (23743,1373526000,1,489979,489979,489979),(23755,1 373526000,1,489979,489979,489979),(23758,137352600 0,1,7177940992,7177940992,7177940992),(22471,13735 26000,1,32768,32768,32768),(22482,1373526000,1,0,0 ,0),(22484,1373526000,1,1,1,1),(22485,1373526000,1 ,1,1,1),(25071,1373526000,1,1,1,1),(22489,13735260 00,1,1,1,1),(22491,1373526000,1,4,4,4),(24183,1373 526000,1,484349,484349,484349),(24186,1373526000,1 ,7108968448,7108968448,7108968448),(24190,13735260 00,1,916656128,916656128,916656128),(24191,1373526 000,1,7108968448,7108968448,7108968448),(24194,137 3526000,1,916660224,916660224,916660224),(24195,13 73526000,1,7108964352,7108964352,7108964352),(2416 7,1373526000,1,153036098,153036098,153036098),(267 15,1373526000,1,7074947072,7074947072,7074947072), (26719,1373526000,1,950677504,950677504,950677504) ,(26720,1373526000,1,7074947072,7074947072,7074947 072),(26724,1373526000,1,950677504,950677504,95067 7504),(26725,1373526000,1,7074947072,7074947072,70 74947072),(23159,1373526000,1,482491,482491,482491 ),(23162,1373526000,1,482491,482491,482491),(23165 ,1373526000,1,482491,482491,482491),(23168,1373526 000,1,482491,482491,482491),(23171,1373526000,1,48 2491,482491,482491),(23174,1373526000,1,7106805760 ,7106805760,7106805760),(23178,1373526000,1,918822 912,918822912,918822912);
]
1325:20130711:082326.986 [Z3005] query failed: [1062] Duplicate entry '24003-1373522400' for key 'PRIMARY' [insert into trends_uint (itemid,clock,num,value_min,value_avg,value_max) values (23762,1373522400,3,847679488,847679488,847679488) ,(23763,1373522400,3,7177945088,7177945088,7177945 088),(23766,1373522400,3,847679488,847679488,84767 9488),(27052,1373522400,2,2553397248,2553468928,25 53540608),(27053,1373522400,6,5472083968,547220002 1,5472223232),(27057,1373522400,6,264871936,264871 936,264871936),(27058,1373522400,6,1977012224,1977 035434,1977151488),(27059,1373522400,6,1292337152, 1292466858,1292492800),(27060,1373522400,6,0,0,0), (27063,1373522400,8,1,1,1),(26959,1373522400,4,385 086,385086,385086),(26960,1373522400,4,32768,32768 ,32768),(26969,1373522400,4,1,1,1),(26974,13735224 00,4,1,1,1),(26976,1373522400,4,1,1,1),(22484,1373 522400,1,1,1,1),(22485,1373522400,1,1,1,1),(25071, 1373522400,1,1,1,1),(22489,1373522400,1,1,1,1),(22 491,1373522400,1,4,4,4),(22493,1373522400,9,59,59, 59),(22498,1373522400,9,1323959055,1323959055,1323 959055),(24003,1373522400,5,186761216,186762853,18 6765312),(24004,1373522400,5,171532288,171594546,1 71687936),(24005,1373522400,5,0,0,0),(23905,137352 2400,4,59518,59518,59518),(23906,1373522400,4,3276 8,32768,32768),(23917,1373522400,5,0,0,0),(23919,1 373522400,5,1,1,1),(24199,1373522400,9,916639744,9 16639744,916639744),(24200,1373522400,9,7108984832 ,7108984832,7108984832),(24204,1373522400,8,916643 840,916643840,916643840),(24205,1373522400,8,71089 80736,7108980736,7108980736),(26715,1373522400,1,7 075102720,7075102720,7075102720),(26719,1373522400 ,1,950521856,950521856,950521856),(26720,137352240 0,1,7075102720,7075102720,7075102720),(26724,13735 22400,1,950677504,950677504,950677504),(26725,1373 522400,1,7074947072,7074947072,7074947072),(26729, 1373522400,11,205893632,205893632,205893632),(2673 0,1373522400,11,221433856,221433856,221433856),(26 731,1373522400,10,146092032,146092032,146092032),( 26732,1373522400,10,0,0,0),(23159,1373522400,1,482 492,482492,482492),(23162,1373522400,1,482492,4824 92,482492),(23174,1373522400,1,7105757184,71057571 84,7105757184),(23178,1373522400,1,919871488,91987 1488,919871488),(23179,1373522400,3,7105753088,710 5753088,7105753088),(23182,1373522400,3,919871488, 919871488,919871488),(23183,1373522400,3,710684672 0,7106846720,7106846720);
]
after running Zabbix for a few years (on 1.8.10 for the last six months or so) with MySQL, we're suddenly getting duplicate entry errors similar to those below. Any ideas why these are happening and what we can do about them?
thanks
Michael
1325:20130711:082323.151 [Z3005] query failed: [1062] Duplicate entry '23743-1373526000' for key 'PRIMARY' [insert into trends_uint (itemid,clock,num,value_min,value_avg,value_max) values (23743,1373526000,1,489979,489979,489979),(23755,1 373526000,1,489979,489979,489979),(23758,137352600 0,1,7177940992,7177940992,7177940992),(22471,13735 26000,1,32768,32768,32768),(22482,1373526000,1,0,0 ,0),(22484,1373526000,1,1,1,1),(22485,1373526000,1 ,1,1,1),(25071,1373526000,1,1,1,1),(22489,13735260 00,1,1,1,1),(22491,1373526000,1,4,4,4),(24183,1373 526000,1,484349,484349,484349),(24186,1373526000,1 ,7108968448,7108968448,7108968448),(24190,13735260 00,1,916656128,916656128,916656128),(24191,1373526 000,1,7108968448,7108968448,7108968448),(24194,137 3526000,1,916660224,916660224,916660224),(24195,13 73526000,1,7108964352,7108964352,7108964352),(2416 7,1373526000,1,153036098,153036098,153036098),(267 15,1373526000,1,7074947072,7074947072,7074947072), (26719,1373526000,1,950677504,950677504,950677504) ,(26720,1373526000,1,7074947072,7074947072,7074947 072),(26724,1373526000,1,950677504,950677504,95067 7504),(26725,1373526000,1,7074947072,7074947072,70 74947072),(23159,1373526000,1,482491,482491,482491 ),(23162,1373526000,1,482491,482491,482491),(23165 ,1373526000,1,482491,482491,482491),(23168,1373526 000,1,482491,482491,482491),(23171,1373526000,1,48 2491,482491,482491),(23174,1373526000,1,7106805760 ,7106805760,7106805760),(23178,1373526000,1,918822 912,918822912,918822912);
]
1325:20130711:082326.986 [Z3005] query failed: [1062] Duplicate entry '24003-1373522400' for key 'PRIMARY' [insert into trends_uint (itemid,clock,num,value_min,value_avg,value_max) values (23762,1373522400,3,847679488,847679488,847679488) ,(23763,1373522400,3,7177945088,7177945088,7177945 088),(23766,1373522400,3,847679488,847679488,84767 9488),(27052,1373522400,2,2553397248,2553468928,25 53540608),(27053,1373522400,6,5472083968,547220002 1,5472223232),(27057,1373522400,6,264871936,264871 936,264871936),(27058,1373522400,6,1977012224,1977 035434,1977151488),(27059,1373522400,6,1292337152, 1292466858,1292492800),(27060,1373522400,6,0,0,0), (27063,1373522400,8,1,1,1),(26959,1373522400,4,385 086,385086,385086),(26960,1373522400,4,32768,32768 ,32768),(26969,1373522400,4,1,1,1),(26974,13735224 00,4,1,1,1),(26976,1373522400,4,1,1,1),(22484,1373 522400,1,1,1,1),(22485,1373522400,1,1,1,1),(25071, 1373522400,1,1,1,1),(22489,1373522400,1,1,1,1),(22 491,1373522400,1,4,4,4),(22493,1373522400,9,59,59, 59),(22498,1373522400,9,1323959055,1323959055,1323 959055),(24003,1373522400,5,186761216,186762853,18 6765312),(24004,1373522400,5,171532288,171594546,1 71687936),(24005,1373522400,5,0,0,0),(23905,137352 2400,4,59518,59518,59518),(23906,1373522400,4,3276 8,32768,32768),(23917,1373522400,5,0,0,0),(23919,1 373522400,5,1,1,1),(24199,1373522400,9,916639744,9 16639744,916639744),(24200,1373522400,9,7108984832 ,7108984832,7108984832),(24204,1373522400,8,916643 840,916643840,916643840),(24205,1373522400,8,71089 80736,7108980736,7108980736),(26715,1373522400,1,7 075102720,7075102720,7075102720),(26719,1373522400 ,1,950521856,950521856,950521856),(26720,137352240 0,1,7075102720,7075102720,7075102720),(26724,13735 22400,1,950677504,950677504,950677504),(26725,1373 522400,1,7074947072,7074947072,7074947072),(26729, 1373522400,11,205893632,205893632,205893632),(2673 0,1373522400,11,221433856,221433856,221433856),(26 731,1373522400,10,146092032,146092032,146092032),( 26732,1373522400,10,0,0,0),(23159,1373522400,1,482 492,482492,482492),(23162,1373522400,1,482492,4824 92,482492),(23174,1373522400,1,7105757184,71057571 84,7105757184),(23178,1373522400,1,919871488,91987 1488,919871488),(23179,1373522400,3,7105753088,710 5753088,7105753088),(23182,1373522400,3,919871488, 919871488,919871488),(23183,1373522400,3,710684672 0,7106846720,7106846720);
]
Comment