question Balancer is not available in Support Questions

Balancer is not available

dmitrybalak — Tue, 25 Jul 2023 01:43:08 GMT

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.

Re: Balancer is not available

rki_ — Tue, 25 Jul 2023 08:39:33 GMT

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

Re: Balancer is not available

dmitrybalak — Fri, 28 Jul 2023 06:20:16 GMT

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

Do you can to copy solution?

Re: Balancer is not available

rki_ — Fri, 28 Jul 2023 16:57:28 GMT

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:

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" ; 
```
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";
```
Re-execute the select statement to check to ensure the configured_status is now indicating the correct state.
After changing the status the Rebalance option should no longer be greyed out in Cloudera Manager.

Re: Balancer is not available

dmitrybalak — Sat, 29 Jul 2023 01:18:52 GMT

I think about some DB action:)

I try it on monday.

Thx!

Re: Balancer is not available

dmitrybalak — Mon, 31 Jul 2023 02:03:10 GMT

its works!
Thank you:)