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.
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.
I've produced a tgz file with the details at
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.
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.
>Originator: Nick Lindridge
>MySQL support: none
>Synopsis: mysqld coredumps
>Release: mysql-3.23.11-alpha (Official MySQL RPM)
System: Linux boobox 2.0.36 #13 Sat Mar 6 23:03:41 GMT 1999 i686 unknown
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=''
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
|• Consistent mysqld coredump (3.23.11-alpha for pc-linux-gnu on i686)||Nick Lindridge||27 Feb|