LP #1738128: pt-query-digest produces empty output for mysql 5.7 general log with timestamp

Description

**Reported in Launchpad by Nickolay Ihalainen last update 19-12-2017 16:13:16

/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

  • (?disappointed face\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
    + (?disappointed face\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

Environment

None

Smart Checklist

Activity

Show:

lpjirasync January 24, 2018 at 9:51 PM

**Comment from Launchpad by: Carlos Salguero on: 19-12-2017 16:13:15

Fix commited.
https://raw.githubusercontent.com/percona/percona-toolkit/3.0/bin/pt-query-digest

Details

Assignee

Reporter

Priority

Fix versions

Smart Checklist

Created January 24, 2018 at 9:51 PM
Updated December 20, 2023 at 3:45 AM

Flag notifications