Hi @Ilya Li , If you are using default postgreSQL of ambari , Please follow this steps which might help you get ride to this issue 1) Stop ambari -server 2) login to psql psql -U ambari ambari (default password will be bigdata) select * from ambari.stack where stack_id in (select clusters.desired_stack_id from ambari.clusters); probably it will be pointing towards HDF-3.1.0 if my assumption is correct or pointing towards a wrong REPO then you might need to update the desired_stack_id to HDF-3.1.2 which is your current version , cluster id yu can get from clusters table. update clusters set desired_stack_id = X where cluster_id = Y; You will get the stack_ID X from this command : select stack_id,stack_version from stack; Please refer to this help which explains it very good manner : https://community.hortonworks.com/content/supportkb/150258/the-ambari-versions-page-keeps-loading-when-upgrad.html Suggested DB backup before this operaton If PostgreSQL: pg_dump -U ambari ambari > ./ambari_$(date +"%Y%m%d%H%M%S").sql If MySQL: mysqldump -u ambari -p ambari > ./ambari_$(date +"%Y%m%d%H%M%S").sql After the opration you can start ambari-server. Please mark the asnwer as accepted if this helps you. ... View more

hi @XM , It seems you might have removed some tasks manually from the database. can you please execute following commands and see if it helps you. select * from host_role_command where stage_id in (select stage_id from upgrade_item) order by task_id; select * from upgrade_item where stage_id not in (select distinct(stage_id) from host_role_command); select * from upgrade_group; select * from upgrade_item; the upgrade_item table contains all the subtasks of upgrade and host_role_command contains all the tasks. both are mapped with stage_id Please use more specific scripts than '*' as i gave if you are using the command line to inspect queries. I use PGAdmin 4 a UI tool which gives a better idea of the tables. There is another simple way which I can suggest downgrade and upgrade again and don't modify Database unless you take backup. hope this Comment helps you. ... View more

Hi @Saurabh , Its not possible to register a host with IP.its suggested using the FQDN so that it will be easy to change ip in /etc/hosts if IP changes in future. IF you try to give the IP in Add Host wizard it will show this corresponding error message : The following hostnames are not valid FQDNs: 172.26.69.17 This may cause problems during installation. Do you want to continue? Later the registration will fail with below error message Registeringwith the server...Registrationwith the server failed. you won't find any errors in ambari-server logs. What I can suggest you is changing the yarn configs replace it with IP's instead of FQDN . See if that works. If this solves your issue, please mark this as accepted. ... View more

Hi @Saurabh , Its not possible to register a host with IP.its suggested to use the FQDN so that it will be easy to change ip in /etc/hosts if IP changes in future. IF you try to give the IP in Add Host wizard it will show this coresponding error message : The following hostnames are not valid FQDNs: 172.26.69.17 This may cause problems during installation. Do you want to continue? Later the registration will fail with below error message Registering with the server... Registration with the server failed. you wont find any errors in ambari-server logs. Then I tried with FQDN of corresponding IP . its success. Hope this helps. If you find this answer helpfull please mark as accepted which will help other users. ... View more