>Description:
Hi,
I have 28 linux boxes configured identically, 27 as slaves, one as
master. On all 27 slaves, everything works fine, but only on one I have strange
errors in the logs:
011002 17:49:49 Slave: received 0 length packet from server, apparent master
shutdown: (0)
011002 17:50:49 Slave: Failed reading log event, reconnecting to retry, log
'cp4230-bin.005' position 664857
011002 17:50:49 Slave: reconnected to master 'repl@xxx:3306',replication resumed in
log 'xxx-bin.005' at position 664857
011002 17:51:49 Slave: received 0 length packet from server, apparent master
shutdown: (0)
This repeats every minute.
I repeat, replication is running fine, just these errors that are bugging me,
and only on one of 27 machines.
Could this be a networking problem of some sort?
my my.cnf:
[client]
#password = your_password
port = 3306
socket = /tmp/mysql.sock
# Here follows entries for some specific programs
# The MySQL server
[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-locking
set-variable = key_buffer=256M
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
# Try number of CPU's*2 for thread_concurrency
set-variable = thread_concurrency=4
set-variable = max_connections=2000
#log-bin
server-id = 101
master-host=xxx
master-user=repl
master-password=micro
master-port=3306
replicate-do-table=micro.screen_text
replicate-do-table=micro.websp_prices
replicate-do-table=micro.websp_flights
replicate-do-table=micro.partner_config
replicate-do-table=micro.banner_ads
replicate-do-table=micro.country
replicate-do-table=micro.partner_country
replicate-do-table=micro.es_airports
[mysqldump]
quick
set-variable = max_allowed_packet=16M
[mysql]
no-auto-rehash
[isamchk]
set-variable = key_buffer=128M
set-variable = sort_buffer=128M
set-variable = read_buffer=2M
set-variable = write_buffer=2M
[myisamchk]
set-variable = key_buffer=128M
set-variable = sort_buffer=128M
set-variable = read_buffer=2M
set-variable = write_buffer=2M
[mysqlhotcopy]
interactive-timeout
>How-To-Repeat: no idea
>Fix: no idea
>Submitter-Id: <submitter ID>
>Originator: root
>Organization: 2e Systems
>MySQL support: [none ]
>Synopsis: strange failures during replication
>Severity: non-critical
>Priority: low
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.39 (Source distribution)
>Environment:
Dual PIII/866, 1Gb RAM, SuSe 7.1
System: Linux cp4120 2.2.18-SMP #1 SMP Sat Jan 20 07:41:17 GMT 2001 i686 unknown
Architecture: i686
Some paths: /usr/bin/perl
Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS=''
LIBC:
-rwxr-xr-x 1 root root 1382179 Jan 19 2001 /lib/libc.so.6
-rw-r--r-- 1 root root 2585872 Jan 19 2001 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Jan 19 2001 /usr/lib/libc.so
Configure command: ./configure --prefix=/web/soft/mysql-3.23.39 --without-docs
--without-bench --without-readline --without-debug --with-pthread
--with-charset=german1
---------------------------------------------------------------------
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
