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 -
ERROR:
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' |
