I am using pt-online-schema-change to convert some large tables to the utf8mb4 character set. For a number of tables I am getting an error message similar to the following
The new table
_my_table_newdoes not have a PRIMARY KEY or a unique index which is required for the DELETE trigger.
In each case, I have confirmed that a composite unique key is, in fact, defined on the original table. The error message is referencing the _new version of the table
Does pt-online-schema-change not work with composite unique keys? Is there a specific switch I should be using for it to take effect?
I’m using Aurora MySQL 5.6 and pt-online-schema-change version 3.1.0