Possible portrange.randomized problems?

[Jaco van Tonder]

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 at freebsd.org mailing list
>http://lists.freebsd.org/mailman/listinfo/freebsd-stable
>To unsubscribe, send any mail to "freebsd-stable-unsubscribe at 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 at 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 at premsoft.co.za :: Web: http://www.premsoft.co.za/
Disclaimer: http://www.premsoft.co.za/email_disclaimer.html