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
