> > I've set up replication with a master and two slaves, all running > > 3.23.43, and it works like a charm. Except for... > > > > When the master goes down, the slave tries to reconnect after 60 > > seconds, but just once. > > That shouldn't be.
I have the same problem here with the same version! > > > I expected it to retry until it can connect, because when the master > > comes up again, it should catch up on updates and everything would > > work like it should. > > That should be. > > > But when the master goes down for a period exceeding 60 seconds > > (well, the timeout interval), the slave thread exits and never tries > > to start replicating again, unless I manually do a SLAVE START on > > all the slaves. Is there a way to make a slave hammer the master > > indefinitely, until it can connect? I've read the manual several > > times, and found no clue... > > What does the slave's error log say? Can we see replication items > listed in the slave's my.cnf file? error log: 011104 11:02:34 Error reading packet from server: Lost connection to MySQL server during query (read_errno 22,server_errno=2013) 011104 11:02:34 Slave: Failed reading log event, reconnecting to retry, log 'db2-bin.001' position 51733535 011104 11:03:04 Slave thread: error re-connecting to master: Lost connection to MySQL server during query, last_errno=2013, retry in 60 sec 011104 11:04:04 Slave thread killed during or after a reconnect done to recover from failed read 011104 11:04:04 Slave thread exiting, replication stopped in log 'db2-bin.001' at position 51733535 my.cnf : [mysqld] port = 3306 socket = /tmp/mysql.sock skip-locking set-variable = key_buffer=16K set-variable = max_allowed_packet=1M set-variable = thread_stack=64K set-variable = table_cache=4 set-variable = sort_buffer=64K set-variable = net_buffer_length=2K server-id = 2 master-host = db2.sayhi.net master-user = <don't tell> master-password = <don't tell> master-port = 3306 Any hint? Arne --------------------------------------------------------------------- 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
