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 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:253427 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
