Issues
- LP #1738128: pt-query-digest produces empty output for mysql 5.7 general log with timestampPT-1467
- LP #1714630: pt-query-digest parses timestamps incorrectly from general logPT-1442
- LP #1048844: pt-query-digest doesn't parse user info from general logsPT-580
- LP #1078838: pt-query-digest doesn't parse general log with "Connect user as user"PT-340Resolved issue: PT-340
4 of 4
LP #1738128: pt-query-digest produces empty output for mysql 5.7 general log with timestamp
General
Escalation
General
Escalation
Description
Environment
None
Smart Checklist
Details
Assignee
UnassignedUnassignedReporter
lpjirasynclpjirasync(Deactivated)Priority
LowFix versions
Details
Details
Assignee
Unassigned
UnassignedReporter
lpjirasync
lpjirasync(Deactivated)
Priority
LowFix versions
Smart Checklist
Smart Checklist
Smart Checklist
Created January 24, 2018 at 9:51 PM
Updated December 20, 2023 at 3:45 AM
Activity
Show:
lpjirasyncJanuary 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
**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
(?\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