Yeah, I'm getting these errors all the time on 3.23.51, also. I agree that the slave_net_timeout variable is definitely not being paid any attention. However, I'm not comfortable just upping the net_read_timeout without knowing what other effects it might have.
--jeff ----- Original Message ----- From: "Mark Hughes" <[EMAIL PROTECTED]> To: "Nilesh Shah" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, July 10, 2002 9:57 AM Subject: RE: Replication - Error reading packet from server: (server_errno=1159) > Thanks, I had a look at that and it seems that slave_net_timeout is the > variable that should be used and this is set to 3600 seconds - however it > appears that the net_read_timeout is being used and by changing this from > 30 to 3600 seconds the messages seem to have gone away. > > In the 3.23.38 version we are using with our other slaves they never > timeout and the slave_new_timeout variable doesn't exist - it would > seem that some code has been introduced to allow the slave connections to > timeout but is using the net_read_timeout variable rather than the > slave_net_timeout variable as I would expect. > > > On Wed, 10 Jul 2002, Nilesh Shah wrote: > > > 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 > --------------------------------------------------------------------- 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
