2014-12-15 18:07:45 |
Ovais Tariq |
bug |
|
|
added bug |
2014-12-15 18:08:31 |
Ovais Tariq |
description |
When parsing a tcpdump file created with MySQL 5.6 with pt-query-digest the "use database" statements are parsed incorrectly.
The database name is appended with a null character and the string "mysql_native_password".
The Percona toolkit version used is 2.2.11.
The tcpdump command line used is the following:
/usr/sbin/tcpdump -i eth0 -s 65535 -x -n -q -tttt 'port 3306 and tcp[1] & 7 == 2 and tcp[3] & 7 == 2'
The pt-query-digest command line used is the following:
/usr/bin/pt-query-digest --type tcpdump /tmp/mysql.tcp.out \
--output slowlog --no-report \
--filter '($event->{fingerprint} =~ m/^select/i) && ($event->{arg} !~ m/for update/i) && ($event->{fingerprint} !~ m/some_table_name_to_ignore/i)' \
> /tmp/slow.log.out 2> /dev/null |
When parsing a tcpdump file created with MySQL 5.6 with pt-query-digest the "use database" statements are parsed incorrectly.
The database name is appended with a null character and the string "mysql_native_password".
The Percona toolkit version used is 2.2.11.
The tcpdump command line used is the following:
/usr/sbin/tcpdump -i eth0 -s 65535 -x -n -q -tttt 'port 3306 and tcp[1] & 7 == 2 and tcp[3] & 7 == 2'
The pt-query-digest command line used is the following:
/usr/bin/pt-query-digest --type tcpdump /tmp/mysql.tcp.out --output slowlog --no-report --filter '($event->{fingerprint} =~ m/^select/i) && ($event->{arg} !~ m/for update/i) && ($event->{fingerprint} !~ m/some_table_name_to_ignore/i)' > /tmp/slow.log.out 2> /dev/null |
|
2015-01-17 15:45:04 |
everflux |
bug |
|
|
added subscriber everflux |
2015-01-19 11:27:39 |
Nilnandan Joshi |
attachment added |
|
FirstExample.java https://bugs.launchpad.net/percona-toolkit/+bug/1402776/+attachment/4301691/+files/FirstExample.java |
|
2015-01-19 11:27:46 |
Nilnandan Joshi |
percona-toolkit: status |
New |
Incomplete |
|
2015-01-20 13:22:33 |
Nilnandan Joshi |
bug |
|
|
added subscriber Nilnandan Joshi |
2015-01-23 20:55:47 |
Frank Cizmich |
percona-toolkit: status |
Incomplete |
Triaged |
|
2015-01-23 20:55:55 |
Frank Cizmich |
percona-toolkit: importance |
Undecided |
Medium |
|
2015-01-23 21:22:03 |
Frank Cizmich |
tags |
|
pt-query-digest |
|
2015-01-25 22:21:42 |
Frank Cizmich |
percona-toolkit: assignee |
|
Frank Cizmich (frank-cizmich) |
|
2015-01-25 22:22:02 |
Frank Cizmich |
percona-toolkit: milestone |
|
2.2.14 |
|
2015-01-26 15:59:00 |
Tim Pearson |
bug |
|
|
added subscriber Tim Pearson |
2015-04-09 14:25:54 |
Frank Cizmich |
percona-toolkit: milestone |
2.2.14 |
|
|
2015-08-25 14:12:32 |
Rick Pizzi |
bug |
|
|
added subscriber Rick Pizzi |
2015-10-05 12:01:54 |
Frank Cizmich |
percona-toolkit: status |
Triaged |
In Progress |
|
2015-10-05 12:01:56 |
Frank Cizmich |
percona-toolkit: milestone |
|
2.3.1 |
|
2016-03-03 16:06:39 |
Hrvoje Matijakovic |
percona-toolkit: milestone |
2.2.17 |
2.2.18 |
|
2016-03-24 21:02:21 |
Sveta Smirnova |
tags |
pt-query-digest |
i67231 pt-query-digest |
|
2016-04-04 23:09:32 |
Jenni Snyder |
bug |
|
|
added subscriber Jenni Snyder |
2016-04-05 09:51:18 |
Avadhut Phatarpekar |
bug |
|
|
added subscriber Avadhut Phatarpekar |
2016-06-08 11:04:55 |
Sveta Smirnova |
attachment added |
|
tcpdump output https://bugs.launchpad.net/percona-toolkit/+bug/1402776/+attachment/4679762/+files/mysqltcp.txt |
|
2016-06-08 11:05:15 |
Sveta Smirnova |
attachment added |
|
pt-query-digest log https://bugs.launchpad.net/percona-toolkit/+bug/1402776/+attachment/4679763/+files/out.log |
|
2016-06-08 11:05:34 |
Sveta Smirnova |
attachment added |
|
pt-query-digest error log https://bugs.launchpad.net/percona-toolkit/+bug/1402776/+attachment/4679764/+files/err.log |
|
2016-06-13 18:19:42 |
Frank Cizmich |
percona-toolkit: status |
In Progress |
Fix Committed |
|
2016-06-24 13:10:19 |
EvgeniyPatlan |
percona-toolkit: status |
Fix Committed |
Fix Released |
|
2016-11-16 21:16:53 |
Carlos Salguero |
percona-toolkit: milestone |
2.2.18 |
2.2.20 |
|
2016-11-16 21:16:59 |
Carlos Salguero |
percona-toolkit: status |
Fix Released |
In Progress |
|
2016-11-16 21:17:06 |
Carlos Salguero |
percona-toolkit: assignee |
Frank Cizmich (frank-cizmich) |
Carlos Salguero (carlos-salguero) |
|
2016-12-06 15:27:21 |
Carlos Salguero |
percona-toolkit: milestone |
2.2.20 |
2.2.21 |
|
2016-12-17 01:52:10 |
Carlos Salguero |
percona-toolkit: status |
In Progress |
Fix Committed |
|
2017-05-26 18:41:45 |
Carlos Salguero |
percona-toolkit: status |
Fix Committed |
Fix Released |
|