Due to AMBARI-24283 BUG some times there would be warnings like below,
2018-08-09 09:38:27,666 WARN - You have config groups present in the database with no corresponding service found, [(ConfigGroup, Service) => ( HDFS_DL111, null ), ( YARN_2222, null )]. Run --auto-fix-database to fix this automatically.
Possible root cause: In some of the Ambari 2.5.x/2.6.x versions, service DELETE does not delete config groups cleanly and it shows the WARNING while starting ambari-server.
To fix above WARNINGS below steps can be followed.
1. Take Ambari database backup.
2. Run below queries
delete from confgroupclusterconfigmapping where config_group_id in (select group_id from configgroup where group_name in ( 'HDFS_DL111', 'YARN_2222'));
delete from configgrouphostmapping where config_group_id in (select group_id from configgroup where group_name in ( 'HDFS_DL111', 'YARN_2222'));
delete from configgroup where group_name in ( 'HDFS_DL111', 'YARN_2222');
Backing up the Ambari database with Postgres
How to generate the ambari's setup-security options in non interactive mode?
How to create a key-based Cloudbreak credential on AWS (Video)
How to find the configuration changes using Ambari APIs ?
How to configure LogSearch UI for Https based access.
How to fix ambari Hive View 1.5 /2.0 'Result fetch timed out' issue ?
YARN Application Monitoring with NiFi
How to create an app-based Cloudbreak credential on Azure (Video)
Ambari REST API to add a component in kerberized cluster
New Hortonworks Data Cloud for AWS Technical Preview is now available!
This website uses cookies for analytics, personalisation and advertising. To learn more or change your cookie settings, please read our Cookie Policy. By continuing to browse, you agree to our use of cookies.
HCC Guidelines | HCC FAQs | HCC Privacy Policy | Privacy Policy | Terms of Service
© 2011-2019 Hortonworks Inc. All Rights Reserved.
Hadoop, Falcon, Atlas, Sqoop, Flume, Kafka, Pig, Hive, HBase, Accumulo, Storm, Solr, Spark, Ranger, Knox, Ambari, ZooKeeper, Oozie and the Hadoop elephant logo are trademarks of the Apache Software Foundation.