pt-deadlock-logger can't clear deadlocks on 5.5
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Toolkit moved to https://jira.percona.com/projects/PT |
Fix Released
|
Medium
|
Baron Schwartz |
Bug Description
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:
*******
Id: 43
User: msandbox
Host: localhost
db: test
Command: Sleep
Time: 2263
State:
Info: NULL
*******
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
Related branches
- Daniel Nichter: Approve
- Diff: 0 lines
tags: | added: mysql-5.5 |
Changed in percona-toolkit: | |
status: | New → Confirmed |
Changed in percona-toolkit: | |
milestone: | none → 2.1.2 |
status: | Confirmed → Fix Committed |
Changed in percona-toolkit: | |
assignee: | nobody → Baron Schwartz (baron-xaprb) |
Changed in percona-toolkit: | |
status: | Fix Committed → Fix Released |
Killing connection 43 above makes it go ahead.