[
https://issues.apache.org/jira/browse/AMBARI-24606?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Tim Thorpe updated AMBARI-24606:
Description:
When a service is deleted, there are artifacts that are left behind in the
Ambari DB such as configuration versions.
These are no longer needed and can cause issues.
When restarting the ambari server, you will see the following error:
DB configs consistency check found warnings. See
/var/log/ambari-server/ambari-server-check-database.log for more details.
/var/log/ambari-server/ambari-server-check-database.log:
2018-09-06 11:12:49,455 WARN - You have config(s): ... that is(are) not
mapped (in serviceconfigmapping table) to any service!
You can use following command to cleanup the postgress database:
grep WARN /var/log/ambari-server/ambari-server-check-database.log | tail -n 1 |
awk '\{print $8}'| sed 's/,/\n/g' | sed 's/-version/ version/g' | awk '\{printf
"delete from clusterconfig WHERE type_name='\''%s'\'' AND
version_tag='\''%s'\'';\n", $1, $2}' | psql -U ambari ambari
There are no REST API calls that can be used to clean up the unwanted
configurations.
curl -u admin:admin -i -H 'X-Requested-By: ambari' -X DELETE
'http://localhost:8080/api/v1/clusters/cc/configurations/service_config_versions?service_name=HDFS
HTTP/1.1 405 Method Not Allowed'
curl -u admin:admin -i -H 'X-Requested-By: ambari' -X DELETE
'http://localhost:8080/api/v1/clusters/cc/configurations?type=hdfs-conf=version1'
HTTP/1.1 405 Method Not Allowed'
There are many defects related to this which are still opened:
https://issues.apache.org/jira/browse/AMBARI-18358
https://issues.apache.org/jira/browse/AMBARI-14624
https://issues.apache.org/jira/browse/AMBARI-19990
https://issues.apache.org/jira/browse/AMBARI-21269
https://issues.apache.org/jira/browse/AMBARI-12573
https://issues.apache.org/jira/browse/AMBARI-11713
I haven't verified whether all of the issues described are still valid or not.
was:
When a service is deleted, there are artifacts that are left behind in the
Ambari DB such as configuration versions.
These are no longer needed and can cause issues.
When restarting the ambari server, you will see the following error:
DB configs consistency check found warnings. See
/var/log/ambari-server/ambari-server-check-database.log for more details.
/var/log/ambari-server/ambari-server-check-database.log:
2018-09-06 11:12:49,455 WARN - You have config(s): ... that is(are) not mapped
(in serviceconfigmapping table) to any service!
You can use following command to cleanup the postgress database:
grep WARN /var/log/ambari-server/ambari-server-check-database.log | tail -n 1 |
awk '\{print $8}'| sed 's/,/\n/g' | sed 's/-version/ version/g' | awk '\{printf
"delete from clusterconfig WHERE type_name='\''%s'\'' AND
version_tag='\''%s'\'';\n", $1, $2}' | psql -U ambari ambari
There are no REST API calls that can be used to clean up the unwanted
configurations.
There are many defects related to this which are still opened:
https://issues.apache.org/jira/browse/AMBARI-18358
https://issues.apache.org/jira/browse/AMBARI-14624
https://issues.apache.org/jira/browse/AMBARI-19990
https://issues.apache.org/jira/browse/AMBARI-21269
https://issues.apache.org/jira/browse/AMBARI-12573
https://issues.apache.org/jira/browse/AMBARI-11713
I haven't verified whether all of the issues described are still valid or not.
> Deleting a service should do a better job of cleaning up the Ambari DB
> --
>
> Key: AMBARI-24606
> URL: https://issues.apache.org/jira/browse/AMBARI-24606
> Project: Ambari
> Issue Type: Bug
> Components: ambari-server
>Affects Versions: 2.7.0
>Reporter: Tim Thorpe
>Priority: Major
>
> When a service is deleted, there are artifacts that are left behind in the
> Ambari DB such as configuration versions.
> These are no longer needed and can cause issues.
> When restarting the ambari server, you will see the following error:
> DB configs consistency check found warnings. See
> /var/log/ambari-server/ambari-server-check-database.log for more details.
> /var/log/ambari-server/ambari-server-check-database.log:
> 2018-09-06 11:12:49,455 WARN - You have config(s): ... that is(are) not
> mapped (in serviceconfigmapping table) to any service!
> You can use following command to cleanup the postgress database:
> grep WARN /var/log/ambari-server/ambari-server-check-database.log | tail -n 1
> | awk '\{print $8}'| sed 's/,/\n/g' | sed 's/-version/ version/g' | awk
> '\{printf "delete from clusterconfig WHERE type_name='\''%s'\'' AND
> version_tag='\''%s'\'';\n", $1, $2}' | psql -U ambari ambari
> There are no REST API calls that can be used to clean up the unwanted
> configurations.
> curl -u admin:admin -i -H