At 01:48 PM 7/12/2002, Jeremy Zawodny wrote: >On Fri, Jul 12, 2002 at 01:43:02PM -0700, Jon Drukman wrote: > > now instead of getting the error every 30 seconds, i get it every > > hour. is there a way to make it go away forever? > >Make the number really big? > >I wonder if you can set it to 0 to mean "don't timeout". But that >could be bad in some cases too. > > > why does it happen and what does it mean? > >It means that the slave closed the connection because it hadn't heard >from the master in a while. You must not be sending a lot of data to >the slave(s) regularly, huh?
right, these machines are in test mode. the databases aren't being modified/used at all at the moment. i'm just setting them up for production use later. i sure would have been happier if the message wasn't phrased like some sort of network communication error! 020712 15:39:59 Error reading packet from server: (server_errno=1159) 020712 15:40:59 Slave: Failed reading log event, reconnecting to retry, log 'rs1-bin.004' position 215 020712 15:40:59 Slave: reconnected to master 'replica@rs1private:3306',replication resumed in log 'rs1-bin.004' i'll probably set it to 86400 (1 day) eventually. i just wanted to make sure that i wasn't masking the symptom of some deep problem. thanks for the speedy reply. -jsd- sql query purple monkey dishwasher --------------------------------------------------------------------- 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