Brook, below is a suggestion passed on to me:
-- Since they are using SQL the timeout attribute is supported in <cfquery>, it's not in oracle. They should add a timeout to all their queries. That way if SQL is caught in a deadlock situation SQL will use that timeout attribute as a timer, and if the query waits that long SQL will throw and error back to CF, and more important it will hand the thread back to CF so it can continue handling request. -- have you tried this? Also, have you contacted support? I don't want to restart the whole support thread, but you should get a little more prompt / escelated support from them. mike chambers [EMAIL PROTECTED] > -----Original Message----- > From: Brook Davies [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, November 27, 2002 6:20 PM > To: CF-Talk > Subject: Re: CFMX Server Crash #4 for the day.. > > > I wish it was, but we have only one app on the server, and it > does not use > session variables and the application var usage has been thoroughly > reviewed and the locks appear correct. > > The application vars used by the app are refreshed > essentially once a day > or when they do not exist (isdefined), these locks would not > have been in > effect at the time of these crashed. The application vars > would have been > being read but not written. This is the case throughout the > site with no > exceptions. > > There are several 3rd party calls, and I had thought > initially that this > was the problem. But I am not alone with this problem as it > seems Tyler is > with his "Success" stories. Tyler, do you think every one in > this thread > has some application issues and that we should all stop > blaming CFMX and > use your limited success as proof that CFMX works under load? > > http://webforums.macromedia.com/coldfusion/messageview.cfm?cat > id=143&threadi > d=468954 > > Brook > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
