Ambari Background operation removal

[#1]

Hi,

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

Attaching the screenshot 

[#2]

@saivenkatg55 

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