pt-online-schema-change not finding primary key
When using 2.1.1 of the tool I had an issue with it not finding the primary key. The only way I could get it to use the simple numeric PK was by doing 2 things
1. changing the index detection query ti "select id from <tbl_name> where 1=1"...obviously that only worked because my primary key IS 'ID'
2. Also passing --chunk-
doing #1 without #2 made it try to use a non unique other index which of course, at the copy data part.
Doing just #2 (as some bug in pt-tablechecksum indicates) just fails with this error
"Use of uninitialized value in string eq at /usr/bin/
|Changed in percona-toolkit:|
|assignee:||nobody → Daniel Nichter (daniel-nichter)|