MySQL 4.1: master and slave both crash when using RESET SLAVE

MySQL 4.1: master and slave both crash when using RESET SLAVE

am 25.11.2002 22:30:51 von gbichot

Description:
I set up a master and a slave, both running on the same machine (I know it's artificial, that's
for testing).
They are compiled with --with-debug (exactly, using BUILD/compile-pentium-debug).
When the 2 servers are started, and the slave thread is running, I issue
RESET SLAVE
(I know this is maybe illegal and maybe I should do STOP SLAVE; RESET SLAVE; START SLAVE;)
This makes BOTH servers (master and slave) crash immediately.
Slave reports it crashed in sql/slave.cc at :
int start_slave_thread (void *(*) (void *), safe_mutex_t *, safe_mutex_t *, pthread_cond_t *,
volatile bool *, volatile ulong *, MASTER_INFO *): Assertion `mi->inited' failed.
This is a DBUG_ASSERT assertion.


How-To-Repeat:
#master
mysqld_safe --no-defaults --skip-innodb --user=mysql --datadir=/usr/local/mysql/var1 --server-id=1
&
#slave
mysqld_safe --no-defaults --skip-innodb --user=mysql --datadir=/usr/local/mysql/var2 --port=3307
--server-id=2 --socket=/tmp/mysql.sock.2 --master_host=localhost --master_port=3306
--master_user=root --master_password= &
#open a mysql client to the slave
mysql --no-defaults -uroot --socket=/tmp/mysql.sock.2
#be sure that the slave thread is running, and do
RESET SLAVE

Fix:
?

Originator: Guilhem Bichot
Synopsis: MySQL 4.1: master and slave both crash when using RESET SLAVE
Release: mysql-4.1.0-alpha (Source distribution) from bitkeeper tree pulled 11-25
Server version 4.1.0-alpha-debug-log
System: Linux localhost.localdomain 2.4.18-6mdk #1 Fri Mar 15 02:59:08 CET 2002 i686 unknown
Architecture: i686

Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i586-mandrake-linux-gnu/2.96/specs
gcc version 2.96 20000731 (Mandrake Linux 8.2 2.96-0.76mdk)
Compilation info: CC='gcc' CFLAGS='-Wimplicit -Wreturn-type -Wswitch -Wtrigraphs -Wcomment -W
-Wchar-subscripts -Wformat -Wparentheses -Wsign-compare -Wwrite-strings -Wunused -mcpu=pentiumpro
-DUNIV_MUST_NOT_INLINE -DEXTRA_DEBUG -DFORCE_INIT_OF_VARS -DSAFEMALLOC -DPEDANTIC_SAFEMALLOC
-DSAFE_MUTEX -O1' CXX='gcc' CXXFLAGS='-Wimplicit -Wreturn-type -Wswitch -Wtrigraphs -Wcomment -W
-Wchar-subscripts -Wformat -Wparentheses -Wsign-compare -Wwrite-strings -Woverloaded-virtual
-Wsign-promo -Wreorder -Wctor-dtor-privacy -Wnon-virtual-dtor -felide-constructors
-fno-exceptions -fno-rtti -mcpu=pentiumpro -DUNIV_MUST_NOT_INLINE -DEXTRA_DEBUG
-DFORCE_INIT_OF_VARS -DSAFEMALLOC -DPEDANTIC_SAFEMALLOC -DSAFE_MUTEX -O1' LDFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 13 Oct 4 22:32 /lib/libc.so.6 -> libc-2.2.4.so
-rwxr-xr-x 1 root root 1275300 Mar 7 2002 /lib/libc-2.2.4.so
-rw-r--r-- 1 root root 27274138 Mar 7 2002 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Mar 7 2002 /usr/lib/libc.so
Configure command: ./configure --prefix=/usr/local/mysql --enable-assembler
--with-extra-charsets=complex --enable-thread-safe-client --with-debug --enable-local-infile
'CFLAGS=-Wimplicit -Wreturn-type -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat
-Wparentheses -Wsign-compare -Wwrite-strings -Wunused -mcpu=pentiumpro -DUNIV_MUST_NOT_INLINE
-DEXTRA_DEBUG -DFORCE_INIT_OF_VARS -DSAFEMALLOC -DPEDANTIC_SAFEMALLOC -DSAFE_MUTEX -O1'
'CXXFLAGS=-Wimplicit -Wreturn-type -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat
-Wparentheses -Wsign-compare -Wwrite-strings -Woverloaded-virtual -Wsign-promo -Wreorder
-Wctor-dtor-privacy -Wnon-virtual-dtor -felide-constructors -fno-exceptions -fno-rtti
-mcpu=pentiumpro -DUNIV_MUST_NOT_INLINE -DEXTRA_DEBUG -DFORCE_INIT_OF_VARS -DSAFEMALLOC
-DPEDANTIC_SAFEMALLOC -DSAFE_MUTEX -O1' CXX=gcc



___________________________________________________________
Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français !
Yahoo! Mail : http://fr.mail.yahoo.com

------------------------------------------------------------ ---------
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 bugs-thread13115@lists.mysql.com
To unsubscribe, e-mail