Hi,
Getting below error from PT-Archiver…
Unicode surrogate U+D83D is illegal in UTF-8 at /usr/bin/pt-archiver line 6924.
My MySQL version is 5.6, and the character set of the table is UTF8, which stores special characters such as “���”, causing pt-archiver errors. However, I do not have this problem in MySQL version 5.7.
Here are my pt archiver commands:
pt-archiver --no-version-check --source h=xxx,u=root,p=xxx,P=3306,D=zuoning2_v2,t=his_sales_trade_log_ext,A=utf8 --where ‘created < DATE_SUB(NOW(), INTERVAL 1095 DAY)’ --charset utf8 --statistics --limit 100000 --txn-size 100000 --file ./his_sales_trade_log_ext.txt --skip-foreign-key-checks --no-delete