I have fought these particular beasts before... Uggh! Contrary to popular opinion, I would guess this is a coding problem and that you are using a CFTRANSACTION that calls upon multiple tables? What is happening is two different transactions are locking tables and getting stuck waiting for the other transaction to release the one's its got locked up.
A diagram to illustrate the point: TRANS_1: - SELECT FROM tbl_a - SELECT FROM tbl_b TRANS_2: - SELECT FROM tbl_b - SELECT FROM tbl_a When two users fire the transactions at the same time, the result is the error you are experiencing. This is just a guess, tho... the solution is to take a closer look at those transactions. M -----Original Message----- From: Craig Thomas [mailto:[EMAIL PROTECTED]] Sent: Friday, April 12, 2002 2:21 PM To: CF-Talk 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
