"hostcomponentstate" and column would be "current_state".
cluster_id | component_name | current_state | service_name |
upgrade_state | version | security_state | host_id | current_stack_id | id
------------+---------------------+---------------+--------------+---------------+--------------+----------------+---------+------------------+----
2 | NAMENODE | STARTED | HDFS | NONE
| 2.2.0.0-2041 | UNSECURED | 1 | 3 | 7
________________________________________
From: Hari Sekhon (JIRA) <[email protected]>
Sent: Wednesday, September 16, 2015 9:01 AM
To: [email protected]
Subject: [jira] [Commented] (AMBARI-12834) Ambari Hive roles in invalid state,
cannot restart service
[
https://issues.apache.org/jira/browse/AMBARI-12834?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14790605#comment-14790605
]
Hari Sekhon commented on AMBARI-12834:
--------------------------------------
This is blocking restart of the Hive service now I need to integrate Hive with
Ranger.
There must be some table in the underlying postgres db where I can manually
reset the state similar to I had to do for AMBARI-10495.
Anybody know which underlying table/field?
> Ambari Hive roles in invalid state, cannot restart service
> ----------------------------------------------------------
>
> Key: AMBARI-12834
> URL: https://issues.apache.org/jira/browse/AMBARI-12834
> Project: Ambari
> Issue Type: Bug
> Components: ambari-server, ambari-web
> Affects Versions: 2.1.0
> Environment: HDP 2.3
> Reporter: Hari Sekhon
> Priority: Blocker
> Attachments: ambari-server.log
>
>
> Ambari has run in to another invalid state scenario where it's unable to
> restart a service, in this case Hive. The service OP goes to yellow with the
> following errors:
> {code}On host <host> role HCAT in invalid state.
> Invalid transition. Invalid event: HOST_SVCCOMP_OP_IN_PROGRESS at
> INSTALL_FAILED{code}
> {code}On host <host> role HIVE_CLIENT in invalid state.
> Invalid transition. Invalid event: HOST_SVCCOMP_OP_IN_PROGRESS at
> INSTALL_FAILED{code}
> This was previously working, but is now failing to restart with this error,
> and trying just a start (it's already started) prompts for kerberos admin
> principal.
> I'm attaching the ambari server log.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)