[
https://issues.apache.org/jira/browse/AMBARI-19990?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15865155#comment-15865155
]
Rahul Pathak commented on AMBARI-19990:
---------------------------------------
[~arborkar]
I have replicated this in latest ambari version 2.4.2
Rahul
> Unable to delete config group.
> ------------------------------
>
> Key: AMBARI-19990
> URL: https://issues.apache.org/jira/browse/AMBARI-19990
> Project: Ambari
> Issue Type: Bug
> Components: ambari-server
> Reporter: Rahul Pathak
>
> Currently deleting config group from Ambari does not work.
> Deleting and saving will show it is gone however on checking again it will
> show up with name Deleted.
> Following can be seen in ambari-server.log if trying to rename deleted config
> group:
> org.apache.ambari.server.AmbariException: Config group not found, clusterName
> = xyz, groupId = 2
> Workaround is to delete all references of group id from ambari database
> manually.
> Backup ambari-server database and run below queries.
> delete from ambari."serviceconfighosts" where service_config_id in (select
> service_config_id from serviceconfig where group_id=2);
> delete from ambari."serviceconfigmapping" where service_config_id in (select
> service_config_id from serviceconfig where group_id=2);
> delete from ambari.serviceconfig where group_id=2;
> Here 2 is group id for which ambari is throwing error.
> Restart ambari-server. It will not display Deleted config group anymore.
> Rahul
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)