LP #821694: pt-query-digest doesn't recognize hex InnoDB txn IDs

Description

**Reported in Launchpad by Daniel Nichter last update 19-03-2012 16:57:40

Imported from http://code.google.com/p/maatkit/issues/detail?id=1244

Quoting the original:

root@ubuntu:/tmp# ./mk-query-digest /var/run/mysqld/mysqld-slow.log

  1. mk_query_digest:12521 17577 Argument "2020D" isn't numeric in numeric gt (>) at (eval 48) line 6, <> line 3.

Parsing this record:

  1. Time: 110207 4:16:15.0000392717

  2. User@Host: root[root] @ localhost []

  3. Thread_id: 38 Schema: test Last_errno: 0 Killed: 0

  4. Query_time: 0.001202 Lock_time: 0.000637 Rows_sent: 1 Rows_examined: 1 Rows_affected: 0 Rows_read: 1

  5. Bytes_sent: 67 Tmp_tables: 0 Tmp_disk_tables: 0 Tmp_table_sizes: 0

  6. InnoDB_trx_id: 2020D

  7. QC_Hit: No Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No

  8. Filesort: No Filesort_on_disk: No Merge_passes: 0

  9. InnoDB_IO_r_ops: 1 InnoDB_IO_r_bytes: 16384 InnoDB_IO_r_wait: 0.001273

  10. InnoDB_rec_lock_wait: 0.000000 InnoDB_queue_wait: 0.000000

  11. InnoDB_pages_distinct: 21
    SET timestamp=1297080975;
    select * from zzz;

Environment

None

Smart Checklist

Activity

Show:

lpjirasync January 24, 2018 at 2:48 PM

**Comment from Launchpad by: Baron Schwartz on: 23-02-2012 16:05:22

Also reported as bug 930503.

Done

Details

Assignee

Reporter

Priority

Smart Checklist

Created January 24, 2018 at 2:47 PM
Updated January 24, 2018 at 2:48 PM
Resolved January 24, 2018 at 2:48 PM