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.
... View more
