pt-upgrade produces wrong outputs if the query is larger than 1455 chars

Bug #1587412 reported by Miguel Angel Nieto
6
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

If some of your queries is larger than 1455, it breaks. It tries to run queries like this:

SELECT ..... (1455 characters later)^M^D...

And of course, it fails to run that query.

The problem could happen in different ways.

Sometimes the query text is cut at that point, adding some garbage characters as shown before.

Sometimes it adds the garbage and then start a new query text. Mixing two different queries in one, so it fails to execute it too:

SELECT ..... (1455 characters later)^M^D^@^@^CSELECT whatever...

Tags: i69667 pt159
tags: added: i69667
Przemek (pmalkowski)
Changed in percona-toolkit:
status: New → Confirmed
Changed in percona-toolkit:
status: Confirmed → In Progress
assignee: nobody → Miguel Angel Nieto (miguelangelnieto)
Changed in percona-toolkit:
assignee: Miguel Angel Nieto (miguelangelnieto) → nobody
status: In Progress → Incomplete
tags: added: pt159
Revision history for this message
Launchpad Janitor (janitor) wrote :

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

Changed in percona-toolkit:
status: Incomplete → Expired
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

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

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

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.