Ad Widget

Collapse

PGRES_FATAL_ERROR:ERROR: duplicate key value

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • stefek143
    Junior Member
    • Feb 2021
    • 3

    #1

    PGRES_FATAL_ERROR:ERROR: duplicate key value

    Hello,
    In my zabbix server in logs I see:

    1724:20210221:132525.309 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: duplicate key value violates unique constraint "alerts_pkey"
    DETAIL: Key (alertid)=(4414644) already exists.
    1724:20210221:132525.312 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: duplicate key value violates unique constraint "alerts_pkey"
    DETAIL: Key (alertid)=(4414645) already exists.
    1724:20210221:132525.315 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: duplicate key value violates unique constraint "alerts_pkey"
    DETAIL: Key (alertid)=(4414646) already exists.
    My infrastructure based on several proxies and one server hosts. Zabbix version is 5.2.4.
    Does anyone known, what can couse this problem?
  • perkik1
    Junior Member
    • Dec 2021
    • 7

    #2
    I'm getting same error when trying to point existing servers to a new Zabbix 6.0 server. Any answers to how to resolve?

    Comment

    • cyber
      Senior Member
      Zabbix Certified SpecialistZabbix Certified Professional
      • Dec 2006
      • 4807

      #3
      Originally posted by perkik1
      I'm getting same error when trying to point existing servers to a new Zabbix 6.0 server. Any answers to how to resolve?
      Proxies and server have to be on same version.

      Comment

      Working...