Parsing of tcpdump capture from MySQL 5.6 with pt-query-digest adds erroneous \x0mysql_native_password to "use database" statements
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Toolkit moved to https://jira.percona.com/projects/PT |
Fix Released
|
Medium
|
Carlos Salguero |
Bug 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_
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/
description: | updated |
Changed in percona-toolkit: | |
status: | Incomplete → Triaged |
importance: | Undecided → Medium |
tags: | added: pt-query-digest |
Changed in percona-toolkit: | |
assignee: | nobody → Frank Cizmich (frank-cizmich) |
milestone: | none → 2.2.14 |
Changed in percona-toolkit: | |
milestone: | 2.2.14 → none |
Changed in percona-toolkit: | |
milestone: | 2.2.17 → 2.2.18 |
tags: | added: i67231 |
Changed in percona-toolkit: | |
status: | In Progress → Fix Committed |
Changed in percona-toolkit: | |
status: | Fix Committed → Fix Released |
Changed in percona-toolkit: | |
milestone: | 2.2.18 → 2.2.20 |
status: | Fix Released → In Progress |
assignee: | Frank Cizmich (frank-cizmich) → Carlos Salguero (carlos-salguero) |
Changed in percona-toolkit: | |
milestone: | 2.2.20 → 2.2.21 |
Changed in percona-toolkit: | |
status: | Fix Committed → Fix Released |
Here is a sample dump of $event:
$VAR1 = { index_used => 'No', -java-5. 1.24 ( Revision: ${bzr.revision-id} ) */SHOW VARIABLES WHERE Variable_name =\'language\' OR Variable_name = \'net_write_ timeout\ ' OR Variable_name = \'interactive_ timeout\ ' OR Variable_name = \'wait_timeout\' OR Variable_name = \'character_ set_client\ ' OR Variable_name = \'character_ set_connection\ ' OR Variable_name = \'character_set\' OR Variable_name = \'character_ set_server\ ' OR Variable_name = \'tx_isolation\' OR Variable_name = \'transaction_ isolation\ ' OR Variable_name = \'character_ set_results\ ' OR Variable_name = \'timezone\' OR Variable_name = \'time_zone\' OR Variable_name = \'system_ time_zone\ ' OR Variable_name = \'lower_ case_table_ names\' OR Variable_name = \'max_allowed_ packet\ ' OR Variable_name = \'net_buffer_ length\ ' OR Variable_name = \'sql_mode\' OR Variable_name = \'query_ cache_type\ ' OR Variable_name = \'query_ cache_size\ ' OR Variable_name = \'init_connect\'', @mysql_ native_ password' ,
No_good_
No_index_used => 'Yes',
Query_time => '0.000811',
Rows_affected => 0,
Thread_id => 7181212,
Warning_count => 0,
arg => '/* mysql-connector
bytes => 873,
cmd => 'Query',
db => 'db_name^
fingerprint => 'show variables where variable_name =? or variable_name = ? or variable_name = ? or variable_name = ? or variable_name = ? or variable_name = ? or variable_name = ? or variable_name = ? or variable_name = ? or variable_name = ? or variable_name = ? or variable_name = ? or variable_name = ? or variable_name = ? or variable_name = ? or variable_name = ? or variable_name = ? or variable_name = ? or variable_name = ? or variable_name = ? or variable_name = ?',
host => '192.168.10.25',
ip => '192.168.10.25',
port => '54170',
pos_in_log => 3191192,
ts => '141212 15:33:45.829984',
user => 'db_name'
};