Community Articles

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for Show only | Search instead for Did you mean: Announcements Celebrating as our community reaches 100,000 members! Thank you!

HDP Downgrade is Hung in Ambari UI.

Apache Ambari

Hortonworks Data Platform (HDP)

Super Guru

Created on ‎12-28-2016 07:19 PM - edited ‎08-17-2019 06:32 AM

Issue: While performing HDP downgrade the last "Finalize Downgrade" step went successfully but 'Downgrade in Progress' is still struck on 99%. Please find the screenshot below -

ROOT CAUSE: There are few task which are in PENDING state from table host_role_command

Below is sample output -

SELECT task_id, status, event, host_id, role, role_command, command_detail, custom_command_name FROM host_role_command WHERE request_id = 858 AND status != 'COMPLETED' ORDER BY task_id DESC

8964, PENDING, 4, KAFKA_BROKER, CUSTOM_COMMAND, RESTART KAFKA/KAFKA_BROKER, RESTART 8897, PENDING, 4, KAFKA_BROKER, CUSTOM_COMMAND, STOP KAFKA/KAFKA_BROKER, STOP

RESOLUTION: We need to manually move the task to COMPLETED state

UPDATE host_role_command SET status = 'COMPLETED' WHERE request_id = 858 AND status = 'PENDING'