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.
Revision history for this message
| Shahriyar Rzayev (rzayev-sehriyar) wrote | #1 |
To post a comment you must log in.
Percona now uses JIRA for bug reports so this bug report is migrated to: https:/