Skip to content
New issue

Have a question about this project? # for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “#”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? # to your account

Fail to partition table after changing placement rule #55705

Closed
Nickelth opened this issue Aug 27, 2024 · 0 comments · Fixed by #57560
Closed

Fail to partition table after changing placement rule #55705

Nickelth opened this issue Aug 27, 2024 · 0 comments · Fixed by #57560
Assignees
Labels
affects-7.5 This bug affects the 7.5.x(LTS) versions. affects-8.1 This bug affects the 8.1.x(LTS) versions. affects-8.5 This bug affects the 8.5.x(LTS) versions. severity/major sig/sql-infra SIG: SQL Infra type/bug The issue is confirmed as a bug.

Comments

@Nickelth
Copy link

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

create or replace placement policy p2 primary_region="region3", regions="region1,region2, region3";

CREATE TABLE t0(c5 FLOAT ZEROFILL PRIMARY KEY );
ALTER TABLE t0 PLACEMENT POLICY=p2;

ALTER TABLE t0 PARTITION BY HASH(c5) PARTITIONS 7;

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

Statement executed successfully.

3. What did you see instead (Required)

mysql> ALTER TABLE t0 PARTITION BY HASH(c5) PARTITIONS 7;
ERROR 8243 (HY000): "[PD:placement:ErrBuildRuleList]build rule list failed, multiple leader replicas for range {7480000000000000FF9B00000000000000F8, 7480000000000000FF9C00000000000000F8}"

4. What is your TiDB version? (Required)

 Release Version: v8.4.0-alpha-21-g162cb15402
Edition: Community
Git Commit Hash: 162cb15402de471152a1e59e2ed5d8d1ffcbb4b0
Git Branch: master
UTC Build Time: 2024-08-22 08:12:28
GoVersion: go1.22.5
Race Enabled: false
Check Table Before Drop: false
Store: tikv

tikv was set up with partitioned raft kv
labels are as follows:

mysql> SHOW PLACEMENT LABELS;
+--------+-----------------------------------+
| Key    | Values                            |
+--------+-----------------------------------+
| host   | ["host1", "host2", "host3"]       |
| region | ["region1", "region2", "region3"] |
| zone   | ["zone1", "zone2", "zone3"]       |
+--------+-----------------------------------+
3 rows in set (0.00 sec)
@Nickelth Nickelth added the type/bug The issue is confirmed as a bug. label Aug 27, 2024
@Nickelth Nickelth changed the title Fail to partition table after change placement rule Fail to partition table after changing placement rule Aug 27, 2024
@ti-chi-bot ti-chi-bot bot added the affects-8.5 This bug affects the 8.5.x(LTS) versions. label Nov 1, 2024
@lcwangchao lcwangchao added sig/sql-infra SIG: SQL Infra and removed component/pd labels Nov 20, 2024
@mjonss mjonss added affects-8.1 This bug affects the 8.1.x(LTS) versions. affects-7.5 This bug affects the 7.5.x(LTS) versions. and removed may-affects-8.1 may-affects-7.5 may-affects-5.4 This bug maybe affects 5.4.x versions. may-affects-6.1 may-affects-6.5 may-affects-7.1 labels Nov 20, 2024
@mjonss mjonss self-assigned this Nov 26, 2024
@ti-chi-bot ti-chi-bot bot closed this as completed in b2f29ee Nov 29, 2024
# for free to join this conversation on GitHub. Already have an account? # to comment
Labels
affects-7.5 This bug affects the 7.5.x(LTS) versions. affects-8.1 This bug affects the 8.1.x(LTS) versions. affects-8.5 This bug affects the 8.5.x(LTS) versions. severity/major sig/sql-infra SIG: SQL Infra type/bug The issue is confirmed as a bug.
Projects
None yet
Development

Successfully merging a pull request may close this issue.

4 participants