Set variable net_read_timeout to some bigger value. http://www.mysql.com/doc/S/H/SHOW_VARIABLES.html
Nilesh Shah -----Original Message----- From: Mark Hughes [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 10, 2002 3:36 AM To: [EMAIL PROTECTED] Subject: Replication - Error reading packet from server: (server_errno=1159) Hi, We updated one of our slave servers to 3.3.51 from 3.23.38 and in common with lots of other posts i've seen we're getting lots of errors where the slave loses the connection to the master: 020710 7:24:05 Error reading packet from server: (server_errno=1159) 020710 7:25:05 Slave: Failed reading log event, reconnecting to retry, log 'update.408' position 131306 020710 7:25:05 Slave: reconnected to master '[EMAIL PROTECTED]:3306',replication resumed in log 'update.408' at position 131306 020710 7:26:12 Error reading packet from server: (server_errno=1159) 020710 7:26:12 Slave: Failed reading log event, reconnecting to retry, log 'update.408' position 132434 020710 7:26:12 Slave: reconnected to master '[EMAIL PROTECTED]:3306',replication resumed in log 'update.408' at position 132434 020710 7:26:42 Error reading packet from server: (server_errno=1159) 020710 7:27:42 Slave: Failed reading log event, reconnecting to retry, log 'update.408' position 132434 020710 7:27:42 Slave: reconnected to master '[EMAIL PROTECTED]:3306',replication resumed in log 'update.408' at position 132434 These are happening every 60 seconds or so. Some info on our architecture System: Linux int04948-2 2.2.19-6.2.16 #1 Wed Mar 13 13:03:05 EST 2002 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) Compilation info: CC='gcc' CFLAGS=' -O3' CXX='gcc' CXXFLAGS=' -O3 -felide-constructors -fno-exceptions -fno-rtti ' LDFLAGS='' LIBC: lrwxrwxrwx 1 root root 13 Jul 9 16:49 /lib/libc.so.6 -> libc-2.1.3.so -rwxr-xr-x 1 root root 4105868 Dec 8 2001 /lib/libc-2.1.3.so -rw-r--r-- 1 root root 20299228 Dec 8 2001 /usr/lib/libc.a -rw-r--r-- 1 root root 178 Dec 8 2001 /usr/lib/libc.so Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --without-berkeley-db --without-innodb --enable-assembler --enable-local-infile --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/info --includedir=/usr/include --mandir=/usr/man '--with-comment=Official MySQL RPM' CC=gcc 'CFLAGS= -O3' 'CXXFLAGS= -O3 -felide-constructors -fno-exceptions -fno-rtti ' CXX=gcc Perl: This is perl, version 5.005_03 built for i386-linux I couldn't find a solution to this, is it a known problem with 3.3.51 ? Thanks, Mark. --------------------------------------------------------------------- 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