Add support for thread id format present in Percona Server 5.6 and MySQL 5.6 slow log

Bug #1197042 reported by Przemek
22
This bug affects 4 people
Affects Status Importance Assigned to Milestone
MOVED - Percona Playback
Triaged
High
Unassigned

Bug Description

Since thread id information in slow log entries was introduced in upstream MySQL 5.6, though in different format than the existing one in Percona Server 5.5 and earlier, Percona Server 5.6 in sake of compatibility also uses the same format as MySQL 5.6.
Percona Playback (0.6) does not recognize the new format, so in case of slow log coming from MySQL or Percona Server 5.6 - the tool does not create threads based on that information, but executes all transactions in single thread.

Please add support for new thread id information present in MySQL 5.6.
Percona Server pre 5.6 format:
# Thread_id: 3 Schema: test Last_errno: 0 Killed: 0

5.6 format:
# User@Host: root[root] @ localhost [] Id: 3

tags: added: i33059
Changed in percona-playback:
status: New → Confirmed
Stewart Smith (stewart)
Changed in percona-playback:
milestone: none → 0.8
importance: Undecided → High
status: Confirmed → Triaged
Revision history for this message
Kenny Gryp (gryp) wrote :
tags: added: i49245
Revision history for this message
sidh (1-michael-l) wrote :

I'm concerned with this problem too.

It seems if you replace "Thread_Id:" by "Id:" on line 269 of the file :

percona-playback-0.7/percona_playback/query_log/query_log.cc

The problem is fixed .

Enclosed, the smallest "patch" we've ever seen

P.S. #1 Thanks to tanj who advises me to figure out the problem.

P.S. #2 I've been told that percona-playback is mostly unmaintained and we can't expect any bugfix in the future.

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.