[AMBARI-19990] Unable to delete config group.

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: ambari-server
• Assignee: Unassigned
• Reporter: Rahul Pathak
• Created: 13/Feb/17 18:06
• Updated: 14/Feb/17 06:22

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