too many connections???

 
Post new topic   Reply to topic    Aprelium Forum Index -> Networking Issues
View previous topic :: View next topic  
Author Message
jammy3
-


Joined: 17 Aug 2005
Posts: 10

PostPosted: Wed Nov 28, 2007 2:32 am    Post subject: too many connections??? Reply with quote

Recently I've had trouble connecting to Abyss. Restarting Abyss resolves the problem. The issue seems to be between Abyss, Mysql and a new php survey "app" that I have running.

Here is a small netstat -b result (there are MANY, MANY connections)

TCP p4-server:1251 localhost:3306 ESTABLISHED 3716
[abyssws.exe]

TCP p4-server:1257 localhost:3306 ESTABLISHED 3716
[abyssws.exe]

TCP p4-server:1261 localhost:3306 ESTABLISHED 3716
[abyssws.exe]

TCP p4-server:1267 localhost:3306 ESTABLISHED 3716
[abyssws.exe]

TCP p4-server:1273 localhost:3306 ESTABLISHED 3716
[abyssws.exe]

TCP p4-server:1279 localhost:3306 ESTABLISHED 3716
[abyssws.exe]

TCP p4-server:1285 localhost:3306 ESTABLISHED 3716
[abyssws.exe]

TCP p4-server:1291 localhost:3306 ESTABLISHED 3716
[abyssws.exe]

This tells me that Abyss is connecting to mysql on port 3306 (normal) but not ever closing the connection.

Is there a bad config on my part somewhere? A fix available? Any other idea?

Thanks.
Back to top View user's profile Send private message
AbyssUnderground
-


Joined: 31 Dec 2004
Posts: 3855

PostPosted: Wed Nov 28, 2007 9:20 am    Post subject: Reply with quote

The script probably forgot to use a mysql_close() (i think its that command off the top of my head) so the connection doesn't close until it times out.

If its not causing any problems, I wouldn't worry about it since its not a particularly high number of connections. I'd get worried when its 20-30 or more connections not being closed.
_________________
Andy (AbyssUnderground) (previously The Inquisitor)
www.abyssunderground.co.uk
Back to top View user's profile Send private message Visit poster's website
jammy3
-


Joined: 17 Aug 2005
Posts: 10

PostPosted: Thu Dec 13, 2007 3:09 am    Post subject: Reply with quote

Well, hopefully this log will post.

I run abyss restarter, so this is less than 24 hours. As you can see, almost all connections are from either abyss, mysql or the helix server.

I think this fits into the excessive category??? :-)

I wouldn't be surprised if one poster was correct about php software not closing the connections. Is it possible to force connections to time-out?

Thanks.


Active Connections

Proto Local Address Foreign Address State PID
TCP p4-server:2440 localhost:3306 ESTABLISHED 33788
[abyssws.exe]

TCP p4-server:2441 localhost:3306 ESTABLISHED 33788
[abyssws.exe]

TCP p4-server:2442 localhost:3306 ESTABLISHED 33788
[abyssws.exe]

TCP p4-server:2444 localhost:3306 ESTABLISHED 33788
[abyssws.exe]

TCP p4-server:2454 localhost:3306 ESTABLISHED 33788
[abyssws.exe]

TCP p4-server:2455 localhost:3306 ESTABLISHED 33788
[abyssws.exe]

TCP p4-server:2457 localhost:3306 ESTABLISHED 33788
[abyssws.exe]

TCP p4-server:2458 localhost:3306 ESTABLISHED 33788
[abyssws.exe]

TCP p4-server:2460 localhost:3306 ESTABLISHED 33788
[abyssws.exe]

TCP p4-server:2468 localhost:3306 ESTABLISHED 33788
[abyssws.exe]

TCP p4-server:2472 localhost:3306 ESTABLISHED 33788
[abyssws.exe]

TCP p4-server:2473 localhost:3306 ESTABLISHED 33788
[abyssws.exe]

TCP p4-server:2475 localhost:3306 ESTABLISHED 33788
[abyssws.exe]

TCP p4-server:2476 localhost:3306 ESTABLISHED 33788
[abyssws.exe]

TCP p4-server:2478 localhost:3306 ESTABLISHED 33788
[abyssws.exe]

TCP p4-server:2479 localhost:3306 ESTABLISHED 33788
[abyssws.exe]

TCP p4-server:2516 localhost:3306 ESTABLISHED 33788
[abyssws.exe]

TCP p4-server:2517 localhost:3306 ESTABLISHED 33788
[abyssws.exe]

TCP p4-server:2519 localhost:3306 ESTABLISHED 33788
[abyssws.exe]

TCP p4-server:2520 localhost:3306 ESTABLISHED 33788
[abyssws.exe]

TCP p4-server:2523 localhost:3306 ESTABLISHED 33788
[abyssws.exe]

TCP p4-server:2524 localhost:3306 ESTABLISHED 33788
[abyssws.exe]

TCP p4-server:2533 localhost:3306 ESTABLISHED 33788
[abyssws.exe]

TCP p4-server:2534 localhost:3306 ESTABLISHED 33788
[abyssws.exe]

TCP p4-server:2681 localhost:3306 ESTABLISHED 33788
[abyssws.exe]

TCP p4-server:2700 localhost:3306 ESTABLISHED 33788
[abyssws.exe]

TCP p4-server:2701 localhost:3306 ESTABLISHED 33788
[abyssws.exe]

TCP p4-server:2703 localhost:3306 ESTABLISHED 33788
[abyssws.exe]

TCP p4-server:2705 localhost:3306 ESTABLISHED 33788
[abyssws.exe]

TCP p4-server:2707 localhost:3306 ESTABLISHED 33788
[abyssws.exe]

TCP p4-server:3306 localhost:2440 ESTABLISHED 1904
[mysqld-nt.exe]

TCP p4-server:3306 localhost:2472 ESTABLISHED 1904
[mysqld-nt.exe]

TCP p4-server:3306 localhost:2701 ESTABLISHED 1904
[mysqld-nt.exe]

TCP p4-server:3306 localhost:2681 ESTABLISHED 1904
[mysqld-nt.exe]

TCP p4-server:3306 localhost:2441 ESTABLISHED 1904
[mysqld-nt.exe]

TCP p4-server:3306 localhost:2468 ESTABLISHED 1904
[mysqld-nt.exe]

TCP p4-server:3306 localhost:2516 ESTABLISHED 1904
[mysqld-nt.exe]

TCP p4-server:3306 localhost:2478 ESTABLISHED 1904
[mysqld-nt.exe]

TCP p4-server:3306 localhost:2457 ESTABLISHED 1904
[mysqld-nt.exe]

TCP p4-server:3306 localhost:2479 ESTABLISHED 1904
[mysqld-nt.exe]

TCP p4-server:3306 localhost:2473 ESTABLISHED 1904
[mysqld-nt.exe]

TCP p4-server:3306 localhost:2524 ESTABLISHED 1904
[mysqld-nt.exe]

TCP p4-server:3306 localhost:2455 ESTABLISHED 1904
[mysqld-nt.exe]

TCP p4-server:3306 localhost:2519 ESTABLISHED 1904
[mysqld-nt.exe]

TCP p4-server:3306 localhost:2476 ESTABLISHED 1904
[mysqld-nt.exe]

TCP p4-server:3306 localhost:2534 ESTABLISHED 1904
[mysqld-nt.exe]

TCP p4-server:3306 localhost:2705 ESTABLISHED 1904
[mysqld-nt.exe]

TCP p4-server:3306 localhost:2520 ESTABLISHED 1904
[mysqld-nt.exe]

TCP p4-server:3306 localhost:2707 ESTABLISHED 1904
[mysqld-nt.exe]

TCP p4-server:3306 localhost:2442 ESTABLISHED 1904
[mysqld-nt.exe]

TCP p4-server:3306 localhost:2458 ESTABLISHED 1904
[mysqld-nt.exe]

TCP p4-server:3306 localhost:2475 ESTABLISHED 1904
[mysqld-nt.exe]

TCP p4-server:3306 localhost:2454 ESTABLISHED 1904
[mysqld-nt.exe]

TCP p4-server:3306 localhost:2523 ESTABLISHED 1904
[mysqld-nt.exe]

TCP p4-server:3306 localhost:2533 ESTABLISHED 1904
[mysqld-nt.exe]

TCP p4-server:3306 localhost:2517 ESTABLISHED 1904
[mysqld-nt.exe]

TCP p4-server:3306 localhost:2444 ESTABLISHED 1904
[mysqld-nt.exe]

TCP p4-server:3306 localhost:2703 ESTABLISHED 1904
[mysqld-nt.exe]

TCP p4-server:3306 localhost:2700 ESTABLISHED 1904
[mysqld-nt.exe]

TCP p4-server:3306 localhost:2460 ESTABLISHED 1904
[mysqld-nt.exe]

TCP p4-server:3584 localhost:3585 ESTABLISHED 3760
[rmserver.exe]

TCP p4-server:3585 localhost:3584 ESTABLISHED 3760
[rmserver.exe]

TCP p4-server:3586 localhost:3587 ESTABLISHED 3760
[rmserver.exe]

TCP p4-server:3587 localhost:3586 ESTABLISHED 3760
[rmserver.exe]

TCP p4-server:3592 localhost:3593 ESTABLISHED 3760
[rmserver.exe]

TCP p4-server:3593 localhost:3592 ESTABLISHED 3760
[rmserver.exe]

TCP p4-server:3594 localhost:3595 ESTABLISHED 3760
[rmserver.exe]

TCP p4-server:3595 localhost:3594 ESTABLISHED 3760
[rmserver.exe]

TCP p4-server:3596 localhost:3597 ESTABLISHED 3760
[rmserver.exe]

TCP p4-server:3597 localhost:3596 ESTABLISHED 3760
[rmserver.exe]

TCP p4-server:3598 localhost:3599 ESTABLISHED 3760
[rmserver.exe]

TCP p4-server:3599 localhost:3598 ESTABLISHED 3760
[rmserver.exe]

TCP p4-server:3600 localhost:3601 ESTABLISHED 3760
[rmserver.exe]

TCP p4-server:3601 localhost:3600 ESTABLISHED 3760
[rmserver.exe]

TCP p4-server:3602 localhost:3603 ESTABLISHED 3760
[rmserver.exe]

TCP p4-server:3603 localhost:3602 ESTABLISHED 3760
[rmserver.exe]

TCP p4-server:3604 localhost:3605 ESTABLISHED 3760
[rmserver.exe]

TCP p4-server:3605 localhost:3604 ESTABLISHED 3760
[rmserver.exe]

TCP p4-server:3607 localhost:3608 ESTABLISHED 3760
[rmserver.exe]

TCP p4-server:3608 localhost:3607 ESTABLISHED 3760
[rmserver.exe]

TCP p4-server:3609 localhost:3610 ESTABLISHED 3760
[rmserver.exe]

TCP p4-server:3610 localhost:3609 ESTABLISHED 3760
[rmserver.exe]

TCP p4-server:3611 localhost:3612 ESTABLISHED 3760
[rmserver.exe]

TCP p4-server:3612 localhost:3611 ESTABLISHED 3760
[rmserver.exe]

TCP p4-server:3613 localhost:3614 ESTABLISHED 3760
[rmserver.exe]

TCP p4-server:3614 localhost:3613 ESTABLISHED 3760
[rmserver.exe]

TCP p4-server:3615 localhost:3616 ESTABLISHED 3760
[rmserver.exe]

TCP p4-server:3616 localhost:3615 ESTABLISHED 3760
[rmserver.exe]

TCP p4-server:3617 localhost:3618 ESTABLISHED 3760
[rmserver.exe]

TCP p4-server:3618 localhost:3617 ESTABLISHED 3760
[rmserver.exe]

TCP p4-server:3620 localhost:3621 ESTABLISHED 3760
[rmserver.exe]

TCP p4-server:3621 localhost:3620 ESTABLISHED 3760
[rmserver.exe]

TCP p4-server:3622 localhost:3623 ESTABLISHED 3760
[rmserver.exe]

TCP p4-server:3623 localhost:3622 ESTABLISHED 3760
[rmserver.exe]

TCP p4-server:3624 localhost:3625 ESTABLISHED 3760
[rmserver.exe]

TCP p4-server:3625 localhost:3624 ESTABLISHED 3760
[rmserver.exe]

TCP p4-server:3626 localhost:3627 ESTABLISHED 3760
[rmserver.exe]

TCP p4-server:3627 localhost:3626 ESTABLISHED 3760
[rmserver.exe]

TCP p4-server:3629 localhost:3630 ESTABLISHED 3760
[rmserver.exe]

TCP p4-server:3630 localhost:3629 ESTABLISHED 3760
[rmserver.exe]

TCP p4-server:3631 localhost:3632 ESTABLISHED 3760
[rmserver.exe]

TCP p4-server:3632 localhost:3631 ESTABLISHED 3760
[rmserver.exe]

TCP p4-server:3633 localhost:3634 ESTABLISHED 3760
[rmserver.exe]

TCP p4-server:3634 localhost:3633 ESTABLISHED 3760
[rmserver.exe]

TCP p4-server:3636 localhost:3637 ESTABLISHED 3760
[rmserver.exe]

TCP p4-server:3637 localhost:3636 ESTABLISHED 3760
[rmserver.exe]

TCP p4-server:netbios-ssn 192.168.0.25:2881 ESTABLISHED 4
[System]

TCP p4-server:2225 localhost:3306 CLOSE_WAIT 33788
[abyssws.exe]

TCP p4-server:2226 localhost:3306 CLOSE_WAIT 33788
[abyssws.exe]

TCP p4-server:554 localhost:3034 TIME_WAIT 0
TCP p4-server:554 localhost:3035 TIME_WAIT 0
Back to top View user's profile Send private message
AbyssUnderground
-


Joined: 31 Dec 2004
Posts: 3855

PostPosted: Thu Dec 13, 2007 9:24 am    Post subject: Reply with quote

There might be an option in the php.ini or the my.ini file. I can't be sure but it would be worth taking a look.
_________________
Andy (AbyssUnderground) (previously The Inquisitor)
www.abyssunderground.co.uk
Back to top View user's profile Send private message Visit poster's website
Kavkazzz
-


Joined: 16 May 2009
Posts: 17
Location: USA

PostPosted: Wed Jul 22, 2009 5:49 pm    Post subject: too many connections Reply with quote

Ive turned off phpBBs automatically using persistent connections, so hopefully that will help this error a bit.. Ive noticed it on the front-page of the site since were now using a database-driven system there too though.
Sorry for offtop: [URL="http://groups.filestube.com/group/2df0771e8a4ef14a,view.html"]Michael Jackson Full Discography in MP3 for free[/URL]
Everybody must have... for free
Back to top View user's profile Send private message Send e-mail ICQ Number
DonQuichote
-


Joined: 24 Dec 2006
Posts: 68
Location: The Netherlands

PostPosted: Wed Jul 22, 2009 7:09 pm    Post subject: Reply with quote

If you are running the Abyss on Windows, this is a known phenomenon. And it has nothing to do with the abyss itself.

Windows will temporarily assign a port if you connect through tcp. Also for MySQL connections. However, closing the connection will not close the connection windows. From the manual: there are 4000 ports available and it takes 4 minutes before a port is closed again. So if you open a lot of connections, you can run into problems.
Back to top View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    Aprelium Forum Index -> Networking Issues All times are GMT + 1 Hour
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB phpBB Group