Skip to content
New issue

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

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

Already on GitHub? Sign in to your account

Concurrent Column Type Change would cause inconsistent schema and data #31048

Closed
wjhuang2016 opened this issue Dec 27, 2021 · 1 comment · Fixed by #31051
Closed

Concurrent Column Type Change would cause inconsistent schema and data #31048

wjhuang2016 opened this issue Dec 27, 2021 · 1 comment · Fixed by #31051
Assignees
Labels
affects-5.1 This bug affects 5.1.x versions. affects-5.2 This bug affects 5.2.x versions. affects-5.3 This bug affects 5.3.x versions. severity/critical sig/sql-infra SIG: SQL Infra type/bug This issue is a bug.

Comments

@wjhuang2016
Copy link
Member

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

create table test(a int, b int);
insert into test values (1, 1);
alter table test change column b b double; /* in session 1 */
alter table test change column b b double; /* in session 2 */
select * from test;

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

No error

3. What did you see instead (Required)

mysql> select * from test;
ERROR 1105 (HY000): insufficient bytes to decode value

4. What is your TiDB version? (Required)

5.1 5.2 5.3 master

@wjhuang2016 wjhuang2016 added type/bug This issue is a bug. affects-5.1 This bug affects 5.1.x versions. affects-5.2 This bug affects 5.2.x versions. affects-5.3 This bug affects 5.3.x versions. severity/critical sig/sql-infra SIG: SQL Infra labels Dec 27, 2021
ti-chi-bot pushed a commit that referenced this issue Dec 28, 2021
@github-actions
Copy link

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
affects-5.1 This bug affects 5.1.x versions. affects-5.2 This bug affects 5.2.x versions. affects-5.3 This bug affects 5.3.x versions. severity/critical sig/sql-infra SIG: SQL Infra type/bug This issue is a bug.
Projects
None yet
2 participants