In case ambari API doesn't help. You can use following SQL queries to abort hung/queued/pending operations directly from ambari database.
- Stop Ambari-Server
ambari-server stop
Take backup of ambari database before making any changes to ambari db
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';
- 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';
- Start ambari-server
ambari-server start
