Check List.
1. Check Ambari-Server DB
# ambari-server check-database
You must return a message "No errors were found."
If you installed hdp&ambari normally, then Ambari-Server will connect in ambari database of your postgres.
But I think, maybe you were upgraded twice between hdp 2.4.0 -> hdp 2.5.3.0 and hdp 2.5.3.0-> hdp 2.6.0.0 of rolling or manual upgrade.
So I asking, did you upgrade clearly from previous hdp version?
Now, your ambari database in postgres is conflicting cluster, service, some tables, FK constraint(alert_definition table doesn't exist.)..
2. Check Ambari DDL Postgres.
# cd /var/lib/ambari-server/resources
If embeded postgres
# vim Ambari-DDL-Postgres-EMBEDDED-CREATE.sql
Else if custom postgres
# vim Ambari-DDL-Postgres-CREATE.sql
ambari-server still can't find you hadoop cluster 'cresta'.
3. Check ambari database in Postgres.
connect postgres.
\connect ambari
SELECT * FROM ambari.alert_definition;
SELECT * FROM ambari.alert_history;
SELECT * FROM alert_definition WHERE definition_id=74;
SELECT * FROM alert_history WHERE alert_definition_id=74;
definition_id in alert_definition table is alert_definition_id in alert_history table like FK.
But alert_definition_id (74) does not exist in alert_definition table.
It seems something wrong and not clean upgraded.
