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

    • Team C
    • Sprint 70 (Nov 2020)
    • 1

      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

        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

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

              Created:
              Updated:
              Resolved: