pt-online-schema-change resume functionality doesn't work with ADD INDEX
General
Escalation
General
Escalation
Description
Environment
None
AFFECTED CS IDs
CS0052072
relates to
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:
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: