At 04:26 AM 7/15/2002, David Harper wrote: > >Description: > Every 60 seconds, the replication slave gets an error 1159 from >the master server. Thirty seconds later, it reconnects to the master. >Then the cycle starts all over again. I have master-connect-retry=30 in >the config file. > >Here is an extract of the replication slave's error log: > >020715 12:05:33 Error reading packet from server: (server_errno=1159) >020715 12:06:03 Slave: Failed reading log event, reconnecting to retry, >log 'mysql.001' position 73 >020715 12:06:03 Slave: reconnected to master >'slave@venus:24641',replication resumed in log 'mysql.001' at position 73
david, i just posted the exact same question last week. apparently it is not a problem. if the message bothers you (it bothered me!) if you put these lines in my.cnf: set-variable = slave_net_timeout=3600 set-variable = net_read_timeout=3600 it will reduce the error msg frequency to once per hour. change 3600 to a higher number if you want it even less frequently. -jsd- --------------------------------------------------------------------- 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