>Description:
i set up replication according to the directions in the manual. i have
repeatedly ensured that all the tables are synced up and the logs are
cleaned before restarting. it seems to work, but the slave is constantly
generating these errors:
020711 17:18:10 Error reading packet from server: (server_errno=1159)
020711 17:18:10 Slave: Failed reading log event, reconnecting to retry, log
'rs1-bin.001' position 276
020711 17:18:10 Slave: reconnected to master 'replica@rs1private:3306',replication
resumed in log 'rs1-bin.001' at position 276
eventually (30 seconds) it will reconnect and the replication will
proceed successfully, but it's not supposed to work like this.
how do i find out what server_errno=1159 is? perror doesn't say.
>How-To-Repeat:
set up replication as i have done.
master:
[mysqld]
user = mysql
port = 3306
socket = /tmp/mysql.sock
bind-address = 192.168.1.5
datadir = /usr/local/mysql/data
skip-locking
set-variable = max_user_connections=325
set-variable = key_buffer=128M
set-variable = max_allowed_packet=1M
set-variable = table_cache=256
set-variable = sort_buffer=1M
set-variable = record_buffer=1M
set-variable = myisam_sort_buffer_size=64M
set-variable = thread_cache=8
set-variable = thread_concurrency=8
log-bin
server-id = 1
slave:
[mysqld]
user = mysql
port = 3306
socket = /tmp/mysql.sock
datadir = /usr/local/mysql/data
skip-locking
set-variable = max_user_connections=325
set-variable = key_buffer=128M
set-variable = max_allowed_packet=1M
set-variable = table_cache=256
set-variable = sort_buffer=1M
set-variable = record_buffer=1M
set-variable = myisam_sort_buffer_size=64M
set-variable = thread_cache=8
set-variable = thread_concurrency=8
master-host=rs1private
master-user=replica
master-password=xxxx
server-id=2
replicate-ignore-db=mysql
>Fix:
>Submitter-Id: jsd
>Originator: Charlie &
>Organization:
gamespot
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis: replication error - server errno 1159
>Severity: serious
>Priority: medium
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.51 (Official MySQL binary)
>Environment:
System: FreeBSD rs1.gamespot.com 4.5-RELEASE FreeBSD 4.5-RELEASE #0: Mon Jan 28
14:31:56 GMT 2002 [EMAIL PROTECTED]:/usr/src/sys/compile/GENERIC i386
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc
GCC: Using builtin specs.
gcc version 2.95.3 20010315 (release) [FreeBSD]
Compilation info: CC='gcc' CFLAGS='-O3 -fno-omit-frame-pointer' CXX='gcc'
CXXFLAGS='-O3 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti'
LDFLAGS=''
LIBC:
-r--r--r-- 1 root wheel 1208074 Jan 28 13:11 /usr/lib/libc.a
lrwxrwxrwx 1 root wheel 9 Jun 28 15:25 /usr/lib/libc.so -> libc.so.4
-r--r--r-- 1 root wheel 573760 Jan 28 13:11 /usr/lib/libc.so.4
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 --enable-assembler
--with-named-z-libs=not-used --disable-shared 'CFLAGS=-O3 -fno-omit-frame-pointer'
CXX=gcc CC=gcc 'CXXFLAGS=-O3 -fno-omit-frame-pointer -felide-constructors
-fno-exceptions -fno-rtti'
Perl: This is perl, version 5.005_03 built for i386-freebsd
---------------------------------------------------------------------
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
