[ZBX-22695] Message "query failed due to primary key constraint:" in history syncer process. Created: 2023 Apr 19  Updated: 2024 Apr 10  Resolved: 2023 Jun 20

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Server (S)
Affects Version/s: None
Fix Version/s: 6.0.19rc1, 6.4.4rc1, 7.0.0alpha2, 7.0 (plan)

Type: Problem report Priority: Major
Reporter: Kazuo Ito Assignee: Michael Veksler
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

zabbix server 6.0.13
Windows OS / zabbix agent 4.0.5 / 4.0.10


Attachments: Zip Archive zabbix_agent-6.0.17-windows-amd64-openssl.zip    
Issue Links:
Causes
causes ZBX-23310 Request for Backport of ZBX-22695 to ... Closed
caused by ZBXNEXT-6921 Use primary keys for historical table... Closed
Duplicate
Team: Team B
Sprint: Sprint 99 (Apr 2023), Sprint 100 (May 2023), Sprint 101 (Jun 2023)
Story Points: 0.5

 Description   

The message "query failed due to primary key constraint:" occurs in the history syncer process when the monitored OS is Windows and Type: "Zabbix agent(active)" is monitored.

The last 6 digits of ns will be 0 when it occurs.
i.e. in milliseconds.



 Comments   
Comment by Michael Veksler [ 2023 Jun 16 ]

Available in:

Generated at Wed Mar 12 23:08:34 EET 2025 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.