From owner-freebsd-stable@FreeBSD.ORG Wed Jun 2 02:51:18 2004 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 7930416A4CE for ; Wed, 2 Jun 2004 02:51:18 -0700 (PDT) Received: from pipefish.mweb.co.za (pipefish.mweb.co.za [196.2.45.87]) by mx1.FreeBSD.org (Postfix) with ESMTP id 66D0B43D49 for ; Wed, 2 Jun 2004 02:51:14 -0700 (PDT) (envelope-from jaco@premsoft.co.za) Received: by pipefish.mweb.co.za (Postfix, from userid 501) id 83E0EEEE9; Wed, 2 Jun 2004 11:51:11 +0200 (SAST) Received: from firewall.symphiano (rdg-dial-196-30-236-118.mweb.co.za [196.30.236.118]) by pipefish.mweb.co.za (Postfix) with SMTP id E2FA0EEE3 for ; Wed, 2 Jun 2004 11:51:08 +0200 (SAST) Received: (qmail 99178 invoked from network); 2 Jun 2004 09:46:13 -0000 Received: from unknown (HELO ?192.168.53.102?) (192.168.53.102) by firewall.symphiano with SMTP; 2 Jun 2004 09:46:13 -0000 Message-ID: <40BDA264.8010402@premsoft.co.za> Date: Wed, 02 Jun 2004 11:48:20 +0200 From: Jaco van Tonder User-Agent: Mozilla Thunderbird 0.6 (Windows/20040502) X-Accept-Language: en MIME-Version: 1.0 To: Mike Silbersack References: <20040602023824.B37780@odysseus.silby.com> In-Reply-To: <20040602023824.B37780@odysseus.silby.com> X-Enigmail-Version: 0.84.0.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on pipefish.mweb.co.za X-Spam-Level: X-Spam-Status: No, hits=0.8 required=7.5 tests=RATWR10_MESSID,TW_QS,TW_VP X-Spam-Report: * 0.6 RATWR10_MESSID Message-ID has ratware pattern (HEXHEX.HEXHEX@) * 0.1 TW_QS BODY: Odd Letter Triples with QS * 0.1 TW_VP BODY: Odd Letter Triples with VP X-Mailman-Approved-At: Wed, 02 Jun 2004 05:17:24 -0700 cc: "freebsd-stable@freebsd.org"@pipefish.mweb.co.za Subject: Re: Possible portrange.randomized problems? X-BeenThere: freebsd-stable@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list Reply-To: jaco@premsoft.co.za List-Id: Production branch of FreeBSD source code List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 02 Jun 2004 09:51:18 -0000 Mike Silbersack typed on a keyboard not too far away, on 6/2/2004 9:44 AM: >I've been informed that there have been some reports of problems with >MySQL connections failing due to randomized ephemeral ports. If you're >one of the people affected, could you check a few things and then contact >me? > >Things to check: > >1. Are the stuck sockets / failing connections sticking in the SYN_SENT >state? > >2. Does the range of ports in use look like it's relatively random, or do >you see only a small amount of your portrange being used? (The portrange >is 1024 to 5000 by default.) > >3. Does setting net.inet.ip.portrange.randomized=0 solve the problem for >you? > >Thanks, > >Mike "Silby" Silbersack >_______________________________________________ >freebsd-stable@freebsd.org mailing list >http://lists.freebsd.org/mailman/listinfo/freebsd-stable >To unsubscribe, send any mail to "freebsd-stable-unsubscribe@freebsd.org" > > Mike, This problem exists even if you do not allow network connections to MySQL. MySQLd is started with --skip-networking, thus making use of UNIX-sockets only, and I get this problem. I am running 4.9-STABLE: FreeBSD riot.xxx.xx.xx 4.9-STABLE FreeBSD 4.9-STABLE #2: Sat Jan 24 13:13:08 SAST 2004 jacovt@riot.xxx.xx.xx:/usr/obj/usr/src/sys/RIOT i386 I do _not_ have net.inet.ip.portrange.randomized: riot% sysctl net.inet.ip.portrange.randomized sysctl: unknown oid 'net.inet.ip.portrange.randomized' riot% sysctl net.inet.ip.portrange net.inet.ip.portrange.lowfirst: 1023 net.inet.ip.portrange.lowlast: 600 net.inet.ip.portrange.first: 1024 net.inet.ip.portrange.last: 5000 net.inet.ip.portrange.hifirst: 49152 net.inet.ip.portrange.hilast: 65535 Here is the output of sockstat (for what it may be worth): qscand perl 17215 4 stream mysqld[78219]:15 mysql mysqld 17214 3 stream /tmp/mysql.sock mysql mysqld 17214 15 stream /tmp/mysql.sock vpopmail qmail-sm 17213 4 stream mysqld[78219]:15 .... mysql mysqld 78229 3 stream /tmp/mysql.sock mysql mysqld 78229 15 stream /tmp/mysql.sock mysql mysqld 78228 3 stream /tmp/mysql.sock mysql mysqld 78228 15 stream /tmp/mysql.sock mysql mysqld 78227 3 stream /tmp/mysql.sock mysql mysqld 78227 15 stream /tmp/mysql.sock mysql mysqld 78226 3 stream /tmp/mysql.sock mysql mysqld 78226 15 stream /tmp/mysql.sock mysql mysqld 78225 3 stream /tmp/mysql.sock mysql mysqld 78225 15 stream /tmp/mysql.sock mysql mysqld 78224 3 stream /tmp/mysql.sock mysql mysqld 78224 15 stream /tmp/mysql.sock mysql mysqld 78223 3 stream /tmp/mysql.sock mysql mysqld 78223 15 stream /tmp/mysql.sock mysql mysqld 78222 3 stream /tmp/mysql.sock mysql mysqld 78222 15 stream /tmp/mysql.sock mysql mysqld 78221 3 stream /tmp/mysql.sock mysql mysqld 78221 15 stream /tmp/mysql.sock mysql mysqld 78220 3 stream /tmp/mysql.sock mysql mysqld 78220 15 stream /tmp/mysql.sock mysql mysqld 78219 3 stream /tmp/mysql.sock mysql mysqld 78219 15 stream /tmp/mysql.sock -- Jaco van Tonder Magic Developer :: Premsoft Development (Pty) Ltd Direct: +27 11 312 2122 :: Fax: +27 11 312 2122 :: Mobile: +27 83 417 5424 Email: jaco@premsoft.co.za :: Web: http://www.premsoft.co.za/ Disclaimer: http://www.premsoft.co.za/email_disclaimer.html