|
При deadlock не прошло автоматическое снятие сессии
#40019932
Ссылка:
Ссылка на сообщение:
Ссылка с названием темы:
|
|
|
|
felix_ff,
Ок, заменил имя БД, таблиц и сервера на аналог, остальное не трогал.
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.
66.
67.
68.
69.
70.
71.
72.
73.
74.
75.
76.
77.
78.
79.
80.
81.
82.
83.
84.
85.
86.
87.
88.
89.
90.
91.
92.
93.
94.
95.
96.
97.
98.
99.
100.
101.
102.
103.
104.
105.
106.
107.
108.
109.
110.
111.
112.
113.
114.
115.
116.
117.
118.
119.
120.
121.
122.
123.
124.
125.
126.
127.
128.
129.
130.
131.
132.
133.
134.
135.
136.
137.
138.
139.
140.
141.
142.
143.
144.
145.
146.
147.
148.
149.
150.
151.
152.
153.
154.
155.
156.
157.
158.
159.
160.
161.
162.
163.
164.
165.
166.
167.
168.
169.
170.
171.
172.
173.
174.
175.
176.
177.
178.
179.
180.
181.
182.
183.
184.
185.
186.
187.
188.
189.
190.
191.
192.
193.
194.
195.
196.
197.
198.
199.
200.
201.
202.
203.
204.
205.
206.
207.
208.
209.
210.
211.
212.
213.
214.
215.
216.
217.
218.
219.
220.
221.
222.
223.
224.
225.
226.
227.
<deadlock>
<victim-list>
<victimProcess id="processbb3c067848" />
</victim-list>
<process-list>
<process id="processbb3c067848" taskpriority="0" logused="10000" waittime="396" schedulerid="10" kpid="18308" status="suspended" spid="329" sbid="1" ecid="4" priority="0" trancount="0" lastbatchstarted="2020-11-17T08:18:34.760" lastbatchcompleted="2020-11-17T08:18:34.710" lastattention="1900-01-01T00:00:00.710" hostname="priklad-12" hostpid="0" isolationlevel="read committed (2)" xactid="54905556086" currentdb="9" currentdbname="DataBase" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
<executionStack>
<frame procname="adhoc" line="3" stmtstart="164" stmtend="1862" sqlhandle="0x02000000428fd42cd8f4fad83ab358d1900f3ce6206f5a550000000000000000000000000000000000000000">
unknown </frame>
<frame procname="unknown" line="1" sqlhandle="0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000">
unknown </frame>
</executionStack>
<inputbuf>
(@P1 nvarchar(4000),@P2 nvarchar(4000),@P3 nvarchar(4000))SET DATEFORMAT dmy;
SELECT
o.*,
u.name as nurse,
p.first_name,
p.middle_name,
p.last_name,
p.birthday,
CAST(d.Discount AS nvarchar(50))+'% - '+d.DiscountName as discount, k.Name as partner,
CASE WHEN (o.visit_date <= convert(date, GETDATE()) AND o.status < 2) OR (o.visit_date < convert(date, GETDATE()) AND o.status = 2)
THEN 1
ELSE 0
END AS timeoff,
k.name as kontragentName
FROM table1 o
LEFT JOIN table2 p ON p.id = o.patient_id
LEFT JOIN table3 u ON u.id=o.nurse_id
LEFT JOIN table4 doc ON doc.id = o.doctor_id
LEFT JOIN table5 d ON d.AID = o.discount_id
LEFT JOIN table6 k ON k.[Key]=o.partner_id
WHERE o.visit_date >= @P1 AND o.visit_date <= @P2 AND p.last_name+' '+p.first_name+' '+p.middle_name like @P3
ORDER BY o.status, o.visit_date, o.visit_time ASC </inputbuf>
</process>
<process id="processbb3c06fc28" taskpriority="0" logused="10000" waittime="2477" schedulerid="11" kpid="19692" status="suspended" spid="329" sbid="1" ecid="2" priority="0" trancount="0" lastbatchstarted="2020-11-17T08:18:34.760" lastbatchcompleted="2020-11-17T08:18:34.710" lastattention="1900-01-01T00:00:00.710" hostname="priklad-12" hostpid="0" isolationlevel="read committed (2)" xactid="54905556086" currentdb="9" currentdbname="DataBase" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
<executionStack>
<frame procname="adhoc" line="3" stmtstart="164" stmtend="1862" sqlhandle="0x02000000428fd42cd8f4fad83ab358d1900f3ce6206f5a550000000000000000000000000000000000000000">
unknown </frame>
<frame procname="unknown" line="1" sqlhandle="0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000">
unknown </frame>
</executionStack>
<inputbuf>
(@P1 nvarchar(4000),@P2 nvarchar(4000),@P3 nvarchar(4000))SET DATEFORMAT dmy;
SELECT
o.*,
u.name as nurse,
p.first_name,
p.middle_name,
p.last_name,
p.birthday,
CAST(d.Discount AS nvarchar(50))+'% - '+d.DiscountName as discount, k.Name as partner,
CASE WHEN (o.visit_date <= convert(date, GETDATE()) AND o.status < 2) OR (o.visit_date < convert(date, GETDATE()) AND o.status = 2)
THEN 1
ELSE 0
END AS timeoff,
k.name as kontragentName
FROM table1 o
LEFT JOIN table2 p ON p.id = o.patient_id
LEFT JOIN table3 u ON u.id=o.nurse_id
LEFT JOIN table4 doc ON doc.id = o.doctor_id
LEFT JOIN table5 d ON d.AID = o.discount_id
LEFT JOIN table6 k ON k.[Key]=o.partner_id
WHERE o.visit_date >= @P1 AND o.visit_date <= @P2 AND p.last_name+' '+p.first_name+' '+p.middle_name like @P3
ORDER BY o.status, o.visit_date, o.visit_time ASC </inputbuf>
</process>
<process id="process6abc037468" taskpriority="0" logused="10000" waittime="2477" schedulerid="8" kpid="9868" status="suspended" spid="329" sbid="1" ecid="1" priority="0" trancount="0" lastbatchstarted="2020-11-17T08:18:34.760" lastbatchcompleted="2020-11-17T08:18:34.710" lastattention="1900-01-01T00:00:00.710" hostname="priklad-12" hostpid="0" isolationlevel="read committed (2)" xactid="54905556086" currentdb="9" currentdbname="DataBase" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
<executionStack>
<frame procname="adhoc" line="3" stmtstart="164" stmtend="1862" sqlhandle="0x02000000428fd42cd8f4fad83ab358d1900f3ce6206f5a550000000000000000000000000000000000000000">
unknown </frame>
<frame procname="unknown" line="1" sqlhandle="0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000">
unknown </frame>
</executionStack>
<inputbuf>
(@P1 nvarchar(4000),@P2 nvarchar(4000),@P3 nvarchar(4000))SET DATEFORMAT dmy;
SELECT
o.*,
u.name as nurse,
p.first_name,
p.middle_name,
p.last_name,
p.birthday,
CAST(d.Discount AS nvarchar(50))+'% - '+d.DiscountName as discount, k.Name as partner,
CASE WHEN (o.visit_date <= convert(date, GETDATE()) AND o.status < 2) OR (o.visit_date < convert(date, GETDATE()) AND o.status = 2)
THEN 1
ELSE 0
END AS timeoff,
k.name as kontragentName
FROM table1 o
LEFT JOIN table2 p ON p.id = o.patient_id
LEFT JOIN table3 u ON u.id=o.nurse_id
LEFT JOIN table4 doc ON doc.id = o.doctor_id
LEFT JOIN table5 d ON d.AID = o.discount_id
LEFT JOIN table6 k ON k.[Key]=o.partner_id
WHERE o.visit_date >= @P1 AND o.visit_date <= @P2 AND p.last_name+' '+p.first_name+' '+p.middle_name like @P3
ORDER BY o.status, o.visit_date, o.visit_time ASC </inputbuf>
</process>
<process id="processbb3c0768c8" taskpriority="0" logused="0" waitresource="KEY: 9:72057596710289408 (828781b99285)" waittime="2477" ownerId="54905556086" transactionname="SELECT" lasttranstarted="2020-11-17T08:18:34.747" XDES="0x6306cd2960" lockMode="S" schedulerid="12" kpid="20304" status="suspended" spid="329" sbid="1" ecid="3" priority="0" trancount="0" lastbatchstarted="2020-11-17T08:18:34.760" lastbatchcompleted="2020-11-17T08:18:34.710" lastattention="1900-01-01T00:00:00.710" hostname="priklad-12" hostpid="0" isolationlevel="read committed (2)" xactid="54905556086" currentdb="9" currentdbname="DataBase" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
<executionStack>
<frame procname="adhoc" line="3" stmtstart="164" stmtend="1862" sqlhandle="0x02000000428fd42cd8f4fad83ab358d1900f3ce6206f5a550000000000000000000000000000000000000000">
unknown </frame>
<frame procname="unknown" line="1" sqlhandle="0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000">
unknown </frame>
</executionStack>
<inputbuf>
(@P1 nvarchar(4000),@P2 nvarchar(4000),@P3 nvarchar(4000))SET DATEFORMAT dmy;
SELECT
o.*,
u.name as nurse,
p.first_name,
p.middle_name,
p.last_name,
p.birthday,
CAST(d.Discount AS nvarchar(50))+'% - '+d.DiscountName as discount, k.Name as partner,
CASE WHEN (o.visit_date <= convert(date, GETDATE()) AND o.status < 2) OR (o.visit_date < convert(date, GETDATE()) AND o.status = 2)
THEN 1
ELSE 0
END AS timeoff,
k.name as kontragentName
FROM table1 o
LEFT JOIN table2 p ON p.id = o.patient_id
LEFT JOIN table3 u ON u.id=o.nurse_id
LEFT JOIN table4 doc ON doc.id = o.doctor_id
LEFT JOIN table5 d ON d.AID = o.discount_id
LEFT JOIN table6 k ON k.[Key]=o.partner_id
WHERE o.visit_date >= @P1 AND o.visit_date <= @P2 AND p.last_name+' '+p.first_name+' '+p.middle_name like @P3
ORDER BY o.status, o.visit_date, o.visit_time ASC </inputbuf>
</process>
<process id="process943a6b28c8" taskpriority="0" logused="452" waitresource="PAGE: 9:1:127149510 " waittime="2547" ownerId="54905549280" transactionname="UPDATE" lasttranstarted="2020-11-17T08:18:34.523" XDES="0x8fb86d8420" lockMode="IX" schedulerid="64" kpid="14236" status="suspended" spid="428" sbid="1" ecid="0" priority="0" trancount="2" lastbatchstarted="2020-11-17T08:18:34.527" lastbatchcompleted="2020-11-17T08:18:34.527" lastattention="1900-01-01T00:00:00.527" hostname="priklad-05" hostpid="0" loginname="login" isolationlevel="read committed (2)" xactid="54905549280" currentdb="9" currentdbname="DataBase" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
<executionStack>
<frame procname="adhoc" line="1" stmtstart="396" stmtend="870" sqlhandle="0x020000007954ae38890048dc24ce164761443b0a0444eab50000000000000000000000000000000000000000">
unknown </frame>
<frame procname="unknown" line="1" sqlhandle="0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000">
unknown </frame>
</executionStack>
<inputbuf>
(@P1 nvarchar(4000),@P2 nvarchar(4000),@P3 nvarchar(4000),@P4 nvarchar(4000),@P5 nvarchar(4000),@P6 nvarchar(4000),@P7 char(1),@P8 char(1),@P9 nvarchar(4000))SET DATEFORMAT dmy; update table1 set [discount_id]=@P1, [delivery_address]=@P2, [user_id]=@P3, [phone]=@P4, [mobile]=@P5, [email]=@P6, [preferred_pay_type]=@P7, [formal_confirmation]=@P8, [complete_dt]=@P9 where [id]='369112' </inputbuf>
</process>
<process id="processbb3bb81c28" taskpriority="0" logused="10000" waittime="2588" schedulerid="30" kpid="17780" status="suspended" spid="329" sbid="1" ecid="0" priority="0" trancount="0" lastbatchstarted="2020-11-17T08:18:34.760" lastbatchcompleted="2020-11-17T08:18:34.710" lastattention="1900-01-01T00:00:00.710" hostname="priklad-12" hostpid="0" loginname="login" isolationlevel="read committed (2)" xactid="54905556086" currentdb="9" currentdbname="DataBase" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
<executionStack>
<frame procname="adhoc" line="3" stmtstart="164" stmtend="1862" sqlhandle="0x02000000428fd42cd8f4fad83ab358d1900f3ce6206f5a550000000000000000000000000000000000000000">
unknown </frame>
<frame procname="unknown" line="1" sqlhandle="0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000">
unknown </frame>
</executionStack>
<inputbuf>
(@P1 nvarchar(4000),@P2 nvarchar(4000),@P3 nvarchar(4000))SET DATEFORMAT dmy;
SELECT
o.*,
u.name as nurse,
p.first_name,
p.middle_name,
p.last_name,
p.birthday,
CAST(d.Discount AS nvarchar(50))+'% - '+d.DiscountName as discount, k.Name as partner,
CASE WHEN (o.visit_date <= convert(date, GETDATE()) AND o.status < 2) OR (o.visit_date < convert(date, GETDATE()) AND o.status = 2)
THEN 1
ELSE 0
END AS timeoff,
k.name as kontragentName
FROM table1 o
LEFT JOIN table2 p ON p.id = o.patient_id
LEFT JOIN table3 u ON u.id=o.nurse_id
LEFT JOIN table4 doc ON doc.id = o.doctor_id
LEFT JOIN table5 d ON d.AID = o.discount_id
LEFT JOIN table6 k ON k.[Key]=o.partner_id
WHERE o.visit_date >= @P1 AND o.visit_date <= @P2 AND p.last_name+' '+p.first_name+' '+p.middle_name like @P3
ORDER BY o.status, o.visit_date, o.visit_time ASC </inputbuf>
</process>
</process-list>
<resource-list>
<exchangeEvent id="Portbb31ab8e00" WaitType="e_waitPortOpen" waiterType="Producer" nodeId="1" tid="2" ownerActivity="notYetOpened" waiterActivity="waitForAllOwnersToOpen">
<owner-list>
<owner id="processbb3c06fc28" />
</owner-list>
<waiter-list>
<waiter id="processbb3c067848" />
</waiter-list>
</exchangeEvent>
<exchangeEvent id="Portbb31ab8e00" WaitType="e_waitPortOpen" waiterType="Producer" nodeId="1" tid="3" ownerActivity="notYetOpened" waiterActivity="waitForAllOwnersToOpen">
<owner-list>
<owner id="processbb3c0768c8" />
</owner-list>
<waiter-list>
<waiter id="processbb3c06fc28" />
</waiter-list>
</exchangeEvent>
<exchangeEvent id="Portbb31ab8e00" WaitType="e_waitPortOpen" waiterType="Producer" nodeId="1" tid="1" ownerActivity="notYetOpened" waiterActivity="waitForAllOwnersToOpen">
<owner-list>
<owner id="processbb3c067848" />
</owner-list>
<waiter-list>
<waiter id="process6abc037468" />
</waiter-list>
</exchangeEvent>
<keylock hobtid="72057596710289408" dbid="9" objectname="DataBase.dbo.table1" indexname="PK_table1" id="lock7ea2ba2280" mode="X" associatedObjectId="72057596710289408">
<owner-list>
<owner id="process943a6b28c8" mode="X" />
</owner-list>
<waiter-list>
<waiter id="processbb3c0768c8" mode="S" requestType="wait" />
</waiter-list>
</keylock>
<pagelock fileid="1" pageid="127149510" dbid="9" subresource="FULL" objectname="DataBase.dbo.table1" id="lock7893bba680" mode="S" associatedObjectId="72057596807151616">
<owner-list>
<owner id="processbb3bb81c28" mode="S" />
</owner-list>
<waiter-list>
<waiter id="process943a6b28c8" mode="IX" requestType="wait" />
</waiter-list>
</pagelock>
<exchangeEvent id="Portbb31ab8e00" WaitType="e_waitPortOpen" waiterType="Coordinator" nodeId="1" tid="0" ownerActivity="notYetOpened" waiterActivity="waitForAllOwnersToOpen">
<owner-list>
<owner id="process6abc037468" />
</owner-list>
<waiter-list>
<waiter id="processbb3bb81c28" />
</waiter-list>
</exchangeEvent>
</resource-list>
</deadlock>
|
|
|
