List:General Discussion« Previous MessageNext Message »
From:Jim Lyons Date:August 10 2008 5:41pm
Subject:Re: can some please help me -- REPLICATION
View as plain text  
you should probably just resync your slave.  If it hasn't run for over a
month then there's not a lot of point in trying to start it up.  Even if you
did start the slave (which seems doubtful) you'd have over a month's worth
of commands to make up.

You can tell mysql to not keep relay logs that have already been used.  Just
copy over the masters' files, reset slave and master and start up the
slave.


On Sun, Aug 10, 2008 at 11:34 AM, Brown, Charles <CBrown@stripped> wrote:

> The background:
> We are doing replication. The file-system containing the SLAVE's
> relay-log got filled to capacity. Later on, I noticed replication has
> not been working for the last month or more.
>
> My Action:
> I deleted the 2 oldest relay-log then attempted to restart SLAVE. Now,
> the SLAVE will not start. Replication will not start. The SLAVE
> continues to request for those logs.
>
> My Question:
> What instructions/command can I issue to the SLAVE so it can ignore
> relay-logs not found? See below for msg I have been getting from the
> SLAVE -- for all attempts to restart.
>
>
> 080809  2:09:23 [ERROR] Failed to open the relay log 'FIRST'
> (relay_log_pos 4)
> 080809  2:09:23 [ERROR] Could not open log file
> 080809  2:13:58 [ERROR] Error reading master configuration
> 080809  2:29:49 [ERROR] Error reading master configuration
> 080809  7:31:40 [ERROR] Error reading master configuration
> 080809  7:57:32 [ERROR] Failed to open log (file
> './naxbmisq02-relay-bin.000157', errno 2)
> 080809  7:57:32 [ERROR] Failed to open the relay log 'FIRST'
> (relay_log_pos 4)
> 080809  7:57:32 [ERROR] Could not open log file
> 080809  8:01:27 [ERROR] Error reading master configuration
> 080809  8:11:42 [ERROR] Error reading master configuration
>
>
>
> ********************************************
> This message is intended only for the use of the Addressee and
> may contain information that is PRIVILEGED and CONFIDENTIAL.
>
> If you are not the intended recipient, you are hereby notified
> that any dissemination of this communication is strictly prohibited.
>
> If you have received this communication in error, please erase
> all copies of the message and its attachments and notify us
> immediately.
>
> Thank you.
> ********************************************
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
>


-- 
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com

Thread
SELECT N records from each categoryKevin Waterson10 Aug
  • Re: SELECT N records from each categoryPeter Brawley10 Aug
    • can some please help me -- REPLICATIONCharles Brown10 Aug
      • Re: can some please help me -- REPLICATIONJim Lyons10 Aug
        • Re: can some please help me -- REPLICATIONDavid Giragosian10 Aug
          • RE: can some please help me -- REPLICATIONCharles Brown10 Aug
          • RE: can some please help me -- REPLICATIONCharles Brown10 Aug
            • Re: can some please help me -- REPLICATIONMoon's Father12 Aug
    • Re: SELECT N records from each categoryKevin Waterson10 Aug
      • Re: SELECT N records from each categoryPeter Brawley11 Aug
        • Re: SELECT N records from each categoryKevin Waterson11 Aug
          • Re: SELECT N records from each categoryPeter Brawley11 Aug
  • Re: SELECT N records from each categoryPerrin Harkins11 Aug
    • Re: SELECT N records from each categoryKevin Waterson11 Aug