List:General Discussion« Previous MessageNext Message »
From:Atle Veka Date:February 14 2005 10:03pm
Subject:Re: Empty 'Relay_Master_Log_File'?
View as plain text  
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
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