Hello,
I've installed zabbix server using postgresql as DBserver. it's working fine, but I've got a problem, when I'm trying to create item to monitor I've got DB error
pg_query(): Query failed: ERROR: duplicate key value violates unique constraint "items_applications_1"
DETAIL: Key (applicationid, itemid)=(356, 23328) already exists. [include/db.inc.php:511]
Error in query [INSERT INTO items_applications (applicationid,itemid,itemappid) VALUES ('356','23328','5525')] [ERROR: duplicate key value violates unique constraint "items_applications_1"
DETAIL: Key (applicationid, itemid)=(356, 23328) already exists.]
SQL statement execution has failed "INSERT INTO items_applications (applicationid,itemid,itemappid) VALUES ('356','23328','5525')".
I've checked table items_applications but there is no records with that values
I've installed zabbix server using postgresql as DBserver. it's working fine, but I've got a problem, when I'm trying to create item to monitor I've got DB error
pg_query(): Query failed: ERROR: duplicate key value violates unique constraint "items_applications_1"
DETAIL: Key (applicationid, itemid)=(356, 23328) already exists. [include/db.inc.php:511]
Error in query [INSERT INTO items_applications (applicationid,itemid,itemappid) VALUES ('356','23328','5525')] [ERROR: duplicate key value violates unique constraint "items_applications_1"
DETAIL: Key (applicationid, itemid)=(356, 23328) already exists.]
SQL statement execution has failed "INSERT INTO items_applications (applicationid,itemid,itemappid) VALUES ('356','23328','5525')".
I've checked table items_applications but there is no records with that values
Comment