Creating new IT services.

[shafim]

Hi ,

We are getting below mentioned error while creating Zabbix It services.


[6/06/2018 10:34 AM] ACHARYA, AISHI:
Cannot add service
Details–Error in query [INSERT INTO services_links (serviceupid,servicedownid,soft,linkid) VALUES ('16825','5062','1','321570')] [Duplicate entry '321570' for key 'PRIMARY']
–SQL statement execution has failed "INSERT INTO services_links (serviceupid,servicedownid,soft,linkid) VALUES ('16825','5062','1','321570')". [services.php:160 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CService->create() → CService->addDependencies() → DB::insert() → DB::exception() in include/classes/db/DB.php:468]
Also adding the dependencies for hard link we are getting the error like-
Service "IISAUTSTPR097.ecomtst.ecorptst.anz.com" is already hardlinked to a different service. [services.php:160 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CService->create() → CService->addDependencies() → CService->validateAddDependencies() → CService->checkForHardlinkedDependencies() → CApiService::exception() in include/classes/api/services/CService.php:1119]


We are using Zabbix 3.4.7
We have installed zabbix on on solaries machine.

Let me know if you need more details.

[kloczek]

Duplicate entry '321570' for key 'PRIMARY'

You must remove one of those records manually and do the test do the test about do you have more such duplicated entries.
I"m assuming that you using this database since much earlier zabbix version which had some issues with leaving such dup keys. is that correct?