pt-query-digest produces empty output for mysql 5.7 general log with timestamp

Bug #1738128 reported by Nickolay Ihalainen
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Toolkit moved to https://jira.percona.com/projects/PT
Fix Committed
Undecided
Unassigned

Bug Description

/usr/local/mysql/bin/mysqld, Version: 5.7.19-17-log (Percona Server (GPL), Release 17, Revision e19a6b7b73f). started with:
Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock
Time Id Command Argument
2017-12-08T14:56:57.252473-07:00 1 Query BEGIN

Works with:
pt-query-digest 3.0.4

diff --git a/pt-query-digest.orig b/pt-query-digest
index 8c545ac..1636d62 100755
--- a/pt-query-digest.orig
+++ b/pt-query-digest
@@ -9868,7 +9868,7 @@ sub new {

 my $genlog_line_1= qr{
    \A
- (?:(\d{6}\s+\d{1,2}:\d\d:\d\d|\d{4}-\d{1,2}-\d{1,2}T\d\d:\d\d:\d\d\.\d+))?Z? # Timestamp
+ (?:(\d{6}\s+\d{1,2}:\d\d:\d\d|\d{4}-\d{1,2}-\d{1,2}T\d\d:\d\d:\d\d\.\d+(?:Z|-?\d\d:\d\d)))? # Timestamp
    \s+
    (?:\s*(\d+)) # Thread ID
    \s

Changed in percona-toolkit:
status: New → Confirmed
Revision history for this message
Nickolay Ihalainen (ihanick) wrote :
Changed in percona-toolkit:
status: Confirmed → In Progress
Revision history for this message
Carlos Salguero (carlos-salguero) wrote :
Changed in percona-toolkit:
status: In Progress → Fix Committed
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PT-1467

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.