Skip site navigation (1)Skip section navigation (2)
Date:      Tue, 07 Feb 2006 01:22:50 +0100
From:      Miroslav Lachman <000.fbsd@quip.cz>
To:        Adam Bayless <adam@baylessfamily.org>
Cc:        freebsd-database@freebsd.org
Subject:   Re: MySQL 5 crashing on 6.0
Message-ID:  <43E7E85A.1010606@quip.cz>
In-Reply-To: <43E7806A.8000801@baylessfamily.org>
References:  <43E7806A.8000801@baylessfamily.org>

next in thread | previous in thread | raw e-mail | index | archive | help
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



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?43E7E85A.1010606>