too many connections???

jammy3

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.

AbyssUnderground

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.

jammy3

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

AbyssUnderground

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.

Kavkazzz

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:
Michael Jackson Full Discography in MP3 for free
Everybody must have... for free

DonQuichote

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.