Bug #43117 Killing get_locks from other threads
Submitted: 23 Feb 2009 17:53 Modified: 27 Dec 2010 12:13
Reporter: Andrew Hutchings Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Locking Severity:S4 (Feature request)
Version: OS:Any
Assigned to: CPU Architecture:Any

[23 Feb 2009 17:53] Andrew Hutchings
Description:
When a thread creates a thread with get_lock only that thread can release the lock.  There should perhaps be a way of a superuser thread to release the lock (maybe with a new kill_lock function).

How to repeat:
use get_lock() and try to remove it from another thread

Suggested fix:
implement kill_lock() to be executed as a superuser