From owner-freebsd-stable@FreeBSD.ORG Mon Feb 4 16:05:45 2008 Return-Path: Delivered-To: freebsd-stable@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 9974316A46E for ; Mon, 4 Feb 2008 16:05:45 +0000 (UTC) (envelope-from primeroz.lists@googlemail.com) Received: from rv-out-0910.google.com (rv-out-0910.google.com [209.85.198.191]) by mx1.freebsd.org (Postfix) with ESMTP id 1FFF813C4E5 for ; Mon, 4 Feb 2008 16:05:44 +0000 (UTC) (envelope-from primeroz.lists@googlemail.com) Received: by rv-out-0910.google.com with SMTP id g13so1659601rvb.43 for ; Mon, 04 Feb 2008 08:05:44 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=googlemail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; bh=KOEOYuGhD6cMP6Rn9T+wxIPSQqgg3eCLINb5UR3A+lQ=; b=DqlqlD6h9l8i+cVBBYvCWIW6GXAyysKnm4pkwCT534ZgxJD8F6oCD1TFnCdKMqWOBS0BehrQdK77r7HTZk7cgVs70vLxFbnnqVZF+RL6N2RoFX9wQ3jU0b3/QFLWr/xIktSJHcxV2ljZzSq0+QdUb/FG3gUcfwNaopEKk4sebG8= DomainKey-Signature: a=rsa-sha1; c=nofws; d=googlemail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=QMCPkvv9FL8BHdyjbl31UxSlBA1sLvkYAWgdySle8jp6PCcIujW7wm8hmzHZm3MBqMF0elzubSSm+amX6MLigrQhfYq8iNSbT3Nw3nrZZqsYYkOo+lbkM7aWkmstl77T0+QPKFtaESUf3y4z6PrtHnlr5rwLhstYR8Y+SQkD8mw= Received: by 10.141.99.4 with SMTP id b4mr2627452rvm.275.1202141144468; Mon, 04 Feb 2008 08:05:44 -0800 (PST) Received: by 10.140.203.6 with HTTP; Mon, 4 Feb 2008 08:05:44 -0800 (PST) Message-ID: <55b8c6fe0802040805o5c075e54m42145fec4a1fd4c1@mail.gmail.com> Date: Mon, 4 Feb 2008 16:05:44 +0000 From: "Primeroz lists" To: "Jeremy Chadwick" In-Reply-To: <20080204152803.GB11397@eos.sc1.parodius.com> MIME-Version: 1.0 References: <55b8c6fe0802040450r7ca3e739s931be2d38f499fc2@mail.gmail.com> <20080204133832.GA6950@eos.sc1.parodius.com> <55b8c6fe0802040619m8728e68kbe408ee4a94e591a@mail.gmail.com> <20080204152803.GB11397@eos.sc1.parodius.com> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Content-Filtered-By: Mailman/MimeDel 2.1.5 Cc: freebsd-stable@freebsd.org Subject: Re: Crashing repeatedly: 6.2-RELEASE-p5 and MySQL 5.0.41 X-BeenThere: freebsd-stable@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Production branch of FreeBSD source code List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 04 Feb 2008 16:05:45 -0000 > > We use mysql-server-5.0.45 (fairly old, since newest is 5.0.51a); yours > is a bit older. I'll have to look at the ChangeLog between 5.0.41 and > 5.0.51a to see if there's any relevant changes which might give hints to > what's causing it. > > I don't see any changes relevant between 5.0.41 and 5.0.45, 5.0.51, > nor 5.0.51a which could cause what you're seeing. Yes, i looked at that changes but nothing really seemed to relate to my issue that's why i did not proceeded with a mysql straight upgrade. > > > > I did not setup anything in the /boot/loader.conf so i guess i'm using > > default values for all of those settings, > > See my other mail; amd64 might be doing something different with those > values (calculating them in a more appropriate manner?). I'm looking into that right now , especially about having a maxdsiz bigger then actual RAM+Swap ... > A few more questions: > > 1) Shortly before the kernel panics, do you get any odd messages in > /var/log/messages or on the console itself? (dmesg -a could help here). > I'm left wondering if maybe the problem is something else, like a disk > issue or other oddity and is manifesting itself in an odd way. Not at all ... very wierd indeed. I see totally nothing bad in all sort of information i can find before the crash. Everything is fine and then at some point i see the messages from kernel booting again. > > 2) Are you remapping any libraries using /etc/libmap.conf, such as > transparently remapping pthread to kse? > No, i'm remapping libpthread -> libthr but we run the same mapping on a bunch of other mysql server without issues > > 3) How big are all the InnoDB tables? If you're not sure, how big do > the ibdata* and ib_logfile* files grow to? > Quite big actually, -rw-rw---- 1 mysql mysql 5.0M Feb 4 15:58 ib_logfile0 -rw-rw---- 1 mysql mysql 5.0M Feb 4 15:58 ib_logfile1 -rw-rw---- 1 mysql mysql 4.2G Feb 4 15:58 ibdata1 ... ... thanks FC