List:General Discussion« Previous MessageNext Message »
From:Jeff Kilbride Date:July 10 2002 8:26pm
Subject:Re: Replication - Error reading packet from server: (server_errno=1159)
View as plain text  
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" <mark@stripped>
To: "Nilesh Shah" <nshah@stripped>
Cc: <mysql@stripped>
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:mark@stripped]
> > Sent: Wednesday, July 10, 2002 3:36 AM
> > To: mysql@stripped
> > 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
> > 'repuser@stripped: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
> > 'repuser@stripped: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
> > 'repuser@stripped: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 <mysql-thread114167@stripped>
> > To unsubscribe, e-mail
> > <mysql-unsubscribe-nshah=vonage.com@stripped>
> > 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 <mysql-thread114218@stripped>
> To unsubscribe, e-mail
<mysql-unsubscribe-jeff=kilbride.com@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>

Thread
Replication - Error reading packet from server: (server_errno=1159)Mark Hughes10 Jul
RE: Replication - Error reading packet from server: (server_errno=1159)Nilesh Shah10 Jul
  • RE: Replication - Error reading packet from server: (server_errno=1159)Mark Hughes10 Jul
    • Re: Replication - Error reading packet from server: (server_errno=1159)Jeremy Zawodny10 Jul
    • Re: Replication - Error reading packet from server: (server_errno=1159)Jeff Kilbride10 Jul
  • Re: Replication - Error reading packet from server: (server_errno=1159)Jeff Kilbride11 Jul
    • Re: Replication - Error reading packet from server: (server_errno=1159)Jeremy Zawodny11 Jul