From: sasha
Date: October 26 2000 3:58pm
Subject: Re: Strange behavior of flush logs with the replication
List-Archive: http://lists.mysql.com/internals/61
Message-Id: <39F854B8.8D97B863@mysql.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hi,

I made just a 'flush logs' on the master. At the same moment the slave started
the former log-file anew.

Before 'flush logs':
-Master: oracle-bin.002 Pos: about 1.4 gb
-Slave: oracle-bin.002 Pos: about 1.4 gb
After 'flush logs':
-Master: oracle-bin.003 Pos: a few kb
-Slave: oracle-bin.002 Pos: a few kb

But the last command in the oracle-bin.002 is 'oracle-bin.003'.

And yes, I'm sure there is no one who could have coincidentally made a 'flush
slave' on the slave.

Regards,

Christian "Maverick" Rabe
IT-Development
wallstreet:online AG
------------------------------------------
http://www.wallstreet-online.de
Tel.:  03 37 01 5 29 16
Fax.:  03 37 01 5 29 19

What are the contents of the log index on the master? 
/path/to/datadir/oracle-bin.index
What about master.info on the slave?



-- 
MySQL Development Team
   __  ___     ___ ____  __ 
  /  |/  /_ __/ __/ __ \/ /   Sasha Pachev <sasha@stripped>
 / /|_/ / // /\ \/ /_/ / /__  MySQL AB, http://www.mysql.com/
/_/  /_/\_, /___/\___\_\___/  Provo, Utah, USA
       <___/