List:Commits« Previous MessageNext Message »
From:Dmitry Lenev Date:November 17 2010 3:17pm
Subject:Re: bzr commit into mysql-5.5-runtime branch (jon.hauglid:3187)
Bug#57663
View as plain text  
Hello Jon Olav!

* Jon Olav Hauglid <jon.hauglid@stripped> [10/11/17 17:48]:
> #At file:///export/home/x/mysql-5.5-runtime-refactor/ based on
> revid:jon.hauglid@stripped
> 
>  3187 Jon Olav Hauglid	2010-11-17
>       Bug #57663 Concurrent statement using stored function and DROP DATABASE
>                  breaks SBR
>       
>       The problem was that DROP DATABASE ignored any metadata locks on stored
>       functions and procedures held by other connections. This made it
>       possible for DROP DATABASE to drop functions/procedures that were in use
>       by other connections and therefore break statement based replication.
>       (DROP DATABASE could appear in the binlog before a statement using a
>       dropped function/procedure.)
>       
>       This problem was an issue left unresolved by the patch for Bug#30977
>       where metadata locks for stored functions/procedures were introduced.
>       
>       This patch fixes the problem by making sure DROP DATABASE takes
>       exclusive metadata locks on all stored functions/procedures to be
>       dropped.
>       
>       Test case added to sp-lock.test.

I think that it is OK to push this patch.

Thanks a lot for addressing this problem !!!

-- 
Dmitry Lenev, Software Developer
Oracle Development SPB/MySQL, www.mysql.com

Are you MySQL certified?  http://www.mysql.com/certification
Thread
bzr commit into mysql-5.5-runtime branch (jon.hauglid:3187) Bug#57663Jon Olav Hauglid17 Nov
  • Re: bzr commit into mysql-5.5-runtime branch (jon.hauglid:3187)Bug#57663Dmitry Lenev17 Nov