[
https://issues.apache.org/jira/browse/AMBARI-19990?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Rahul Pathak updated AMBARI-19990:
----------------------------------
Description:
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
was:
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.
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)
