threads/135673: databases/mysql50-server - MySQL query lock-ups on 7.2-RELEASE amd64

[Attilio Rao]

2009/11/24 Conor McDermottroe <ports at mcdermottroe.com>:
> The following reply was made to PR threads/135673; it has been noted by GNATS.
>
> From: Conor McDermottroe <ports at mcdermottroe.com>
> To: bug-followup at FreeBSD.org, freebsd-bugs at desert.net
> Cc:
> Subject: Re: threads/135673: databases/mysql50-server - MySQL query
>        lock-ups on 7.2-RELEASE amd64
> Date: Tue, 24 Nov 2009 15:19:38 +0000
>
>  Thanks very much for the patch, we were running into it as well. The good
>  news is that it improves the situation quite a bit. The bad news is that
>  it does not appear to cure the problem entirely. Under heavy load we see
>  the same problem re-occurring.
>
>  We'll be bringing up another machine with 8.0 in the coming weeks and I
>  hope to test it then.
>
>  We're currently avoiding this bug by under-loading the 7.2 machine and
>  handling more queries on a different 7.0 machine. Is there any
>  information I can provide which would help diagnose this bug further?

My last findings were revealing a sudden zeroing of userland
structures where a lock was embedded, leaving some waiters on such
locks stuck in the kernel.
I think this is a MySQL bug and I feel to suggest you to upgrade to
newest MySQL versions.

Attilio


-- 
Peace can only be achieved by understanding - A. Einstein