From: Christian Rabe
Date: October 26 2000 4:33pm
Subject: Re: Strange behavior of flush logs with the replication
List-Archive: http://lists.mysql.com/internals/63
Message-Id: <03c801c03f6a$6de6cf20$b401a8c0@gis.priv>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

the oracle-bin.index has now two lines
./oracle-bin.002
./oracle-bin.003

the master.info on the slave is now (after rereading the whole .002) in the
.003-file.
i forgot to look in the master.info the moment it happened (only used 'show
slave status'), sorry.

----- Original Message -----
From: sasha@stripped
To: Christian Rabe
Cc: internals@stripped
Sent: Thursday, October 26, 2000 5:58 PM
Subject: Re: Strange behavior of flush logs with the replication


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
       <___/