pt-online-schema change fails if foreign key name is too long
Bug #1727137 reported by
Aleksandr Kuzminsky
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Toolkit moved to https://jira.percona.com/projects/PT |
New
|
Undecided
|
Unassigned |
Bug Description
MySQL poses a limit on max length of foreign key name.
pt-osc renames foreign key by adding a prefix. If the initial FK name is as long as the limit renaming the FK will fail. pt-osc subsequently fails as well.
After the failure pt-osc leaves tables in broken state. The table is renamed but foreign keys refer to the _old table.
To post a comment you must log in.
Percona now uses JIRA for bug reports so this bug report is migrated to: https:/ /jira.percona. com/browse/ PT-1453