pt-query-digest doesn't recognize hex InnoDB txn IDs

[Daniel Nichter]

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
# mk_query_digest:12521 17577 Argument "2020D" isn't numeric in numeric gt (>) at (eval 48) line 6, <> line 3.

Parsing this record:

# Time: 110207 4:16:15.0000392717
# User@Host: root[root] @ localhost []
# Thread_id: 38 Schema: test Last_errno: 0 Killed: 0
# Query_time: 0.001202 Lock_time: 0.000637 Rows_sent: 1 Rows_examined: 1 Rows_affected: 0 Rows_read: 1
# Bytes_sent: 67 Tmp_tables: 0 Tmp_disk_tables: 0 Tmp_table_sizes: 0
# InnoDB_trx_id: 2020D
# QC_Hit: No Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
# Filesort: No Filesort_on_disk: No Merge_passes: 0
# InnoDB_IO_r_ops: 1 InnoDB_IO_r_bytes: 16384 InnoDB_IO_r_wait: 0.001273
# InnoDB_rec_lock_wait: 0.000000 InnoDB_queue_wait: 0.000000
# InnoDB_pages_distinct: 21
SET timestamp=1297080975;
select * from zzz;

[Baron Schwartz (baron-xaprb)]

Also reported as bug 930503.

[Shahriyar Rzayev (rzayev-sehriyar)]

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