>Description:
Replication has been running fine for the past few months. Last
night after we did a couple of table rebuilds and a few hundred
thousand sql updates, replication started falling behind due to the
slave disconnecting every minute or so. Here's what we see in the
error log:
020604 7:08:53 Error reading packet from server: Lost connection to
MySQL server during query (read_errno 0,server_errno=
2013)
020604 7:08:53 Slave: Failed reading log event, reconnecting to retry,
log 'fosters-bin.906' position 218272266
020604 7:08:53 Slave: reconnected to master
'mysql-repl@fosters:3306',replication resumed in log 'fosters-bin.906' at
pos
ition 218272266
The slave reconnects, runs for about 1-5 minutes and then get's the same
error as above.
We have another slave which is encountering the same problem but much
less frequently (2.5 hours
between the last error and it's replication has managed to stay caught
up.
Both master and servers are running 3.23.46.
What do you think is causing the disconnects and is there any way to
debug this?
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator: Marc Prewitt
>Organization:
Wall Street Source
>MySQL support: extended login support
>Synopsis: Replication not staying connected
>Severity: critical
>Priority: high
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.46 (Source distribution)
>Server: /usr/local/bin/mysqladmin Ver 8.23 Distrib 3.23.46, for sun-solaris2.8 on
>sparc
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 3.23.46-log
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/tmp/mysql.sock
Uptime: 8 hours 36 min 18 sec
Threads: 2 Questions: 3970404 Slow queries: 127 Opens: 461 Flush
tables: 1 Open tables: 448 Queries per second avg: 128.169
>Environment:
System: SunOS polar 5.8 Generic_108528-12 sun4u sparc SUNW,Sun-Blade-1000
Architecture: sun4
Some paths: /usr/local/bin/perl /usr/local/bin/make /usr/local/bin/gcc
GCC: Reading specs from
/opt/gcc/3.0.4/lib/gcc-lib/sparc-sun-solaris2.8/3.0.4/specs
Configured with: ../3.0.4/configure
--with-gcc-version-trigger=/usr/local/src/gcc/3.0.4/gcc/version.c
--prefix=/opt/gcc/3.0.4 --with-system-zlib
Thread model: posix
gcc version 3.0.4
Compilation info: CC='/opt/gcc/2.95.2/bin/gcc' CFLAGS='-O3 -mcpu=v8
-Wa,-xarch=v8plusa' CXX='/opt/gcc/2.95.2/bin/g++' CXXFLAGS='-O3 -mcpu=v8
-Wa,-xarch=v8plusa -felide-constructors -fno-exceptions -fno-rtti'
LDFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 11 Aug 22 2001 /lib/libc.so ->
./libc.so.1
-rwxr-xr-x 1 root bin 1136748 Nov 27 2001 /lib/libc.so.1
lrwxrwxrwx 1 root root 11 Aug 22 2001 /usr/lib/libc.so ->
./libc.so.1
-rwxr-xr-x 1 root bin 1136748 Nov 27 2001 /usr/lib/libc.so.1
Configure command: ./configure --prefix=/opt/mysql/3.23.46
--with-berkeley-db --with-innobase --localstatedir=/export/DB/mysqldb
--with-unix-socket-path=/var/tmp/mysql.sock
---------------------------------------------------------------------
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
