Bug #733 server crash on 'purge master logs' or 'show master logs' when binlog is off
Submitted: 26 Jun 2003 7:38 Modified: 3 Jul 2003 15:44
Reporter: Sergey Kostyliov Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:4.0.13 OS:Linux (Gentoo Linux 1.4rc4)
Assigned to: Sergei Glukhov CPU Architecture:Any

[26 Jun 2003 7:38] Sergey Kostyliov
Description:
One can crash mysqld by issuing 'purge master logs' in case when binary loging is 
not configured. 
 
>Release:       mysql-4.0.13 (Source distribution) 
>Server: /usr/bin/mysqladmin  Ver 8.40 Distrib 4.0.13, for pc-linux-gnu on i686 
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          4.0.13 
Protocol version        10 
Connection              Localhost via UNIX socket 
UNIX socket             /var/run/mysqld/mysqld.sock 
Uptime:                 2 min 37 sec 
 
Threads: 1  Questions: 1  Slow queries: 0  Opens: 6  Flush tables: 1  Open 
tables: 0  Queries per second avg: 
0.006 
 
>C compiler:    gcc (GCC) 3.2.2 
>C++ compiler:  gcc (GCC) 3.2.2 
>Environment: 
       System: Linux rotor.lamport.ru 2.4.21-rc4aa1 #2 SMP Mon Jun 2 07:40:27 
UTC 2003 i686 Pentium II (Klamath) GenuineIntel GNU/Linux 
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/i686-pc-linux-gnu/3.2.2/specs 
Configured with: /var/tmp/portage/gcc-3.2.2/work/gcc-3.2.2/configure 
--prefix=/usr --bindir=/usr/i686-pc-linux-gnu/gcc-bin/3.2 
--includedir=/usr/lib/gcc-lib/i686-pc-linux-gnu/3.2.2/include 
--datadir=/usr/share/gcc-data/i686-pc-linux-gnu/3.2 
--mandir=/usr/share/gcc-data/i686-pc-linux-gnu/3.2/man 
--infodir=/usr/share/gcc-data/i686 
-pc-linux-gnu/3.2/info --enable-shared --host=i686-pc-linux-gnu 
--target=i686-pc-linux-gnu --with-system-zlib 
--enable-languages=c,c++,ada,f77,objc --enable-threads=posix 
--enable-long-long --disable-checking --enable-cs 
tdio=stdio --enable-clocale=generic --enable-__cxa_atexit 
--enable-version-specific-runtime-libs --with-gxx-in 
clude-dir=/usr/lib/gcc-lib/i686-pc-linux-gnu/3.2.2/include/g++-v3 
--with-local-prefix=/usr/local --enable-shar 
ed --enable-nls --without-included-gettext 
Thread model: posix 
gcc version 3.2.2 
Compilation info: CC='gcc'  CFLAGS='-march=pentium2 -mcpu=pentium2  -O4 
-pipe -DHAVE_ERRNO_AS_DEFINE=1'  CXX=' 
gcc'  CXXFLAGS='-march=pentium2 -mcpu=pentium2  -O4 -pipe 
-felide-constructors -fno-exceptions -fno-rtti -DUSE 
_MYSYS_NEW'  LDFLAGS=''  ASFLAGS='' 
LIBC: 
lrwxrwxrwx    1 root     root           13 Jun  2 12:25 /lib/libc.so.6 -> libc-2.3.1.so 
-rwxr-xr-x    1 root     root      1419125 May 29 19:32 /lib/libc-2.3.1.so 
-rw-r--r--    1 root     root      2516156 May 29 19:32 /usr/lib/libc.a 
-rwxr-xr-x    1 root     root          178 May 29 19:32 /usr/lib/libc.so 
lrwxrwxrwx    1 root     root           19 Jun  3 15:38 /usr/lib/libc-client.a -> 
/usr/lib/c-client.a 
Configure command: ./configure '--prefix=/usr' '--libdir=/usr/lib' 
'--exec-prefix=/usr' '--datadir=/usr/share' '--libexecdir=/usr/sbin' 
'--sysconfdir=/etc' '--mandir=/usr/share/man' '--infodir=/usr/share/info' 
'--includedir=/usr/include' '--localstatedir=/var/lib/mysql' '--enable-assembler' 
'--with-mysql-user=mysql' '--with-innodb' 
'--with-unix-socket-path=/var/run/mysqld/mysqld.sock' 
'--with-extra-charsets=latin1,koi8_ru,cp1251' '--without-openssl' 
'--build=i686-pc-linux-gnu' '--without-readline' 'CC=gcc' 
'CFLAGS=-march=pentium2 -mcpu=pentium2  -O4 -pipe 
-DHAVE_ERRNO_AS_DEFINE=1' 'CXXFLAGS=-march=pentium2 -mcpu=pentium2  
-O4 -pipe -felide-constructors -fno-exceptions -fno-rtti -DUSE_MYSYS_NEW' 
'CXX=gcc' 'build_alias=i686-pc-linux-gnu' 

How to repeat:
mysql> purge master logs to 'binlog.001'; 
ERROR 2013: Lost connection to MySQL server during query
[27 Jun 2003 0:13] Guilhem Bichot
A note for Sergey Gluhov:
this bug is true, and I also get a crash (a safemutex assertion) when doing
SHOW MASTER LOGS
when mysqld is started without --lob-bin
(I changed the bug's synopsis accordingly).
[3 Jul 2003 15:44] Michael Widenius
Thank you for your bug report. This issue has been fixed in the latest
development tree for that product. You can find more information about
accessing our development trees at 
    http://www.mysql.com/doc/en/Installing_source_tree.html

Will be fixed in 4.0.14