From: Dmitry Lenev Date: November 17 2010 3:17pm Subject: Re: bzr commit into mysql-5.5-runtime branch (jon.hauglid:3187) Bug#57663 List-Archive: http://lists.mysql.com/commits/124167 Message-Id: <20101117151758.GI649@mockturtle> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Hello Jon Olav! * Jon Olav Hauglid [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