Percona Toolkit moved to https://jira.percona.com/projects/PT

  1. Bug #918056
  2. Comment #6

Comment 6 for bug 918056

Revision history for this message
kedar (k-vaijanapurkar) wrote : Re: "Cannot nibble table" when running pt-table-sync

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.

Do we have any workaround?