I can't to add a new services with error "Cannot create service".
Frontend show me the log:
But I didn't add the service direct into database.
This screenshot:
In the database I realy see the service with this id, but why the zabbix add new service with the same id.
How can I fix this problem or change next serviceid value?
Frontend show me the log:
Code:
pg_query(): Query failed: ERROR: duplicate key value violates unique constraint "services_pkey"
DETAIL: Key (serviceid)=(69) already exists. [zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerServiceCreate->doAction() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CService->create() → DB::insert() → DB::insertBatch() → DBexecute() → pg_query() in include/db.inc.php:373]Error in query [INSERT INTO services (serviceid,name,algorithm,sortorder,description,uu id,created_at) VALUES ('69','HTTP health check','2','0','','9d15b56c150d4852b22d3d708b23e28 d','1735122597')] [ERROR: duplicate key value violates unique constraint "services_pkey"
DETAIL: Key (serviceid)=(69) already exists.]SQL statement execution has failed "INSERT INTO services (serviceid,name,algorithm,sortorder,description,uu id,created_at) VALUES ('69','HTTP health check','2','0','','9d15b56c150d4852b22d3d708b23e28 d','1735122597')".
This screenshot:
In the database I realy see the service with this id, but why the zabbix add new service with the same id.
How can I fix this problem or change next serviceid value?
Comment