|
The transactions insert new rows in 1 table and
update the balance in another.
I tried read committed while doing tests once and
it inserted rows into a table in random order not one after
another.
Allan
----- Original Message -----
Sent: Friday, April 02, 2004 10:47
AM
Subject: RE: [cf-dev] RE: [ cf-dev ]
Deadlocks in SQL 2000
Are the transactions inserting new rows or are they also
updating and
deleting?
Try using "Read committed" - this may
help but it could cause errors if you
are updating rows and multiple
transactions are
involved.
N
________________________________
From:
Allan Cliff - CFUG Spain [mailto:[EMAIL PROTECTED]
Sent: 02 April 2004
09:41
To: [EMAIL PROTECTED]
Subject:
Re: [cf-dev] RE: [ cf-dev ] Deadlocks in SQL 2000
They are
currently all CFQUERY.
----- Original Message -----
From:
Robertson-Ravo, Neil (RX)
<mailto:[EMAIL PROTECTED]>
To: '[EMAIL PROTECTED]'
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?
________________________________
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
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
--
These
lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/
Archive:
http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
CFDeveloper
Sponsors and contributors:-
*Hosting and support provided by
CFMXhosting.co.uk* :: *ActivePDF provided by
activepdf.com*
*Forums provided by
fusetalk.com* :: *ProWorkFlow provided by
proworkflow.com*
*Tutorials provided by helmguru.com* :: *Lists hosted by
gradwell.com*
To unsubscribe, e-mail: [EMAIL PROTECTED]
|
