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.
>
"
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.
"
On 30.08.12 9:27, Raghavendra D Prabhu wrote: sprunge. us/AYKP) seems to have been null merged (so without
> 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://
> 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 bugs.mysql. com/bug. php?id= 60682 :
http://
" rm_table( ) the above mentioned CYCLE does not form.
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_
"
Hence the null merge.