MySQL Bugs: #74107: Add check that MTR testcases clean up any user locks

Bug #74107	Add check that MTR testcases clean up any user locks
Submitted:	26 Sep 2014 12:32
Reporter:	Laurynas Biveinis (OCA)	Email Updates:
Status:	Open	Impact on me:	None
Category:	MySQL Server: Tests	Severity:	S4 (Feature request)
Version:	5.7.5	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	GET_LOCK

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
Now that 5.7.5 supports multiple user locks per connection, and a newly taken lock does not automatically release any previously taken lock anymore, it might be a good idea to test that MTR testcases clean up after themselves.

How to repeat:
See above.

Suggested fix:
Add check that RELEASE_ALL_LOCKS returns 0 in mtr_check.sql CHECK_TESTCASE.

The alternative of querying P_S.METADATA_LOCKS looks less attractive for folks who compile PFS away.