MySQL 5 crashing on 6.0

[Miroslav Lachman]

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