I have setup replication between two 3.23.43 servers. Replication is working properly during normal circumstances, but when I shutdown mysql on the master, the slave never reconnects. An entry is made in the slave's error log stating that it will reconnect in 60 seconds, but then if I bring the master back up in within 60 seconds, the slave does not reconnect. Also, if I do not bring the master back up in 60 seconds, the slave just quits. Additionally, I have set master-connect-retry to different values in /etc/my.cnf but the entry in the error log always states that it will retry in 60 seconds. What is going on here? Does the slave retry feature just not work?
Here is my /etc/my.cnf file: [mysqld] master-host=master.gleim.com master-user=repl master-password=somethingorother master-connect-retry=120 server-id=2 And here are the messages from the error log on the slave: 011005 14:41:01 mysqld started /usr/local/mysql-3.23.43/libexec/mysqld: ready for connections 011005 14:41:01 Slave: connected to master '[EMAIL PROTECTED]:3306', replication started in log master-bin.005' at position 73 011005 14:41:15 Slave: received 0 length packet from server, apparent master shutdown: (0) 011005 14:41:15 Slave: Failed reading log event, reconnecting to retry, log 'master-bin.006' position 73 011005 14:41:15 Slave thread: error re-connecting to master: , last_errno=0, retry in 60 sec 011005 14:42:15 Slave thread killed during or after a reconnect done to recover from failed read 011005 14:42:15 Slave thread exiting, replication stopped in log master-bin.006' at position 73 ____________________________________ Dave Greco [EMAIL PROTECTED] Network Administrator Gleim Publications, Inc. (800) 87-GLEIM x312 http://www.gleim.com ____________________________________ --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
