List:Bugs« Previous MessageNext Message »
From:sasha Date:September 8 2000 6:21pm
Subject:Re: Bug: 'CHANGE MASTER TO' with no previous master
View as plain text  
Weslee Bilodeau wrote:
> 
> I'm using MySQL 3.23.24 ..
> 
> If I try to issue a 'CHANGE MASTER TO' command with no previously
> defined master (no my.cnf options or no master.info file), the MySQL
> server locks up.
> 
> I'm doing this because I have a farm of servers with a central master.
> In the event the master goes down, a slave is assigned temporary master
> status untill the master comes up. I do this so the master can re-sync
> its data in case any primary keys have changed, then tell the slaves to
> switch back to the original master.
> 
> Weslee

This is something I forgot to test :-) Temporary workaround is to have some
default invalid master and execute SLAVE STOP every time you start the server to
avoid the spam in the error log. Will be fixed ASAP.

-- 
Sasha Pachev

+------------------------------------------------------------------+
|      ____  __     _____   _____  ___     http://www.mysql.com    |
|     /*/\*\/\*\   /*/ \*\ /*/ \*\ |*|     Sasha Pachev            |
|    /*/ /*/ /*/   \*\_   |*|   |*||*|     sasha@stripped         |
|   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*|     Provo, Utah, USA        |
|  /*/     /*/  /*/\*\_/*/ \*\_/*/ |*|____                         |
|  ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^                        |
|             /*/             \*\ Developers Team                  |
+------------------------------------------------------------------+
Thread
Bug: 'CHANGE MASTER TO' with no previous masterWeslee Bilodeau8 Sep
  • Re: Bug: 'CHANGE MASTER TO' with no previous mastersasha8 Sep