Re: Excessive Memory Usage CFMX 7 Standard Windows 2003 resulting in Crash
Hi All, was there a solution to this problem? Thanks On 19/09/06, Dan Plesse [EMAIL PROTECTED] wrote: I wonder if this issue has to do with Microsoft undermining Java (again) only this time its with the JDBC driver? I would switch up the driver and start over and see if the problem comes back. If this is a fix please tell everyone about it. Thanks Dan ~| 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:256860 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Excessive Memory Usage CFMX 7 Standard Windows 2003 resulting in Crash
It might possibly have been an option before the money was spent, but I'm not a fan of doubling up on costs. I'd rather try to fix or get a fix for what I've already spent money to buy. Thanks, Ken Ferguson 214.636.6126 -Original Message- From: Vince Bonfanti [mailto:[EMAIL PROTECTED] Sent: Monday, September 18, 2006 4:19 PM To: CF-Talk Subject: Re: Excessive Memory Usage CFMX 7 Standard Windows 2003 resulting in Crash Tom, Dan, Since you're both running Windows 2003 and SQL Server, is BlueDragon.NET an option to consider? http://www.newatlanta.com/products/bluedragon/index.cfm Vince Bonfanti New Atlanta Communications, LLC Hi Daniel, Pretty much everyone running CF/Windows/SQL Server has this problem. See my page here http://www.digitalmethod.co.uk/cf/ There is no guaranteed fix other than to have an alert system in place to monitor memory usage and restart when it gets over 90% or so. Don't waste time playing with garbage collection - you also might do more harm than good. The only settings you might want to consider playing with are the SQL connections settings - the method (cursor or direct), the max number of connections and maintain connections. I've seen people mediate the problem reasonably well by splitting DSN's into two - one cursor connection that doesn't maintain connections and one direct with maintained connections for smaller queries. When the system goes into the state you describe it's often quicker to restart the server than wait for CF to restart (sometimes it never does). Tom Peer Digital Method We have had the following issue with Macromedia ColdFusion 7 (7.0.1. 116466), running on windows 2003, which we have not been able to reolve, and cannot see really where to start! - At 00:30 on 09/09/2006 we rebooted our server. - All sites hosted on the server were tested following reboot, and were operating normally - At 11:26 all http requests to ColdFusion sites started timing out (taking longer than 30secs) The following pair of errors were logged (multiple times) within the ColdFusion exception log: *Error 1* Error,jrpp-228,*Date*,*time*,*CF Application Name*,Error attempting to resolve the template error.cfm.The template could not be found. The specific sequence of files included or processed is: *PhysicalPath*\public\index.cfm, line: 176 coldfusion.tagext.lang.ErrorTag$InvalidErrorTemplateException: Error attempting to resolve the template error.cfm. *Error 2* Error,jrpp-228,* Date*,*time*,,Not enough storage is available to process this command The specific sequence of files included or processed is: E:\CFusionMX 7\wwwroot\WEB-INF\exception\coldfusion\runtime\MissingIncludeException. cfm java.io.IOException: Not enough storage is available to process this command No requests were logged within the IIS log files until: - From 13:26 all http requests to ColdFusion sites resulted in the following error: *Server Error* The server encountered an internal error and was unable to complete your request *JRun closed connection. *These requests were logged in the IIS log files. - From 14:56 all http requests to ColdFusion sites resulted in the following error: *Server Error* Either the Macromedia application server is unreachable or it does not have a mapping to process this request.* *These requests were logged in the IIS log files. - When we connected to the server on Monday morning (12/09) CPU usage for JRun was minimal, but Memory usage was at 1.4 Gb, and increasing (this is on a server with 2Gb RAM, also running MS SQL Server) - We attempted to restart ColdFusion ? eventually CF service stopped (after about 5 min) and once stopped, we started the service again without any problems. All sites were tested, and found to be running normally. - The server was rebooted again at 02:40 on 16/09, and again showed pretty much the same symptoms as before (although this time with no errors reported within the CF exception log) - I had increased the max JVM heap size from 512 MB to 1024 MB following the previous crash ? which may have prevented the java.io.IOException: Not enough storage is available to process this command errors. - This is now the third time we have had this occur ? (although I did not record full details for the first time ? and cannot be certain that this was following a reboot). - This has only happened at times when the server is not handling much traffic
RE: Excessive Memory Usage CFMX 7 Standard Windows 2003 resulting in Crash
You're right, so I looked around at the rest of our servers. They're all Win2k3/ CF7 and none have SQL Server. RAM usage for the jrun service seems to hover between 85,500K and about 188,000K. All but one of those has traffic which is really quite heavy in relation to the one trouble machine. Thanks, Ken Ferguson 214.636.6126 -Original Message- From: Tom Kitta [mailto:[EMAIL PROTECTED] Sent: Monday, September 18, 2006 4:21 PM To: CF-Talk Subject: RE: Excessive Memory Usage CFMX 7 Standard Windows 2003 resulting in Crash 55,144K is rather low for jrun - on my dev box its around 50,000k when server starts then it goes to about 80,000k after few hours of development. That is with one developer working on few sites max, TK -Original Message- From: Ken Ferguson [mailto:[EMAIL PROTECTED] Sent: Monday, September 18, 2006 5:06 PM To: CF-Talk Subject: RE: Excessive Memory Usage CFMX 7 Standard Windows 2003 resulting in Crash Come to think of it, virtually all of my CF performance problems started just about the time I added an application to the server which uses SQL Server. This is a server on which there are only about two or three people at any given time - MAX. I wonder if this is a driver issue or what? I just looked right now, because pages are taking forever to load and the jrun.exe is using 312,469K of memory and 97% of CPU. I've got another server with Win2K and SQL Server which has MUCH more traffic and jrun.exe is using 55,144K and hasn't restarted in weeks. Thanks, Ken Ferguson 214.636.6126 ~| 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:253492 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Excessive Memory Usage CFMX 7 Standard Windows 2003 resulting in Crash
The latest Macromedia drivers for cfmx are version 3.5 and available here: http://www.adobe.com/go/42dcb10a. Also, Microsoft has a new JDBC driver of their own. It might be worth testing with it to see if there is a change in behavior. http://www.microsoft.com/downloads/details.aspx?FamilyId=6D483869-816A-44CB-9787-A866235EFC7Cdisplaylang=en. Clearly if it is a driver specific issue, you would not expect to see it with all drivers. ~| 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:253495 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Excessive Memory Usage CFMX 7 Standard Windows 2003 resulting in Crash
Hi Ken, I certainly understand your position. But there are other issues to consider when calculating costs. For example, earlier this year HealthGrades (www.healthgrades.com) was suffering from similar performance and reliability issues. Then they replaced 14 CFMX7 servers with 4 BlueDragon.NET servers (same hardware). The hardware savings of 10 servers helped offset the cost of the Bluedragon.NET software; while more difficult to measure, they've also experienced operational savings due to the increased reliability of their servers. Let me know if you'd like to take this discussion offline, or have someone call you with more info. Regards, Vince Bonfanti New Atlanta Communications, LLC It might possibly have been an option before the money was spent, but I'm not a fan of doubling up on costs. I'd rather try to fix or get a fix for what I've already spent money to buy. Thanks, Ken Ferguson 214.636.6126 -Original Message- From: Vince Bonfanti [mailto:[EMAIL PROTECTED] Sent: Monday, September 18, 2006 4:19 PM To: CF-Talk Subject: Re: Excessive Memory Usage CFMX 7 Standard Windows 2003 resulting in Crash Tom, Dan, Since you're both running Windows 2003 and SQL Server, is BlueDragon.NET an option to consider? http://www.newatlanta.com/products/bluedragon/index.cfm Vince Bonfanti New Atlanta Communications, LLC ~| 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:253519 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Excessive Memory Usage CFMX 7 Standard Windows 2003 resulting in Crash
Ken, I had the same problem with almost exactly the same setup. Since I didn't know it was a known issue, I installed Fusion Reactor to see if I could diagnose the problem after looking through the IIS and Coldfusion logs with no result. While I was in the Fusion Reactor admin, I enabled the Crash Protection options (http://www.fusion-reactor.com/featureFocus-crashProtection.html). Since doing so, the crashes have stopped and server uptime has been 100% for over a month now (with the exception of one Windows update and CF hotfix which was applied). A side benefit is that the server is running faster on all fronts. My setup has Coldfusion and Windows running on the C partition and all other programs and sites running on a larger E partition. One other thing which I did, which seems to have helped, is to disable the C partition for pagefile usage and max the pagefile usage on the secondary partition. Good Luck, Jon C. We have had the following issue with Macromedia ColdFusion 7 (7.0.1. 116466), running on windows 2003, which we have not been able to reolve, and cannot see really where to start! - At 00:30 on 09/09/2006 we rebooted our server. - All sites hosted on the server were tested following reboot, and were operating normally - At 11:26 all http requests to ColdFusion sites started timing out (taking longer than 30secs) The following pair of errors were logged (multiple times) within the ColdFusion exception log: *Error 1* Error,jrpp-228,*Date*,*time*,*CF Application Name*,Error attempting to resolve the template error.cfm.The template could not be found. The specific sequence of files included or processed is: *PhysicalPath*\public\index.cfm, line: 176 coldfusion.tagext.lang.ErrorTag$InvalidErrorTemplateException: Error attempting to resolve the template error.cfm. *Error 2* Error,jrpp-228,* Date*,*time*,,Not enough storage is available to process this command The specific sequence of files included or processed is: E:\CFusionMX 7\wwwroot\WEB-INF\exception\coldfusion\runtime\MissingIncludeException. cfm java.io.IOException: Not enough storage is available to process this command No requests were logged within the IIS log files until: - From 13:26 all http requests to ColdFusion sites resulted in the following error: *Server Error* The server encountered an internal error and was unable to complete your request *JRun closed connection. *These requests were logged in the IIS log files. - From 14:56 all http requests to ColdFusion sites resulted in the following error: *Server Error* Either the Macromedia application server is unreachable or it does not have a mapping to process this request.* *These requests were logged in the IIS log files. - When we connected to the server on Monday morning (12/09) CPU usage for JRun was minimal, but Memory usage was at 1.4 Gb, and increasing (this is on a server with 2Gb RAM, also running MS SQL Server) - We attempted to restart ColdFusion ? eventually CF service stopped (after about 5 min) and once stopped, we started the service again without any problems. All sites were tested, and found to be running normally. - The server was rebooted again at 02:40 on 16/09, and again showed pretty much the same symptoms as before (although this time with no errors reported within the CF exception log) - I had increased the max JVM heap size from 512 MB to 1024 MB following the previous crash ? which may have prevented the java.io.IOException: Not enough storage is available to process this command errors. - This is now the third time we have had this occur ? (although I did not record full details for the first time ? and cannot be certain that this was following a reboot). - This has only happened at times when the server is not handling much traffic ? previously to experiencing these problems, the server had been hosting an online competition, handling around 30 simultaneous users during busy periods, and never having a window of more than 20 minutes inactivity. This did make me wonder if it might be an issue with the Garbage Collection Process? Has anyone Experienced this problem, or got any ideas as to how to resolve it? Thanks, Dan. ~| 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:253523 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Re: Excessive Memory Usage CFMX 7 Standard Windows 2003 resulting in Crash
I wonder if this issue has to do with Microsoft undermining Java (again) only this time its with the JDBC driver? I would switch up the driver and start over and see if the problem comes back. If this is a fix please tell everyone about it. Thanks Dan ~| 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:253532 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Excessive Memory Usage CFMX 7 Standard Windows 2003 resulting in Crash
Hi Daniel, Pretty much everyone running CF/Windows/SQL Server has this problem. See my page here http://www.digitalmethod.co.uk/cf/ There is no guaranteed fix other than to have an alert system in place to monitor memory usage and restart when it gets over 90% or so. Don't waste time playing with garbage collection - you also might do more harm than good. The only settings you might want to consider playing with are the SQL connections settings - the method (cursor or direct), the max number of connections and maintain connections. I've seen people mediate the problem reasonably well by splitting DSN's into two - one cursor connection that doesn't maintain connections and one direct with maintained connections for smaller queries. When the system goes into the state you describe it's often quicker to restart the server than wait for CF to restart (sometimes it never does). Tom Peer Digital Method We have had the following issue with Macromedia ColdFusion 7 (7.0.1. 116466), running on windows 2003, which we have not been able to reolve, and cannot see really where to start! - At 00:30 on 09/09/2006 we rebooted our server. - All sites hosted on the server were tested following reboot, and were operating normally - At 11:26 all http requests to ColdFusion sites started timing out (taking longer than 30secs) The following pair of errors were logged (multiple times) within the ColdFusion exception log: *Error 1* Error,jrpp-228,*Date*,*time*,*CF Application Name*,Error attempting to resolve the template error.cfm.The template could not be found. The specific sequence of files included or processed is: *PhysicalPath*\public\index.cfm, line: 176 coldfusion.tagext.lang.ErrorTag$InvalidErrorTemplateException: Error attempting to resolve the template error.cfm. *Error 2* Error,jrpp-228,* Date*,*time*,,Not enough storage is available to process this command The specific sequence of files included or processed is: E:\CFusionMX 7\wwwroot\WEB-INF\exception\coldfusion\runtime\MissingIncludeException. cfm java.io.IOException: Not enough storage is available to process this command No requests were logged within the IIS log files until: - From 13:26 all http requests to ColdFusion sites resulted in the following error: *Server Error* The server encountered an internal error and was unable to complete your request *JRun closed connection. *These requests were logged in the IIS log files. - From 14:56 all http requests to ColdFusion sites resulted in the following error: *Server Error* Either the Macromedia application server is unreachable or it does not have a mapping to process this request.* *These requests were logged in the IIS log files. - When we connected to the server on Monday morning (12/09) CPU usage for JRun was minimal, but Memory usage was at 1.4 Gb, and increasing (this is on a server with 2Gb RAM, also running MS SQL Server) - We attempted to restart ColdFusion ? eventually CF service stopped (after about 5 min) and once stopped, we started the service again without any problems. All sites were tested, and found to be running normally. - The server was rebooted again at 02:40 on 16/09, and again showed pretty much the same symptoms as before (although this time with no errors reported within the CF exception log) - I had increased the max JVM heap size from 512 MB to 1024 MB following the previous crash ? which may have prevented the java.io.IOException: Not enough storage is available to process this command errors. - This is now the third time we have had this occur ? (although I did not record full details for the first time ? and cannot be certain that this was following a reboot). - This has only happened at times when the server is not handling much traffic ? previously to experiencing these problems, the server had been hosting an online competition, handling around 30 simultaneous users during busy periods, and never having a window of more than 20 minutes inactivity. This did make me wonder if it might be an issue with the Garbage Collection Process? Has anyone Experienced this problem, or got any ideas as to how to resolve it? Thanks, Dan. ~| 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:253423 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe:
RE: Excessive Memory Usage CFMX 7 Standard Windows 2003 resulting in Crash
That fact that you have stated you store large objects in session scope is most likely your problem. If you are instantiating CFC's in session scope, then this uses tons of memory, as you are needlessly creating a new CFC instance for each user, and unless the cose is different for every single user, there is no need to do this. Better to cache a single copy in application scope. Russ -Original Message- From: Thomas Peer [mailto:[EMAIL PROTECTED] Sent: 18 September 2006 16:18 To: CF-Talk Subject: Re: Excessive Memory Usage CFMX 7 Standard Windows 2003 resulting in Crash Hi Daniel, Pretty much everyone running CF/Windows/SQL Server has this problem. See my page here http://www.digitalmethod.co.uk/cf/ There is no guaranteed fix other than to have an alert system in place to monitor memory usage and restart when it gets over 90% or so. Don't waste time playing with garbage collection - you also might do more harm than good. The only settings you might want to consider playing with are the SQL connections settings - the method (cursor or direct), the max number of connections and maintain connections. I've seen people mediate the problem reasonably well by splitting DSN's into two - one cursor connection that doesn't maintain connections and one direct with maintained connections for smaller queries. When the system goes into the state you describe it's often quicker to restart the server than wait for CF to restart (sometimes it never does). Tom Peer Digital Method We have had the following issue with Macromedia ColdFusion 7 (7.0.1. 116466), running on windows 2003, which we have not been able to reolve, and cannot see really where to start! - At 00:30 on 09/09/2006 we rebooted our server. - All sites hosted on the server were tested following reboot, and were operating normally - At 11:26 all http requests to ColdFusion sites started timing out (taking longer than 30secs) The following pair of errors were logged (multiple times) within the ColdFusion exception log: *Error 1* Error,jrpp-228,*Date*,*time*,*CF Application Name*,Error attempting to resolve the template error.cfm.The template could not be found. The specific sequence of files included or processed is: *PhysicalPath*\public\index.cfm, line: 176 coldfusion.tagext.lang.ErrorTag$InvalidErrorTemplateException: Error attempting to resolve the template error.cfm. *Error 2* Error,jrpp-228,* Date*,*time*,,Not enough storage is available to process this command The specific sequence of files included or processed is: E:\CFusionMX 7\wwwroot\WEB-INF\exception\coldfusion\runtime\MissingIncludeException. cfm java.io.IOException: Not enough storage is available to process this command No requests were logged within the IIS log files until: - From 13:26 all http requests to ColdFusion sites resulted in the following error: *Server Error* The server encountered an internal error and was unable to complete your request *JRun closed connection. *These requests were logged in the IIS log files. - From 14:56 all http requests to ColdFusion sites resulted in the following error: *Server Error* Either the Macromedia application server is unreachable or it does not have a mapping to process this request.* *These requests were logged in the IIS log files. - When we connected to the server on Monday morning (12/09) CPU usage for JRun was minimal, but Memory usage was at 1.4 Gb, and increasing (this is on a server with 2Gb RAM, also running MS SQL Server) - We attempted to restart ColdFusion ? eventually CF service stopped (after about 5 min) and once stopped, we started the service again without any problems. All sites were tested, and found to be running normally. - The server was rebooted again at 02:40 on 16/09, and again showed pretty much the same symptoms as before (although this time with no errors reported within the CF exception log) - I had increased the max JVM heap size from 512 MB to 1024 MB following the previous crash ? which may have prevented the java.io.IOException: Not enough storage is available to process this command errors. - This is now the third time we have had this occur ? (although I did not record full details for the first time ? and cannot be certain that this was following a reboot). - This has only happened at times when the server is not handling much traffic ? previously to experiencing these problems, the server had been hosting an online competition, handling around 30 simultaneous users during busy periods, and never having a window of more than 20 minutes inactivity. This did make me wonder if it might be an issue with the Garbage Collection Process? Has
Re: Excessive Memory Usage CFMX 7 Standard Windows 2003 resulting in Crash
As a test you could chop out the SQL Server DSN and do a one new connection for reach new request and no pooling and see if that does it. Start the connection in the application file and close it when the person leaves. ~| 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:253443 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Excessive Memory Usage CFMX 7 Standard Windows 2003 resulting in Crash
Ok... I have read and reread the mail I sent - and I still can't see where I said I store large objects in session scope :-/ The server is currently only hosting a single application, which uses the seesion scope only for storing a small number of simple variables specific to the currently logged in user - and there is a restriction of 5 concurrent authenticated users on the system. I doubt therefore thatsession memory usage is the problem here. Cheers Dan. On 9/18/06, Snake [EMAIL PROTECTED] wrote: That fact that you have stated you store large objects in session scope is most likely your problem. If you are instantiating CFC's in session scope, then this uses tons of memory, as you are needlessly creating a new CFC instance for each user, and unless the cose is different for every single user, there is no need to do this. Better to cache a single copy in application scope. Russ ~| 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:253454 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Excessive Memory Usage CFMX 7 Standard Windows 2003 resulting in Crash
Hi Thomas, It's a real relief (in a way) to know we are not the only ones experiencing this issue - as at least if it is a recognised issue, macrodobe may fix it at some point (although based on my experiences today even attempting to send a support email to adobe, I wonder if that is a valid assumption) First time in over six years of using CF that I've had a crash that I haven't been able to ascertain the cause... been tearing my hair out... Thanks for your suggestions with regards to SQL connections - I will look into these and see if any are relevant in our hosting environment. Have other people just been having a problem with CF 7? or has it also been an issue in CF 6.1? Also, has anyone experiencing this problem found any benefit from installing the 7.0.2 updater? - I have scheduled downtime for midngiht tonight to install the updater... not that I could see anything in the release notes that made me hopeful that this would make any difference... Cheers Dan. On 9/18/06, Thomas Peer [EMAIL PROTECTED] wrote: Hi Daniel, Pretty much everyone running CF/Windows/SQL Server has this problem. See my page here http://www.digitalmethod.co.uk/cf/ There is no guaranteed fix other than to have an alert system in place to monitor memory usage and restart when it gets over 90% or so. Don't waste time playing with garbage collection - you also might do more harm than good. The only settings you might want to consider playing with are the SQL connections settings - the method (cursor or direct), the max number of connections and maintain connections. I've seen people mediate the problem reasonably well by splitting DSN's into two - one cursor connection that doesn't maintain connections and one direct with maintained connections for smaller queries. When the system goes into the state you describe it's often quicker to restart the server than wait for CF to restart (sometimes it never does). Tom Peer Digital Method ~| 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:253459 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Excessive Memory Usage CFMX 7 Standard Windows 2003 resulting in Crash
Come to think of it, virtually all of my CF performance problems started just about the time I added an application to the server which uses SQL Server. This is a server on which there are only about two or three people at any given time - MAX. I wonder if this is a driver issue or what? I just looked right now, because pages are taking forever to load and the jrun.exe is using 312,469K of memory and 97% of CPU. I've got another server with Win2K and SQL Server which has MUCH more traffic and jrun.exe is using 55,144K and hasn't restarted in weeks. Thanks, Ken Ferguson 214.636.6126 -Original Message- From: Daniel Lancelot [mailto:[EMAIL PROTECTED] Sent: Monday, September 18, 2006 3:48 PM To: CF-Talk Subject: Re: Excessive Memory Usage CFMX 7 Standard Windows 2003 resulting in Crash Hi Thomas, It's a real relief (in a way) to know we are not the only ones experiencing this issue - as at least if it is a recognised issue, macrodobe may fix it at some point (although based on my experiences today even attempting to send a support email to adobe, I wonder if that is a valid assumption) First time in over six years of using CF that I've had a crash that I haven't been able to ascertain the cause... been tearing my hair out... Thanks for your suggestions with regards to SQL connections - I will look into these and see if any are relevant in our hosting environment. Have other people just been having a problem with CF 7? or has it also been an issue in CF 6.1? Also, has anyone experiencing this problem found any benefit from installing the 7.0.2 updater? - I have scheduled downtime for midngiht tonight to install the updater... not that I could see anything in the release notes that made me hopeful that this would make any difference... Cheers Dan. On 9/18/06, Thomas Peer [EMAIL PROTECTED] wrote: Hi Daniel, Pretty much everyone running CF/Windows/SQL Server has this problem. See my page here http://www.digitalmethod.co.uk/cf/ There is no guaranteed fix other than to have an alert system in place to monitor memory usage and restart when it gets over 90% or so. Don't waste time playing with garbage collection - you also might do more harm than good. The only settings you might want to consider playing with are the SQL connections settings - the method (cursor or direct), the max number of connections and maintain connections. I've seen people mediate the problem reasonably well by splitting DSN's into two - one cursor connection that doesn't maintain connections and one direct with maintained connections for smaller queries. When the system goes into the state you describe it's often quicker to restart the server than wait for CF to restart (sometimes it never does). Tom Peer Digital Method ~| 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:253461 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Excessive Memory Usage CFMX 7 Standard Windows 2003 resulting in Crash
We've been having stability issues ourselves, and can't figure out why. It relates to sending email, a task that does a lot of sql as well as string processing activity. The memory doesn't seem to jump that much, but the server restarts every so often. We haven't been able to pinpoint the cause yet, but this seems like a good culprit. We are on SQL 2k and cf 7.0.1 Are there any updated drivers available? Russ -Original Message- From: Ken Ferguson [mailto:[EMAIL PROTECTED] Sent: Monday, September 18, 2006 5:06 PM To: CF-Talk Subject: RE: Excessive Memory Usage CFMX 7 Standard Windows 2003 resulting in Crash Come to think of it, virtually all of my CF performance problems started just about the time I added an application to the server which uses SQL Server. This is a server on which there are only about two or three people at any given time - MAX. I wonder if this is a driver issue or what? I just looked right now, because pages are taking forever to load and the jrun.exe is using 312,469K of memory and 97% of CPU. I've got another server with Win2K and SQL Server which has MUCH more traffic and jrun.exe is using 55,144K and hasn't restarted in weeks. Thanks, Ken Ferguson 214.636.6126 -Original Message- From: Daniel Lancelot [mailto:[EMAIL PROTECTED] Sent: Monday, September 18, 2006 3:48 PM To: CF-Talk Subject: Re: Excessive Memory Usage CFMX 7 Standard Windows 2003 resulting in Crash Hi Thomas, It's a real relief (in a way) to know we are not the only ones experiencing this issue - as at least if it is a recognised issue, macrodobe may fix it at some point (although based on my experiences today even attempting to send a support email to adobe, I wonder if that is a valid assumption) First time in over six years of using CF that I've had a crash that I haven't been able to ascertain the cause... been tearing my hair out... Thanks for your suggestions with regards to SQL connections - I will look into these and see if any are relevant in our hosting environment. Have other people just been having a problem with CF 7? or has it also been an issue in CF 6.1? Also, has anyone experiencing this problem found any benefit from installing the 7.0.2 updater? - I have scheduled downtime for midngiht tonight to install the updater... not that I could see anything in the release notes that made me hopeful that this would make any difference... Cheers Dan. On 9/18/06, Thomas Peer [EMAIL PROTECTED] wrote: Hi Daniel, Pretty much everyone running CF/Windows/SQL Server has this problem. See my page here http://www.digitalmethod.co.uk/cf/ There is no guaranteed fix other than to have an alert system in place to monitor memory usage and restart when it gets over 90% or so. Don't waste time playing with garbage collection - you also might do more harm than good. The only settings you might want to consider playing with are the SQL connections settings - the method (cursor or direct), the max number of connections and maintain connections. I've seen people mediate the problem reasonably well by splitting DSN's into two - one cursor connection that doesn't maintain connections and one direct with maintained connections for smaller queries. When the system goes into the state you describe it's often quicker to restart the server than wait for CF to restart (sometimes it never does). Tom Peer Digital Method ~| 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:253463 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Excessive Memory Usage CFMX 7 Standard Windows 2003 resulting in Crash
55,144K is rather low for jrun - on my dev box its around 50,000k when server starts then it goes to about 80,000k after few hours of development. That is with one developer working on few sites max, TK -Original Message- From: Ken Ferguson [mailto:[EMAIL PROTECTED] Sent: Monday, September 18, 2006 5:06 PM To: CF-Talk Subject: RE: Excessive Memory Usage CFMX 7 Standard Windows 2003 resulting in Crash Come to think of it, virtually all of my CF performance problems started just about the time I added an application to the server which uses SQL Server. This is a server on which there are only about two or three people at any given time - MAX. I wonder if this is a driver issue or what? I just looked right now, because pages are taking forever to load and the jrun.exe is using 312,469K of memory and 97% of CPU. I've got another server with Win2K and SQL Server which has MUCH more traffic and jrun.exe is using 55,144K and hasn't restarted in weeks. Thanks, Ken Ferguson 214.636.6126 -Original Message- From: Daniel Lancelot [mailto:[EMAIL PROTECTED] Sent: Monday, September 18, 2006 3:48 PM To: CF-Talk Subject: Re: Excessive Memory Usage CFMX 7 Standard Windows 2003 resulting in Crash Hi Thomas, It's a real relief (in a way) to know we are not the only ones experiencing this issue - as at least if it is a recognised issue, macrodobe may fix it at some point (although based on my experiences today even attempting to send a support email to adobe, I wonder if that is a valid assumption) First time in over six years of using CF that I've had a crash that I haven't been able to ascertain the cause... been tearing my hair out... Thanks for your suggestions with regards to SQL connections - I will look into these and see if any are relevant in our hosting environment. Have other people just been having a problem with CF 7? or has it also been an issue in CF 6.1? Also, has anyone experiencing this problem found any benefit from installing the 7.0.2 updater? - I have scheduled downtime for midngiht tonight to install the updater... not that I could see anything in the release notes that made me hopeful that this would make any difference... Cheers Dan. On 9/18/06, Thomas Peer [EMAIL PROTECTED] wrote: Hi Daniel, Pretty much everyone running CF/Windows/SQL Server has this problem. See my page here http://www.digitalmethod.co.uk/cf/ There is no guaranteed fix other than to have an alert system in place to monitor memory usage and restart when it gets over 90% or so. Don't waste time playing with garbage collection - you also might do more harm than good. The only settings you might want to consider playing with are the SQL connections settings - the method (cursor or direct), the max number of connections and maintain connections. I've seen people mediate the problem reasonably well by splitting DSN's into two - one cursor connection that doesn't maintain connections and one direct with maintained connections for smaller queries. When the system goes into the state you describe it's often quicker to restart the server than wait for CF to restart (sometimes it never does). Tom Peer Digital Method ~| 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:253464 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Excessive Memory Usage CFMX 7 Standard Windows 2003 resulting in Crash
Tom, Dan, Since you're both running Windows 2003 and SQL Server, is BlueDragon.NET an option to consider? http://www.newatlanta.com/products/bluedragon/index.cfm Vince Bonfanti New Atlanta Communications, LLC Hi Daniel, Pretty much everyone running CF/Windows/SQL Server has this problem. See my page here http://www.digitalmethod.co.uk/cf/ There is no guaranteed fix other than to have an alert system in place to monitor memory usage and restart when it gets over 90% or so. Don't waste time playing with garbage collection - you also might do more harm than good. The only settings you might want to consider playing with are the SQL connections settings - the method (cursor or direct), the max number of connections and maintain connections. I've seen people mediate the problem reasonably well by splitting DSN's into two - one cursor connection that doesn't maintain connections and one direct with maintained connections for smaller queries. When the system goes into the state you describe it's often quicker to restart the server than wait for CF to restart (sometimes it never does). Tom Peer Digital Method We have had the following issue with Macromedia ColdFusion 7 (7.0.1. 116466), running on windows 2003, which we have not been able to reolve, and cannot see really where to start! - At 00:30 on 09/09/2006 we rebooted our server. - All sites hosted on the server were tested following reboot, and were operating normally - At 11:26 all http requests to ColdFusion sites started timing out (taking longer than 30secs) The following pair of errors were logged (multiple times) within the ColdFusion exception log: *Error 1* Error,jrpp-228,*Date*,*time*,*CF Application Name*,Error attempting to resolve the template error.cfm.The template could not be found. The specific sequence of files included or processed is: *PhysicalPath*\public\index.cfm, line: 176 coldfusion.tagext.lang.ErrorTag$InvalidErrorTemplateException: Error attempting to resolve the template error.cfm. *Error 2* Error,jrpp-228,* Date*,*time*,,Not enough storage is available to process this command The specific sequence of files included or processed is: E:\CFusionMX 7\wwwroot\WEB-INF\exception\coldfusion\runtime\MissingIncludeException. cfm java.io.IOException: Not enough storage is available to process this command No requests were logged within the IIS log files until: - From 13:26 all http requests to ColdFusion sites resulted in the following error: *Server Error* The server encountered an internal error and was unable to complete your request *JRun closed connection. *These requests were logged in the IIS log files. - From 14:56 all http requests to ColdFusion sites resulted in the following error: *Server Error* Either the Macromedia application server is unreachable or it does not have a mapping to process this request.* *These requests were logged in the IIS log files. - When we connected to the server on Monday morning (12/09) CPU usage for JRun was minimal, but Memory usage was at 1.4 Gb, and increasing (this is on a server with 2Gb RAM, also running MS SQL Server) - We attempted to restart ColdFusion ? eventually CF service stopped (after about 5 min) and once stopped, we started the service again without any problems. All sites were tested, and found to be running normally. - The server was rebooted again at 02:40 on 16/09, and again showed pretty much the same symptoms as before (although this time with no errors reported within the CF exception log) - I had increased the max JVM heap size from 512 MB to 1024 MB following the previous crash ? which may have prevented the java.io.IOException: Not enough storage is available to process this command errors. - This is now the third time we have had this occur ? (although I did not record full details for the first time ? and cannot be certain that this was following a reboot). - This has only happened at times when the server is not handling much traffic ? previously to experiencing these problems, the server had been hosting an online competition, handling around 30 simultaneous users during busy periods, and never having a window of more than 20 minutes inactivity. This did make me wonder if it might be an issue with the Garbage Collection Process? Has anyone Experienced this problem, or got any ideas as to how to resolve it?
RE: Excessive Memory Usage CFMX 7 Standard Windows 2003 resulting in Crash
It wasn't you who said it, it was someone else you replied to you and gave a link to his problem. Russ -Original Message- From: Daniel Lancelot [mailto:[EMAIL PROTECTED] Sent: 18 September 2006 21:33 To: CF-Talk Subject: Re: Excessive Memory Usage CFMX 7 Standard Windows 2003 resulting in Crash Ok... I have read and reread the mail I sent - and I still can't see where I said I store large objects in session scope :-/ The server is currently only hosting a single application, which uses the seesion scope only for storing a small number of simple variables specific to the currently logged in user - and there is a restriction of 5 concurrent authenticated users on the system. I doubt therefore thatsession memory usage is the problem here. Cheers Dan. On 9/18/06, Snake [EMAIL PROTECTED] wrote: That fact that you have stated you store large objects in session scope is most likely your problem. If you are instantiating CFC's in session scope, then this uses tons of memory, as you are needlessly creating a new CFC instance for each user, and unless the cose is different for every single user, there is no need to do this. Better to cache a single copy in application scope. Russ ~| 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:253472 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Excessive Memory Usage CFMX 7 Standard Windows 2003 resulting in Crash
Hi Dan, Based on the description of the problem, it appears that the CF Server is hanging beforehand and timed out requests/memory growing large are the after affects. There could be many reasons that cause the server to hang. Since the server is not crashing completely, the thread dump could provide very useful information. Please refer to the following technote as to how to get a thread dump: http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=tn_18339 It will be great if you can send the thread dump to [EMAIL PROTECTED] One more piece of information that can be useful is, if you have applied any CHF(Cumulative Hot Fix) on the server. If yes, please let me know that as well. Thanks, Praveen. We have had the following issue with Macromedia ColdFusion 7 (7.0.1. 116466), running on windows 2003, which we have not been able to reolve, and cannot see really where to start! - At 00:30 on 09/09/2006 we rebooted our server. - All sites hosted on the server were tested following reboot, and were operating normally - At 11:26 all http requests to ColdFusion sites started timing out (taking longer than 30secs) The following pair of errors were logged (multiple times) within the ColdFusion exception log: *Error 1* Error,jrpp-228,*Date*,*time*,*CF Application Name*,Error attempting to resolve the template error.cfm.The template could not be found. The specific sequence of files included or processed is: *PhysicalPath*\public\index.cfm, line: 176 coldfusion.tagext.lang.ErrorTag$InvalidErrorTemplateException: Error attempting to resolve the template error.cfm. *Error 2* Error,jrpp-228,* Date*,*time*,,Not enough storage is available to process this command The specific sequence of files included or processed is: E:\CFusionMX 7\wwwroot\WEB-INF\exception\coldfusion\runtime\MissingIncludeException. cfm java.io.IOException: Not enough storage is available to process this command No requests were logged within the IIS log files until: - From 13:26 all http requests to ColdFusion sites resulted in the following error: *Server Error* The server encountered an internal error and was unable to complete your request *JRun closed connection. *These requests were logged in the IIS log files. - From 14:56 all http requests to ColdFusion sites resulted in the following error: *Server Error* Either the Macromedia application server is unreachable or it does not have a mapping to process this request.* *These requests were logged in the IIS log files. - When we connected to the server on Monday morning (12/09) CPU usage for JRun was minimal, but Memory usage was at 1.4 Gb, and increasing (this is on a server with 2Gb RAM, also running MS SQL Server) - We attempted to restart ColdFusion ? eventually CF service stopped (after about 5 min) and once stopped, we started the service again without any problems. All sites were tested, and found to be running normally. - The server was rebooted again at 02:40 on 16/09, and again showed pretty much the same symptoms as before (although this time with no errors reported within the CF exception log) - I had increased the max JVM heap size from 512 MB to 1024 MB following the previous crash ? which may have prevented the java.io.IOException: Not enough storage is available to process this command errors. - This is now the third time we have had this occur ? (although I did not record full details for the first time ? and cannot be certain that this was following a reboot). - This has only happened at times when the server is not handling much traffic ? previously to experiencing these problems, the server had been hosting an online competition, handling around 30 simultaneous users during busy periods, and never having a window of more than 20 minutes inactivity. This did make me wonder if it might be an issue with the Garbage Collection Process? Has anyone Experienced this problem, or got any ideas as to how to resolve it? Thanks, Dan. ~| 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:253481 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
