[ZBX-3731] Errors in Server Log file. Query failed: [1062] Duplicate entry Created: 2011 Apr 15  Updated: 2017 May 30  Resolved: 2011 Aug 21

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Server (S)
Affects Version/s: 1.8.4
Fix Version/s: 1.8.6, 1.9.4 (alpha)

Type: Incident report Priority: Major
Reporter: Alexander Vladishev Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Duplicate

 Description   

32193:20110415:115311.110 [Z3005] Query failed: [1062] Duplicate entry '22162-1302854400' for key 1 [insert into trends_uint (itemid,clock,num,value_min,value_avg,value_max) values (22162,1302854400,1,1,1,1);
]
32195:20110415:115516.135 [Z3005] Query failed: [1062] Duplicate entry '22162-1302854400' for key 1 [insert into trends_uint (itemid,clock,num,value_min,value_avg,value_max) values (22162,1302854400,1,1,1,1);
]



 Comments   
Comment by Alexander Vladishev [ 2011 May 03 ]

Fixed in the development branch svn://svn.zabbix.com/branches/dev/ZBX-3731

Comment by Alexander Vladishev [ 2011 May 05 ]

Fixed in the version pre1.8.6, r19378.

Comment by richlv [ 2011 Jul 21 ]

still seeing the issue with 1.8 branch rev 20636 server

2937:20110721:120009.940 [Z3005] query failed: [1062] Duplicate entry '22173-1311246000' for key 'PRIMARY' [insert into trends (itemid,clock,num,value_min,value_avg,value_max) values (22173,1311246000,10,0.000000,0.034000,0
.140000),(22176,1311246000,10,0.000000,0.000000,0.000000);
]
2937:20110721:120009.941 [Z3005] query failed: [1062] Duplicate entry '22172-1311246000' for key 'PRIMARY' [insert into trends_uint (itemid,clock,num,value_min,value_avg,value_max) values (22171,1311246000,10,1549,1812,2255
),(22172,1311246000,10,873,4341,15906),(22174,1311246000,10,541,1184,1760);
]

trends :

itemid clock num value_min value_avg value_max

------------------------------------------------+

22173 1311246000 1 0.0000 0.0000 0.0000

trends_uint :

itemid clock num value_min value_avg value_max

------------------------------------------------+

22172 1311246000 1 15 15 15
Comment by richlv [ 2011 Aug 21 ]

not reproducible at will, new issue will be created if happens again

Generated at Thu Apr 18 22:19:47 EEST 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.