question

Julian avatar image
Julian asked

SQL Server Deadlock

Hi

I have been trying to resolve this deadlock for a while now with no success.The users are opening multiple tabs where executing this task. The below deadlock trace is from the red gate tool

deadlock-list deadlock victim=process1bbb2527848 process-list process id=process1bbb2527848 taskpriority=0 logused=1960 waitresource=KEY: 15:72057739557339136 (d7f6d73c0dde) waittime=4696 ownerId=187047213 transactionguid=0xfcaf651c9b121d42a51a2b70fe695dea transactionname=user_transaction lasttranstarted=2019-10-14T13:28:46.673 XDES=0x1b1fcfa0420 lockMode=RangeI-N schedulerid=7 kpid=6444 status=suspended spid=295 sbid=2 ecid=0 priority=0 trancount=2 lastbatchstarted=2019-10-14T13:28:51.207 lastbatchcompleted=2019-10-14T13:28:51.203 lastattention=1900-01-01T00:00:00.203 isolationlevel=serializable (4) xactid=187047213 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056 executionStack frame procname=adhoc line=1 stmtstart=248 stmtend=1258 sqlhandle=0x020000004134de04324ea90259781aa68565de5ed013ea1f0000000000000000000000000000000000000000 unknown frame procname=unknown line=1 sqlhandle=0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 unknown inputbuf (@0 int,@1 int,@2 int,@3 int,@4 datetime2(7),@5 decimal(18,2),@6 int,@7 int,@8 varchar(100),@9 datetime2(7),@10 int,@11 int)INSERT [Finance].[PaymentSchedule]([fkEntityID], [C_EntityType], [fkPersonID], [C_PersonTypeCode], [DatePayable], [DatePaid], [Amount], [C_PaymentMethod], [C_PaymentStatus], [Reference], [CreateDate], [bRecon], [fkBankAccountID], [fkInstitutionAccountID], [fkCreateUserID], [fkReleaseUserID], [DateChanged], [fkUserChangedID], [fkParentID], [SplitPayment], [ProcInstID], [InitialAmount]) VALUES (@0, @1, @2, @3, @4, NULL, @5, @6, @7, @8, @9, NULL, @10, NULL, @11, NULL, NULL, NULL, NULL, NULL, NULL, NULL) SELECT [pkPaymentScheduleID], [VersionStamp] FROM [Finance].[PaymentSchedule] WHERE @@ROWCOUNT > 0 AND [pkPaymentScheduleID] = scope_identity() process id=process1b3aa6ff088 taskpriority=0 logused=19236 waitresource=KEY: 15:72057739557339136 (d7f6d73c0dde) waittime=1691 ownerId=187049365 transactionguid=0xa116e9ae50bd6545876d38775c0023d6 transactionname=user_transaction lasttranstarted=2019-10-14T13:28:48.977 XDES=0x1b27a314420 lockMode=RangeI-N schedulerid=9 kpid=8516 status=suspended spid=266 sbid=2 ecid=0 priority=0 trancount=2 lastbatchstarted=2019-10-14T13:28:54.210 lastbatchcompleted=2019-10-14T13:28:54.210 lastattention=1900-01-01T00:00:00.210 l isolationlevel=serializable (4) xactid=187049365 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056 executionStack frame procname=adhoc line=1 stmtstart=248 stmtend=1258 sqlhandle=0x020000004134de04324ea90259781aa68565de5ed013ea1f0000000000000000000000000000000000000000 unknown frame procname=unknown line=1 sqlhandle=0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 unknown inputbuf (@0 int,@1 int,@2 int,@3 int,@4 datetime2(7),@5 decimal(18,2),@6 int,@7 int,@8 varchar(100),@9 datetime2(7),@10 int,@11 int)INSERT [Finance].[PaymentSchedule]([fkEntityID], [C_EntityType], [fkPersonID], [C_PersonTypeCode], [DatePayable], [DatePaid], [Amount], [C_PaymentMethod], [C_PaymentStatus], [Reference], [CreateDate], [bRecon], [fkBankAccountID], [fkInstitutionAccountID], [fkCreateUserID], [fkReleaseUserID], [DateChanged], [fkUserChangedID], [fkParentID], [SplitPayment], [ProcInstID], [InitialAmount]) VALUES (@0, @1, @2, @3, @4, NULL, @5, @6, @7, @8, @9, NULL, @10, NULL, @11, NULL, NULL, NULL, NULL, NULL, NULL, NULL) SELECT [pkPaymentScheduleID], [VersionStamp] FROM [Finance].[PaymentSchedule] WHERE @@ROWCOUNT > 0 AND [pkPaymentScheduleID] = scope_identity() resource-list keylock hobtid=72057739557339136 dbid=15 objectname=Finance.PaymentSchedule indexname=IX_PaymentSchedule_fkEntityID_C_EntityType_pkPaymentScheduleID_fkPersonID_DatePayable_DatePaid_Amount_C_PaymentStatus id=lock1b37f82f580 mode=RangeS-S associatedObjectId=72057739557339136 owner-list owner id=process1b3aa6ff088 mode=RangeS-S owner id=process1b3aa6ff088 mode=RangeI-N requestType=convert waiter-list waiter id=process1bbb2527848 mode=RangeI-N requestType=convert keylock hobtid=72057739557339136 dbid=15 objectname=Finance.PaymentSchedule indexname=IX_PaymentSchedule_fkEntityID_C_EntityType_pkPaymentScheduleID_fkPersonID_DatePayable_DatePaid_Amount_C_PaymentStatus id=lock1b37f82f580 mode=RangeS-S associatedObjectId=72057739557339136 owner-list owner id=process1bbb2527848 mode=RangeS-S owner id=process1bbb2527848 mode=RangeI-N requestType=convert waiter-list waiter id=process1b3aa6ff088 mode=RangeI-N requestType=convert

deadlocksql server 2017
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.