This is a multi-part message in MIME format.
------=_NextPart_000_0038_01C03791.1ADD9A10
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Hi all
We have an app which was exhibiting strange behaviour until we realised we
needed to read-only lock some application and session variables.
(Previously, we had always used exclusive locks for writing these variables,
but no locks for reading). This seems to have fixed our problem, but we now
have a new problem, where the site gets deadlocked
eg the following error message:
Microsoft][ODBC SQL Server Driver][SQL Server]Your transaction (process ID
#14) was deadlocked with another process and has been chosen as the deadlock
victim. Rerun your transaction.
Have we removed one set of problems just to get another set, or is there
something we have missed here? Any feedback would be appreciated.
Thanks
Garry
------=_NextPart_000_0038_01C03791.1ADD9A10
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR></HEAD>
<BODY>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D763194606-16102000>Hi=20
all</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D763194606-16102000></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D763194606-16102000>We =
have an app which=20
was exhibiting strange behaviour until we realised we needed to =
read-only lock=20
some application and session variables. (Previously, we had always used=20
exclusive locks for writing these variables, but no locks for =
reading).=20
This seems to have fixed our problem, but we now have a new problem, =
where the=20
site gets deadlocked</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D763194606-16102000></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D763194606-16102000>eg the =
following=20
error message:</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D763194606-16102000></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN =
class=3D763194606-16102000>Microsoft][ODBC SQL=20
Server Driver][SQL Server]Your transaction (process ID #14) was =
deadlocked with=20
another process and has been chosen as the deadlock victim. Rerun your=20
transaction.</SPAN></FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D763194606-16102000>Have =
we removed one=20
set of problems just to get another set, or is there something we have =
missed=20
here? Any feedback would be appreciated.</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D763194606-16102000></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D763194606-16102000>Thanks</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D763194606-16102000></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D763194606-16102000>Garry</SPAN></FONT></DIV></BODY></HTML>
------=_NextPart_000_0038_01C03791.1ADD9A10--
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
