Mike,
We have been working with Mike Collins on this. He has COMPLETE access
to one of our servers that has been experiencing these problems, and is
quite familiar with how we have things setup there.
Just FYI.
Lee
| -----Original Message-----
| From: Mike Chambers [mailto:[EMAIL PROTECTED]]
| Sent: Thursday, November 28, 2002 7:35 AM
| To: CF-Talk
| Subject: RE: CFMX Server Crash #4 for the day..
|
|
| 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
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
