From owner-freebsd-stable@FreeBSD.ORG Sat Feb 11 08:16:01 2006 Return-Path: X-Original-To: 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 3B4CB16A420 for ; Sat, 11 Feb 2006 08:16:01 +0000 (GMT) (envelope-from ob@gruft.de) Received: from obh.snafu.de (obh.snafu.de [213.73.92.34]) by mx1.FreeBSD.org (Postfix) with ESMTP id 1E4EE43D58 for ; Sat, 11 Feb 2006 08:15:59 +0000 (GMT) (envelope-from ob@gruft.de) Received: from ob by obh.snafu.de with local (Exim 4.60 (FreeBSD)) (envelope-from ) id 1F7pvC-000EM4-DC for freebsd-stable@freebsd.org; Sat, 11 Feb 2006 09:15:58 +0100 Date: Sat, 11 Feb 2006 09:15:58 +0100 From: Oliver Brandmueller To: freebsd-stable@freebsd.org Message-ID: <20060211081557.GE18919@e-Gitt.NET> Mail-Followup-To: freebsd-stable@freebsd.org References: <43EBEB9B.1060402@animenfo.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <43EBEB9B.1060402@animenfo.com> User-Agent: Mutt/1.5.11 Sender: Oliver Brandmueller Subject: Re: Connectivity issue with FreeBSD6.0 X-BeenThere: freebsd-stable@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Production branch of FreeBSD source code List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 11 Feb 2006 08:16:01 -0000 Hi. On Thu, Feb 09, 2006 at 08:25:47PM -0500, Kevin Lamothe wrote: > Hey there, I'm running BSD6 on my servers. > > One problem I'm having is the webserver keeps randomly losing > connections to the SQL server which is on another box. > > From the tcpdump logs it looks like the packets are not reaching the > sql server, I've talked to one of the admins at the dc and they're > saying a few other freebsd6 boxes are having this issue. > > Any ideas on this weird issue? I had something, that looked quite like that, but it turned out, it had nothing to do with FreeBSD or the network. Are you using MySQL from through JDBC? There's a bug in JDBC, so that the driver does not notice, if the server closes a connection due to timeout. So have a look how long the idle timeout on the MySQL server is and be sure to set the timeout of the JDBC pooled connections to a value lower than that (or disable timeouts on the MySQL server). Just an idea, since your description does not tell too much about the surrounding environment. - Oliver -- | Oliver Brandmueller | Offenbacher Str. 1 | Germany D-14197 Berlin | | Fon +49-172-3130856 | Fax +49-172-3145027 | WWW: http://the.addict.de/ | | Ich bin das Internet. Sowahr ich Gott helfe. | | Eine gewerbliche Nutzung aller enthaltenen Adressen ist nicht gestattet! |