List:Bugs« Previous MessageNext Message »
From:sasha Date:September 8 2000 6:18pm
Subject:Re: 'slave stop' not removing slave from processlist on Master ..
View as plain text  
Weslee Bilodeau wrote:
> 
> I've noticed that if I issue a 'slave stop', the master still shows the
> slave connected in the process list.
> 
> If I issue 'slave start' again a new entry shows up in the processlist
> list. I can continue this multiple times and get multiple entries in the
> process list for the master.

The problem is that binlog dump thread is waiting for updates and will not know
the client has terminated until you either update the master or kill it. One
update on the master should kill all "zombie" dump threads.

-- 
Sasha Pachev

+------------------------------------------------------------------+
|      ____  __     _____   _____  ___     http://www.mysql.com    |
|     /*/\*\/\*\   /*/ \*\ /*/ \*\ |*|     Sasha Pachev            |
|    /*/ /*/ /*/   \*\_   |*|   |*||*|     sasha@stripped         |
|   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*|     Provo, Utah, USA        |
|  /*/     /*/  /*/\*\_/*/ \*\_/*/ |*|____                         |
|  ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^                        |
|             /*/             \*\ Developers Team                  |
+------------------------------------------------------------------+
Thread
'slave stop' not removing slave from processlist on Master ..Weslee Bilodeau8 Sep
  • Re: 'slave stop' not removing slave from processlist on Master ..sasha8 Sep
    • Re: 'slave stop' not removing slave from processlist on Master ..Michael Widenius9 Sep