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

Unexpected error "DDL reorg element does not exist" when adding index #41381

Closed
tangenta opened this issue Feb 14, 2023 · 0 comments · Fixed by #41383
Closed

Unexpected error "DDL reorg element does not exist" when adding index #41381

tangenta opened this issue Feb 14, 2023 · 0 comments · Fixed by #41383
Labels
severity/moderate type/bug The issue is confirmed as a bug.

Comments

@tangenta
Copy link
Contributor

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

create table t(id int primary key, b int);
insert into t values (1, 1);
alter table t add unique index idx(b);

insert into t values (2, 1); -- write only
admin cancel ddl jobs X; -- the job must be rolling back because of the duplicated entry

It is not easy to reproduce with MySQL client because the state changes are usually fast.

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

Cancelled DDL job

or

Duplicate entry '1' for key 't.idx'

3. What did you see instead (Required)

ERROR 8235 (HY000): DDL job rollback, error msg: DDL reorg element does not exist

4. What is your TiDB version? (Required)

@tangenta tangenta added type/bug The issue is confirmed as a bug. severity/moderate labels Feb 14, 2023
@tangenta tangenta changed the title Unexpected error "DDL reorg element does not exist" for adding index Unexpected error "DDL reorg element does not exist" when adding index Feb 14, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
severity/moderate type/bug The issue is confirmed as a bug.
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant