pt-deadlock-logger can't clear deadlocks on 5.5

[Baron Schwartz]

It hangs forever, and I see this in SHOW ENGINE INNODB STATUS:

---TRANSACTION 2900, not started
MySQL thread id 44, OS thread handle 0xaf0f1b90, query id 1452 localhost 127.0.0.1 msandbox Waiting for table metadata lock
DROP TABLE test.make_deadlock
---TRANSACTION 28FF, ACTIVE 2184 sec
3 lock struct(s), heap size 320, 2 row lock(s), undo log entries 2
MySQL thread id 43, OS thread handle 0xaf05eb90, query id 1451 localhost msandbox

Meanwhile, in processlist:

*************************** 4. row ***************************
     Id: 43
   User: msandbox
   Host: localhost
     db: test
Command: Sleep
   Time: 2263
  State:
   Info: NULL
*************************** 5. row ***************************
     Id: 44
   User: msandbox
   Host: localhost:39804
     db: test
Command: Query
   Time: 2263
  State: Waiting for table metadata lock
   Info: DROP TABLE test.make_deadlock

[Baron Schwartz (baron-xaprb)]

Killing connection 43 above makes it go ahead.

[Baron Schwartz (baron-xaprb)]

This makes the test suite fail on 5.5 in pt-deadlock-logger/standard_options. It also fails "badly" by hanging forever.

[Shahriyar Rzayev (rzayev-sehriyar)]

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