RE: [ cf-dev ] Deadlocks in SQL 2000

[Robertson-Ravo, Neil (RX)]

Hmmm, well DEADLOCKS are usually a sign of a flawed DB design (which I am sure its not) but from what you are saying you just seem to be locking and not releasing each PID in good time.  i.e. you will get deadlocks if you are trying to write to a table when its locked...using SQL Transactions in T-SQL may help you.  Try running a SQL Trace and see what the guilty party is but from the description its just not queuing the requests correctly.   Is this is all in CFQUERY? or are there SP's in play?     From: Allan Cliff - CFUG Spain [mailto:[EMAIL PROTECTED] Sent: 02 April 2004 09:28 To: CF - List Subject: [ cf-dev ] Deadlocks in SQL 2000 I work on a system that sends payments from 1 account to another.   There are thousands of accounts and they can send money to each other or program a direct debit to pay another account when they have no access to internet.   Each set of Transactions is wrapped in its <CFTRANSACTION> tag with the isolation set to SERIALIZABLE.   1 account is very busy and has hundreds of direct debits set up which run at a certain time using cfschedule. This can take up to 6 or 7 minutes to run.   During that time if anyone tries to send money to that account while that account is busy paying out I get an error in the log (Transaction (Process ID XX) was deadlocked on lock resources with another process and has been chosen as the deadlock victim.)   How can I get around this? Any ideas? I know its Friday.   Thanks -------------------------------------------------------------- Allan Cliff Malaga RedPro S.L. -------------------------------------------------------------- This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com