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
