RE: 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 I know that this is an old saw, but are you locking properly? If not then added load is exactly when you'll see problems. I've a guide to locking here that might be useful: http://www.depressedpress.com/DepressedPress/Content/ColdFusion/Guides/L ocking/Index.cfm The guide is really only application to CF 4-5 as MX changes (and improves) the locking rules quite a bit, but since you're on 5.0 it's still VERY important. Jim Davis ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
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=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: CF server hangng with unresponsive threads
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=subscribeforumid=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
