No buffer space available (maximum connections reached?)

[alucidgeeked]

I keep getting the error below on my website.  I am on a shared host, running IIS 7.0 and Coldfusion 8.  I called my hosting company and they told me it was a scripting error, but I can't see how that is.  I have the same scripts running on my local server with no issues, and when I had the site on a different host a few months ago I never had this problem.  Can someone help, even if you can reassure me that it's not a scripting error I would appreciate it

Error Message :

Error Executing Database Query.

Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION ** java.net.SocketException MESSAGE: No buffer space available (maximum connections reached?): connect STACKTRACE: java.net.SocketException: No buffer space available (maximum connections reached?): connect at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333) at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195) at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366) at java.net.Socket.connect(Socket.java:519) at java.net.Socket.connect(Socket.java:469) at java.net.Socket.(Socket.java:366) at java.net.Socket.(Socket.java:209) at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:173) at com.mysql.jdbc.MysqlIO.(MysqlIO.java:267) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2739) at com.mysql.jdbc....

[Adam Cameron. · Accepted solution]

Whoever you talked to at your hosting company is either stupid or disingenuous.  This is - clearly - a problem with

your DB config, the DSN config or the driver itself.

And nothing to do with you CF code.

I suggest escalating the issue to the line manager of whomever you were talking to @ the hosting company.  Both your issue, and how the tech responded to you.

--

Adam

[alucidgeeked]

Thank you for the help.  I found this link and sent it to them... haven't heard from them as to whether they used it or not, but the error messages stopped about an hour after I sent it.

http://kb2.adobe.com/cps/400/kb400700.html

[Adam Cameron.]

Thank you for the help.  I found this link and sent it to them... haven't heard from them as to whether they used it or not, but the error messages stopped about an hour after I sent it.

http://kb2.adobe.com/cps/400/kb400700.html

Their (lack of ~) reaction doesn't surprise me.  Email them back saying you noticed the problem has resolved, so you presume the fix you sent them worked.

--

Adam