Percona Toolkit moved to https://jira.percona.com/projects/PT

pt-upgrade results truncated if hostnames are long

Bug #980318 reported by Sean O'Connell
10
This bug affects 2 people
Affects Status Importance Assigned to Milestone
Percona Toolkit moved to https://jira.percona.com/projects/PT
Fix Released
High
Daniel Nichter
Percona Toolkit moved to https://jira.percona.com/projects/PT 2.1.3

Bug Description

When comparing DSNs with fairly long hostnames plus port number, the results for the second machine show up as an ellipsis. In my case the FQDN plus port number for each machine was 38 characters (33 in the hostname), and I only saw the first 27 characters of the second host above the hidden results. If I modify use DSN to use non-FQDN for each, I see the results for both servers.

See original description
Revision history for this message
Sean O'Connell (slzd) wrote :

To follow up, I am using version 2.1.1

pt-upgrade --version
pt-upgrade 2.1.1

Sean O'Connell (slzd)
description: updated
Revision history for this message
Baron Schwartz (baron-xaprb) wrote :

Thanks for the report. We shorten the values so they don't linewrap. However there have been other complaints that the format of the report isn't very useful, so it is possible we will change this in the future. It even seems reasonable to print out something like this at the beginning:

A = host1
B = host2

And then use A and B thereafter.

Changed in percona-toolkit:
status: New → Confirmed
importance: Undecided → Wishlist
Revision history for this message
Sean O'Connell (slzd) wrote :

That would be great. I was think it could be done per query type

# Query N: ID ..
# Server1: hostname:port
# Server2: hostname:port
#
# Found X differences
# ..
# Server 1 Server2
#

The main issue I have with the truncation is the results for the second server are shown as '...' the hostname truncation is more off a side effect.

Revision history for this message
Sean O'Connell (slzd) wrote :
Daniel Nichter (daniel-nichter)
tags: added: pt-upgrade wrong-output
Daniel Nichter (daniel-nichter)
Changed in percona-toolkit:
assignee: nobody → Daniel Nichter (daniel-nichter)
importance: Wishlist → High
status: Confirmed → In Progress
milestone: none → 2.1.3
tags: added: percona-24578
Daniel Nichter (daniel-nichter)
Changed in percona-toolkit:
status: In Progress → Fix Committed
Daniel Nichter (daniel-nichter)
summary: - Long hostnames prevent display of full results
+ pt-upgrade results truncated if hostnames are long
Daniel Nichter (daniel-nichter)
Changed in percona-toolkit:
status: Fix Committed → Fix Released
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-307

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

Other bug subscribers

Remote bug watches

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