Ah... strangely enough... that's another problem we're getting, too.

We were also getting it in CF5.  If's not a CF thing.  You are getting
a race condition, where there's a lock on a table that someone else is
trying to access.  It can be hard to fix - we're still trying to fix
our problem.

On Fri, 14 Jan 2005 10:20:42 -0500, Jeffry Houser <[EMAIL PROTECTED]> wrote:
> At 10:04 AM 1/14/2005, you wrote:
> >From: Brian Meloche <[EMAIL PROTECTED]>
> >Date: Fri, 14 Jan 2005 09:39:22 -0500
> >Thread:
> >http://www.houseoffusion.com/cf_lists/index.cfm/method=messages&threadid=15553&forumid=5#142499
> >
> > >>Interesting (at least to me) is that the problem appears to be w/ the
> >database server, not the ColdFusion servers.  However, once the DB Server
> >ramps up to 100% utilization, CF starts spouting out timeout errors very
> >fiercely.
> >
> >What kind of timeout errors are you seeing?  We just had a problem
> >with seeing "No more data available to read" errors on our CF5 to CFMX
> >6.1 J2EE upgrade.  They were eliminated once we changed timeouts in CF
> >Administrator on the afflicted datasource (SQL Server 2000) from 0 to
> >30 minutes.  Not sure if that's your problem or not without knowing
> >the type of timeout you're getting, but if it is that kind of error, I
> >hope this info helps.
> 
> 
>  First things appear to be fine.  Then we get one of these:
> 
> Error Detail:[Macromedia][SQLServer JDBC Driver][SQLServer]Transaction
> (Process ID 85) was deadlocked on lock resources with another process and
> has been chosen as the deadlock victim. Rerun the transaction.
> 
>  Then we get tons of these:
> The request has exceeded the allowable time limit Tag: cfquery
> 
> (the tag entry usually being, cfquery or cfstoredproc.  I have seen
> cfoutput there too)
> 
>  Thanks for the info.
> 
> 
> --
> Jeffry Houser, Web Developer, Writer, Songwriter, Recording Engineer
> AIM: Reboog711  | Phone: 1-203-379-0773
> --
> My Books: <http://www.instantcoldfusion.com>
> My Recording Studio: <http://www.fcfstudios.com>
> My Energetic Acoustic Rock Band: <http://www.farcryfly.com>
> --
> When did Reality Become TV
> 
> 

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:5:142514
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/5
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:5
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Reply via email to