>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