Some tables in the placement rule are in PENDING status

Translated
1

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: placement rule 部份表处于 PENDING 状态

| username: Hacker_ojLJ8Ndr

Some tables remain in a PENDING state when using placement rules. Even after canceling and resetting the placement rules for these tables, they still do not take effect. However, using the same rules on tables that are in a normal state works fine. How can this issue be resolved?

2
| username: redgame | Original post link

One possibility is that the table is undergoing a large number of write or change operations: When the table is in an active write or change state, placement rules may not take effect immediately. This is because the TiDB cluster needs to maintain data consistency and handle current write requests. You can wait for a while, let the cluster finish processing the current write operations, and then try setting the placement rules again.

3
| username: tidb菜鸟一只 | Original post link

Could you provide the table creation statement and the placement rule creation statement for the table whose placement rule status has been pending?

4
| username: Hacker_ojLJ8Ndr | Original post link

It has been resolved. It was due to LowSpace Stores. After handling it, scheduling is now normal.

5
| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.