Re: Have trouble to understand bug 10942

Sergei Golubchik <[email protected]> Wed, 25 Mar 2009 15:03:23 +0100

Newsgroups	gmane.comp.db.mysql.bugs
Message-ID	<[email protected]>

Hi, king!

On Mar 23, king wrote:
> Hi there,
>
> Bug #10942 is deadlock with FLUSH TABLES WITH READ LOCK + STOP SLAVE
>
> On http://bugs.mysql.com/bug.php?id=10942, it says "FLUSH TABLES WITH READ 
> LOCK will prevent slave SQL thread to start next replicated statement", and 
> the next STOP SLAVE will lead to deadlock. My questions are:
..
> *In general, I do not understand how they deadlock. If you can explain 
> that, you can also skip my questions. Thanks.*

Read the bug report and the 'How to repeat:' test case. Or at least see
the 'show processlist;' output in the bug report.

It's obvious from there that the replication slave is blocked when it
tries to execute 'create database db1', which is a replicated statement
from the master.

Regards / Mit vielen Grüßen,
Sergei

-- 
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /   Sergei Golubchik <[email protected]>
 / /|_/ / // /\ \/ /_/ / /__  Principal Software Engineer/Server Architect
/_/  /_/\_, /___/\___\_\___/  Sun Microsystems GmbH, HRB München 161028
       <___/                  Sonnenallee 1, 85551 Kirchheim-Heimstetten
Geschäftsführer: Thomas Schroeder, Wolfgang Engels, Dr. Roland Boemer
Vorsitzender des Aufsichtsrates: Martin Häring

-- 
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe:    http://lists.mysql.com/[email protected]