Cloudera Community
mike_bronson7
user rank
Guru

Re: how to remove old registered hosts from DB

by Guru in Support Questions
‎12-05-2017 06:18 PM
‎12-05-2017 06:18 PM
can you share with me please how to rows which have FK constraint in different tables ... View more

API + how to delete all component from worker mach...

by Guru in Support Questions
‎12-05-2017 06:03 PM
‎12-05-2017 06:03 PM
how to remove the following component by API from worker machine we need to remove these component since ambari GUI not have the option to delete this component /component clients from worker machine curl -u admin:admin -H "X-Requested-By: ambari" -X GET http://master02:8080/api/v1/clusters/HDP/hosts/worker04.sys45.com | grep component_name % Total % Received % Xferd Average Speed Time Time Time Current Dload Upload Total Spent Left Speed 100 24661 100 24661 0 0 164k 0 --:--:-- --:--:-- --:--:-- 164k "component_name" : "DATANODE", "component_name" : "HCAT", "component_name" : "HDFS_CLIENT", "component_name" : "HIVE_CLIENT", "component_name" : "METRICS_MONITOR", "component_name" : "NODEMANAGER", "component_name" : "PIG", "component_name" : "SLIDER", "component_name" : "SPARK2_CLIENT", "component_name" : "TEZ_CLIENT", "component_name" : "YARN_CLIENT", "component_name" : "ZOOKEEPER_CLIENT", ... View more
Labels:

Re: how to remove old registered hosts from DB

by Guru in Support Questions
‎12-05-2017 05:07 PM
‎12-05-2017 05:07 PM
we still get the same errors about ambari=> delete from host_role_command where host_id=351; ERROR: update or delete on table "host_role_command" violates foreign key constraint "fk_execution_command_task_id" on table "execution_command" DETAIL: Key (task_id)=(5156) is still referenced from table "execution_command". ambari=> Delete from hosts where host_id=351; ERROR: update or delete on table "hosts" violates foreign key constraint "fk_host_role_command_host_id" on table "host_role_command" DETAIL: Key (host_id)=(351) is still referenced from table "host_role_command". ... View more

Re: how to remove old registered hosts from DB

by Guru in Support Questions
‎12-05-2017 04:54 PM
‎12-05-2017 04:54 PM
another issue I have about : ambari=> Delete from hosts where host_id=351; ERROR: update or delete on table "hosts" violates foreign key constraint "fk_host_role_command_host_id" on table "host_role_command" DETAIL: Key (host_id)=(351) is still referenced from table "host_role_command". ... View more

Re: how to remove old registered hosts from DB

by Guru in Support Questions
‎12-05-2017 04:34 PM
‎12-05-2017 04:34 PM
from the ambari-server log we see that configs for this execution command: Cluster not found, clusterName=clusterID=-1 05 Dec 2017 16:33:37,189 WARN [ambari-action-scheduler] ExecutionCommandWrapper:185 - Unable to lookup the cluster by ID; assuming that there is no cluster and therefore no configs for this execution command: Cluster not found, clusterName=clusterID=-1 05 Dec 2017 16:33:37,189 WARN [ambari-action-scheduler] ExecutionCommandWrapper:185 - Unable to lookup the cluster by ID; assuming that there is no cluster and therefore no configs for this execution command: Cluster not found, clusterName=clusterID=-1 05 Dec 2017 16:33:38,222 WARN [ambari-action-scheduler] ExecutionCommandWrapper:185 - Unable to lookup the cluster by ID; assuming that there is no cluster and therefore no configs for this execution command: Cluster not found, clusterName=clusterID=-1 05 Dec 2017 16:33:38,222 WARN [ambari-action-scheduler] ExecutionCommandWrapper:185 - Unable to lookup the cluster by ID; assuming that there is no cluster and therefore no configs for this execution command: Cluster not found, clusterName=clusterID=-1 05 Dec 2017 16:33:38,222 WARN [ambari-action-scheduler] ExecutionCommandWrapper:185 - Unable to lookup the cluster by ID; assuming that there is no cluster and therefore no configs for this execution command: Cluster not found, clusterName=clusterID=-1 05 Dec 2017 16:33:39,247 WARN [ambari-action-scheduler] ExecutionCommandWrapper:185 - Unable to lookup the cluster by ID; assuming that there is no cluster and therefore no configs for this execution command: Cluster not found, clusterName=clusterID=-1 05 Dec 2017 16:33:39,247 WARN [ambari-action-scheduler] ExecutionCommandWrapper:185 - Unable to lookup the cluster by ID; assuming that there is no cluster and therefore no configs for this execution command: Cluster not found, clusterName=clusterID=-1 05 Dec 2017 16:33:39,247 WARN [ambari-action-scheduler] ExecutionCommandWrapper:185 - Unable to lookup the cluster by ID; assuming that there is no cluster and therefore no configs for this execution command: Cluster not found, clusterName=clusterID=-1 05 Dec 2017 16:33:40,272 WARN [ambari-action-scheduler] ExecutionCommandWrapper:185 - Unable to lookup the cluster by ID; assuming that there is no cluster and therefore no configs for this execution command: Cluster not found, clusterName=clusterID=-1 05 Dec 2017 16:33:40,273 WARN [ambari-action-scheduler] ExecutionCommandWrapper:185 - Unable to lookup the cluster by ID; assuming that there is no cluster and therefore no configs for this execution command: Cluster not found, clusterName=clusterID=-1 05 Dec 2017 16:33:40,273 WARN [ambari-action-scheduler] ExecutionCommandWrapper:185 - Unable to lookup the cluster by ID; assuming that there is no cluster and therefore no configs for this execution command: Cluster not found, clusterName=clusterID=-1 ^C ... View more

Re: how to remove old registered hosts from DB

by Guru in Support Questions
‎12-05-2017 04:15 PM
‎12-05-2017 04:15 PM
the deleted host - worker 06 only deleted and we not removed the worker component , so now when we add this worker again mayby this is the conflict because worker is already installed ?| ... View more

Re: how to remove old registered hosts from DB

by Guru in Support Questions
‎12-05-2017 04:05 PM
‎12-05-2017 04:05 PM
now after we delete the worler06 now we want to add it to the cluster but we get from the ambari GUI: we waiting more then 20min - is it logical ? Please wait while the hosts are being checked for potential problems... ... View more

Re: how to remove old registered hosts from DB

by Guru in Support Questions
‎12-05-2017 03:46 PM
‎12-05-2017 03:46 PM
I am usually remove it by the amabri GUI ( dlete node ) , but I guess the API do the same ? ... View more

how to remove old registered hosts from DB

by Guru in Support Questions
‎12-05-2017 03:12 PM
‎12-05-2017 03:12 PM
I am trying to remove old worker from the DB ( from ambari-server machine ) as the following * reference - https://community.hortonworks.com/questions/52910/how-can-i-remove-registered-host-but-do-not-added.html psql -U ambari ambari Password for user ambari: ambari-> select host_id from hosts where host_name='worker05.sys59.com'; host_id --------- 255 (1 row) so I delete the host: ambari=> Delete from hoststate where host_id=255 ambari-> Delete from hosts where host_id=255 ambari=> select host_id from hosts where host_name='worker05.sys59.com'; host_id --------- 255 (1 row) this worker still exists in DB , ( host_id=255 ) , even I restart the ambari-server !! why? and how to total remove this worker include all worker properties from postgreSQL ? ... View more
Labels:

Re: Unable to determine service address for nameno...

by Guru in Support Questions
‎12-05-2017 12:56 PM
‎12-05-2017 12:56 PM
@Aditya ok , so what we can do next ? ... View more
Contact Me
Online
Offline
Last Visited
‎08-27-2024 09:17 AM
Community Statistics
Member Since ‎08-08-2017 09:40 AM
Last Visited ‎08-27-2024 09:17 AM
Posts 1,652
Kudos received 29