Date: Fri, 05 May 2006 11:57:39 -0500 From: Matt Hartzell <mchartzell@getdts.com> To: Christian Marcos <christian.marcos@gmail.com> Cc: freebsd-database@freebsd.org Subject: Re: (mysqld), uid 88: exited on signal 11 (core dumped) Message-ID: <445B8403.7030605@getdts.com> In-Reply-To: <f3e2b6ef0605050736v502de0e1j71a4acd06db3f7ae@mail.gmail.com> References: <f3e2b6ef0605050736v502de0e1j71a4acd06db3f7ae@mail.gmail.com>
next in thread | previous in thread | raw e-mail | index | archive | help
This is a multi-part message in MIME format. --------------060802060203010603090707 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit I had almost the same issue on several mysql 5.0 servers running on freebsd 6.0. My problem continued to get worse as I restarted the database each time after the crash. The final solution was to get the server up (--skip-networking) and do a mysql-dump. Then I looked through the sample my.cnf files provided in /usr/local/share/mysql By reading the comments in those files I was able to craft a my.cnf that is now quite stable and fast. After I had the server going, I re-imported my data. Knock on wood, but things have run quite smoothly on the 5 or so servers I have used this my.cnf on. 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" > -- Matt Hartzell Founder, Owner Digital Technology and Surveillance 1622 Sycamore Church Road Branson, Missouri 65616 417-334-8077 417-334-8078 fax mchartzell@getdts.com www.getdts.com for support: support@getdts.com --------------060802060203010603090707--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?445B8403.7030605>