From owner-freebsd-stable@FreeBSD.ORG Sun Jan 2 02:17:09 2005 Return-Path: Delivered-To: freebsd-stable@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 0C44416A4CE for ; Sun, 2 Jan 2005 02:17:09 +0000 (GMT) Received: from natco8.natcotech.com (natco8.natcotech.com [205.167.142.108]) by mx1.FreeBSD.org (Postfix) with ESMTP id BA72943D1F for ; Sun, 2 Jan 2005 02:17:08 +0000 (GMT) (envelope-from smartweb@leadhill.net) Received: from localhost (int9.natcotech.com [192.168.1.9]) by natco8.natcotech.com (Postfix) with ESMTP id 26AA92983EA for ; Sat, 1 Jan 2005 20:17:08 -0600 (CST) Received: from natco8.natcotech.com ([192.168.1.8]) by localhost (natco9 [192.168.1.9]) (amavisd-new, port 10024) with LMTP id 15739-01-20 for ; Sat, 1 Jan 2005 20:17:08 -0600 (CST) Received: from [192.168.0.4] (lhr5-dial-12-28-24-42.natcotech.com [12.28.24.42]) by natco8.natcotech.com (Postfix) with ESMTP id BBA8C2981FA for ; Sat, 1 Jan 2005 20:17:07 -0600 (CST) Message-ID: <41D759A2.7020105@leadhill.net> Date: Sat, 01 Jan 2005 20:17:06 -0600 From: Billy Newsom User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.7) Gecko/20040616 X-Accept-Language: en-us, en MIME-Version: 1.0 To: freebsd-stable@freebsd.org Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at natco9.natcotech.com Subject: mysql crashes on 5.3-stable, SMP, linuxthreads X-BeenThere: freebsd-stable@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Production branch of FreeBSD source code List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sun, 02 Jan 2005 02:17:09 -0000 I have just built a FreeBSD 5.3 box with SMP enabled on a dual processor machine. I kept having a lot of crashes at some point in the install, and I believe I now have the cuprit: mysql-server-4.1.7 is doing it. Lately, when mysql-server is running under no load, it caused lockups of the system, with no core dumps. Troubleshooting: I have been frantically trying to re-install a lot of things -- I did a cvsup on the stable tree, recompiled the source, and tried a generic kernel with no SMP. I reinstalled a lot of ports that could have been doing this. Meanwhile, a lot of things were dumping core. I tried cooling the CPU and memory just in case it was hardware-related. Finally, I now have a stable computer, running in SMP, but only if mysql-server is disabled. Does anyone know what sort of things I can do to get mysql to run? I am in the middle of another recompile of the same mysql-server with the same options (I believe they are openssl, linuxthreads, and optimize) as before. Has anyone seen this problem before? I will report back tomorrow if a "simple" reinstall of the port has fixed this issue, but I have reinstalled it thrice now. Thanks, Billy