>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
