Skipping load balancing for table t1 as its placement information is not available yet

Setup: Three nodes, replication factor 3, yugabyte 2.6.0.0

Getting the below error. Any idea on this

INFO logs

##Log path is: ~/master/logs/yb-master.INFO

ad balancing for table t1 as its placement information is not available yet
I0726 08:25:56.554682 14290 cluster_balance.cc:294] Skipping load balancing for table t1 as its placement information is not available yet
I0726 08:26:06.565382 14290 cluster_balance.cc:294] Skipping load balancing for table t1 as its placement information is not available yet
I0726 08:26:16.575987 14290 cluster_balance.cc:294] Skipping load balancing for table t1 as its placement information is not available yet
I0726 08:26:26.587234 14290 cluster_balance.cc:294] Skipping load balancing for table t1 as its placement information is not available yet
I0726 08:26:36.597838 14290 cluster_balance.cc:294] Skipping load balancing for table t1 as its placement information is not available yet
I0726 08:26:46.608222 14290 cluster_balance.cc:294] Skipping load balancing for table t1 as its placement information is not available yet
I0726 08:26:56.619372 14290 cluster_balance.cc:294] Skipping load balancing for table t1 as its placement information is not available yet

Hi @AddictionAwesome

What type of table is this ?
How long has it been since the table has been created and are the logs still being created ?

This can be a temporary error on new tables if the manager cache hasn’t yet been refreshed: yugabyte-db/cluster_balance.cc at 621b45236a805c857004039ee65fc25d8867f72d · yugabyte/yugabyte-db · GitHub

Thanks @dorian_yugabyte for the reply
Table type is: PGSQL_TABLE_TYPE
We have created 2 tables ‘t1’ and ‘t2’ for testing purpose.
for table ‘t1’ we are getting the error.
table has been created more than 10 days back and even today logs are being generated with the below error
I0727 07:51:16.195806 14290 cluster_balance.cc:294] Skipping load balancing for table t1 as its placement information is not available yet
I0727 07:51:26.206166 14290 cluster_balance.cc:294] Skipping load balancing for table t1 as its placement information is not available yet
I0727 07:51:36.216820 14290 cluster_balance.cc:294] Skipping load balancing for table t1 as its placement information is not available yet
I0727 07:51:46.227675 14290 cluster_balance.cc:294] Skipping load balancing for table t1 as its placement information is not available yet
I0727 07:51:56.237993 14290 cluster_balance.cc:294] Skipping load balancing for table t1 as its placement information is not available yet.

Please could you give me the following information:

  1. Have there been any custom flags set in this environment? Specifically the flag --ysql_tablespace_info_refresh_secs
  2. Upload complete YB-Master logs
  3. Are you using YSQL Tablespaces in this setup?
  4. Just to confirm, only t1 has this issue and not t2?

If possible, could you enable verbose logging for YB-Master and turn on this flag:
--vmodule=sys_catalog=5,cluster_balance=1

Setting this flag requires a YB-Master restart. Can you turn this on for a 2-3 minutes and send me the logs for that duration?

Hi @dorian_yugabyte,

I tried restarting one of the YB-Master service, Issue got resolved.
Now the Load is balanced.

Thanks :slightly_smiling_face:

Hi @AddictionAwesome Good to see that the issue is resolved. But if its not too much trouble, please could you provide the YB-Master logs pertaining to the time you had this problem anyway? These logs will help greatly to understand why the issue occurred and prevent it from happening again. Will greatly appreciate your help :slightly_smiling_face:

Hi Deepthi_Srinivasan

The cluster is no longer available since the cluster was not being used and hence destroyed.
will share the logs in case if I get the similar error.

Thanks:)