MySQL Bugs: #50297: InnoDB monitor should report which locks are held by trx (1)

Bug #50297	InnoDB monitor should report which locks are held by trx (1)
Submitted:	13 Jan 2010 3:42	Modified:	13 May 2010 16:03
Reporter:	Mikiya Okuno	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: InnoDB storage engine	Severity:	S4 (Feature request)
Version:		OS:	Any
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
While InnoDB monitor reports the latest detected deadlock, but sometimes information displayed is not sufficient to troubleshoot deadlocks. We only see "(2) HOLDS THE LOCK(S):", "(2) WAITING FOR THIS LOCK TO BE GRANTED:" and (1) WAITING FOR THIS LOCK TO BE GRANTED:", but section like "(1) HOLDS THE LOCK(S):" is missing.

How to repeat:
n/a

Suggested fix:
n/a