flush-hosts

blacksheepradio

after working correctly for many months
i suddenly get this error allot

Warning: mysql_pconnect(): Host 'gttcp03.30u.com' is blocked because of many connection errors. Unblock with 'mysqladmin flush-hosts' in /home/mordenu/public_html/common/db.php on line 43

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /home/mordenu/public_html/common/db.php on line 44

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /home/mordenu/public_html/common/db.php on line 58

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/mordenu/public_html/common/db.php on line 59
status=err
SQL error=0
SQL error string=
SQL=SELECT songlist.*, historylist.listeners as listeners, historylist.requestID as requestID, historylist.date_played as starttime FROM historylist,songlist WHERE (historylist.songID = songlist.ID) AND (songlist.songtype='S') ORDER BY historylist.date_played DESC LIMIT 6

my host says
"This is caused by badly written PHP scripts that open mySQL connections and don't close them.

I'm not sure why it's suddenly effecting us now."

Any advice

fredouille

simply restart mysql....

tsinka

Hi,

this could be a problem of mysql_pconnect, since using mysql_pconnect keeps mysql connections open. To find the reason why they aren't closed is a little bit hard (heavy load, sites that use frames hosted on a server farm with a load balancer ....) but you might try to use mysql_connect instead since these connections normally get closed automatically after the php code has been parsed.

I had such a problem with a frame based site that was hosted on a server farm using a load balancer. The load balancer sent the requests for each frame to different servers thus opening a bunch of persistent connections at a time. Switching to mysql_connect solved the problem immediately.

This will not solve the problem if you have e.g. infinite loops in your code that contain mysql queries. That would force a connection to stay open forever (and bring the server down very fast, so this shouldn't be a problem here).

Thomas