When running pt-query-digest on a certain type of database query, I receive the following error. If I run other types of queries, the error does not appear:
The pipeline caused an error: Pipeline process 4 (MySQLProtocolParser) caused an error: Use of uninitialized value $types[0] in hash element at /usr/local/bin/pt-query-digest line 4847, <$fh> line 5343.
Terminating pipeline because process 3 (MySQLProtocolParser) caused too many errors.
I have uploaded two pcaps to github, one with queries that pt-query-digest crashes on, and another from the same system with only queries that work fine. For context, this is a powerdns server. Queries that involve some combination of updating and reading the database are crashing it, while queries that only read from the database (no updates) seem to work fine.
Crashes pt-query-digest: https://github.com/0xBEAKER/0xBEAKER.github.io/blob/master/files/pdns_crash_create_and_query.pcap
Works fine: https://github.com/0xBEAKER/0xBEAKER.github.io/blob/master/files/pdns_only_queries.pcap
Additional info:
Tcpdump command used to collect data:
sudo tcpdump -s 65535 -x -nn -q -tttt -i ens33 tcp port 3306 > tcpdump.pcap
pt-query-digest command:
pt-query-digest --type tcpdump tcpdump.pcap --timeline --no-report