pt-query-digest stops digesting log when it encounters DELETE statement

Polyglot Projects Percona Toolkit
1

I’m trying to digest some slow query logs but pt-query-digest appears to stop working when it encounters a DELETE statement. The tool still takes a long time so it would appear that it is digesting the entire file but fails to report the DELETE statements in the report. It will either give me only the DELETE statement and then fail to give me everything else or only give me the other statements without the DELETE statement.

Here is the DELETE statement from the slow query log file:

User@Host: abc[abc] @ [##.#.#.#]

Query_time: 0.013774 Lock_time: 0.000049 Rows_sent: 0 Rows_examined: 16094

use my_db;
SET timestamp=1420780225;
DELETE FROM sessions WHERE date_modified < ‘2015-01-07 22:10:25’;

When I execute pt-query-digest I do it like this: /opt/percona-toolkit-2.2.12/bin/pt-query-digest /opt/slow_query.log > /opt/slow_query_report.txt

Anyone know why the tool is failing to put the DELETE statements into the report?

2

Can you please run pt-query-digest with PTDEBUG=1. This will generate lots of debugging output and will help to identify what causing the issue.

$ PTDEBUG=1 output.log 2>&1