Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Removing and reinstalling A Service Causes DB Verification To Produce Warnings in ambari

avatar
Contributor

When you restart ambari server you will see warning.

This is for ambari 2.6.1 version

2018-05-31 13:52:47,897 WARN - You have config(s): hive-interactive-site-version1526669268436,spark2-thrift-sparkconf-version1523470551917,hive-env-version1523468253282,ranger-hive-security-version1523468253282,hive-interactive-site-version1523468253282,hive-site-version1523470551910,hive-env-version1523470551912,webhcat-site-version1523476281613,spark2-defaults-version1523546169843,ranger-hive-security-version1523541830065,webhcat-site-version1523468253282,hive-interactive-env-version1526669268434,oozie-site-version1523476282031,ranger-hive-security-version1523470551914,hive-site-version1523475239563,livy2-conf-version1523470551917,oozie-site-version1523470551917,hive-env-version1524144296621,ranger-hive-policymgr-ssl-version1523470551915,oozie-site-version1523548496113,hive-env-version1523475386015,hive-interactive-site-version1526679191562,tez-interactive-site-version1523468253282,hive-interactive-env-version1526679191561,ranger-hive-audit-version1523473225964,oozie-env-version1523470551917,hive-site-version1523544593764,oozie-site-version1523631139320,hive-site-version1526676861358,hive-site-version1523476281402,oozie-env-version1523548262140,hive-interactive-site-version1526676861357,ranger-hive-audit-version1523468253282,ranger-hive-audit-version1523470551913,spark2-defaults-version1523470551917,spark2-defaults-version1523476281670,hive-interactive-site-version1526672227348,hive-site-version1523468253282,hive-interactive-env-version1523468253282,hive-env-version1524243680992,tez-interactive-site-version1526669268437,oozie-site-version1523554724976,tez-interactive-site-version1526674777606,ranger-hive-plugin-properties-version1523468253282,hive-interactive-env-version1526672227349,hive-atlas-application.properties-version1523468253282,hive-site-version1526670928225,hive-site-version1523475386016,ranger-hive-policymgr-ssl-version1523468253282,hive-interactive-site-version1523476282107,hiveserver2-site-version1523468253282 that is(are) not mapped (in serviceconfigmapping table) to any service!

1 ACCEPTED SOLUTION

avatar
Contributor
hide-solution

This problem has been solved!

Want to get a detailed solution you have to login/registered on the community

Register/Login
3 REPLIES 3

avatar
Contributor
hide-solution

This problem has been solved!

Want to get a detailed solution you have to login/registered on the community

Register/Login

avatar

@Sudheer Velagapudi

How did you remove the service from Ambari? Did you used UI/API to do that? looks like there are stale Hive, oozie, ranger configs are there.

You can try cleaning up those services by following https://community.hortonworks.com/articles/79546/how-to-cleanup-service-from-ambari-database.html

avatar
Contributor

I used ambari to uninstall and reinstall those services.