Check the list. This question has been asked before many time. You can set net_read_timeout variable to bigger value to avoid this problem.
Still no one knows (or answered) impact of net_read_timeout and wait_timeout. which one takes precedence. Nilesh -----Original Message----- From: Santiago Alba [mailto:[EMAIL PROTECTED]] Sent: Monday, July 15, 2002 11:35 AM To: Pierre Baridon; David Harper; [EMAIL PROTECTED] Subject: RE: Replication slave repeatedly gets error 1159 from master Yes, I have a cluster installed with 3.23.49 and I have any problem. Now, I am installing a new cluster with 3.23.51 version and it's appearing these problems. Could anybody help us? Thanks in advance. Santiago. ----- Original Message ----- From: Pierre Baridon <[EMAIL PROTECTED]> To: David Harper <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, July 15, 2002 4:29 PM Subject: Re: Replication slave repeatedly gets error 1159 from master i have the same probem since i ugraded my slave from 3.23.50 to 3.23.51 Pierre ----- Original Message ----- From: "David Harper" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, July 15, 2002 1:26 PM Subject: Replication slave repeatedly gets error 1159 from master > >Description: > Every 60 seconds, the replication slave gets an error 1159 from > the master server. Thirty seconds later, it reconnects to the master. > Then the cycle starts all over again. I have master-connect-retry=30 in > the config file. > > Here is an extract of the replication slave's error log: > > 020715 12:05:33 Error reading packet from server: (server_errno=1159) > 020715 12:06:03 Slave: Failed reading log event, reconnecting to retry, log 'mysql.001' position 73 > 020715 12:06:03 Slave: reconnected to master 'slave@venus:24641',replication resumed in log 'mysql.001' at position 73 > 020715 12:06:33 Error reading packet from server: (server_errno=1159) > 020715 12:07:03 Slave: Failed reading log event, reconnecting to retry, log 'mysql.001' position 73 > 020715 12:07:03 Slave: reconnected to master 'slave@venus:24641',replication resumed in log 'mysql.001' at position 73 > > In between disconnections, replication *appears* to be occurring correctly, > but it is rather disturbing that there seems to be some kind of communication > problem between the master and slave servers. > > This problem did not occur in version 3.23.49, by the way. It appeared when > we upgraded to 3.23.51. > > >How-To-Repeat: > Set up a master/slave replication pair of servers. > >Fix: > Not known. > > >Submitter-Id: <submitter ID> > >Originator: David Harper > >Organization: Wellcome Trust Sanger Institute, Hinxton, Cambridge CB10 1SA, England > > > >MySQL support: none > >Synopsis: Replication slave repeatedly gets error 1159 from master > >Severity: serious > >Priority: medium > >Category: mysql > >Class: sw-bug > >Release: mysql-3.23.51 (Official MySQL binary) > >Environment: > > System: OSF1 mars V5.1 732 alpha > Machine: alpha > Some paths: /bin/perl /bin/make /usr/local/bin/gmake /usr/local/bin/gcc /bin/cc > GCC: Reading specs from /usr/local/lib/gcc-lib/alpha-dec-osf5.1/3.0.3/specs > Configured with: ../configure > Thread model: single > gcc version 3.0.3 > Compilation info: CC='cc -pthread' CFLAGS='-O4 -ansi_alias -ansi_args -fast -inline speed -speculate all' CXX='cxx -pthread' CXXFLAGS='-O4 -ansi_alias -fast -inline speed -speculate all -noexceptions -nortti' LDFLAGS='' > LIBC: > lrwxrwxrwx 1 root system 17 Mar 30 2001 /lib/libc.a -> ../ccs/lib/libc.a > lrwxrwxrwx 1 root system 17 Mar 30 2001 /usr/lib/libc.a -> ../ccs/lib/libc.a > Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --with-server-suffix= --enable-thread- safe-client --enable-local-infile --with-prefix=/usr/local/mysql --with-mysq ld-ldflags=-all-static --disable-shared '--with-named-thread-libs=-lpthread -lmach -lexc -lc' --disable-shared 'CC=cc -pthread' 'CFLAGS=-O4 -ansi_alias -ansi_args -fast -inline speed -speculate all' 'CXXFLAGS=-O4 -ansi_alias -fast -inline speed -speculate all -noexceptions -nortti' 'CXX=cxx -pthread' > Perl: This is perl, version 5.005_03 built for alpha-dec_osf > > --------------------------------------------------------------------- > 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 --------------------------------------------------------------------- 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
