Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-22695

Message "query failed due to primary key constraint:" in history syncer process.

    XMLWordPrintable

Details

    • Problem report
    • Resolution: Fixed
    • Major
    • 6.0.19rc1, 6.4.4rc1, 7.0.0alpha2, 7.0 (plan)
    • None
    • Server (S)
    • None
    • zabbix server 6.0.13
      Windows OS / zabbix agent 4.0.5 / 4.0.10
    • Team B
    • Sprint 99 (Apr 2023), Sprint 100 (May 2023), Sprint 101 (Jun 2023)
    • 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.

      Attachments

        Issue Links

          caused by

          Change Request - An Change Request or enhancement Improvement to an existing feature or task. ZBXNEXT-6921 Use primary keys for historical tables (PoC)

          • Trivial - Cosmetic problem like misspelt words or misaligned text.
          • Closed
          causes

          Problem report - Problem report ZBX-23310 Request for Backport of ZBX-22695 to Zabbix 4.0 and Zabbix 5.0

          • Trivial - Cosmetic problem like misspelt words or misaligned text.
          • Closed

          Activity

            People

              MVekslers Michael Veksler
              kazuo.ito Kazuo Ito
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: