From: Nick Lindridge
Date: February 27 2000 1:56pm
Subject: Consistent mysqld coredump (3.23.11-alpha for pc-linux-gnu on i686)
List-Archive: http://lists.mysql.com/bugs/28
Message-Id: <200002271356.NAA07671@macaw.demon.co.uk>

From: nick@stripped
Subject: Consistent mysqld coredump (3.23.11-alpha for pc-linux-gnu on i686)

I just decided to try MySQL to move away from using a 'database' of 20,000 
or so flat files (although it works very well) and hit the following problem.

>Description:
	mysqld coredumps consistently when, while using a simple shell script
calling mysql repeatedly to load raw data files into a table, the table 
being written to is accessed with a select query. I used the 3.23 version
as I wanted variables and haven't rewritten things to try 3.22 yet.

	I've produced a tgz file (~573k) which contains enough datafiles and
the scripts to allow a shot at reproducing the problem. The README file shows
the assumptions that the example makes and how to execute the test. The tar
also contains typescript outputs showing the server output, output from the
database create, table create, and crash steps, and the loader output.

	The installation was the static build from the offical site.

>How-To-Repeat:
	I've produced a tgz file with the details at
		http://www.macaw.demon.co.uk/mysql-crasher.tgz
	The README file should detail everything necessary. 'tar zxvf' the file
onto a linux system, (I'm using suse 6.0), and follow the README. The shell
scripts to create the database tables, populate the database, and that crash 
the server are included, and a directory of data (amex stock symbols) is 
included to give the loader something to work on. When running the data loader
executing the crash script, perhaps a few times, kills the server.

>Fix:
	Unknown, but perhaps this has been found and fixed already.

Any info would be welcome and please email for more info if necessary. If not
fixed already, I hope the tgz helps.

Cheers,
Nick


>Originator:	Nick Lindridge
>MySQL support: none
>Synopsis:	mysqld coredumps
>Severity:	critical
>Priority:	high
>Category:	mysqld
>Class:		sw-bug
>Release:	mysql-3.23.11-alpha (Official MySQL RPM)

>Environment:
System: Linux boobox 2.0.36 #13 Sat Mar 6 23:03:41 GMT 1999 i686 unknown
Architecture: i686

Some paths:  /usr/bin/perl /usr/bin/make /usr/local/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/local/lib/gcc-lib/i686-pc-linux-gnu/egcs-2.91.66/specs
gcc version egcs-2.91.66 19990314 (egcs-1.1.2 release)
Compilation info: CC='egcs'  CFLAGS='-O6 -fomit-frame-pointer -mpentium'  CXX='egcs'  CXXFLAGS='-O6 -fomit-frame-pointer 	          -felide-constructors -fno-exceptions -fno-rtti -mpentium'  LDFLAGS=''
LIBC: 
lrwxrwxrwx   1 root     root           13 Mar  2  1999 /lib/libc.so.4 -> libc.so.4.7.6
-rwxr-xr-x   1 root     root       634880 Apr 29  1996 /lib/libc.so.4.7.6
-rwxr-xr-x   1 root     root      2478585 Jan 14  1999 /lib/libc.so.6
-rw-r--r--   1 root     root     10684978 Jan 14  1999 /usr/lib/libc.a
-rw-r--r--   1 root     root          178 Jan 14  1999 /usr/lib/libc.so
Configure command: ./configure  --disable-shared --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --enable-assembler --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/info --includedir=/usr/include --mandir=/usr/man '--with-comment=Official MySQL RPM'
Perl: This is perl, version 5.005_02 built for i586-linux