通过PLACEMENT POLICY增加Learner副本不生效

🌞 建议反馈 产品缺陷
15
  1. PD里对应的Rule是：
{
  "group_id": "TiDB_DDL_45199",
  "group_index": 80,
  "group_override": true,
  "rules": [
    {
      "group_id": "TiDB_DDL_45199",
      "id": "partition_rule_45199_0",
      "index": 40,
      "start_key": "74800000000000b0ff8f00000000000000f8",
      "end_key": "74800000000000b0ff9000000000000000f8",
      "role": "voter",
      "is_witness": false,
      "count": 3,
      "label_constraints": [
        {
          "key": "disk",
          "op": "notIn",
          "values": [
            "sata"
          ]
        },
        {
          "key": "engine",
          "op": "notIn",
          "values": [
            "tiflash"
          ]
        }
      ],
      "create_timestamp": 1713431877
    },
    {
      "group_id": "TiDB_DDL_45199",
      "id": "partition_rule_45199_1",
      "index": 40,
      "start_key": "74800000000000b0ff8f00000000000000f8",
      "end_key": "74800000000000b0ff9000000000000000f8",
      "role": "learner",
      "is_witness": false,
      "count": 1,
      "label_constraints": [
        {
          "key": "disk",
          "op": "notIn",
          "values": [
            "sata"
          ]
        },
        {
          "key": "engine",
          "op": "notIn",
          "values": [
            "tiflash"
          ]
        }
      ],
      "create_timestamp": 1713431877
    }
  ]
}
  1. show table test.t_partion regions能看到一些region的状态确实是处于PENDING状态
*************************** 63. row ***************************
             REGION_ID: 15631951
             START_KEY: t_45197_
               END_KEY: t_45198_
             LEADER_ID: 15631954
       LEADER_STORE_ID: 1
                 PEERS: 15631952, 15631953, 15631954
            SCATTERING: 0
         WRITTEN_BYTES: 39
            READ_BYTES: 0
  APPROXIMATE_SIZE(MB): 1
      APPROXIMATE_KEYS: 0
SCHEDULING_CONSTRAINTS: CONSTRAINTS="[-disk=sata]"
      SCHEDULING_STATE: SCHEDULED
*************************** 64. row ***************************
             REGION_ID: 15631955
             START_KEY: t_45198_
               END_KEY: t_45199_
             LEADER_ID: 15631956
       LEADER_STORE_ID: 4
                 PEERS: 15631956, 15631957, 15631958
            SCATTERING: 0
         WRITTEN_BYTES: 0
            READ_BYTES: 0
  APPROXIMATE_SIZE(MB): 1
      APPROXIMATE_KEYS: 0
SCHEDULING_CONSTRAINTS: CONSTRAINTS="[-disk=sata]"
      SCHEDULING_STATE: SCHEDULED
*************************** 65. row ***************************
             REGION_ID: 15635914
             START_KEY: t_45199_i_1_0419afd60000000000013132343100000000fb013100000000000000f80380000000002771cf013034383132363030ff0000000000000000f7014341425534493449ff4c324d4e34430000fd01434c303030303531ff3538000000000000f9013031323034310000fd
               END_KEY: t_45199_r_72057594042656696
             LEADER_ID: 15635916
       LEADER_STORE_ID: 2
                 PEERS: 15635915, 15635916, 15635917
            SCATTERING: 0
         WRITTEN_BYTES: 0
            READ_BYTES: 0
  APPROXIMATE_SIZE(MB): 44
      APPROXIMATE_KEYS: 273502
SCHEDULING_CONSTRAINTS: CONSTRAINTS="[-disk=sata]" LEARNERS=1
      SCHEDULING_STATE: PENDING
*************************** 66. row ***************************
             REGION_ID: 15635894
             START_KEY: t_45199_r_72057594042656696
               END_KEY: t_45199_r_648518346345467670
             LEADER_ID: 15635895
       LEADER_STORE_ID: 4
                 PEERS: 15635895, 15635896, 15635897
            SCATTERING: 0
         WRITTEN_BYTES: 0
            READ_BYTES: 0
  APPROXIMATE_SIZE(MB): 101
      APPROXIMATE_KEYS: 669709
SCHEDULING_CONSTRAINTS: CONSTRAINTS="[-disk=sata]" LEARNERS=1
      SCHEDULING_STATE: PENDING