Failed to read auto-increment value from storage engine

[aytrack]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

CREATE TABLE UK_5046 (COL1 BIGINT(46) AUTO_INCREMENT COMMENT 'AUTO INCREMENT FOR UK',COL2 VARCHAR(20),COL3 DATETIME,COL4 BIGINT,COL5 FLOAT,UNIQUE KEY UK_COL1(COL1)) AUTO_INCREMENT = 1000;
insert into UK_5046 (COL1,COL2,COL3,COL4,COL5) values(-9223372036854775808,"瀫飾鸂驻浅鞯敦洁姴餶鄾倣ľ膉椋鵣韵璄謈塱","0880\-04\-15\ 14:51:47",5324810252090160585,6.71788281780488e+37);
insert into UK_5046 (COL1,COL2,COL3,COL4,COL5) values(9223372036854775807,"羟劗屸鲫橲轧鮌溝觳望煃冨勒Q駝昫Ķ鱭帶盆","4419\-05\-13\ 16:46:35",-8255166187230039281,3.2907630702134185e+38);
insert into UK_5046 (COL1,COL2,COL3,COL4,COL5) values(-8100164477646717705,"礠崍鮐鏆裲忈幼洽鋁歊詶讖尌杩鲸蛧璡翃腀羜","0336\-10\-26\ 09:08:32",-5161287593627465637,1.2373522472022954e+38);
insert into UK_5046 (COL1,COL2,COL3,COL4,COL5) values(100,"礠崍鮐鏆裲忈幼洽鋁歊詶讖尌杩鲸蛧璡翃腀羜","0336\-10\-26\ 09:08:32",-5161287593627465637,1.2373522472022954e+38);

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

all data insert successfully

3. What did you see instead (Required)

mysql test> insert into UK_5046 (COL1,COL2,COL3,COL4,COL5) values(-9223372036854775808,"瀫飾鸂驻浅鞯敦洁姴餶鄾倣ľ膉椋鵣韵璄謈塱","0880\-04\-15\ 14:51:47",5324810252090160585,6.71788281
                          ->  780488e+37);
Query OK, 1 row affected
Time: 0.303s
mysql test> insert into UK_5046 (COL1,COL2,COL3,COL4,COL5) values(9223372036854775807,"羟劗屸鲫橲轧鮌溝觳望煃冨勒Q駝昫Ķ鱭帶盆","4419\-05\-13\ 16:46:35",-8255166187230039281,3.290763070
                          ->  2134185e+38);
(1467, 'Failed to read auto-increment value from storage engine')
mysql test> insert into UK_5046 (COL1,COL2,COL3,COL4,COL5) values(-8100164477646717705,"礠崍鮐鏆裲忈幼洽鋁歊詶讖尌杩鲸蛧璡翃腀羜","0336\-10\-26\ 09:08:32",-5161287593627465637,1.237352
                          ->  2472022954e+38);
(1467, 'Failed to read auto-increment value from storage engine')
mysql test> insert into UK_5046 (COL1,COL2,COL3,COL4,COL5) values(100,"礠崍鮐鏆裲忈幼洽鋁歊詶讖尌杩鲸蛧璡翃腀羜","0336\-10\-26\ 09:08:32",-5161287593627465637,1.2373522472022954e+38);
(1467, 'Failed to read auto-increment value from storage engine')

4. What is your TiDB version? (Required)

+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| tidb_version()                                                                                                                                                                                                                                                                                                               |
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Release Version: v4.0.10\nEdition: Community\nGit Commit Hash: dbade8cda4c5a329037746e171449e0a1dfdb8b3\nGit Branch: heads/refs/tags/v4.0.10\nUTC Build Time: 2021-01-15 02:59:27\nGoVersion: go1.13\nRace Enabled: false\nTiKV Min Version: v3.0.0-60965b006877ca7234adaced7890d7b029ed1306\nCheck Table Before Drop: false |
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

It's similar to #10481 but has a different behavior

[ti-srebot]

This issue contains Chinese, please use English.

[bb7133]

This is actually duplicated with #982.

It will be fixed by #20708, but it may lead to some compatibility issues, so the PR is not merged yet.

[morgo]

Closing as a duplicate of #982

Thanks!

[glkappe]

@bb7133 is it merged for this issue?