RE: connection limit has been reached
I've got a client that is seeing this error message. (I have not seen the code/site yet) Timed-out trying to get a connection to DB_BOFA. The connection limit has been reached. The only ideas I have is either: 1. There are too many queries on the page and it's using all of the possible connections. 2. The DB or CF is holding DB connections and there are none left in the 'pool' for use. Any possibilities I may have missed? The connection limit for the datasource hasn't been set to match the number of connections that the database will allow? Unless the queries in a page use different datasources, it's my understanding that all of them will use the same connection. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:244556 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: connection limit has been reached
What about maintain connections across requests in cfadmin dsource? Can't that setting effect how many connections are opened? I had the same trouble when I switched to MySQL 5, but futzing with that setting seems to have fixed it... I think. Might have been something else... Oh, I did have to set the connection limit up in the mysql config file. I'd used the 4gig heavy, which defaulted to 10 I think... I put it at 20 and THAT's what seemed to have fixed it, now that I think about it. :D On 6/22/06, Michael Dinowitz [EMAIL PROTECTED] wrote: I've got a client that is seeing this error message. (I have not seen the code/site yet) Timed-out trying to get a connection to DB_BOFA. The connection limit has been reached. The only ideas I have is either: 1. There are too many queries on the page and it's using all of the possible connections. 2. The DB or CF is holding DB connections and there are none left in the 'pool' for use. Any possibilities I may have missed? Michael Dinowitz President: House of Fusion http://www.houseoffusion.com Publisher: Fusion Authority http://www.fusionauthority.com Adobe Community Expert ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:244599 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: connection limit has been reached?
There could be another issue. If CF is not releasing connections, you may be creating a slew of them and using up the available slots. Lon Lentz Applications Developer CyberEntomologist - Alvion Technologies DataWarehousing and List Sales - Market Your Lists on the Net! [EMAIL PROTECTED] 941-574-8600 Ext. 210 -Original Message- From: Russel Madere [mailto:[EMAIL PROTECTED]] Sent: Friday, January 19, 2001 10:29 AM To: CF-Talk Subject: RE: connection limit has been reached? If you are using Winders NT use the Lisence Manager to verify that you have the correct number of SQL and NT lisences for the servers. If necessary, purchase a few more. Russel Russel Madere, Jr. Senior Web Developer ICQ: 5446158 http://www.TurboSquid.com Some days you eat the bear; some days the bear eats you. -Original Message- From: Jay Patton [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 18, 2001 09:41 To: CF-Talk Subject: connection limit has been reached? can anyone help me with this error or atleast give me an idea of what to do about it? i get it when i try to log onto the client section of the site im working on and ive never seen this before Error Diagnostic Information ODBC Error Code = () Timed-out trying to get a connection to MYDATASOURCENAME. The connection limit has been reached. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (3:1) to (5:23) in the template file d:\??.???.???.??\Clients\Login.cfm. ~~ 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: connection limit has been reached?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 We've had similar problems. If you have a static number of database connections to your datasource (under the Limit Conections section of the CF Settings for datasources), and you don't have a connection timeout, then those connections remain open indefinitely. This limit, we've discovered, is per uniquer Datasource username (so if you have a generic datasource defined to point to an ORACLE database, and you've set up a limit on the number of connections to 15, then you can have up to 15 connections per ORACLE database user). Another setting that we've found helps to alleviate error messages like this is to set the "Limit cached database connection inactive time to __ minutes" to some smallish number. We have it set to 10 minutes. Also, if you are running rather large and complicated queries to your datasource under high load (I'm talking queries that can take up to a minute to execute with X users, where X is the maximum # of connections that your database can handle (or is configured to handle) you can experience this message as well. Finally, if your CF server loses connectivity to the datasource (Network problems, etc.), and queries are actively being executed over cached connections, those queries will continue to "lock" those cached connections until you recycle the services OR Un-check the Maintain Database connections or Check Disable database connections in the CF Settings section of the Datasource Configuration. Hope this helps! Joe Joseph Cruz Wharton Computing and Information Technology Programmer/Analyst 3620 Locust Walk Suite 400 SH-DH Philadelphia, PA 19104-6302 [EMAIL PROTECTED] 215-898-1220(w) 215-573-2798(f) 215-308-0657(p) 215-768-2071(m) -Original Message- From: Lon Lentz [mailto:[EMAIL PROTECTED]] Sent: Monday, January 22, 2001 10:44 AM To: CF-Talk Subject: RE: connection limit has been reached? There could be another issue. If CF is not releasing connections, you may be creating a slew of them and using up the available slots. Lon Lentz Applications Developer CyberEntomologist - Alvion Technologies DataWarehousing and List Sales - Market Your Lists on the Net! [EMAIL PROTECTED] 941-574-8600 Ext. 210 -Original Message- From: Russel Madere [mailto:[EMAIL PROTECTED]] Sent: Friday, January 19, 2001 10:29 AM To: CF-Talk Subject: RE: connection limit has been reached? If you are using Winders NT use the Lisence Manager to verify that you have the correct number of SQL and NT lisences for the servers. If necessary, purchase a few more. Russel Russel Madere, Jr. Senior Web Developer ICQ: 5446158 http://www.TurboSquid.com Some days you eat the bear; some days the bear eats you. -Original Message- From: Jay Patton [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 18, 2001 09:41 To: CF-Talk Subject: connection limit has been reached? can anyone help me with this error or atleast give me an idea of what to do about it? i get it when i try to log onto the client section of the site im working on and ive never seen this before Error Diagnostic Information ODBC Error Code = () Timed-out trying to get a connection to MYDATASOURCENAME. The connection limit has been reached. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (3:1) to (5:23) in the template file d:\??.???.???.??\Clients\Login.cfm. ~~ 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: connection limit has been reached?
At 10:17 AM 1/20/2001 -0700, you wrote: I'm having the same problem. I'm on a winNT server to which I'm the only real connection. Does the 10 connection limit apply to web hits? I was also wondering if it might be cfhttp bogarting all of my threads on failed connections. Like a dope, I haven't written them with timeout attributes. Or in win2k a maximum of 10 connections to anyone machine are allowed on a peer to peer network. If you're running Server there isn't this limitation in the OS...ONLY on a Peer to Peer... ~~ 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: connection limit has been reached?
I'm having the same problem. I'm on a winNT server to which I'm the only real connection. Does the 10 connection limit apply to web hits? I was also wondering if it might be cfhttp bogarting all of my threads on failed connections. Like a dope, I haven't written them with timeout attributes. -Original Message- From: JayB [mailto:[EMAIL PROTECTED]] Sent: Friday, January 19, 2001 5:24 PM To: CF-Talk Subject: RE: connection limit has been reached? Or in win2k a maximum of 10 connections to anyone machine are allowed on a peer to peer network. don't forget to check in cfadmin - odbc -cfsettings for a maximum # of connections allowed.. If you are using Winders NT use the Lisence Manager to verify that you have the correct number of SQL and NT lisences for the servers. If necessary, purchase a few more. can anyone help me with this error or atleast give me an idea of what to do about it? i get it when i try to log onto the client section of the site im working on and ive never seen this before Error Diagnostic Information ODBC Error Code = () Timed-out trying to get a connection to MYDATASOURCENAME. The connection limit has been reached. ~~ 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: connection limit has been reached?
I'm having the same problem. I'm on a winNT server to which I'm the only real connection. Does the 10 connection limit apply to web hits? I was also wondering if it might be cfhttp bogarting all of my threads on failed connections. Like a dope, I haven't written them with timeout attributes. CFServer isn't a web server, but a server application - therefore it doesn't care what goes on on the web server, but is only interested in requests that are passed to it If you tie it up with 10 really big tasks, then your server will sit there doing nothing... Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ 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: connection limit has been reached?
can anyone help me with this error or atleast give me an idea of what to do about it? i get it when i try to log onto the client section of the site im working on and ive never seen this before Error Diagnostic Information ODBC Error Code = () Timed-out trying to get a connection to MYDATASOURCENAME. The connection limit has been reached. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (3:1) to (5:23) in the template file d:\??.???.???.??\Clients\Login.cfm. Is the site running Access, if so - UPGRADE! If it's not Access, and SQL Server, then the server isn't installed with an Internet License, so UPGRADE! If it's neither of these, which database is it? That could effect it Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ 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: connection limit has been reached?
If you are using Winders NT use the Lisence Manager to verify that you have the correct number of SQL and NT lisences for the servers. If necessary, purchase a few more. Russel Russel Madere, Jr. Senior Web Developer ICQ: 5446158 http://www.TurboSquid.com Some days you eat the bear; some days the bear eats you. -Original Message- From: Jay Patton [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 18, 2001 09:41 To: CF-Talk Subject: connection limit has been reached? can anyone help me with this error or atleast give me an idea of what to do about it? i get it when i try to log onto the client section of the site im working on and ive never seen this before Error Diagnostic Information ODBC Error Code = () Timed-out trying to get a connection to MYDATASOURCENAME. The connection limit has been reached. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (3:1) to (5:23) in the template file d:\??.???.???.??\Clients\Login.cfm. Date/Time: 01/17/01 23:37:07 Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows 98) Remote Address: 199.2.139.183 Jay Patton Web Pro USA 406.549.3337 ext. 203 1.888.5WEBPRO www.webpro-usa.com ~~ 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: connection limit has been reached?
don't forget to check in cfadmin - odbc -cfsettings for a maximum # of connections allowed.. -- Stephenie Hamilton Senior ColdFusion Administrator Express Technologies, Inc. want CF_Freedom? try CFXHosting.com Winner of the 2000 ColdFusion Developer's Journal Best ColdFusion Web Host!! -Original Message- From: Russel Madere [mailto:[EMAIL PROTECTED]] Sent: Friday, January 19, 2001 10:29 AM To: CF-Talk Subject: RE: connection limit has been reached? If you are using Winders NT use the Lisence Manager to verify that you have the correct number of SQL and NT lisences for the servers. If necessary, purchase a few more. Russel Russel Madere, Jr. Senior Web Developer ICQ: 5446158 http://www.TurboSquid.com Some days you eat the bear; some days the bear eats you. -Original Message- From: Jay Patton [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 18, 2001 09:41 To: CF-Talk Subject: connection limit has been reached? can anyone help me with this error or atleast give me an idea of what to do about it? i get it when i try to log onto the client section of the site im working on and ive never seen this before Error Diagnostic Information ODBC Error Code = () Timed-out trying to get a connection to MYDATASOURCENAME. The connection limit has been reached. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (3:1) to (5:23) in the template file d:\??.???.???.??\Clients\Login.cfm. Date/Time: 01/17/01 23:37:07 Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows 98) Remote Address: 199.2.139.183 Jay Patton Web Pro USA 406.549.3337 ext. 203 1.888.5WEBPRO www.webpro-usa.com ~~ 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: connection limit has been reached?
thanks but it ended up being that we had to put the site up on a SQL server rather than a shared cfserver and that took care of the problem. Jay Patton Web Pro USA 406.549.3337 ext. 203 1.888.5WEBPRO www.webpro-usa.com - Original Message - From: "Russel Madere" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, January 19, 2001 8:29 AM Subject: RE: connection limit has been reached? If you are using Winders NT use the Lisence Manager to verify that you have the correct number of SQL and NT lisences for the servers. If necessary, purchase a few more. Russel Russel Madere, Jr. Senior Web Developer ICQ: 5446158 http://www.TurboSquid.com Some days you eat the bear; some days the bear eats you. -Original Message- From: Jay Patton [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 18, 2001 09:41 To: CF-Talk Subject: connection limit has been reached? can anyone help me with this error or atleast give me an idea of what to do about it? i get it when i try to log onto the client section of the site im working on and ive never seen this before Error Diagnostic Information ODBC Error Code = () Timed-out trying to get a connection to MYDATASOURCENAME. The connection limit has been reached. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (3:1) to (5:23) in the template file d:\??.???.???.??\Clients\Login.cfm. Date/Time: 01/17/01 23:37:07 Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows 98) Remote Address: 199.2.139.183 Jay Patton Web Pro USA 406.549.3337 ext. 203 1.888.5WEBPRO www.webpro-usa.com ~~ 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: connection limit has been reached?
Or in win2k a maximum of 10 connections to anyone machine are allowed on a peer to peer network. don't forget to check in cfadmin - odbc -cfsettings for a maximum # of connections allowed.. If you are using Winders NT use the Lisence Manager to verify that you have the correct number of SQL and NT lisences for the servers. If necessary, purchase a few more. can anyone help me with this error or atleast give me an idea of what to do about it? i get it when i try to log onto the client section of the site im working on and ive never seen this before Error Diagnostic Information ODBC Error Code = () Timed-out trying to get a connection to MYDATASOURCENAME. The connection limit has been reached. ~~ 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