Using percona toolkit 2.1.7 I'm still getting the error:
perl percona-toolkit-2.1.7/bin/pt-table-sync --print --verbose --set-vars wait_timeout=30000 -t xxxxxxx --ignore-columns xxxxxxx --no-foreign-key-checks --sync-to-master --chunk-size=200 --chunk-column ID h=xxxxxxx,u=xxxxxxx,p=xxxxxxx >> 12282012_4.log
Cannot nibble table `xxxxxxx`.`xxxxxxx` because MySQL chose no index instead of the `PRIMARY` index at percona-toolkit-2.1.7/bin/pt-table-sync line 5407. while doing DB.TABLE on HOST.
Using percona toolkit 2.1.7 I'm still getting the error:
perl percona- toolkit- 2.1.7/bin/ pt-table- sync --print --verbose --set-vars wait_timeout=30000 -t xxxxxxx --ignore-columns xxxxxxx --no-foreign- key-checks --sync-to-master --chunk-size=200 --chunk-column ID h=xxxxxxx, u=xxxxxxx, p=xxxxxxx >> 12282012_4.log toolkit- 2.1.7/bin/ pt-table- sync line 5407. while doing DB.TABLE on HOST.
Cannot nibble table `xxxxxxx`.`xxxxxxx` because MySQL chose no index instead of the `PRIMARY` index at percona-
Do we have any workaround?