Re: No buffer space available (maximum connections reached?)
Richard, I use *netstat -a* The Connection object has methods to test the connection Can you provide a full stack trace? Does it look like this? Error Executing Database Query. [Macromedia][SQLServer JDBC Driver]Error establishing socket. No buffer space available (maximum connections reached?): JVM_Bind? You can domains/domain1/serverx/config/server.xml change the port address >From reading some posts on various forums this looks like a TCP/IP root cause. I.e. sql server can no longer find a port that it can pass off the connection to (within itself) in order to free up its default port to service incoming requests. ( could be wrong here). ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254919 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: No buffer space available (maximum connections reached?)
OK thanks Jochem Richard ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254912 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: No buffer space available (maximum connections reached?)
Richard Cooper wrote: > It's our dedicated server which has SQL server installed on it. > > I also have the tick box for 'maintain connections across client > request' ticked for the datasources. > > Does this give a cleared indication of the cause? Unfortunately not. If you hadn't enabled the maintain connections option then we would have had something to try :) While I can't really point the finger, I do have some recommendations though. First, make sure there is no firewall in the way. Especially firewalls of antivirus software have a habit of inserting LSPs in the TCP/IP stack and breaking things left and right. If you have antivirus on the server, reconsider if you need it. In my experience it rarely interferes with a CF server, but it is a major pain when running on a database server. Check your setting for TCPTimedWaitDelay. It defaults to the standard 4 minutes, but with current networks that is a bit over the top. I usually set it to 60 seconds on a server. (While you are at it, you might want to read the rest of the TCP/IP whitepaper from Microsoft, it is interesting stuff.) Lastly, if this happens again, test where the problem is. A simple telnet to the port of the SQL Server should tell you whether it is listening. If it isn't, we can rule out CF from the equation. Jochem ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254911 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: No buffer space available (maximum connections reached?)
How would you directly test if the socket is open? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254907 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: No buffer space available (maximum connections reached?)
Jochem, Are you saying users can turn connection pooling off and people are getting their collective hands dirty with JDBC conections or is it if the connection fails reconnect and hence persist? What I meant was if someone was making connections outside the scope of pooling and making a direct socket connections with the server and not using the close() methods or not catching a socket error and thus not closing the connection correctly. It sound like an *orphaned* connection deletion problem with CF. I use JDBC methods directly to test if the socket is open and take action accordingly and hence the three link system and evently embeding after all three databases MS Access, MySql and SQL Server broke for one reason or another. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254905 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: No buffer space available (maximum connections reached?)
Watch out, Jochem has his "spock" ears on again..:-p. Totally illogical. - Original Message - From: "Jochem van Dieten" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Sunday, October 01, 2006 4:55 AM Subject: Re: No buffer space available (maximum connections reached?) > Dan Plesse wrote: > > I would assume he is not persisting the connection because normally people > > don't know how to do that. > > Considering the default setting is to maintain connections, I find that statement illogical :) > > Jochem > > ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254903 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: No buffer space available (maximum connections reached?)
It's our dedicated server which has SQL server installed on it. I also have the tick box for 'maintain connections across client request' ticked for the datasources. Does this give a cleared indication of the cause? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254902 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: No buffer space available (maximum connections reached?)
Dan Plesse wrote: > I would assume he is not persisting the connection because normally people > don't know how to do that. Considering the default setting is to maintain connections, I find that statement illogical :) Jochem ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254901 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: No buffer space available (maximum connections reached?)
I would assume he is not persisting the connection because normally people don't know how to do that. I would assume also that he is on a shared host and is sharing a SQL server connections so someone is messing around with the connections. You can set up a three link system. If one DB goes down the two can pick up the connection. Or embed the database and say good day to SQL server and sharing. On 9/30/06, Jochem van Dieten <[EMAIL PROTECTED]> wrote: > > Richard Cooper wrote: > > > > Its a windows 2000 server with: > > Coldfusion MX7 > > SQL server 2000 on the machine > > All current updates should be run as well. > > > > I had a shared SQL server on a different server which I have been > > migrating from. The sites on this were running fine, but for the sites > > that were using the local sql server these all encountered this error. > > Are you using persistent database connections or do you re-establish the > connection on each query? > > Jochem > > ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254895 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: No buffer space available (maximum connections reached?)
Richard Cooper wrote: > > Its a windows 2000 server with: > Coldfusion MX7 > SQL server 2000 on the machine > All current updates should be run as well. > > I had a shared SQL server on a different server which I have been > migrating from. The sites on this were running fine, but for the sites > that were using the local sql server these all encountered this error. Are you using persistent database connections or do you re-establish the connection on each query? Jochem ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254884 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: No buffer space available (maximum connections reached?)
Hi Jochem, A lot of that info is managed by my host but I can give you a run down of what I know. Its a windows 2000 server with: Coldfusion MX7 SQL server 2000 on the machine All current updates should be run as well. I had a shared SQL server on a different server which I have been migrating from. The sites on this were running fine, but for the sites that were using the local sql server these all encountered this error. Any ideas? Richard ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254766 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: No buffer space available (maximum connections reached?)
Richard Cooper wrote: > > Error establishing socket. No buffer space available (maximum > connections reached?): JVM_Bind > > Seems to only affect sites using a local SQL server 2000. A server > restart sorted it out but don't want it rearing its head again. Could you describe your environment? In particular which servers are involved, their OS, firewalls and anti-virus solutions (and anything else that may have introduced a LSP), custom TCP/IP tuning and a dump of the settings for a datasource with this problem and a datasource without this problem. Jochem ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254710 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: no buffer space available
What are the specifics of your client machine setup? We've been running into similar problems on machines running Windows 2000 Pro machines and Photoshop 6. Complete inability to open new TCP/IP connections, whether FTP, HTTP, lan. We upgraded one machine to Photoshop 6.0.1 and so far it seems like it may have solved the problem. We'll know better after this developers has used the machine for a full day or two. Jim - Original Message - From: "S R" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, April 20, 2001 5:00 PM Subject: no buffer space available > Hi, > > This is not really a CF question but if anyone can help that would be > awesome!! I've been using CuteFTP to upload files to my server which is a > windows NT server. All of a sudden when I tried to connect to the server I > get an error message that says Error 10055 in function bind 'No buffer Space > Available'. > > This is scary because I can't upload anything now. Does anyone know how to > fix this??? > > SR ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: no buffer space available
It means your system is out of resources. http://www.sockets.com/err_lst1.htm#WSAENOBUFS HTH, Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. www.CoolFusion.com 631-737-4668 x101 inFusion Mail Server (iMS) - the World's most configurable mail server - Original Message - From: "S R" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, April 20, 2001 7:00 PM Subject: no buffer space available > Hi, > > This is not really a CF question but if anyone can help that would be > awesome!! I've been using CuteFTP to upload files to my server which is a > windows NT server. All of a sudden when I tried to connect to the server I > get an error message that says Error 10055 in function bind 'No buffer Space > Available'. > > This is scary because I can't upload anything now. Does anyone know how to > fix this??? > > SR > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists