Ad Widget

Collapse

pg_query(): ERROR: duplicate key value violates unique constraint "acknowledges_pkey"

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ruchamatkar
    Junior Member
    • Jul 2021
    • 1

    #1

    pg_query(): ERROR: duplicate key value violates unique constraint "acknowledges_pkey"

    below is the error while acknowledging any problem in UI with zabbix 5.0 & postgres 13
    • pg_query(): Query failed: ERROR: duplicate key value violates unique constraint "acknowledges_pkey"
    • DETAIL: Key (acknowledgeid)=(145) already exists. [zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerPopupAcknowledgeCreate->doAction() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CEvent->acknowledge() → DB::insertBatch() → DBexecute() → pg_query() in include/db.inc.php:348]
    • Error in query [INSERT INTO acknowledges (userid,eventid,clock,message,action,old_severity, new_severity,acknowledgeid) VALUES ('15','91861','1625583529','ack','6','0','0','145' )] [ERROR: duplicate key value violates unique constraint "acknowledges_pkey"
    • DETAIL: Key (acknowledgeid)=(145) already exists.]
    • SQL statement execution has failed "INSERT INTO acknowledges (userid,eventid,clock,message,action,old_severity, new_severity,acknowledgeid) VALUES ('15','91861','1625583529','ack','6','0','0','145' )".
    • Cannot update events



    Please suggest quick solution
Working...