[ZBX-7470] Zabbix Server stopped with "[Z3005] query failed: [1062] Duplicate entry" Created: 2013 Dec 02 Updated: 2017 May 30 Resolved: 2016 Sep 02 |
|
Status: | Closed |
Project: | ZABBIX BUGS AND ISSUES |
Component/s: | Server (S) |
Affects Version/s: | 2.2.0 |
Fix Version/s: | None |
Type: | Incident report | Priority: | Critical |
Reporter: | Yuya Kusakabe | Assignee: | Unassigned |
Resolution: | Won't fix | Votes: | 1 |
Labels: | server, vmware | ||
Remaining Estimate: | Not Specified | ||
Time Spent: | Not Specified | ||
Original Estimate: | Not Specified | ||
Environment: |
Zabbix 2.2.0 |
Attachments: |
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
Description |
Zabbix Server stopped with "[Z3005] query failed: [1062] Duplicate entry". This error logs is in attached file, "zabbix_server.log.1.gz". And I attach the objdump and debug log, "zabbix_server.log.gz". |
Comments |
Comment by Bouygues Telecom [ 2014 Feb 18 ] |
We had a similar problem on our proxies using MySQL : 20127:20140218:104924.341 Received configuration data from server. Datalen 14475347 queries failed -> database error, but proxies don't stop working |
Comment by Alexander Vladishev [ 2016 Sep 02 ] |
Your database is not configured as case-sensitive. You need use utf8_bin collate instead of *_ci. To solve the issue you need to execute it for each table: |
Comment by Alexander Vladishev [ 2016 Sep 02 ] |
I close the issue as Won't Fix. |