Uploaded image for project: 'Percona Toolkit'
  1. Percona Toolkit
  2. PT-1467

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

    XMLWordPrintable

    Details

      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

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

        Smart Checklist

          Attachments

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              lpjirasync lpjirasync (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated: