Resetting the binlogs on the master didn't make a difference. Syncing all MySQL versions didn't make a difference. I've checked network configuration, permissions on both the replication user (on the master) and the files on slaves.
The master error log has nothing in it. Is there a way to turn up the verbosity of the log files without building a debug version of MySQL? -----Original Message----- From: Jeremy Tinley [mailto:[EMAIL PROTECTED]] Sent: Monday, February 17, 2003 4:07 PM To: [EMAIL PROTECTED] Subject: RE: received 0 length packet from server A few more tidbits: * All slaves are running the static i686 linux build (mysql-3.23.55-pc-linux-i686) under RH8.0 (since RH8 won't compile MySQL without it dumping core). * More log snippets: 030217 15:43:01 Slave: received 0 length packet from server, apparent master shutdown: 030217 15:43:01 Slave: Failed reading log event, reconnecting to retry, log 'binlog.010' position 540017428 030217 15:43:01 Slave: reconnected to master 'repl@master1:3306',replication resumed in log 'binlog.010' at position 540017428 030217 15:43:01 Slave: received 0 length packet from server, apparent master shutdown: 030217 15:44:01 Slave: Failed reading log event, reconnecting to retry, log 'binlog.010' position 540017428 030217 15:44:01 Slave: reconnected to master 'repl@master1:3306',replication resumed in log 'binlog.010' at position 540017428 030217 15:44:02 Error reading packet from server: Lost connection to MySQL server during query (server_errno=2013) 030217 15:44:02 Slave: Failed reading log event, reconnecting to retry, log 'binlog.010' position 540037417 030217 15:44:02 Slave: reconnected to master 'repl@master1:3306',replication resumed in log 'binlog.010' at position 540037417 This is one complete cycle of the problem. This time, I see server_errno=2013. Perror doesn't have anything on this error. -----Original Message----- From: Jeremy Tinley [mailto:[EMAIL PROTECTED]] Sent: Monday, February 17, 2003 3:37 PM To: [EMAIL PROTECTED] Subject: received 0 length packet from server Howdy, Running MySQL 3.23.54 on master, 3.23.55 on all slaves, I'm experiencing the following situation: slave1 & slave4 both receive 0 length packets from the server. slave2 & slave3 both work fine. slave1 & 2 are identical machines both in hardware and configuration slave3 & 4 are different from 1 & 2, and from each other in hardware only The my.cnf files are the same, same subnet, different switches (but a machine that works, and one that doesn't are on the same switch). Log files look like this (trimmed for neatness): 030217 15:16:47 Slave: received 0 length packet from server, apparent master shutdown: 030217 15:16:47 Slave: Failed reading log event, reconnecting to retry, log 'binlog.010' position 531922547 030217 15:16:47 Slave: reconnected to master 'repl@master1:3306',replication resumed in log 'binlog.010' at position 531922547 030217 15:16:47 Slave: received 0 length packet from server, apparent master shutdown: 030217 15:16:47 Slave: Failed reading log event, reconnecting to retry, log 'binlog.010' position 531922771 030217 15:16:47 Slave: reconnected to master 'repl@master1:3306',replication resumed in log 'binlog.010' at position 531922771 Troubleshooting thoughts, anyone? The slaves are in an LVS cluster and can be downed at any time. --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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
