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

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

    Details

    • Type: Bug
    • Status: Done
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: 3.0.5
    • Fix Version/s: 3.0.6
    • Component/s: None
    • Labels:

      Description

      Launchpad: https://bugs.launchpad.net/percona-toolkit/+bug/1738128

      /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:
                carlos.salguero Carlos Salguero
                Reporter:
                carlos.salguero Carlos Salguero
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 1 day
                  1d