Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.Original topic: ERROR 8243 (HY000)
|
username: TiDBer_GLm4bHSn
MySQL [tmpdcc]> select * from information_schema.placement_policies;
±----------±-------------±------------------±---------------±--------------------±------------±-------------------±---------------------±--------------------±---------±----------±---------+
| POLICY_ID | CATALOG_NAME | POLICY_NAME | PRIMARY_REGION | REGIONS | CONSTRAINTS | LEADER_CONSTRAINTS | FOLLOWER_CONSTRAINTS | LEARNER_CONSTRAINTS | SCHEDULE | FOLLOWERS | LEARNERS |
±----------±-------------±------------------±---------------±--------------------±------------±-------------------±---------------------±--------------------±---------±----------±---------+
| 1 | def | west | seattle | seattle,shanghai | | | | | | 2 | 0 |
| 6 | def | myplacementpolicy | us-east-1 | us-east-1,us-west-1 | | | | | | 5 | 0 |
| 3 | def | p1 | us-east-1 | us-east-1,us-west-1 | | | | | | 2 | 0 |
| 2 | def | east | seattle | shanghai,seattle | | | | | | 2 | 0 |
±----------±-------------±------------------±---------------±--------------------±------------±-------------------±---------------------±--------------------±---------±----------±---------+
4 rows in set (0.00 sec)
MySQL [tmpdcc]> CREATE TABLE t122 (a INT) PLACEMENT POLICY = myplacementpolicy;
ERROR 8243 (HY000): “[PD:placement:ErrRuleContent]invalid rule content, rule ‘table_rule_249_0’ from rule group ‘TiDB_DDL_249’ can not match any store”