pt-table-checksum checksum error when default-character-set = utf8
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Toolkit moved to https://jira.percona.com/projects/PT |
Fix Released
|
High
|
Frank Cizmich |
Bug Description
Received Error executing checksum query messages on several tables. Was working successfully from a remote server but not on localhost.
Failing hosts had "default-
Once "loose-
-bash-3.2$ pt-table-checksum --version
pt-table-checksum 2.0.2
mysql> select version();
+------------+
| version() |
+------------+
| 5.5.17-log |
+------------+
1 row in set (0.00 sec)
-bash-3.2$ pt-table-checksum h=c1-dbdev103,
Enter MySQL password:
TS ERRORS DIFFS ROWS CHUNKS SKIPPED TIME TABLE
02-02T13:47:50 0 0 3 1 0 1.018 HMS_CampaignAPI
02-02T13:47:51 0 0 1 1 0 0.279 HMS_CampaignAPI
02-02T13:47:51 Error checksumming table HMS_CampaignAPI
02-02T13:47:51 1 0 0 1 0 0.004 HMS_CampaignAPI
02-02T13:47:51 Error checksumming table HMS_CampaignAPI
02-02T13:47:51 1 0 0 1 0 0.003 HMS_CampaignAPI
02-02T13:47:51 0 0 0 1 0 0.012 HMS_CampaignAPI
02-02T13:47:51 0 0 0 1 0 0.011 HMS_CampaignAPI
02-02T13:47:51 Error checksumming table HMS_CampaignAPI
02-02T13:47:51 1 0 0 1 0 0.003 HMS_CampaignAPI
02-02T13:47:51 Error checksumming table HMS_CampaignAPI
02-02T13:47:51 1 0 0 1 0 0.003 HMS_CampaignAPI
02-02T13:47:51 Error checksumming table HMS_CampaignAPI
02-02T13:47:51 1 0 0 1 0 0.003 HMS_CampaignAPI
02-02T13:47:51 0 0 0 1 0 0.259 HMS_CampaignAPI
02-02T13:48:56 0 0 0 1 0 0.005 mysql.columns_priv
02-02T13:48:56 0 0 13 1 0 0.004 mysql.db
02-02T13:48:56 0 0 0 1 0 0.006 mysql.event
02-02T13:48:56 0 0 0 1 0 0.007 mysql.func
02-02T13:48:56 0 0 38 1 0 0.005 mysql.help_category
02-02T13:48:56 0 0 453 1 0 0.006 mysql.help_keyword
02-02T13:48:56 0 0 992 1 0 0.006 mysql.help_relation
02-02T13:48:56 0 0 505 1 0 0.009 mysql.help_topic
02-02T13:48:56 0 0 0 1 0 0.005 mysql.host
02-02T13:48:56 0 0 0 1 0 0.005 mysql.ndb_
02-02T13:48:56 0 0 0 1 0 0.006 mysql.plugin
02-02T13:48:56 0 0 0 1 0 0.005 mysql.proc
02-02T13:48:56 0 0 0 1 0 0.006 mysql.procs_priv
02-02T13:48:56 0 0 2 1 0 0.007 mysql.proxies_priv
02-02T13:48:56 0 0 0 1 0 0.005 mysql.servers
02-02T13:48:56 0 0 3 1 0 0.005 mysql.tables_priv
02-02T13:48:56 0 0 0 1 0 0.006 mysql.time_zone
02-02T13:48:56 0 0 0 1 0 0.005 mysql.time_
02-02T13:48:56 0 0 0 1 0 0.005 mysql.time_
02-02T13:48:56 0 0 0 1 0 0.006 mysql.time_
02-02T13:48:56 0 0 0 1 0 0.006 mysql.time_
02-02T13:48:56 0 0 52 1 0 0.008 mysql.user
-bash-3.2$
Related branches
- Percona Toolkit developers: Pending requested
-
Diff: 285 lines (+92/-67)5 files modifiedbin/pt-table-checksum (+15/-8)
lib/Quoter.pm (+18/-13)
lib/Sandbox.pm (+3/-3)
lib/TableChunker.pm (+2/-27)
t/lib/Quoter.t (+54/-16)
- Daniel Nichter: Approve
-
Diff: 115 lines (+42/-13)2 files modifiedbin/pt-table-checksum (+41/-12)
t/pt-table-checksum/progress.t (+1/-1)
tags: | added: charset pt-table-checksum wrong-sql |
Changed in percona-toolkit: | |
assignee: | nobody → Brian Fraser (fraserbn) |
Changed in percona-toolkit: | |
assignee: | Brian Fraser (fraserbn) → nobody |
tags: | added: i37064 |
Changed in percona-toolkit: | |
assignee: | nobody → Frank Cizmich (frank-cizmich) |
importance: | Undecided → High |
Changed in percona-toolkit: | |
milestone: | none → 2.2.13 |
Changed in percona-toolkit: | |
milestone: | 2.2.13 → 2.2.14 |
Changed in percona-toolkit: | |
status: | In Progress → Fix Committed |
Changed in percona-toolkit: | |
status: | Fix Committed → Fix Released |
I have also tried adding DNS A=utf8 as mentioned in their documentation, but this parameter returns the same errors whether default- character- set = utf8 or loose-default- character- set = utf8 is used. www.percona. com/doc/ percona- toolkit/ 2.0/dsn_ data_source_ name_specificat ions.html
http://
Tests: u=perconaadm --ask-pass --recursion- method= hosts ##with default- character- set = utf8 u=perconaadm, A=utf8 --ask-pass --recursion- method= hosts ##with default- character- set = utf8 u=perconaadm, A=utf8 --ask-pass --recursion- method= hosts ##with loose-default- character- set = utf8 u=perconaadm --ask-pass --recursion- method= hosts ##with loose-default- character- set = utf8
Failed: pt-table-checksum h=c1-dbdev103,
Failed: pt-table-checksum h=c1-dbdev103,
Failed: pt-table-checksum h=c1-dbdev103,
Succeeded: pt-table-checksum h=c1-dbdev103,