Basically your query is taking too long to execute and locking the table(s) that other queries need. When Updating/Inserting , try to minimize the time of queries take. do not use the IN operator, try putting the results into a temp table then join it at the update/insert.
----- Original Message ----- From: "Craig Thomas" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, April 12, 2002 2:21 PM Subject: RE: RE: Deadlock > are you using <cftransaction> tags? > > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Friday, April 12, 2002 1:50 PM > To: CF-Talk > Subject: Re: RE: Deadlock > > > This is not a CF error. This is a SQL Server error. What are you > doing in your SQL that would cause such deadlocks? > > ----- Original Message ----- > From: "Semrau, Steven L Mr RDAISA/SRA" > <[EMAIL PROTECTED]> > Date: Friday, April 12, 2002 11:39 am > Subject: RE: Deadlock > > > Read up on CFLOCK it talks about Deadlocks and the possible > > reasons why. > > > > -----Original Message----- > > From: Justin Waldrip [mailto:[EMAIL PROTECTED]] > > Sent: Friday, April 12, 2002 1:10 PM > > To: CF-Talk > > Subject: Deadlock > > > > > > Your transaction (process ID #39) was deadlocked with another process > > and has been chosen as the deadlock victim. Rerun your transaction. > > > > I am receiving quite a few of these errors in a row. Where is a good > > place to start looking for things that might cause this? > > > > Thanks, > > > > Justin > > > > > > > > > > ______________________________________________________________________ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
