Comment 39 for bug 1040735

Revision history for this message
Alexey Kopytov (akopytov) wrote : Re: [Bug 1040735] Re: Server hang in 5.5.27-rel28

On 30.08.12 9:27, Raghavendra D Prabhu wrote:
> Also, for bug mentioned in #27 --
>
> " Sessions could end up deadlocked when executing a combination of
> SELECT, DROP TABLE, KILL, and SHOW ENGINE INNODB STATUS. (Bug #60682,
> Bug #12636001)"
>
> Even though this is present in 5.5.27 changelogs, it (commit:
> http://sprunge.us/AYKP) seems to have been null merged (so without
> changes) into 5.5.x tree. So, either it is not fixed in 5.5.x or not
> required there; not sure if this requires a separate bug report.
>

Quote from revision comments for the 5.1 version of the fix for
http://bugs.mysql.com/bug.php?id=60682 :

"
      Note: The problem is not found in 5.5. Introduction MDL subsystem
      caused metadata locking responsibility to be moved from TDC/TC to
      MDL subsystem. Due to this, responsibility of LOCK_open is reduced.
      As the use of LOCK_open is removed in open_table() and
      mysql_rm_table() the above mentioned CYCLE does not form.
"

Hence the null merge.