Comment 4 for bug 1082599

Revision history for this message
Ovais Tariq (ovais-tariq) wrote : Re: pt-query-digest fails to parse queries preceded with SET timestamp=x

Daniel,

I have attached the log file that pt-query-digest is failing to parse. Note that removing "set timestamp = xxx" from the log fixes the issue.

For example use the attached slow.log file as follows and pt-query-digest will not parse it correctly:
cat slow.log | pt-query-digest

However, remove the SET TIMESTAMP = xx line and everything works fine:
cat slow.log | sed '/SET timestamp/d' | pt-query-digest