PT- Archiver Error for mysql5.6

MySQL & MariaDB
1

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

2

Hi @runsshark,

You should check how to enable utf8mb4 in your MySQL 5.6 instance to see if it helps.

3

Thank you for your reply. I have thousands of MySQL 5.6 instances all in UTF-8, which store customer data and cannot modify the character set. I can only find a solution to the above problem