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

A DDL job cannot be continued or rolled back #114

Closed
mybjlife opened this issue Dec 15, 2022 · 0 comments
Closed

A DDL job cannot be continued or rolled back #114

mybjlife opened this issue Dec 15, 2022 · 0 comments

Comments

@mybjlife
Copy link

The original issue is from the parent project:
polardb/polardbx#3

Repro steps:

  1. Create a table:
    CREATE TABLE test (
    col1 varchar(255) DEFAULT NULL,
    col2 varchar(255) NOT NULL,
    id int(11) NOT NULL AUTO_INCREMENT,
    PRIMARY KEY (id,col2)
    ) ENGINE = InnoDB DEFAULT CHARSET = utf8 ;

  2. Drop the primary key, drop a column and add a new primary key:
    ALTER TABLE test
    DROP PRIMARY KEY,
    DROP COLUMN col2,
    ADD PRIMARY KEY (id) USING BTREE;

Error: Failed to execute the DDL task. Caused by: Illegal Capacity: -1

  1. "SHOW FULL DDL" returns a PAUSED DDL job.

  2. Cannot rollback the DDL job via CANCEL DDL.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant