Not the answer you need?
Register and ask your own question!

the error about pt-query-digest + tcpdump

bock.tangbock.tang EntrantCurrent User Role Beginner
Dear all;

I am use the tools of pt-query-digest + tcpdump according to the manual of https://www.percona.com/doc/percona-toolkit/3.0/pt-query-digest.html
tcpdump -s 65535 -x -nn -q -tttt -i any -c 1000 port 3306 > mysql.tcp.txt pt-query-digest --type tcpdump mysql.tcp.txt
operation system: CentOS 7.7 x86-64
mySQL: 8.0.18
percona-toolkit: percona-toolkit-3.1.0

first,I execute "tcpdump -s 65535 -x -nn -q -tttt -i any -c 1000 port 3306 > mysql.tcp.txt" <<< root user
then; I use mysql workbench connect to MySQL and run some SQLs
third; I execute "pt-query-digest --type tcpdump mysql.tcp.txt"
but I got some errors:

TCP session 172.16.0.1:50321 had errors, will save them in /tmp/pt-query-digest-errors.u8fGb4B
Pipeline process 4 (MySQLProtocolParser) caused an error: Argument "" isn't numeric in multiplication (*) at /opt/mysql/tools/ptkit/bin/pt-query-digest line 4525, <> line 11.
Will retry pipeline process 3 (MySQLProtocolParser) 100 more times.
Pipeline process 4 (MySQLProtocolParser) caused an error: Argument "" isn't numeric in multiplication (*) at /opt/mysql/tools/ptkit/bin/pt-query-digest line 4525, <> line 13.
...

I uploaded the tcpdump(raw file) and error file,I need help,thanks.

Comments

Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.