pt_sync failed to synchronize this table

[Mike Robinson]

I have a table with three key fields, "colors_cache_id, products_id, and stores_id," all integer, and a "colors" table which is LONGTEXT.

The master table contains 46,197 rows; the out-of-date remote table (which is NOT a replication slave) contains 17,378.

After an I-think-reasonable seven(!) hours spent patiently waiting, I find not only that pt-sync has not reported any progress, but that the number of rows in the target table has not changed at all.

I therefore must conclude that something has gone dreadfully wrong ...

[Carlos Salguero (carlos-salguero)]

Hi,

Could you share the SHOW CREATE TABLE for the table?
When you say "colors" table, did you mean "colors" field?
Also, it would be helpful if you can run the program using:

PTDEBUG=1 pt-table-sync <params>..... and share the output.

Regards

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PT-1451