How to resolve this Deadlock Issue?
-
Hi,
We are facing Deadlock issues, when we try to execute a proceddure for different parameters simulataneously,
Example:
proc_name '20070630','755','Y','html'
proc_name '20070630','681','Y','html'
------
When we are executing the above procedure simultaneously..we are getting the Deadlock error..
Here is the trace file for your reference.. We could not find the KEY parameter in this Trace file and we are not able to find the object name which is creating the Deadlock.
------
2007-07-16 13:59:49.70 logon Login failed for user 'JUnitCustomer'.
2007-07-16 14:00:11.01 logon Login failed for user 'JUnitCustomer'.
2007-07-16 14:00:11.06 logon Login failed for user 'JUnitCustomer'.
2007-07-16 14:00:11.17 logon Login failed for user 'JUnitCustomer'.
2007-07-16 14:00:11.21 logon Login failed for user 'JUnitCustomer'.
2007-07-16 14:00:39.90 spid4 ResType:LockOwner Stype:'OR' Mode: IX SPID:78 ECID:0 Ec0x6B133538) Value:0x6a
2007-07-16 14:00:39.90 spid4 Victim Resource Owner:
2007-07-16 14:00:39.90 spid4 ResType:LockOwner Stype:'OR' Mode: IX SPID:78 ECID:0 Ec0x6B133538) Value:0x6a
2007-07-16 14:00:39.90 spid4 Requested By:
2007-07-16 14:00:39.90 spid4 Grant List 2::
2007-07-16 14:00:39.90 spid4 Input Buf: Language Event: proc_create_fsa_export '20070630','755','Y','html'
2007-07-16 14:00:39.90 spid4 SPID: 74 ECID: 0 Statement Type: UPDATE Line #: 252
2007-07-16 14:00:39.90 spid4 Owner:0x219ed520 Mode: S Flg:0x0 Ref:0 Life:00000001 SPID:74 ECID:0
2007-07-16 14:00:39.90 spid4 Grant List 0::
2007-07-16 14:00:39.90 spid4 PAG: 10:1:3325 CleanCnt:2 Mode: SIU Flags: 0x2
2007-07-16 14:00:39.90 spid4 Node:2
2007-07-16 14:00:39.90 spid4
2007-07-16 14:00:39.90 spid4 ResType:LockOwner Stype:'OR' Mode: IX SPID:74 ECID:0 Ec0x7BB75538) Value:0x54
2007-07-16 14:00:39.90 spid4 Requested By:
2007-07-16 14:00:39.90 spid4 Input Buf: Language Event: proc_create_fsa_export '20070630','284','Y','html'
2007-07-16 14:00:39.90 spid4 SPID: 78 ECID: 0 Statement Type: UPDATE Line #: 224
2007-07-16 14:00:39.90 spid4 Owner:0x1c109a00 Mode: S Flg:0x0 Ref:0 Life:00000001 SPID:78 ECID:0
2007-07-16 14:00:39.90 spid4 Grant List 2::
2007-07-16 14:00:39.90 spid4 Grant List 0::
2007-07-16 14:00:39.90 spid4 PAG: 10:1:45083 CleanCnt:2 Mode: SIU Flags: 0x2
2007-07-16 14:00:39.90 spid4 Node:1
2007-07-16 14:00:39.90 spid4
2007-07-16 14:00:39.90 spid4 Wait-for graph
2007-07-16 14:00:39.90 spid4
2007-07-16 14:00:39.90 spid4 ...
2007-07-16 14:00:41.29 logon Login failed for user 'JUnitCustomer'.
2007-07-16 14:00:41.32 logon Login failed for user 'JUnitCustomer'.
----------
Can any one of you please help to solve this issue.
Regards,
E Ezhilan
-
Please do not cross-post. See my response in the other thread.
--------------------
Colt 45 - the original point and click interface
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply