Balancer is not available

[#1]

command rebalance is not currently available for execution because role balancer must be in state N/A, but it is in state Busy

I cant start rebalance on cdh 5.16.2. 

[#2]

Hi @dmitrybalak . Try the below Cloudera article and see if that helps resolve this.

https://my.cloudera.com/knowledge/Rebalance-option-is-greyed-out-in-the-Cloudera-Manager-under?id=91...

[#3]

The page is closed for me.
I have a free license.

Do you can to copy solution? 

[#4 · Accepted solution]

Summary :

Rebalance option is greyed out in the Cloudera Manager under the HDFS -1 or Balancer Actions dropdown menu.

Symptoms

The Rebalance option is grayed out in the Cloudera Manager under the HDFS -1 or Balancer Actions menu. You have verified that they are no currently running Balancer operations under the HDFS-1->Balancer Instance->Commands tab. The HDFS Balancer menu option is normally greyed out if there is a active Balancer job running.

Instructions

To diagnose and workaround this issue, perform the following actions:

1. Log into the Cloudera Manager SQL database and check the status of BALANCER in the Cloudera Manager database using the following command.

    select CONFIGURED_STATUS, ROLE_TYPE FROM ROLES where ROLE_TYPE = "BALANCER" ; 

2. The normal status is NA. If the status returned is BUSY then the status must be changed to NA using the following command.

    update ROLES set CONFIGURED_STATUS="NA" where ROLE_TYPE = "BALANCER";

3. Re-execute the select statement to check to ensure the configured_status is now indicating the correct state.
4. After changing the status the Rebalance option should no longer be greyed out in Cloudera Manager.

[#5]

its works!
Thank you:)

[#6]

I think about some DB action:) 

I try it on monday. 

Thx!