From owner-freebsd-stable@FreeBSD.ORG  Mon May 24 06:54:06 2004
Return-Path: <owner-freebsd-stable@FreeBSD.ORG>
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 66CF116A4CE
	for <stable@FreeBSD.ORG>; Mon, 24 May 2004 06:54:06 -0700 (PDT)
Received: from veldy.net (fuggle.veldy.net [209.98.200.33])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 2BC3F43D46
	for <stable@FreeBSD.ORG>; Mon, 24 May 2004 06:54:06 -0700 (PDT)
	(envelope-from veldy@veldy.net)
Received: from localhost (localhost.veldy.net [127.0.0.1])
	by veldy.net (Postfix) with ESMTP
	id DEC216127; Mon, 24 May 2004 08:52:20 -0500 (CDT)
Received: from veldy.net ([127.0.0.1])
 by localhost (fuggle.veldy.net [127.0.0.1]) (amavisd-new, port 10024)
 with ESMTP id 92691-06; Mon, 24 May 2004 08:52:18 -0500 (CDT)
Received: from 148L241 (localhost.veldy.net [127.0.0.1])
	by veldy.net (Postfix) with SMTP
	id 9DB156113; Mon, 24 May 2004 08:52:18 -0500 (CDT)
Message-ID: <001a01c44196$544870f0$321d590a@nic.target.com>
From: "Thomas T. Veldhouse" <veldy@veldy.net>
To: <stable@FreeBSD.ORG>, "Pete French" <petefrench@keithprowse.com>
References: <E1BSE40-0009XZ-1X@dilbert.firstcallgroup.co.uk>
Date: Mon, 24 May 2004 08:52:18 -0500
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2800.1409
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409
X-Virus-Scanned: by amavisd-new at veldy.net
Subject: Re: Problems with 4.10 and mysql
X-BeenThere: freebsd-stable@freebsd.org
X-Mailman-Version: 2.1.1
Precedence: list
List-Id: Production branch of FreeBSD source code
	<freebsd-stable.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-stable>,
	<mailto:freebsd-stable-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-stable>
List-Post: <mailto:freebsd-stable@freebsd.org>
List-Help: <mailto:freebsd-stable-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-stable>,
	<mailto:freebsd-stable-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Mon, 24 May 2004 13:54:06 -0000

From: "Pete French" <petefrench@keithprowse.com>
> Unfortunately this is going to be a very indistinct bug
> report, but ever since upgrading to 4.10 from 4.9 I am
> having several problems with mysql. These manifest as
> programs occasionally failing to connect to the database.
> Unfortunately I have been unable to track this down as yet
> due to the fact it only happens once in every few hundred
> attempts, so trying to actually characterise it is proving
> almost impossible!
>
> Has anyone else seen this ? I am using the system on a test
> server and am loathe to upgrade the production machines just in case
> it *isnt* simply some quirk of this machine.
>
> -pcf.


Do you run a firewall (ipfw) on that machine?  Perhaps you are hitting
stateful connection limits?

I used to set this in /etc/sysctl.conf to avoid the issue for me:

# increase the number of dynamic firewall rules allowed
net.inet.ip.fw.dyn_max=3000

Tom Veldhouse