>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-mysqld-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
