Got duplicate entry error for auto increment column

[guo-shaoge]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

1. apply tidb code, check detail code from when leader switch, autoid service does not reset the map #52600. So we can reassign auto_id service leader
2. setup tidb cluster(2 tidb/1 tikv/1 pd)
3. By running following command to make sure auto_id leader is in tidb-0(10080). (command result is 'not owner')

curl http://127.0.0.1:10081/autoid/leader/resign
result: not owner

5. run the following sql to create table:

create table t (id int primary key auto_increment, k int) auto_id_cache = 1;
insert into t (k) values (1);
insert into t (k) values (2);
insert into t (k) values (3);
insert into t (k) values (5);

6. reassign autoid leader to tidb-1(10081). (the result of the command should be success)

curl http://127.0.0.1:10080/autoid/leader/resign

7. run the following sqls to insert again:

insert into t (k) values (6);
insert into t (k) values (7);
insert into t (k) values (8);

8. tiup restart tidb-1(10081)
9. tiup restart tidb-0(10080)
10. run the following sqls to insert 4000 lines: t.txt

source /home/guojiangtao/work/tidb/t.txt;

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

insert runs ok

3. What did you see instead (Required)

4. What is your TiDB version? (Required)

+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| tidb_version()                                                                                                                                                                                                                                                           |
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Release Version: v8.1.0-alpha-1-g42f4a3133d
Edition: Community
Git Commit Hash: 42f4a3133d8cc5309a5fa4dd7c92a2a1cfa3cbca
Git Branch: debug_autoid
UTC Build Time: 2024-05-01 06:19:47
GoVersion: go1.21.0
Race Enabled: false
Check Table Before Drop: false
Store: tikv |
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.009 sec)

[tiancaiamao]

Duplicated with #52600

Are you testing with 8.1? It has not merge the cherry-pick yet #53000
@guo-shaoge

[guo-shaoge]

Duplicated with #52600

Are you testing with 8.1? It has not merge the cherry-pick yet #53000 @guo-shaoge

No, I tested it with v7.5.1.