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

PostgreSQL - PGRES_FATAL_ERROR using zabbix-server 5.0.5

    XMLWordPrintable

    Details

    • Team:
      Team C
    • Sprint:
      Sprint 70 (Nov 2020)
    • Story Points:
      1

      Description

      After upgrading to version 5.0.5, the zabbix server log contains constant errors:
      [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: duplicate key value violates unique constraint "interface_snmp_pkey"
      DETAIL: Key (interfaceid)=(2414) already exists.

      In the postgresql log:
      zabbix zabbix [1678]ERROR: duplicate key value violates unique constraint "interface_snmp_pkey"
      zabbix zabbix [1678]DETAIL: Key (interfaceid)=(706) already exists.
      zabbix zabbix [1678]STATEMENT: insert into interface_snmp

        Attachments

        1. HostID_10898.PNG
          HostID_10898.PNG
          27 kB
        2. HostID_12274.PNG
          HostID_12274.PNG
          21 kB
        3. ps_ax_grep_zabbix
          14 kB
        4. zabbix_server.log-20201115
          626 kB

          Issue Links

            Activity

              People

              Assignee:
              MVekslers Michael Veksler
              Reporter:
              a.yagupov Alexander Yagupov
              Votes:
              0 Vote for this issue
              Watchers:
              8 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: