pt-query-digest doesn't work with Mysql 5.7 genlog

Bug #1597662 reported by Przemek
14
This bug affects 3 people
Affects Status Importance Assigned to Milestone
Percona Toolkit moved to https://jira.percona.com/projects/PT
Invalid
Undecided
Unassigned

Bug Description

There is still information # No events processed.

D:\sw\toolkit\bin>perl pt-query-digest --type genlog general.log

# No events processed.

D:\sw\toolkit\bin>type general.log | more
MySQL57, Version: 5.7.12-log (MySQL Community Server (GPL)). started with:
TCP Port: 3306, Named Pipe: MySQL
Time Id Command Argument
2016-06-30T07:51:43.032260Z3407080 Query select pesel from osoba where id
_osoby=111601
2016-06-30T07:51:43.032260Z3407058 Query select * from osoba_przerwa, prz
erwa where osoba_przerwa.kod_przerwy=przerwa.kod_przerwy and id_osoby=155595
and (od<='2016-07-27' and do>='2016-07-27') and (id_jw='9043927' or id_jw='' )
2016-06-30T07:51:43.032260Z3406991 Query select data_zw from osoba_wyp wh
ere pesel='56123103597' and dz_dat<='2016-06-30' and data_zw>='2016-06-30' and w
ycofano='N'
2016-06-30T07:51:43.032260Z3407063 Query select id, opis from dni_wolne w
here dzien=30 and miesiac=06
2016-06-30T07:51:43.032260Z3407080 Query select stanowisko, nr_etatu, nr_
etatu2, dostep_do_tap from uzytkownik where pesel='88062507721'....

pt-query-digest
Version 2.2.18

Revision history for this message
rahul singh (rahul.singh) wrote :

Yes, I face a similar problem. I have pt-query-digest 2.4.
Upgraded to mysql 5.7.12 and since then the pt-query-digest is not processing the slow queries logged after mysql upgrade to 5.7.12

Percona (percona-team)
summary: - pt-query-digest don't work with Mysql 5.7 genlog
+ pt-query-digest doesn't work with Mysql 5.7 genlog
Revision history for this message
Carlos Salguero (carlos-salguero) wrote :
Changed in percona-toolkit:
status: New → Invalid
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-1370

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.