Chiming in here as I've run into a problem with both pt-table-sync and pt-archiver. I've written a simple script to first archive a table to a backup table using pt-archiver with delete turned off, and then run pt-table-sync to keep it synced from time to time. Unfortunately, there are thousands of entries that aren't copied correctly on archive and aren't synced corrected due to a specific varchar field not being quoted (from what appears to be due to the field appearing as hex where it's not). Including an example.
The problematic field is: `screen_name`=0xD1
(where screen_name is a twitter username, so obviously not supposed to be hex)
UPDATE `21social_digitalreverie_backup`.`21social_digitalreverie_backup_twitter_users` SET `datetime_unix`='1336517818', `datetime_created_unix`='1189650978', `name_hash`='05bcb7dbe787e88213b68ab1b230133f', `screen_name`=0xD1,
Chiming in here as I've run into a problem with both pt-table-sync and pt-archiver. I've written a simple script to first archive a table to a backup table using pt-archiver with delete turned off, and then run pt-table-sync to keep it synced from time to time. Unfortunately, there are thousands of entries that aren't copied correctly on archive and aren't synced corrected due to a specific varchar field not being quoted (from what appears to be due to the field appearing as hex where it's not). Including an example.
The problematic field is: `screen_name`=0xD1
(where screen_name is a twitter username, so obviously not supposed to be hex)
UPDATE `21social_ digitalreverie_ backup` .`21social_ digitalreverie_ backup_ twitter_ users` SET `datetime_ unix`=' 1336517818' , `datetime_ created_ unix`=' 1189650978' , `name_hash` ='05bcb7dbe787e 88213b68ab1b230 133f', `screen_name`=0xD1,
... additional fields...
`followers_ count`= '1243', `friends_ count`= '1368', `statuses_ count`= '12356' , `favourites_ count`= '105', `listed_ count`= '44', `geo_enabled`='1', `status_sync`='1' WHERE `uid`='8845752' LIMIT 1 /*percona-toolkit src_db: 21social_ digitalreverie_ twitter src_tbl: 21social_ digitalreverie_ twitter_ users src_dsn: A=utf8, D=21social_ digitalreverie_ twitter, h=localhost, p=...,t= 21social_ digitalreverie_ twitter_ users,u= ageis dst_db: 21social_ digitalreverie_ backup dst_tbl: 21social_ digitalreverie_ backup_ twitter_ users dst_dsn: A=utf8, D=21social_ digitalreverie_ backup, h=ubuntu4. 21.grid, p=...,t= 21social_ digitalreverie_ backup_ twitter_ users,u= ageis lock:0 transaction:1 changing_src:0 replicate:0 bidirectional:0 pid:19359 user:root host:ubuntu1*/;