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>