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

In server logs records about duplicates

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Duplicate
    • Icon: Trivial Trivial
    • None
    • 7.0.8
    • Server (S)
    • None

      environment:

      1. Server 7.0.5
      2. Active Agent2 7.0.2
      3. PostgreSQL database

      Result:
      On the server in the logs multiple errors like:
       36 duplicates missing
       [Z3008] query failed due to primary key constraint: [0] PGRES_FATAL_ERROR:ERROR: duplicate key value violates unique “history_pkey” constraint
      CONNECT: The key (itemid, clock, ns)=(200806, 1738236706, 756826700) already exists.
       2 duplicates missing
      809348:20250130:143159.357 [Z3008] query failed due to primary key constraint: [0] PGRES_FATAL_ERROR:ERROR: duplicate key value violates unique constraint “history_uint_pkey”
      NOTE: The key (itemid, clock, ns)=(200516, 1738236716, 705656400) already exists.
      This problem occurs only for Windows servers with the “Windows by Zabbix agent active” template applied. For Linux there is no such problem
      No solution has been found at this time.
      Expected:
      Error in logs

            zabbix.dev Zabbix Development Team
            sergey.signalov Sergey Signalov
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: