From: Date: March 14 2003 8:38am
Subject: Thread freezes on SLAVE START/STOP
List-Archive: http://lists.mysql.com/bugs/13957
Message-Id: <1184810487.20030314103837@kaluga.ru>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

>Description:
        A  thread  in  which SLAVE START/STOP was issued freezes. E.g.
        'mysql'  can  be  only  exited  by  pressing Ctrl-C. Actually,
        only first command is executed. Next are ignored.
        Sideeffects  tends to be table files corruption, 'master.info'
        erase.
        Now (4.0.11) they freeze even after server full restart.
        We tried different mysql versions: 4.0.7, 4.0.8, 4.0.11
>How-To-Repeat:
        The  exact  conditions  are  unknown.  Sometimes they work. It
        looks  like  fault  happens after any replication error. (E.g.
        table update error). But I'm not sure.
>Fix:
        -

>Submitter-Id:
>Originator:    Pavel Merdine
>Organization:  Fotki Inc.
>MySQL support: none
>Synopsis:      SLAVE START/STOP freezes
>Severity:      serious
>Priority:      medium
>Category:      mysql
>Class:         sw-bug
>Release:       mysql-4.0.11-gamma-standard (Official MySQL-standard binary)

>C compiler:    2.95.4
>C++ compiler:  2.95.4
>Environment:
        CPU:  Dual  Pentium III/Pentium III Xeon (451.03-MHz)
        avail memory = 777900032 (759668K bytes)
        <machine, os, target, libraries (multiple lines)>
        System:  FreeBSD  dev.fotki.com  4.7-STABLE FreeBSD 4.7-STABLE
        #1: Thu Jan  9 17:40:50 GMT 2003 
        Some  paths:  /usr/bin/perl /usr/bin/make /usr/local/bin/gmake
        /usr/bin/gcc /usr/bin/cc 
        GCC: Using builtin specs.
        gcc version 2.95.4 20020320 [FreeBSD]
        Compilation  info:  CC='gcc'   CFLAGS='-DHAVE_BROKEN_REALPATH'
        CXX='g++'  CXXFLAGS=''  LDFLAGS=''  ASFLAGS='' 
        LIBC:
        -r--r--r--  1 root  wheel  1218496 Oct  9 08:43 /usr/lib/libc.a
        lrwxrwxrwx   1 root  wheel  9 Jan  8 05:16 /usr/lib/libc.so ->
        libc.so.4 
        -r--r--r--  1 root  wheel  574916 Oct  9 08:43 /usr/lib/libc.so.4
        Configure  command:  ./configure  '--prefix=/usr/local/mysql'
        '--with-comment=Official      MySQL-standard      binary'
        '--with-extra-charsets=complex'
        '--with-server-suffix=-standard' '--enable-thread-safe-client'
        '--enable-local-infile'          '--enable-assembler'
        '--with-named-z-libs=not-used'        '--disable-shared'
        '--with-innodb' 'CFLAGS=-DHAVE_BROKEN_REALPATH'