[jira] [Created] (AMBARI-19990) Unable to delete config group.

["Rahul Pathak (JIRA)" <ji...@apache.org>]

Rahul Pathak created AMBARI-19990:
-------------------------------------

             Summary: 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. 

Rahul



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)