Skip to main content
dmitrybalak
Silver ⭐️⭐️
July 25, 2023
Solved

Balancer is not available

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. 

rki_
rki_Answer
Gold ⭐️
July 28, 2023

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 replies

rki_
Gold ⭐️
Gold ⭐️
July 25, 2023

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=91268

Translate
dmitrybalak
Silver ⭐️⭐️
July 28, 2023

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

 

Do you can to copy solution? 

Translate
rki_
Gold ⭐️
rki_Answer
Gold ⭐️
July 28, 2023

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.
Translate
dmitrybalak
Silver ⭐️⭐️
July 31, 2023

its works!
Thank you:)

Translate
dmitrybalak
Silver ⭐️⭐️
July 29, 2023

I think about some DB action:) 

I try it on monday. 

Thx!

Translate