It may be necessary to remove entries from the host_role_command table if the size of the table has grown excessively large in order to reduce the query times for "IN_PROGRESS" requests.
However, if you remove all tasks for an upgrade, but you leave the stages, request, and upgrade items, the upgrade will appear as though it is now PENDING.
The actual request is showing as COMPLETED correctly:
- Perform a simple upgrade of a ZK-only cluster
- Find out the ID of the upgrade request (say its 12)
- Remove tasks