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

Don't update next Key in cache lead to update the wrong next key to storage when modifying column interrupted #39644

Closed
zimulala opened this issue Dec 5, 2022 · 0 comments · Fixed by #39645
Assignees
Labels
severity/moderate sig/sql-infra SIG: SQL Infra type/bug The issue is confirmed as a bug.

Comments

@zimulala
Copy link
Contributor

zimulala commented Dec 5, 2022

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

create table t1 (c1 int, c2 int, c3 int, index idx(c2), index idx1(c1, c2));
alter table t1 change c2 c2 mediumint;
admin check table t1;

When executing modify column statement in the write-reorg state(handling backfill of the first index), encounter a retried error like TxnRetryableError or ErrNotOwner(This error is currently being handled incorrectly).

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

Execute successfully.

3. What did you see instead (Required)

Data indexes are inconsistent.

At present, because ErrNotOwner does not have this problem, TxnRetryableError is difficult to appear (generally a high success rate, in addition, you can retry 10 times). So I set it to [severity/moderate].

4. What is your TiDB version? (Required)

Release Version: v6.5.0-alpha-271-g5127ad25b
Edition: Community
Git Commit Hash: 5127ad25b5e05ae550be148ffaa50c41b2348c80
Git Branch: master
UTC Build T
@zimulala zimulala added type/bug The issue is confirmed as a bug. severity/moderate labels Dec 5, 2022
@zimulala zimulala self-assigned this Dec 5, 2022
@ChenPeng2013 ChenPeng2013 added the sig/sql-infra SIG: SQL Infra label Dec 6, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
severity/moderate 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.

2 participants