pt-online-schema-change resume functionality doesn't work with ADD INDEX

Description

OSC fails to resume an alter that adds an index. Version is 8.0.31 for SQL, 3.6.0 for OSC.

The source is METADATA_ENTRY and the destination _METADATA_ENTRY_new.

I am testing on Dev and causing the interruption deliberately by stopping the MySQL instance. See below for the OSC invocations and select output.


Original invocation:

Log message & job ID when I restart the MySQL instance:

Resume invocation:

Environment

None

AFFECTED CS IDs

CS0052072

Activity

Show:

Sveta Smirnova yesterday

This is fixed by fix for .

Adam Nichols November 14, 2024 at 5:32 PM

Thank you for the reply, I will give it a shot.

Aaditya Dubey November 6, 2024 at 4:08 PM

Hi

Thank you for the report.
This report is now verified.
Please use the same test case that is mentioned here at

After building the table and data, please run the following command:

kill the job using ctrl+c

Resume the job:

Done

Details

Assignee

Reporter

Priority

Components

Affects versions

Fix versions

Needs QA

Yes

Smart Checklist

Created October 16, 2024 at 6:10 PM
Updated yesterday
Resolved yesterday