Stephen, See the following thread at MM's site...
http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=143 | -----Original Message----- | From: Mike Brunt [mailto:[EMAIL PROTECTED]] | Sent: Wednesday, November 27, 2002 9:47 AM | To: CF-Talk | Subject: RE: CF server hangng with unresponsive threads | | | Stephen, are you using Application, Server and/or Session | scoped variables in your application? | | Kind Regards - Mike Brunt, CTO | Webapper | Blog http://www.webapper.net | Web site http://www.webapper.com | Downey CA Office | 562.243.6255 | AIM - webappermb | | Web Application Specialists | | | -----Original Message----- | From: Stephen Richards [mailto:[EMAIL PROTECTED]] | Sent: Wednesday, November 27, 2002 9:21 AM | To: CF-Talk | Subject: CF server hangng with unresponsive threads | | | The number of users on our system has recently increased from | about 15 to 35, and now the server is hanging 3 or 4 times a | day. Server.log reporting that the unrespnsive thread count | (see log snippet at end of message). | | Have tried paying with the various cfadmin settings, but no joy. | | There are killer queries that are being executed, and this | takes 99% of the CPU for up to 2 minutes - and although the | cfserver appears to hang at those times, the response comes | back when the query has finished, btu what we are seeing is | worse than that - indefinite hangs which can only be cured by | stoping and restarting the cf server. | | We are working to get rid of the killer queries (even if they | are not the cause, they should be eliminated in any case), | and will probably move the cf server to another machine | (currently on the same high spec machine as the databse). | | Is there anything else we should be doing? Has anyone else | experienced these problems? | | Am running CF 5.0 on RedHat Linux 2.4.2-2smp, UNIX ODBC and | Postgres 7.2.3 | | ----------------------------- | Stephen Richards | 020 7903 3226 | ------------------------------ | | | | ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm