I'll try this today and see if it helps - thank you.
At 10:35 AM 28/11/02 -0500, you wrote:
>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
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
