pt-online-schema-change utf8 chinese comments be messy

Bug #1504497 reported by MrZhang on 2015-10-09
8
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Toolkit moved to https://jira.percona.com/projects/PT
Expired
Undecided
Unassigned

Bug Description

Mysql version: 5.1
percona tookit version:2.2.1
Command:./pt-online-schema-change --alter "add index scid (scid)" D=baidutui,t=goods_scid -u root -p ***** --execute

My table use utf8 utf8_general_ci and with chinese comments.
When I use pt-online-schema-change to add index , everything goes well and then success terminated.
But I saw the chinese comments become '?????';

Hi,

It seems, you are using old version. Can you please try with latest version of Percona Tollkit 2.2.15 and let us know if you still face this issue?

https://www.percona.com/downloads/percona-toolkit/

If yes, then please provide table structure, PTDEBUG=1 output of that command and test case if possible.

Changed in percona-toolkit:
status: New → Incomplete
Launchpad Janitor (janitor) wrote :

[Expired for Percona Toolkit because there has been no activity for 60 days.]

Changed in percona-toolkit:
status: Incomplete → Expired
responder (responder-s) wrote :

To whom it may concern, I encountered the same issue today (on 2.2.16-1).

Thanks to PTDEBUG=1 trace, I found the issue came from the default mysql client charset is latin1.

After added 'default-character-set=utf8' into my.cnf [client] section, the problem solved! : )

Didn't tested, but --charset or A=utf8 should do the magic, too.

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

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers