From owner-freebsd-database@FreeBSD.ORG Fri May 5 14:50:30 2006 Return-Path: X-Original-To: freebsd-database@freebsd.org Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id CE14416A437 for ; Fri, 5 May 2006 14:50:30 +0000 (UTC) (envelope-from glenn@mail.more.net) Received: from libby.lpmo.org (libby.lpmo.org [216.106.2.138]) by mx1.FreeBSD.org (Postfix) with ESMTP id 75A7C43D4C for ; Fri, 5 May 2006 14:50:30 +0000 (GMT) (envelope-from glenn@mail.more.net) Received: from gkar.earthdome.org (81.mnetw.more.net [207.160.138.81]) by libby.lpmo.org (Postfix) with ESMTP id 904312841D for ; Fri, 5 May 2006 09:45:03 -0500 (CDT) Received: by gkar.earthdome.org (Postfix, from userid 503) id 87536620B33; Fri, 5 May 2006 09:49:15 -0500 (CDT) Date: Fri, 5 May 2006 09:49:15 -0500 From: Glenn Nielsen To: freebsd-database@freebsd.org Message-ID: <20060505144915.GA29047@gkar.earthdome.org> References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.4.2.1i Subject: Re: (mysqld), uid 88: exited on signal 11 (core dumped) X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 05 May 2006 14:50:30 -0000 I had a similar problem on FreeBSD 5.4 and filed a bug report. A patch was found which fixed the problem. See: http://www.freebsd.org/cgi/query-pr.cgi?pr=95127 Glenn On Fri, May 05, 2006 at 04:36:06PM +0200, Christian Marcos wrote: > 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 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) > _______________________________________________ > freebsd-database@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-database > To unsubscribe, send any mail to "freebsd-database-unsubscribe@freebsd.org" ---------------------------------------------------------------------- Glenn Nielsen glenn@more.net | /* Spelin donut madder | MOREnet System Programming | * if iz ina coment. | Missouri Research and Education Network | */ | ----------------------------------------------------------------------