question Re: Is there a way to remove the services from ambari and add the services once again? in Archives of Support Questions (Read Only)

Is there a way to remove the services from ambari and add the services once again?

saravanagopal88 — Fri, 16 Sep 2022 11:18:49 GMT

Re: Is there a way to remove the services from ambari and add the services once again?

jsensharma — Wed, 22 Mar 2017 20:58:34 GMT

Yes, Either you can remove the services from Ambari UI as following:

Ambari UI --> Ambari Metrics Collector (Or any service that you want to delete) --> Service Action (Drop down menu) --> "Delete Service" (Button)

Or use the Ambari Rest API to do the same : https://cwiki.apache.org/confluence/display/AMBARI/Using+APIs+to+delete+a+service+or+all+host+components+on+a+host

Here is an example removing METRICS_COLLECTOR from a host.

# curl -u admin -H "X-Requested-By: ambari" -X DELETE http://<AMBARI_HOST>:8080/api/v1/clusters/<CLUSTERNAME>/hosts/hdmdup0002.machine.test.group/host_components/METRICS_COLLECTOR

- Which version of ambari are you using that also matters. Because you can delete services from ambari UI from Ambari 2.4.x version else you will have to use the Rest API as mentioned in the above link.

Re: Is there a way to remove the services from ambari and add the services once again?

apathan — Wed, 22 Mar 2017 21:05:03 GMT

@saravanan gopalsamy

For removing a service: https://docs.hortonworks.com/HDPDocuments/Ambari-2.4.2.0/bk_ambari-user-guide/content/removing_a_service.html

For adding a service: https://docs.hortonworks.com/HDPDocuments/Ambari-2.4.2.0/bk_ambari-user-guide/content/adding_a_service.html

Re: Is there a way to remove the services from ambari and add the services once again?

saravanagopal88 — Wed, 22 Mar 2017 21:21:18 GMT

Hi Jay thanks a lot for the help but i cant find any option to remove the services in Ambari UI..

Re: Is there a way to remove the services from ambari and add the services once again?

saravanagopal88 — Sun, 18 Aug 2019 10:46:27 GMT

This are the things i could find in service actions tab

Re: Is there a way to remove the services from ambari and add the services once again?

apathan — Wed, 22 Mar 2017 22:01:54 GMT

@saravanan gopalsamy Which version of ambari are you using?

Re: Is there a way to remove the services from ambari and add the services once again?

saravanagopal88 — Wed, 22 Mar 2017 22:11:00 GMT

@Ayub Khan 2.2.1.0 is amabri version and hdp version is 2.4.3.0-227

Re: Is there a way to remove the services from ambari and add the services once again?

apathan — Wed, 22 Mar 2017 22:16:40 GMT

Please use the below API to delete the service from Ambari-2.2.1.0. Below example shows how to delete KNOX service, similarly you can modify its values to reflect your need.

curl -u admin:admin -H "X-Requested-By: ambari" -X DELETE http://<AMBARi_SERVER_HOST>:8080/api/v1/clusters/<$CLUSTER_NAME>/services/KNOX

To add the service you can refer to this documentation.

Re: Is there a way to remove the services from ambari and add the services once again?

jsensharma — Wed, 22 Mar 2017 22:32:18 GMT

@saravanan gopalsamy

As mentioned earlier that you can delete services from ambari UI from Ambari 2.4.x version else you will have to use the Rest API as mentioned in the above link.

In Ambari 2.2.1 that feature is not available in ambari UI. So you will need to either use the Ambari API or more simplest way is to delete the service directly from the Database as mentioned in the following article.

(Easiest and quick option) Deleting Service entry directly from Database using the following query:

    delete from hostcomponentstate where service_name = 'KNOX';
    delete from hostcomponentdesiredstate where service_name = 'KNOX';
    delete from servicecomponentdesiredstate where service_name = 'KNOX';
    delete from servicedesiredstate where service_name = 'KNOX';
    delete from serviceconfighosts where service_config_id in (select service_config_id from serviceconfig where service_name = 'KNOX');
    delete from serviceconfigmapping where service_config_id in (select service_config_id from serviceconfig where service_name = 'KNOX');
    delete from serviceconfig where service_name = 'KNOX';
    delete from requestresourcefilter where service_name = 'KNOX';
    delete from requestoperationlevel where service_name = 'KNOX';
    delete from clusterservices where service_name ='KNOX';
    delete from clusterconfig where type_name like 'knox%';
    delete from clusterconfigmapping where type_name like 'knox%';

Please see: https://community.hortonworks.com/content/kbentry/81939/how-to-resolve-ambari-db-inconsistency-error-you-h.html

Then you will need to restart Ambari Server.

Re: Is there a way to remove the services from ambari and add the services once again?

saravanagopal88 — Wed, 22 Mar 2017 22:39:13 GMT

@Jay SenSharma Thanks for your help..Let me try this one.Moreover i tried the curl calls as well but still i could not delete the services

Re: Is there a way to remove the services from ambari and add the services once again?

jsensharma — Wed, 22 Mar 2017 22:45:54 GMT

@saravanan gopalsamy

Sure, The Database queries should definitely work well as it leaves no foot print in the database of the service that we wanted to delete and completely cleans all the entries related to that mentioned service from the Database completely. You will need to restart AmbariServer after making the database changes.