Hello.
Do you have your Slave is still trying to reconnect? If yes, are you sure that you don't have network problems? > I have a script checking for when the replication fails but that does >not include this type problem. Is this a bug in replication or do I >need to update my script to check for this ? Replication fails sometimes. I haven't found similar bug, but if you able perform an upgrade to the latest release. Often it helps. If you want to debug the problem make a research of the binary logs to find out the weird even, which causes Slave to reconnect. See: http://dev.mysql.com/doc/refman/5.0/en/replication-problems.html Marvin Wright wrote: > Hi, > > I found this morning that the slave replication thread seem to have hung. > Below I have pasted in my show slave status, it seems to be stuck trying to > connect to the master. > To fix this I issued a stop slave and start slave, my slave is about 3 weeks > behind now. > > I have a script checking for when the replication fails but that does not > include this type problem. Is this a bug in replication or do I need to > update my script to check for this ? > > I'm running version 4.1.12 on Redhat AS3. > > Many Thanks > > Marvin. > > mysql> show slave status\G > *************************** 1. row *************************** > Slave_IO_State: Reconnecting after a failed master event read > Master_Host: prdmysql01.prd.lastminute.com > Master_User: web > Master_Port: 3306 > Connect_Retry: 60 > Master_Log_File: prdmysql01-bin.000118 > Read_Master_Log_Pos: 15561995 > Relay_Log_File: prdmysql02-relay-bin.000001 > Relay_Log_Pos: 80882143 > Relay_Master_Log_File: prdmysql01-bin.000118 > Slave_IO_Running: Yes > Slave_SQL_Running: Yes > Replicate_Do_DB: > Replicate_Ignore_DB: > Replicate_Do_Table: > Replicate_Ignore_Table: > Replicate_Wild_Do_Table: > Replicate_Wild_Ignore_Table: > Last_Errno: 0 > Last_Error: > Skip_Counter: 0 > Exec_Master_Log_Pos: 15561995 > Relay_Log_Space: 80882143 > Until_Condition: None > Until_Log_File: > Until_Log_Pos: 0 > Master_SSL_Allowed: No > Master_SSL_CA_File: > Master_SSL_CA_Path: > Master_SSL_Cert: > Master_SSL_Cipher: > Master_SSL_Key: > Seconds_Behind_Master: NULL > 1 row in set (0.00 sec) > > > ********************************************************************** > This email and any files transmitted with it are confidential and > intended solely for the use of the individual or entity to whom they > are addressed. If you have received this email in error please notify > the system manager. > > This footnote also confirms that this email message has been swept by > MIMEsweeper for the presence of computer viruses. > > www.mimesweeper.com > ********************************************************************** > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]