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

LP #1566894: pt-query-digest reports 'No events processed.' with --since option

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: On Hold
    • Priority: Low
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None

      Description

      **Reported in Launchpad by Martin Božič last update 06-04-2016 14:24:32

      I would like to filter events from slow query log to only 4 hours before now, but this doesn't seem to be working no matter what. There aren't any events processed. Processing the whole log without --since option works.

      • Complete commandline used to run the tool: pt-query-digest --database ssio_pro --limit "100%" --since 4h /var/log/slow-query.log
      • Tool version: pt-query-digest 2.2.17
      • MySQL version of all servers involved: Server version: 5.5.48-MariaDB MariaDB Server
      • Output from the tool including STDERR:


      [root@249 ~]# pt-query-digest --database ssio_pro --limit "100%" --since 4h /var/log/slow-query.log /var/log/slow-query.log: 8% 05:15 remain
      /var/log/slow-query.log: 20% 03:54 remain
      /var/log/slow-query.log: 32% 03:10 remain
      /var/log/slow-query.log: 43% 02:37 remain
      /var/log/slow-query.log: 54% 02:05 remain
      /var/log/slow-query.log: 65% 01:35 remain
      /var/log/slow-query.log: 76% 01:04 remain
      /var/log/slow-query.log: 87% 00:33 remain
      /var/log/slow-query.log: 97% 00:06 remain

      1. No events processed.
      • Input files (log/dump/config files, etc.)

        Smart Checklist

          Attachments

            Activity

              People

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

                Dates

                Created:
                Updated: