In case ambari API doesn't help. You can use following SQL queries to abort hung/queued/pending operations directly from ambari database.   1) Stop Ambari-Server   ambari-server stop   2) Take backup of ambari database before making any changes to ambari db 3) Check IN_PROGRESS, QUEUED and PENDING operations.   ambari=> select task_id,role,role_command from host_role_command where status='IN_PROGRESS'; ambari=> select task_id,role,role_command from host_role_command where status='QUEUED' limit 100; ambari=> select task_id,role,role_command from host_role_command where status='PENDING';   4) Abort Operations   ambari=> update host_role_command set status='ABORTED' where status='QUEUED'; ambari=> update host_role_command set status='ABORTED' where status='PENDING'; ambari=> update host_role_command set status='ABORTED' where status='IN_PROGRESS';   5) Start ambari-server   ambari-server start       ... View more

Our installation had the password hash in another table.   update ambari.user_authentication set authentication_key='538916f8943ec225d97a9a86a2c6ec0818c1cd400e09e03b660fdaaec4af29ddbb6f2b1033b81b00' where user_id='1'     Note: user_id=1 was the admin in my case.   ... View more

@Vitor Batista are you still having issues with this? Can you accept the best answer or post your solution? ... View more

Hi, Is there any solution to the error found ? I am facing the same issue in my cluster. Appreciate your help in advance. Thanks! ... View more

I know this is an old post. However, I did send out a support inquiry as to WHEN 5.7 will be supported and got the response that it was being tested for Ambari v2.5. That was very early this year. There are various vulnerabilities identified by Oracle related to not running higher than 5.7.11. In particular, the vulnerabilities cover: MySQL Server 5.6.29 and earlier, 5.7.11 and earlier. There are no workarounds or alternatives for this issue...Not good. I am referring to Oracle Support Note 2120034.1 for the preferred solution. This issue was identified by our security team in May 2016. So, my question is this. WHEN will 5.7.11+ be supported? ... View more

After changing to server:port ,it works. Thank you! ... View more

If you want a Postgresql HA for your Ambari and the other components like Ranger, Hive, Oozie, you have to use an external postgresql database, not the embeded. In front of your Postgresql HA, use a connection pooler like pgbouncer or pgpool, so you will reduce the impact of opening a client connection to the database by keeping sessions open between the connection pooler and the database. ... View more