i386/91051: mysql crashes under load with FreeBSD 6.0

[Edwin Ringersma]

>Number:         91051
>Category:       i386
>Synopsis:       mysql crashes under load with FreeBSD 6.0
>Confidential:   no
>Severity:       serious
>Priority:       medium
>Responsible:    freebsd-i386
>State:          open
>Quarter:        
>Keywords:       
>Date-Required:
>Class:          sw-bug
>Submitter-Id:   current-users
>Arrival-Date:   Thu Dec 29 12:10:07 GMT 2005
>Closed-Date:
>Last-Modified:
>Originator:     Edwin Ringersma
>Release:        6.0 release
>Organization:
Introweb
>Environment:
FreeBSD web9.introweb.nl 6.0-RELEASE FreeBSD 6.0-RELEASE #1: Wed Dec 14 12:01:21 CET 2005     root at web9.introweb.nl:/usr/src/sys/i386/compile/web9  i386

>Description:
Mysql 4 crashes under load with FreeBSD 6.0.
Signal 6.
Started with dual P3, gmirror disks, custom SMP kernel.
Went to P4-2.8 with single ATA disk generic kernel.
Problem stays the same.
First tried build from source, went to ports version.
Problem stays the same. Message mentioning threads.
Finally went to FreeBSD 5.4 with the same machine and MySQL,
problem solved.

Combination FreeBSD 6 and Mysql 4 looks to be problematic.

>How-To-Repeat:
Just put some load on the mysql-server.

>Fix:
Use FreeBSD 5.4 instead of FreeBSD 6.0
>Release-Note:
>Audit-Trail:
>Unformatted: