----- Original Message -----
Sent: Friday, April 02, 2004 10:37
AM
Subject: [cf-dev] RE: [ cf-dev ]
Deadlocks in SQL 2000
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?
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
