I have replication running successfully between two Linux boxes running 3.23.51. However, I'm getting the following error very frequently (every 30 - 60 seconds) in my slave error log:
------------------------- 020703 15:41:09 Error reading packet from server: (server_errno=1159) 020703 15:42:09 Slave: Failed reading log event, reconnecting to retry, log 'db1-bin.009' position 25448 020703 15:42:09 Slave: reconnected to master '[EMAIL PROTECTED]:3306',replication resumed in log 'db1-bin.009' at position 25448 020703 15:42:39 Error reading packet from server: (server_errno=1159) 020703 15:43:39 Slave: Failed reading log event, reconnecting to retry, log 'db1-bin.009' position 25448 020703 15:43:39 Slave: reconnected to master '[EMAIL PROTECTED]:3306',replication resumed in log 'db1-bin.009' at position 25448 ------------------------- Is this just a normal timeout error, because there's currently very little activity on these machines? Or is there some other problem? The slave_net_timeout value is at it's default of 3600, so I would expect to see this type of error every hour -- but maybe I misunderstand that variable. If this is just a normal timeout, is there any way to up the value or prevent these errors from being logged? Thanks, --jeff sql,query --------------------------------------------------------------------- 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
