From owner-freebsd-database@FreeBSD.ORG  Tue Feb  7 00:22:54 2006
Return-Path: <owner-freebsd-database@FreeBSD.ORG>
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 2CE0416A420
	for <freebsd-database@freebsd.org>;
	Tue,  7 Feb 2006 00:22:54 +0000 (GMT)
	(envelope-from 000.fbsd@quip.cz)
Received: from home.quip.cz (grimm.quip.cz [213.220.192.218])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 65E5E43D4C
	for <freebsd-database@freebsd.org>;
	Tue,  7 Feb 2006 00:22:52 +0000 (GMT)
	(envelope-from 000.fbsd@quip.cz)
Received: from [192.168.1.2] (qwork.quip.test [192.168.1.2])
	by home.quip.cz (Postfix) with ESMTP id E3ED36221;
	Tue,  7 Feb 2006 01:22:50 +0100 (CET)
Message-ID: <43E7E85A.1010606@quip.cz>
Date: Tue, 07 Feb 2006 01:22:50 +0100
From: Miroslav Lachman <000.fbsd@quip.cz>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US;
	rv:1.7.12) Gecko/20050915
X-Accept-Language: cs, cz, en, en-us
MIME-Version: 1.0
To: Adam Bayless <adam@baylessfamily.org>
References: <43E7806A.8000801@baylessfamily.org>
In-Reply-To: <43E7806A.8000801@baylessfamily.org>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
Cc: freebsd-database@freebsd.org
Subject: Re: MySQL 5 crashing on 6.0
X-BeenThere: freebsd-database@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: Database use and development under FreeBSD
	<freebsd-database.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-database>, 
	<mailto:freebsd-database-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-database>
List-Post: <mailto:freebsd-database@freebsd.org>
List-Help: <mailto:freebsd-database-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-database>, 
	<mailto:freebsd-database-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Tue, 07 Feb 2006 00:22:54 -0000

Adam Bayless wrote:
> 
> MySQL is crashing and dumping a core file approximately every 4-6 hours. 
> When it crashes mysqld_safe seems to be able to restart it just fine 
> every time, but of course the innodb data has to be rebuilt from the 
> logs which takes several minutes and processing mail stops while that 
> happens. I thought initially that it must have been running into server 
> memory limits, but I cut all of MySQL's internal limits approximately in 
> half (in my.cnf) and it's still having the same trouble. There doesn't 
> seem to be a certain query that causes it to crash every time, though 
> when spamassassin runs a bayes expiration that sometimes seems to 
> trigger the crash, other times it doesn't, though it always increases 
> MySQL's CPU and memory usage.
> 
> I've set the following in /boot/loader.conf:
> 
> kern.maxdsiz="3684354560"
> kern.dfldsiz="3684354560"
> kern.maxssiz="3684354560"
> 
> 
> 'gdb -c mysqld.core' says:
> 
> Program terminated with signal 11, Segmentation fault.
> #0  0x00000000dc9cf81f in ?? ()
> 
> which doesn't help me much. Maybe someone else can make some sense of that?
> 
> Any ideas?
> 
> Thanks,
> 
> Adam
> 


Have you any useful information in mysql errorlog? (usualy 
/var/db/mysql/your.host.name.err)

Miroslav Lachman