pt-upgrade fails if select column > 64 chars
Bug #1060774 reported by
Chris Howells
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Toolkit moved to https://jira.percona.com/projects/PT |
Fix Released
|
Medium
|
Daniel Nichter |
Bug Description
My slow query log (generated from the real log by pt-query-digest contains the following query):
use XXX;
SELECT (UNIX_TIMESTAMP
(I've obscured the DB name)
This unfortunately causes pt-upgrade to break:
# pt_upgrade:10801 5341 DBD::mysql::db do failed: Identifier name '(UNIX_
#
Newline in left-justified string for sprintf at /usr/bin/pt-upgrade line 8293, <$fh> line 23515.
[root@toolkit]# pt-upgrade --version
pt-upgrade 2.1.3
[root@toolkit]# cat /etc/issue
CentOS release 5.7 (Final)
Kernel \r on an \m
Related branches
lp:~percona-toolkit-dev/percona-toolkit/fix-pt-upgrade-select-bug-1060774
- Daniel Nichter: Approve
-
Diff: 129 lines (+79/-2)6 files modifiedbin/pt-upgrade (+8/-1)
lib/MockSyncStream.pm (+11/-1)
t/pt-upgrade/basics.t (+18/-0)
t/pt-upgrade/samples/004/select-func.log (+4/-0)
t/pt-upgrade/samples/004/select-func.txt (+36/-0)
t/pt-upgrade/samples/004/tables.sql (+2/-0)
Changed in percona-toolkit: | |
status: | Fix Committed → Fix Released |
To post a comment you must log in.
Have (or can you) try 2.1.4? If I recall correctly, 2.1.4 has fixes to prevent these kind of printing errors from crashing the tool (the latter one I'm pretty sure of; the former "too long" error maybe not).