-
Type:
Incident report
-
Resolution: Commercial support required
-
Priority:
Trivial
-
None
-
Affects Version/s: None
-
Component/s: Frontend (F)
-
None
I can't to add a new services with error "Cannot create service".
Frontend show me the log:
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,uuid,created_at) VALUES ('69','HTTP health check','2','0','','9d15b56c150d4852b22d3d708b23e28d','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,uuid,created_at) VALUES ('69','HTTP health check','2','0','','9d15b56c150d4852b22d3d708b23e28d','1735122597')".
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?
