updated psql 12 database - psql 14 restored database via ladies
raised a new zabbix everything works
The error occurs when you add a template to the nodes
Tell me how then to update or manually transfer everything?
raised a new zabbix everything works
The error occurs when you add a template to the nodes
Code:
[LIST][*]pg_query(): Query failed: ERROR: duplicate key value violates unique constraint "triggers_pkey" DETAIL: Key (triggerid)=(77319) already exists. [zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostUpdate->doAction() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->update() → CHost->massUpdate() → CHost->massAdd() → CHostGeneral->massAdd() → CHostGeneral->link() → CTriggerGeneral->syncTemplates() → CTriggerGeneral->inherit() → CTriggerGeneral->createReal() → DB::insert() → DB::insertBatch() → DBexecute() → pg_query() in include/db.inc.php:373][*]Error in query [INSERT INTO triggers (description,expression,recovery_mode,recovery_exp ression,url,status,priority,comments,type,correlat ion_mode,correlation_tag,manual_close,opdata,event _name,uuid,templateid,triggerid) VALUES ('test','({122917}<>{122918})=1 and length({122917})>0 and length({122918})>0','0','','','0','4','','0','0',' ','1','','','','62953','77319')] [ERROR: duplicate key value violates unique constraint "triggers_pkey" DETAIL: Key (triggerid)=(77319) already exists.][*]Ошибка при выполнении SQL запроса "INSERT INTO triggers (description,expression,recovery_mode,recovery_exp ression,url,status,priority,comments,type,correlat ion_mode,correlation_tag,manual_close,opdata,event _name,uuid,templateid,triggerid) VALUES ('test','({122917}<>{122918})=1 and length({122917})>0 and length({122918})>0','0','','','0','4','','0','0',' ','1','','','','62953','77319')".[/LIST]