I asked the DBA to start the Server with options -T1204 and -T3605 and
here's what I get. I need help deciphering this. This happens when we
have 5 usrs performing concurrent actions and for the life of me cannot
decipher this. WHat is a Node, what is the branch ?
WHat are the ECIDs. I cannot even easily find out what process blocks
what. Does anyone have any experience with these. ANy and all help will
be appreaciated. I have posted the output of one of the many deadlocks
encountered. Thanks
Deadlock encountered .... Printing deadlock information
2005-01-11 08:49:59.49 spid4
2005-01-11 08:49:59.49 spid4 Wait-for graph
2005-01-11 08:49:59.49 spid4
2005-01-11 08:49:59.49 spid4 Node:1
2005-01-11 08:49:59.49 spid4 Port: 0x42bf0280 Xid Slot: 0, EC:
0x46d09590, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeCXPacket
2005-01-11 08:49:59.49 spid4 SPID: 61 ECID: 0 Statement Type:
SELECT Line #: 651
2005-01-11 08:49:59.49 spid4 Input Buf: RPC Event:
Procedure_GetLatestValues;1
2005-01-11 08:49:59.49 spid4 Coordinator: EC = 0x46d09590, SPID:
61, ECID: 0, Not Blocking
2005-01-11 08:49:59.49 spid4 Consumer List::
2005-01-11 08:49:59.49 spid4 Consumer: Xid Slot: 0, EC =
0x46d09590, SPID: 61, ECID: 0, Not Blocking
2005-01-11 08:49:59.49 spid4 Producer List::
2005-01-11 08:49:59.49 spid4 Producer: Xid Slot: 1, EC =
0x4732c098, SPID: 61, ECID: 6, Blocking
2005-01-11 08:49:59.49 spid4 Producer: Xid Slot: 2, EC =
0x46824098, SPID: 61, ECID: 5, Blocking
2005-01-11 08:49:59.49 spid4 Producer: Xid Slot: 3, EC =
0x47296098, SPID: 61, ECID: 7, Blocking
2005-01-11 08:49:59.49 spid4
2005-01-11 08:49:59.49 spid4 Node:2
2005-01-11 08:49:59.49 spid4 PAG: 7:1:405367
CleanCnt:3 Mode: IX Flags: 0x2
2005-01-11 08:49:59.49 spid4 Grant List 1::
2005-01-11 08:49:59.49 spid4 Grant List 3::
2005-01-11 08:49:59.49 spid4 Owner:0x4ed4b8e0 Mode: IX
Flg:0x0 Ref:1 Life:02000000 SPID:64 ECID:0
2005-01-11 08:49:59.49 spid4 SPID: 64 ECID: 0 Statement Type:
UPDATE Line #: 1
2005-01-11 08:49:59.49 spid4 Input Buf: RPC Event:
Standard_InsertNamePair;1
2005-01-11 08:49:59.49 spid4 Requested By:
2005-01-11 08:49:59.49 spid4 ResType:LockOwner Stype:'OR' Mode:
S SPID:61 ECID:6 Ec:(0x4732C098) Value:0x4aafe660 Cost:(0/A6C)
2005-01-11 08:49:59.49 spid4
2005-01-11 08:49:59.49 spid4 Node:3
2005-01-11 08:49:59.49 spid4 PAG: 7:1:405373
CleanCnt:1 Mode: IX Flags: 0x2
2005-01-11 08:49:59.49 spid4 Grant List 1::
2005-01-11 08:49:59.49 spid4 Owner:0x4ac00160 Mode: IX
Flg:0x0 Ref:1 Life:02000000 SPID:61 ECID:0
2005-01-11 08:49:59.49 spid4 Requested By:
2005-01-11 08:49:59.49 spid4 ResType:LockOwner Stype:'OR' Mode:
U SPID:64 ECID:0 Ec:(0x472F3590) Value:0x46c24a40 Cost:(0/A38)
2005-01-11 08:49:59.49 spid4
2005-01-11 08:49:59.49 spid4 -- next branch --
2005-01-11 08:49:59.49 spid4
2005-01-11 08:49:59.49 spid4
2005-01-11 08:49:59.49 spid4 Node:1
2005-01-11 08:49:59.49 spid4 Port: 0x42bf0280 Xid Slot: 0, EC:
0x46d09590, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeCXPacket
2005-01-11 08:49:59.49 spid4 Coordinator: EC = 0x46d09590, SPID:
61, ECID: 0, Not Blocking
2005-01-11 08:49:59.49 spid4 Consumer List::
2005-01-11 08:49:59.49 spid4 Consumer: Xid Slot: 0, EC =
0x46d09590, SPID: 61, ECID: 0, Not Blocking
2005-01-11 08:49:59.49 spid4 Producer List::
2005-01-11 08:49:59.49 spid4 Producer: Xid Slot: 1, EC =
0x4732c098, SPID: 61, ECID: 6, Blocking
2005-01-11 08:49:59.49 spid4 Producer: Xid Slot: 2, EC =
0x46824098, SPID: 61, ECID: 5, Blocking
2005-01-11 08:49:59.49 spid4 Producer: Xid Slot: 3, EC =
0x47296098, SPID: 61, ECID: 7, Blocking
2005-01-11 08:49:59.49 spid4
2005-01-11 08:49:59.49 spid4 Node:6
2005-01-11 08:49:59.49 spid4 PAG: 7:1:405367
CleanCnt:3 Mode: IX Flags: 0x2
2005-01-11 08:49:59.49 spid4 Wait List:
2005-01-11 08:49:59.49 spid4 Owner:0x4aafe660 Mode: S
Flg:0x0 Ref:1 Life:00000000 SPID:61 ECID:6
2005-01-11 08:49:59.49 spid4 Requested By:
2005-01-11 08:49:59.49 spid4 ResType:LockOwner Stype:'OR' Mode:
S SPID:61 ECID:5 Ec:(0x46824098) Value:0x4edc4d80 Cost:(0/A6C)
2005-01-11 08:49:59.49 spid4
2005-01-11 08:49:59.49 spid4 -- next branch --
2005-01-11 08:49:59.49 spid4
2005-01-11 08:49:59.49 spid4
2005-01-11 08:49:59.49 spid4 Node:1
2005-01-11 08:49:59.49 spid4 Port: 0x42bf0280 Xid Slot: 0, EC:
0x46d09590, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeCXPacket
2005-01-11 08:49:59.49 spid4 Coordinator: EC = 0x46d09590, SPID:
61, ECID: 0, Not Blocking
2005-01-11 08:49:59.49 spid4 Consumer List::
2005-01-11 08:49:59.49 spid4 Consumer: Xid Slot: 0, EC =
0x46d09590, SPID: 61, ECID: 0, Not Blocking
2005-01-11 08:49:59.49 spid4 Producer List::
2005-01-11 08:49:59.49 spid4 Producer: Xid Slot: 1, EC =
0x4732c098, SPID: 61, ECID: 6, Blocking
2005-01-11 08:49:59.49 spid4 Producer: Xid Slot: 2, EC =
0x46824098, SPID: 61, ECID: 5, Blocking
2005-01-11 08:49:59.49 spid4 Producer: Xid Slot: 3, EC =
0x47296098, SPID: 61, ECID: 7, Blocking
2005-01-11 08:49:59.49 spid4
2005-01-11 08:49:59.49 spid4 Node:9
2005-01-11 08:49:59.49 spid4 PAG: 7:1:405367
CleanCnt:3 Mode: IX Flags: 0x2
2005-01-11 08:49:59.49 spid4 Wait List:
2005-01-11 08:49:59.49 spid4 Owner:0x4aafe660 Mode: S
Flg:0x0 Ref:1 Life:00000000 SPID:61 ECID:6
2005-01-11 08:49:59.49 spid4 Requested By:
2005-01-11 08:49:59.49 spid4 ResType:LockOwner Stype:'OR' Mode:
S SPID:61 ECID:7 Ec:(0x47296098) Value:0x42bef7c0 Cost:(0/A6C)
2005-01-11 08:49:59.49 spid4
2005-01-11 08:49:59.49 spid4 -- next branch --
2005-01-11 08:49:59.49 spid4
2005-01-11 08:49:59.49 spid4
2005-01-11 08:49:59.49 spid4 Node:1
2005-01-11 08:49:59.49 spid4 Port: 0x42bf0280 Xid Slot: 0, EC:
0x46d09590, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeCXPacket
2005-01-11 08:49:59.49 spid4 Coordinator: EC = 0x46d09590, SPID:
61, ECID: 0, Not Blocking
2005-01-11 08:49:59.49 spid4 Consumer List::
2005-01-11 08:49:59.49 spid4 Consumer: Xid Slot: 0, EC =
0x46d09590, SPID: 61, ECID: 0, Not Blocking
2005-01-11 08:49:59.49 spid4 Producer List::
2005-01-11 08:49:59.49 spid4 Producer: Xid Slot: 1, EC =
0x4732c098, SPID: 61, ECID: 6, Blocking
2005-01-11 08:49:59.49 spid4 Producer: Xid Slot: 2, EC =
0x46824098, SPID: 61, ECID: 5, Blocking
2005-01-11 08:49:59.49 spid4 Producer: Xid Slot: 3, EC =
0x47296098, SPID: 61, ECID: 7, Blocking
2005-01-11 08:49:59.49 spid4 Victim Resource Owner:
2005-01-11 08:49:59.49 spid4 ResType:LockOwner Stype:'OR' Mode: U
SPID:64 ECID:0 Ec:(0x472F3590) Value:0x46c24a40 Cost:(0/A38)
2005-01-11 08:50:15.11 spid4
5  5707 
drdeadpan (vk***********@yahoo.com) writes: I asked the DBA to start the Server with options -T1204 and -T3605 and
here's what I get. I need help deciphering this. This happens when we
have 5 usrs performing concurrent actions and for the life of me cannot
decipher this. WHat is a Node, what is the branch ?
WHat are the ECIDs. I cannot even easily find out what process blocks
what. Does anyone have any experience with these. ANy and all help will
be appreaciated. I have posted the output of one of the many deadlocks
encountered. Thanks
Deadlock graphs are unfortunately very difficult to read.
But what I can tell from your dump is that your deadlock involves
parallelism. ECID is a thread-id within a spid, and it seems that
some threads may be blocking each other.
When it says "PAG 7:1:405367" that's the resource being fought about.
7 is the database id, and 1 is the file id. Since this is page, the
last number is a page number. By using DBCC PAGE you can find out
which table the page belongs to. (But DBCC PAGE is not documented in
Books Online, and I don't remember the parameters. But a Google search
might find something.)
Parallelism is often more to harm than benefit in my experience. If
you can track down the query that SPID 61 submitted, an OPTION (MAXDOP 1)
at the end of that query, prevents parallelism. (MAXDOP = MAX Degree of
Parallelism.)
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se
Books Online for SQL Server SP3 at http://www.microsoft.com/sql/techinf...2000/books.asp
Thanks as always. I did learn something from that.
Ok, here's an easier one Erland. What can I infer from this?
Deadlock encountered .... Printing deadlock information
2005-01-13 09:00:10.64 spid4
2005-01-13 09:00:10.64 spid4 Wait-for graph
2005-01-13 09:00:10.64 spid4
2005-01-13 09:00:10.64 spid4 Node:1
2005-01-13 09:00:10.64 spid4 KEY: 7:1038026504:2 (17018f579faa)
CleanCnt:1 Mode: X Flags: 0x0
2005-01-13 09:00:10.64 spid4 Grant List 0::
2005-01-13 09:00:10.64 spid4 Owner:0x6746f520 Mode: X
Flg:0x0 Ref:0 Life:02000000 SPID:62 ECID:0
2005-01-13 09:00:10.64 spid4 SPID: 62 ECID: 0 Statement Type:
DELETE Line #: 122
2005-01-13 09:00:10.64 spid4 Input Buf: RPC Event:
Requisition_Scansample;1
2005-01-13 09:00:10.64 spid4 Requested By:
2005-01-13 09:00:10.64 spid4 ResType:LockOwner Stype:'OR' Mode:
S SPID:57 ECID:0 Ec:(0x70E27590) Value:0x7102e5c0 Cost:(0/A10)
2005-01-13 09:00:10.64 spid4
2005-01-13 09:00:10.64 spid4 Node:2
2005-01-13 09:00:10.64 spid4 KEY: 7:1811953977:6 (420154596011)
CleanCnt:1 Mode: X Flags: 0x0
2005-01-13 09:00:10.64 spid4 Grant List 3::
2005-01-13 09:00:10.64 spid4 Owner:0x550cdac0 Mode: X
Flg:0x0 Ref:0 Life:02000000 SPID:57 ECID:0
2005-01-13 09:00:10.64 spid4 SPID: 57 ECID: 0 Statement Type:
CONDITIONAL Line #: 59
2005-01-13 09:00:10.64 spid4 Input Buf: RPC Event:
Requisition_Scansample;1
2005-01-13 09:00:10.64 spid4 Requested By:
2005-01-13 09:00:10.64 spid4 ResType:LockOwner Stype:'OR' Mode:
S SPID:62 ECID:0 Ec:(0x670F7590) Value:0x718e8680 Cost:(0/27E4)
2005-01-13 09:00:10.64 spid4 Victim Resource Owner:
2005-01-13 09:00:10.64 spid4 ResType:LockOwner Stype:'OR' Mode: S
SPID:57 ECID:0 Ec:(0x70E27590) Value:0x7102e5c0 Cost:(0/A10)
2005-01-13 09:01:00.97 spid4
Thanks..
drdeadpan (vk***********@yahoo.com) writes: Thanks as always. I did learn something from that.
Ok, here's an easier one Erland. What can I infer from this?
First of all, you do have this information:
DELETE Line #: 122
2005-01-13 09:00:10.64 spid4 Input Buf: RPC Event:
Requisition_Scansample;1
...
CONDITIONAL Line #: 59
2005-01-13 09:00:10.64 spid4 Input Buf: RPC Event:
Requisition_Scansample;1
That is procedure name and line number. Although if Requisition_Scansample
calls other procedures, the line number may refer to any these instead.
We also have:
2005-01-13 09:00:10.64 spid4 KEY: 7:1038026504:2 (17018f579faa)
SELECT db_name(7) will give you the database, and if you then
go that database SELECT object_name(1038026504) will give you
the table. Finally 2 is index = 2 for that table, check sysindexes.
And again:
2005-01-13 09:00:10.64 spid4 KEY: 7:1811953977:6 (420154596011)
Now you know the involved objects and you have some hint where it's
happening. Then use your knowledge about what's happening in
Requisition_Scansample to understand what is happening.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se
Books Online for SQL Server SP3 at http://www.microsoft.com/sql/techinf...2000/books.asp This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Mark |
last post by:
Hi - Can anyone please help with the error message below - server is XP
Pro, and the ASP code it is failing at is (set
MM_rsUser.ActiveConnection... as below):
<%...
|
by: Agnes |
last post by:
I got a ASP program in the server, it runs properly . However, As I run the
web siste , click 'login' button.
It return the following errors. It seems can't connect the database, I had
stopped...
|
by: debian mojo |
last post by:
Hello faculties,
i'm encountering a strange a deadlock problem on my remote server
which is used to give application demo to the client. It has happened
that on one of the databases a deadlock...
|
by: I am Sam |
last post by:
Ok I set up a button column to delete an individual record. Nothing happens
when I test it. Someone please help understand why. Below is the associated
coding:
DataGrid control:
...
|
by: MR |
last post by:
Hi,
it has been observed that when we try to instantiate
a .Net dll for the first time in a session (e.g. from an
exe in .Net), it takes almost 10 times compared to
subsequent instantiations.
...
|
by: Tiraman |
last post by:
Hi ,
i m getting the following errors under the eventlog while i m trying to run
some class that i wrote.
at the first i got an error about the just-in-time : access denied and i
added the...
|
by: neil brown |
last post by:
Whenever I try and run a project in VB.NET 2003, all i get is:
"An unhandled exception of type 'System.ArgumentException' occurred in
Unknown Module.
Additional information: The parameter is...
|
by: Steve |
last post by:
Hi,
I've asked this question a couple of times before on this forum but no
one seems to be nice enough to point me to the right direction or help
me out with any information, if possible. Please...
|
by: Dio1080 |
last post by:
Hello, I need help making a table based off my tax code I made, the tax code was a little, but I need help with the table part also. The table should look like this:
Income | Single Married |...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
| |
