Placement policy will be lost after restarting the tidb server

[lcwangchao]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

create placement policy p1 primary_region="r1" regions="r1,r2" schedule="EVEN";

-- Restart the tidb server

show placement;

2. What did you expect to see? (Required)

mysql> show placement;
+-----------+-----------------------------------------------------+------------------+
| Target    | Placement                                           | Scheduling_state |
+-----------+-----------------------------------------------------+------------------+
| POLICY p1 | PRIMARY_REGION="r1" REGIONS="r1,r2" SCHEDULE="EVEN" | SCHEDULED        |
+-----------+-----------------------------------------------------+------------------+
1 row in set (0.00 sec)

3. What did you see instead (Required)

mysql> show placement;
Empty set (0.00 sec)

4. What is your TiDB version? (Required)

master

[lcwangchao]

I think the reason for this bug is that full load of information schema did not cover placement policies cases

[github-actions]

Please check whether the issue should be labeled with 'affects-x.y' or 'fixes-x.y.z', and then remove 'needs-more-info' label.