Ambari upgrade issue - Unable to find HDP services in Ambari dashboard post upgrade

[#1]

I'm trying to upgrade HDP 3.0 to 3.1 but after Ambari upgrade HDP services are not listed in dashboard, instead cluster installation wizard come up.

[root@host ~]# curl -u admin:admin -H 'X-Requested-By: ambari' -X GET "http://host/api/v1/clusters/"
{
  "href" : "http://host/api/v1/clusters/",
  "items" : [ ]
}[root@host~]#

while I can see services running in background

[root@host ~]# jps
27457 HMaster
28711 TimelineReaderServer
25675 jar
30637 ZeppelinServer
29427 Main
6195 HRegionServer
2324 AmbariServer
31860 Main
26869 ResourceManager
29013 Main
20150 Jps
23895 SupportToolServer
26391 Main
10041 RemoteInterpreterServer
4219 NameNode
25212 QuorumPeerMain
3679 DFSZKFailoverController

[#2 · Accepted solution]

@Chhaya Vishwakarma

0. Are you entering the Correct Ambari Server Host Name & Port in the rest URL ? (or by mistake it is pointing to a freshly installed ambari server host) ?

1. Are you sure that ambari DB was not reset? (Did some one rest the ambari DB)

2. Do you see the cluster creation wizard shown when you login to the UI ? (if yes then may be the ambari DB is reset or ambari server is pointing to wrong DB which does not have cluster info)

3. Please grep the Ambari DB details from the following output and then check the "clusters" table detail.

# grep jdbc /etc/ambari-server/conf/ambari.properties

4. What output do you see when you run the following SQL query in amabri DB?

# SELECT * FROM clusters;

5. Can you please share the complete output of "/var/log/ambari-server/ambari-server.log"

[#3]

@Chhaya Vishwakarma

Also can you please share the exact steps that you have performed after upgrading the Ambari Server binaries from 2.7.0 to 2.7.3.

[#4]

I managed to resolve the issue, Ambari Database was in Postgres while /etc/ambari-server/conf/ambari.properties was pointing to MySql.

[#5]

@Chhaya Vishwakarma

Good to know that the issue is resolved. It will be great to mark this thread as "Answered" by clicking the "Accept" button.