List:General Discussion« Previous MessageNext Message »
From:Eric Bergen Date:February 14 2005 11:32pm
Subject:Re: Empty 'Relay_Master_Log_File'?
View as plain text  
Did you copy the relay-log.info and relay logs from the seed slave?

Relay_Master_Log_file is line 3 in the relay-log.info file. This file
is managed by the SQL thread and helps the slave keep track of what it
has execute in the relay logs.
http://dev.mysql.com/doc/mysql/en/slave-logs.html

-Eric


On Mon, 14 Feb 2005 14:03:08 -0800 (PST), Atle Veka
<mysql-list@stripped> wrote:
> 
> On Mon, 14 Feb 2005, Jeremy Cole wrote:
> 
> > AFAIK, the log file name is not known by the slave unless it either
> > receives a rotate log event (go to next log) or you have started it
> > against a particular log file.  If you start replication "from the
> > beginning" (not specifying a log file) against a master, the first
> > filename is not passed down.
> >
> > In order to force a filename to be displayed you could either: FLUSH
> > LOGS on the master, or specify the log file name in the CHANGE MASTER on
> > the slave.
> >
> 
> Hi Jeremy,
> 
> If that's the case it would have to mean that the SQL thread knew about it
> while the IO thread did not, correct? Here's a snip of the SHOW SLAVE
> STATUS from yesterday:
> [..]
>        Master_Log_File: db1-bin.248
>    Read_Master_Log_Pos: 428653772
>         Relay_Log_File: db9-relay-bin.002
>          Relay_Log_Pos: 1186147
>  Relay_Master_Log_File:
> [..]
> 
> The way the seeding was done was that the slave got a copy of the
> replicated DB + master.info from an existing slave.
> 
> Thanks,
> 
> Atle
> 
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
> 
> 


-- 
Eric Bergen
eric.bergen@stripped
http://www.bleated.com
Thread
Empty 'Relay_Master_Log_File'?Atle Veka14 Feb
  • Re: Empty 'Relay_Master_Log_File'?Jeremy Cole14 Feb
    • Re: Empty 'Relay_Master_Log_File'?Atle Veka14 Feb
      • Re: Empty 'Relay_Master_Log_File'?Eric Bergen15 Feb
        • Re: Empty 'Relay_Master_Log_File'?Atle Veka15 Feb
          • Re: Empty 'Relay_Master_Log_File'?Eric Bergen15 Feb
            • Re: Empty 'Relay_Master_Log_File'?Atle Veka15 Feb