Date: Fri, 5 May 2006 16:36:06 +0200 From: "Christian Marcos" <christian.marcos@gmail.com> To: freebsd-database@freebsd.org Subject: (mysqld), uid 88: exited on signal 11 (core dumped) Message-ID: <f3e2b6ef0605050736v502de0e1j71a4acd06db3f7ae@mail.gmail.com>
next in thread | raw e-mail | index | archive | help
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@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 ar= e welcome to change it and/or distribute copies of it under certain condition= s. 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)...do= ne. 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)
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?f3e2b6ef0605050736v502de0e1j71a4acd06db3f7ae>