[
https://issues.apache.org/jira/browse/AMBARI-6690?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15083333#comment-15083333
]
Dave Beckett commented on AMBARI-6690:
--------------------------------------
I got this issue with ambari 2.1.0 where HCAT was stuck in INSTALL_FAILED
despite being installed and a restart of ambari-agent didn't work for me.
I did the following fix via the database so if anyone else needs a workaround
until the code can handle it, this is what I did (mysql):
{{use ambari;}}
{{select host_id from hosts where host_name='HOSTNAME';}}
this gives me the host_id I need e.g. HOSTID
{{update hostcomponentstate set current_state='INSTALLED' where
current_state='INSTALL_FAILED' and host_id=HOSTID;}}
Afterwards I did an 'install clients' from the UI and 'refresh configs' to try
to make sure the install state was reflected.
> Hosts emit : Host Role Invalid State
> ------------------------------------
>
> Key: AMBARI-6690
> URL: https://issues.apache.org/jira/browse/AMBARI-6690
> Project: Ambari
> Issue Type: Bug
> Components: ambari-web
> Affects Versions: 1.6.0
> Reporter: Deepak Kumar V
> Assignee: Artem Baranchuk
> Priority: Critical
> Labels: ambari-client, ambari-web
> Fix For: 2.1.0
>
>
> At times hosts move to Invalid state and restart of components throw "Host
> role in invalid state".
> One way to fix this issue is to ssh into the hosts and run ambari-agent
> restart
> http://hortonworks.com/community/forums/topic/host-role-in-invalid-state/
> Ambari web interface being single point to manage cluster must provide option
> to restart ambari-agent. It looses its purpose if one has to manually ssh
> into the hosts.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)