pt-query-digest reports 'No events processed.' with --since option

Bug #1566894 reported by Martin Božič
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Toolkit moved to https://jira.percona.com/projects/PT
New
Undecided
Unassigned

Bug Description

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 command‐line 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

# No events processed.
---

* Input files (log/dump/config files, etc.)

Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PT-1339

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.