pt-query-digest reports 'No events processed.' with --since option for mysql 5.7
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Toolkit moved to https://jira.percona.com/projects/PT |
Fix Released
|
Undecided
|
Carlos Salguero |
Bug Description
Time field in slow log in 5.7 has new format:
"Time: 2016-05-
Quick fix for pt-query-digest tool:
#!/bin/bash
wget http://
patch <<- 'pt-query-
--- pt-query-
+++ pt-query-digest 2016-05-14 07:00:17.075913159 +0000
@@ -4971,7 +4971,7 @@ sub new {
return bless $self, $class;
}
-my $slow_log_ts_line = qr/^# Time: ([0-9: ]{15})/;
+my $slow_log_ts_line = qr/^# Time: ((?:[0-9: ]{15})|(?:[-0-9: T]{19}))/;
my $slow_log_uh_line = qr/# User\@Host: ([^\[]+
my $slow_log_hd_line = qr{
^(?:
pt-query-
chmod +x ./pt-query-digest
./pt-query-digest --since=2016-05-09 /var/lib/
Changed in percona-toolkit: | |
status: | New → Confirmed |
Changed in percona-toolkit: | |
status: | Confirmed → Fix Committed |
milestone: | none → 2.2.19 |
assignee: | nobody → Carlos Salguero (carlos-salguero) |
Changed in percona-toolkit: | |
status: | Fix Committed → Fix Released |
PR: https:/ /github. com/percona/ percona- toolkit/ pull/90