(mysqld), uid 88: exited on signal 11 (core dumped)

[Christian Marcos]

Hi.

I have a problem with mysql and FreeBSD 6.0. It keeps crasching about
2-3 times a day, mainly under more "heavy" trafic (about 350 queries
per second). It's a production server running mainly myisam tables.

/var/log/messages shows:
May  5 14:55:14 garaget kernel: pid 43383 (mysqld), uid 88: exited on
signal 11 (core dumped)

uname -a shows
FreeBSD garaget.org 6.0-RELEASE FreeBSD 6.0-RELEASE #7: Mon Dec  5
06:02:08 CET 2005     chrizz at Elita:/usr/obj/usr/src/sys/SMP  amd64

I have run gdb and the output is shown below.

I appreciate any help I could get. Thanks.


garaget:/var/db/mysql# gdb /usr/local/libexec/mysqld mysqld.core
GNU gdb 6.1.1 [FreeBSD]
Copyright 2004 Free Software Foundation, Inc.
GDB is free software, covered by the GNU General Public License, and you are
welcome to change it and/or distribute copies of it under certain conditions.
Type "show copying" to see the conditions.
There is absolutely no warranty for GDB.  Type "show warranty" for details.
This GDB was configured as "amd64-marcel-freebsd"...(no debugging
symbols found)...
Core was generated by `mysqld'.
Program terminated with signal 11, Segmentation fault.
Reading symbols from /lib/libz.so.3...(no debugging symbols found)...done.
Loaded symbols for /lib/libz.so.3
Reading symbols from /usr/lib/libwrap.so.4...(no debugging symbols
found)...done.
Loaded symbols for /usr/lib/libwrap.so.4
Reading symbols from /lib/libcrypt.so.3...(no debugging symbols found)...done.
Loaded symbols for /lib/libcrypt.so.3
Reading symbols from /usr/lib/libstdc++.so.5...(no debugging symbols
found)...done.
Loaded symbols for /usr/lib/libstdc++.so.5
Reading symbols from /lib/libm.so.4...(no debugging symbols found)...done.
Loaded symbols for /lib/libm.so.4
Reading symbols from /usr/lib/libpthread.so.2...(no debugging symbols
found)...done.
Loaded symbols for /usr/lib/libpthread.so.2
Reading symbols from /lib/libc.so.6...(no debugging symbols found)...done.
Loaded symbols for /lib/libc.so.6
Reading symbols from /libexec/ld-elf.so.1...(no debugging symbols found)...done.
Loaded symbols for /libexec/ld-elf.so.1
#0  0x000000080108d81f in pthread_mutexattr_init () from
/usr/lib/libpthread.so.2
[New Thread 0x19761c00 (LWP 100516)]
[New Thread 0x19715000 (LWP 100527)]
[New Thread 0x196f2c00 (LWP 100111)]
[New Thread 0x1979d800 (LWP 100495)]
[New Thread 0x1979d400 (LWP 100415)]
[New Thread 0x19687c00 (LWP 100490)]
[New Thread 0x19687000 (LWP 100445)]
[New Thread 0x196bbc00 (LWP 100487)]
[New Thread 0x196bb800 (LWP 100331)]
[New Thread 0x19687800 (LWP 100474)]
[New Thread 0x19687400 (LWP 100443)]
[New Thread 0x196a9800 (LWP 100460)]
[New Thread 0x19720400 (LWP 100477)]
[New Thread 0x196a9400 (LWP 100442)]
[New Thread 0x196a9000 (LWP 100431)]
[New Thread 0x19658c00 (LWP 100159)]
[New Thread 0x19461c00 (LWP 100499)]
[New Thread 0x1950f800 (LWP 100496)]
[New Thread 0x19461000 (LWP 100459)]
[New Thread 0x194cf400 (LWP 100522)]
[New Thread 0x19511c00 (LWP 100461)]
[New Thread 0x19528000 (LWP 100425)]
[New Thread 0x192fc800 (LWP 100475)]
[New Thread 0x19022c00 (LWP 100444)]
[New Thread 0x191aec00 (LWP 100410)]
[New Thread 0x190c4000 (LWP 100319)]
[New Thread 0x19022800 (LWP 100456)]
[New Thread 0x18f58800 (LWP 100352)]
[New Thread 0x189cb000 (LWP 100422)]
[New Thread 0x189a2400 (LWP 100414)]
[New Thread 0x18958400 (LWP 100393)]
[New Thread 0x18712800 (LWP 100210)]
[New Thread 0x184ac800 (LWP 100286)]
[New Thread 0x18f08800 (LWP 100398)]
[New Thread 0x18f08400 (LWP 100073)]
[New Thread 0x18c9f800 (LWP 100241)]
[New Thread 0x18cd9400 (LWP 100335)]
[New Thread 0x18852800 (LWP 100312)]
[New Thread 0x18aaf000 (LWP 100351)]
[New Thread 0x18ac4800 (LWP 100309)]
[New Thread 0x18ac4c00 (LWP 100166)]
[New Thread 0x18aaf400 (LWP 100251)]
[New Thread 0x18af1c00 (LWP 100320)]
[New Thread 0x188a0800 (LWP 100221)]
[New Thread 0x18810400 (LWP 100115)]
[New Thread 0x18720400 (LWP 100084)]
[New Thread 0x185c6c00 (LWP 100284)]
[New Thread 0x184ce400 (LWP 100363)]
[New Thread 0x18720000 (LWP 100310)]
[New Thread 0x18684c00 (LWP 100268)]
[New Thread 0x18628c00 (LWP 100290)]
[New Thread 0x1856b800 (LWP 100274)]
[New Thread 0x183e4800 (LWP 100329)]
[New Thread 0x183e4400 (LWP 100204)]
[New Thread 0x18f6d800 (LWP 100302)]
[New Thread 0x18f32000 (LWP 100288)]
[New Thread 0x18edc400 (LWP 100280)]
[New Thread 0x18b50400 (LWP 100279)]
[New Thread 0x18d5c400 (LWP 100263)]
[New Thread 0x18a6a000 (LWP 100212)]
[New Thread 0x18615c00 (LWP 100267)]
[New Thread 0x1825ec00 (LWP 100101)]
[New Thread 0x1825e400 (runnable)]
[New Thread 0x1825e000 (sleeping)]
[New Thread 0x18250c00 (sleeping)]
[New Thread 0x18250400 (sleeping)]
[New Thread 0x18250000 (sleeping)]
[New Thread 0x9c2c00 (sleeping)]
[New Thread 0x9c2800 (sleeping)]
[New Thread 0x9c2400 (LWP 100252)]
[New Thread 0x9c2000 (LWP 100163)]
(gdb)