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