Support Questions

Find answers, ask questions, and share your expertise

Ambari Background operation removal


Could you please any of you tell how to remove the background operation entry in ambari database.


Attaching the screenshot 


Super Collaborator


Use the below commands to remove the background operation entry in ambari database.


# select task_id,role,role_command from host_role_command where status='IN_PROGRESS';


The above command will list all IN_PROGRESS status , You can also check for QUEUED or PENDING STATE by replacing 'IN_PROGRESS' with QUEUED or PENDING


# update host_role_command set status='ABORTED' where status='QUEUED';

Use the above command to change the state to ABORTED