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:142507 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
