>Description:
Deadlock occurs when slave is locked trying to write to table that was
write locked by separate process who then tries to do a slave stop. This should
only happen on a mutual master set up (i.e. 2 servers that are each other's
master); otherwise, the only write locks would be by the slave itself.
>How-To-Repeat:
Constantly write to table on master. On slave, perform 'lock {table}
write' followed by 'slave stop'. Sooner or later, the 'slave stop' will block on
access to the system user thread, which itself is blocked trying to perform the
slave write. If not blocked, do 'slave start' and 'unlock tables'. Then, repeat,
starting at lock step.
>Fix:
I haven't tried it yet, but I feel pretty sure that stopping the slave b
efore getting the write lock will avoid the problem.
>Submitter-Id: Rob West
>Originator: Rob West
>Organization:
Tekelec
>MySQL support: licence
>Synopsis: Deadlock between slave stop and table lock
>Severity: non-critical
>Priority: low
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.33 (Source distribution)
>Environment:
System: SunOS mpsa-c577d4 5.7 Generic_106541-08 sun4u sparc SUNW,Ultra-80
Architecture: sun4
Some paths: /usr/bin/perl /usr/ccs/bin/make /usr/ucb/cc
Compilation info: CC='gcc' CFLAGS='' CXX='gcc' CXXFLAGS='' LDFLAGS=''
LIBC:
-rw-r--r-- 1 bin bin 1690732 Oct 14 1999 /lib/libc.a
lrwxrwxrwx 1 root root 11 Jul 7 17:55 /lib/libc.so -> ./libc.so.
1
-rwxr-xr-x 1 bin bin 1109336 Oct 14 1999 /lib/libc.so.1
-rw-r--r-- 1 bin bin 1690732 Oct 14 1999 /usr/lib/libc.a
lrwxrwxrwx 1 root root 11 Jul 7 17:55 /usr/lib/libc.so -> ./libc
.so.1
-rwxr-xr-x 1 bin bin 1109336 Oct 14 1999 /usr/lib/libc.so.1
Configure command: ./configure --with-unix-socket-path=/var/tmp/mysql.sock --wi
th-low-memory --with-mit-threads=yes --without-perl --enable-thread-safe-client
--without-berkeley-db
Perl: This is perl, version 5.005_03 built for sun4-solaris
---------------------------------------------------------------------
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
