below is the error while acknowledging any problem in UI with zabbix 5.0 & postgres 13
Please suggest quick solution
- 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