Possible portrange.randomized problems?
Jaco van Tonder
jaco at premsoft.co.za
Wed Jun 2 02:51:18 PDT 2004
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
More information about the freebsd-stable
mailing list