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

Bug #1480719
Comment #8

Comment 8 for bug 1480719

Revision history for this message

Branden Timm (branden-timm) wrote on 2016-01-11:

#8

I'm having the same issue with pt-query-digest on Fedora 23/Perl 5.22.1:

$ PT_DEBUG=1 pt-query-digest --user {} --ask-pass --review h={},t={} --history h={},t={} --resume prod-resume-file slow-log
Enter password for --review:
Enter password for --history:
# Resuming slow-log from offset 0 because resume file slow-log does not exist (file size: 240795165)...
Pipeline process 2 (input) caused an error: Redundant argument in printf at /usr/bin/pt-query-digest line 11122, <$fh> line 75848.
Will retry pipeline process 1 (input) 100 more times.

# Saved resume file stop_offset 240795165 to prod-resume-file

# 43.5s user time, 60ms system time, 79.57M rss, 283.95M vsz
# Current date: Mon Jan 11 07:54:08 2016
# Hostname: localhost.localdomain
# Files: slow-log
Pipeline process 5 (iteration) caused an error: Redundant argument in sprintf at /usr/bin/pt-query-digest line 2556.
Will retry pipeline process 4 (iteration) 2 more times.

# Saved resume file stop_offset 240795165 to prod-resume-file

# 44s user time, 60ms system time, 79.77M rss, 283.95M vsz
# Current date: Mon Jan 11 07:54:09 2016
# Hostname: localhost.localdomain
# Files: slow-log
Pipeline process 5 (iteration) caused an error: Redundant argument in sprintf at /usr/bin/pt-query-digest line 2556.
Will retry pipeline process 4 (iteration) 1 more time.

# Saved resume file stop_offset 240795165 to prod-resume-file

# 44.5s user time, 70ms system time, 79.77M rss, 283.95M vsz
# Current date: Mon Jan 11 07:54:09 2016
# Hostname: localhost.localdomain
# Files: slow-log
The pipeline caused an error: Pipeline process 5 (iteration) caused an error: Redundant argument in sprintf at /usr/bin/pt-query-digest line 2556.
Terminating pipeline because process 4 (iteration) caused too many errors.

# Saved resume file stop_offset 240795165 to prod-resume-file

Even worse, pt-query-digest still writes out resume file offsets as if it had run successfully, even though nothing has been written to the history/review tables. I suppose this should be a separate bug?

$ cat prod-resume-file
start_offset=0
stop_offset=240795165

I'm having the same issue with pt-query-digest on Fedora 23/Perl 5.22.1:

$ PT_DEBUG=1 pt-query-digest --user {} --ask-pass --review h={},t={} --history h={},t={} --resume prod-resume-file slow-log 
Enter password for --review: 
Enter password for --history: 
# Resuming slow-log from offset 0 because resume file slow-log does not exist (file size: 240795165)...
Pipeline process 2 (input) caused an error: Redundant argument in printf at /usr/bin/pt-query-digest line 11122, <$fh> line 75848.
Will retry pipeline process 1 (input) 100 more times.

# Saved resume file stop_offset 240795165 to prod-resume-file

# 43.5s user time, 60ms system time, 79.57M rss, 283.95M vsz
# Current date: Mon Jan 11 07:54:08 2016
# Hostname: localhost.localdomain
# Files: slow-log
Pipeline process 5 (iteration) caused an error: Redundant argument in sprintf at /usr/bin/pt-query-digest line 2556.
Will retry pipeline process 4 (iteration) 2 more times.

# Saved resume file stop_offset 240795165 to prod-resume-file

# 44s user time, 60ms system time, 79.77M rss, 283.95M vsz
# Current date: Mon Jan 11 07:54:09 2016
# Hostname: localhost.localdomain
# Files: slow-log
Pipeline process 5 (iteration) caused an error: Redundant argument in sprintf at /usr/bin/pt-query-digest line 2556.
Will retry pipeline process 4 (iteration) 1 more time.

# Saved resume file stop_offset 240795165 to prod-resume-file

# 44.5s user time, 70ms system time, 79.77M rss, 283.95M vsz
# Current date: Mon Jan 11 07:54:09 2016
# Hostname: localhost.localdomain
# Files: slow-log
The pipeline caused an error: Pipeline process 5 (iteration) caused an error: Redundant argument in sprintf at /usr/bin/pt-query-digest line 2556.
Terminating pipeline because process 4 (iteration) caused too many errors.

# Saved resume file stop_offset 240795165 to prod-resume-file

Even worse, pt-query-digest still writes out resume file offsets as if it had run successfully, even though nothing has been written to the history/review tables.  I suppose this should be a separate bug?

$ cat prod-resume-file
start_offset=0
stop_offset=240795165