>Description: If a 'slave stop' command is while a slave is blocked waiting for a table, the slave thread must be manually killed in order for the slave stop command to complete.
>How-To-Repeat: mysql> show slave status\G *************************** 1. row *************************** Master_Host: fosters Master_User: mysql-repl Master_Port: 3306 Connect_retry: 60 Log_File: fosters-bin.1088 Pos: 266992616 Slave_Running: Yes Replicate_do_db: Replicate_ignore_db: Last_errno: 0 Last_error: Skip_counter: 0 1 row in set (0.00 sec) mysql> flush tables with read lock; Query OK, 0 rows affected (0.03 sec) (wait for slave thread to block) mysql> show processlist\G *************************** 1. row *************************** Id: 1 User: system user Host: none db: wssource_prod Command: Connect Time: 28 State: Waiting for table Info: /* WSSource::BusObj::Commit 896@DowJonesParse::Process 356@main */UPDATE dow_jones SET A_ Id = 1027 mysql> slave stop; (switch to another command interpreter) mysql> show processlist\G *************************** 1. row *************************** Id: 1 User: system user Host: none db: wssource_prod Command: Connect Time: 172 State: Waiting for table Info: /* WSSource::BusObj::Commit 896@DowJonesParse::Process 356@main */UPDATE dow_jones SET A_ Id = 1027 *************************** 2. row *************************** Id: 2 User: mysql Host: localhost db: NULL Command: Query Time: 126 State: waiting for slave to die Info: slave stop mysql> kill 2; Query OK, 0 rows affected (0.00 sec) mysql> show processlist\G *************************** 1. row *************************** Id: 1 User: system user Host: none db: wssource_prod Command: Connect Time: 213 State: Waiting for table Info: /* WSSource::BusObj::Commit 896@DowJonesParse::Process 356@main */UPDATE dow_jones SET A_ Id = 1027 *************************** 2. row *************************** Id: 2 User: mysql Host: localhost db: NULL Command: Killed Time: 167 State: waiting for slave to die Info: slave stop mysql> kill 1; >Fix: >Submitter-Id: Marc Prewitt >Originator: "Marc Prewitt" <[EMAIL PROTECTED]> >Organization: Wall Street Source >MySQL support: extended login support >Synopsis: slave stop command doesn't work if slave thread is blocked >Severity: serious >Priority: low >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: 9 min 28 sec Threads: 2 Questions: 5353 Slow queries: 1 Opens: 109 Flush tables: 3 Open tables: 1 Queries per second avg: 9.424 >Environment: System: SunOS polar 5.8 Generic_108528-15 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 1146204 Jul 11 18:02 /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 1146204 Jul 11 18:02 /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