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

    • Bug
    • Status: Done
    • Medium
    • Resolution: Fixed
    • 3.0.5
    • 3.0.6
    • None

    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
      

      Attachments

        Activity

          People

            carlos.salguero Carlos Salguero (Inactive)
            carlos.salguero Carlos Salguero (Inactive)
            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

                Smart Checklist