Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

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

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.)

Environment

None

Smart Checklist

Activity

Show:

Uday Varagani January 23, 2019 at 8:23 AM
Edited

Hello,

Thank you for the report. This has been verified. I could re-produce this locally where the same slow query log when used against latest release percona toolkit release, producing expected results.

 

---> percona toolkit: 2.2.17 version:

  1. md5sum /percona-Inspiron-5570-slow.log

---> percona toolkit: 2.2.17 version:

  1. md5sum /percona-Inspiron-5570-slow.log
    2f19d2a0c8142d70bee816ffc51aa866 /percona-Inspiron-5570-slow.log
    #

  2. ./pt-query-digest --version
    pt-query-digest 2.2.17
    #

  3. ./pt-query-digest --since 30h percona-Inspiron-5570-slow.log

    1. No events processed.*

 

---> percona toolkit: 3.0.12 version:

  1. md5sum percona-Inspiron-5570-slow.log
    2f19d2a0c8142d70bee816ffc51aa866 percona-Inspiron-5570-slow.log

  2. pt-query-digest --version
    pt-query-digest 3.0.12

  1. pt-query-digest --since 30h percona-Inspiron-5570-slow.log | head    ---> Producing expected results.

  2. 1.6s user time, 140ms system time, 36.62M rss, 107.14M vsz

  3. Current date: Wed Jan 23 13:48:10 2019

  4. Hostname: percona-Inspiron-5570

  5. Files: /var/lib/mysql/percona-Inspiron-5570-slow.log

  6. Overall: 48 total, 5 unique, 0.02 QPS, 21.74x concurrency ______________

  7. Time range: 2019-01-22T09:46:45 to 2019-01-22T10:33:15

  8. Attribute total min max avg 95% stddev median

  9. ============ ======= ======= ======= ======= ======= ======= =======

  10. Exec time 60656s 1s 2802s 1264s 2687s 1331s 8s

  11. Caught SIGPIPE.

  12. Exiting on SIGPIPE.

 

Details

Assignee

Reporter

Priority

Labels

Smart Checklist

Created January 24, 2018 at 9:01 PM
Updated March 4, 2024 at 4:42 PM