pt-query-digest aborts with an error when using --tables on a currently open binlog

[Fernando Ipar]

Running pt-query-digest with --group-by tables on a binlog that is still in use, exits with this error:

nice ./pt-query-digest --group-by tables /path/to/bin.log
Pipeline process 8 (tables) caused an error: Substitution loop at ./pt-query-digest line 7495, <> line 1.

I believe we should print out a more useful message instead. This may impact other options too, this happened while running it with a customer.

[Fernando Ipar (fipar)]

Binlog size right before running the tool was 1073742645 bytes.

[Baron Schwartz (baron-xaprb)]

You can't parse a binlog in binary format. It needs to be converted to quasi-SQL with mysqlbinlog. Did you do that?

The error message you reported is from Perl internals, not from the tool.

[Fernando Ipar (fipar)]

Checked with the customer and this was run using the binlog directly as input.
I think this can be closed as this will be implemented by https://blueprints.launchpad.net/percona-toolkit/+spec/detect-log-type right?

On Feb 23, 2012, at 2:11 PM, Baron Schwartz wrote:

> You can't parse a binlog in binary format. It needs to be converted to
> quasi-SQL with mysqlbinlog. Did you do that?
>
> The error message you reported is from Perl internals, not from the
> tool.
>

[Baron Schwartz (baron-xaprb)]

Yes, we should close this issue then.

[Shahriyar Rzayev (rzayev-sehriyar)]

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