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:
Category:MySQL Server: Tests Severity:S4 (Feature request)
Version:5.7.5 OS:Any
Assigned to: CPU Architecture:Any

[26 Sep 2014 12:32] Laurynas Biveinis
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.