Login to mysql database of hive metastore. Connect to hive database DROP INDEX CONSTRAINTS_PARENT_TABLE_ID_INDEX ON KEY_CONSTRAINTS; Just in case you may hit the following problems as well DROP TABLE WRITE_SET; ALTER TABLE TXN_COMPONENTS DROP COLUMN TC_OPERATION_TYPE; ALTER TABLE COMPACTION_QUEUE DROP COLUMN CQ_TBLPROPERTIES; ALTER TABLE COMPLETED_COMPACTIONS DROP COLUMN CC_TBLPROPERTIES; ... View more

@apappu I tried the query and it gave me 103 rows of result. Should I remove all those configurations? ... View more

@apappu @apatel I searched and found that this is a know issue https://docs.hortonworks.com/HDPDocuments/Ambari-2.4.0.1/bk_ambari-release-notes/content/ambari_relnotes-2.4.0.1-known-issues.html. I skipped the database check. But I am worried about the upgrade ... View more

@apatel I am unable to figure out the issue from /var/log/ambari-server/ambari-server-check-database.log 2017-01-24 17:25:35,866 INFO - ******************************* Check database started ******************************* 2017-01-24 17:25:40,576 INFO - Checking for configs not mapped to any cluster 2017-01-24 17:25:40,600 INFO - Checking for configs selected more than once 2017-01-24 17:25:40,603 INFO - Checking for hosts without state 2017-01-24 17:25:40,604 INFO - Checking host component states count equals host component desired states count 2017-01-24 17:25:40,606 INFO - Checking services and their configs 2017-01-24 17:25:42,908 ERROR - Unexpected error, database check failed java.lang.NullPointerException at org.apache.ambari.server.checks.DatabaseConsistencyCheckHelper.checkServiceConfigs(DatabaseConsistencyCheckHelper.java:543) at org.apache.ambari.server.checks.DatabaseConsistencyChecker.main(DatabaseConsistencyChecker.java:115) ... View more

@apappu My previous ambari version was 2.2. I have just upgraded it to 2.4 ... View more