Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

DeadLock Expand / Collapse
Author
Message
Posted Wednesday, April 29, 2009 1:36 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, October 8, 2010 12:31 AM
Points: 41, Visits: 107
Hi

I am getting below error:

Transaction (Process ID xxx) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction

I have given trace logs and table,SPs. When client application restarts due to power failure, all these 3 SPs are called from 200 clients.(server is supported with UPS).

All the SPs are trying to update,select(,insert) a single table at the same time.

Can you please help to sort this problem?


CREATE TABLE [dbo].[STB](
[STBId] [char](12) NOT NULL,
[IpAddress] [varchar](15) NULL,
[RestartTime] [datetime] NULL,
[RoomNo] [varchar](10) NULL,
[ImageVersion] [varchar](10) NULL,
[DeployImageVersion] [varchar](10) NULL,
[IpUpdated] [datetime] NULL,
[TVstate] [smallint] NULL,
[CurrentFeatureUsed] [int] NULL,
CONSTRAINT [PK_STB] PRIMARY KEY CLUSTERED
(
[STBId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]


-----

CREATE PROCEDURE [dbo].[QueryRoomNoFromSTBIP]
@STBId char(12) = null,
@IPAddress char(15) = null
AS
If @STBId is null or @IPAddress is NULL
return -1
If exists (select RoomNo from STB with(NOLOCK) where STBId = @STBId and IPAddress = @IPAddress)--STB-1 IP-1
Begin
--Update the Restart Time
update STB set RestartTime=getdate() where STBId = @STBId
select RoomNo from STB with(NOLOCK) where STBId = @STBId and IPAddress = @IPAddress
End
Else if exists (select RoomNo from STB with(NOLOCK) where STBId = @STBId)--STB-1 IP-0
Begin
if exists(select STBId from STB with(NOLOCK) where IPAddress = @IPAddress )--STB-Different IP-Yes
Begin
update STB set IPAddress = null, IPUpdated = getdate() where IPAddress = @IPAddress
End

update STB set IPAddress = @IPAddress, IPUpdated = getdate(), RestartTime=getdate() where STBId = @STBId
select RoomNo from STB with(NOLOCK) where STBId = @STBId and IPAddress = @IPAddress
End
Else --if not exists(select RoomNo from STB where STBId = @STBId)--STB-0
Begin
if exists(select STBId from STB with(NOLOCK) where IPAddress = @IPAddress)--STB-0 IP-1
Begin
update STB set IPAddress = null, IPUpdated = getdate() where IPAddress = @IPAddress
End
insert into [Config].[dbo].[STB]([STBId] ,[IpAddress],[IPUpdated],[RoomNo],[RestartTime])VALUES(@STBId,@IPAddress,getdate(),'',getdate())
End

------

CREATE Procedure [dbo].[UpdateImageVersion]
@STBId char(12),
@ImageVersion varchar(10)
as
UPDATE [Config].[dbo].[STB]
SET [ImageVersion] = @ImageVersion
,[DeployImageVersion] = null
WHERE STBId = @STBId

----

CREATE PROCEDURE [dbo].[HMSQueryGuestMessagesFromSTB]
@STBId char (12) = null
AS
Declare @RoomNo varchar(10)

If @STBId is null
return -1

select @RoomNo = RoomNo from STB with(NOLOCK) where STBId = @STBId

SELECT HMSGuestMessage.iTVMessageNo as MessageNo,
HMSGuestMessage.MessageText as Message_Text,
HMSGuestMessage.CurrentStatus as Current_Status
FROM HMSGuestMessage
INNER JOIN HMSRoomGuest ON HMSGuestMessage.GuestNo = HMSRoomGuest.GuestNo
INNER JOIN STB with(NOLOCK) ON HMSRoomGuest.RoomNo = STB.RoomNo
Where STB.STBId = @STBId and HMSGuestMessage.CurrentStatus <> -1 and HMSRoomGuest.Checkoutdate is null
order by HMSGuestMessage.CurrentStatus
-- Update Guest New Message Flag
if @RoomNo is not null
Begin
if exists ( select roomno from [Message].[dbo].[GuestMessage] where RoomNo = @RoomNo)
Update [Message].[dbo].[GuestMessage] set [GuestMsgFlag] = 0 where RoomNo = @RoomNo
else
Insert into [Message].[dbo].[GuestMessage] ([RoomNo] ,[Start] ,[End] ,[GuestMsgFlag])
Values ( @RoomNo, Null, Null, 0)
End


----


04/29/2009 10:05:59,spid27s,Unknown,waiter id=processa7ee38 mode=U requestType=wait
04/29/2009 10:05:59,spid27s,Unknown,waiter-list
04/29/2009 10:05:59,spid27s,Unknown,owner id=processa79b58 mode=X
04/29/2009 10:05:59,spid27s,Unknown,owner-list
04/29/2009 10:05:59,spid27s,Unknown,ridlock fileid=1 pageid=183 dbid=5 objectname=Config.dbo.STB id=lockb6bce80 mode=X associatedObjectId=72057594041663488
04/29/2009 10:05:59,spid27s,Unknown,waiter id=processa79b58 mode=U requestType=wait
04/29/2009 10:05:59,spid27s,Unknown,waiter-list
04/29/2009 10:05:59,spid27s,Unknown,owner id=processd25978 mode=X
04/29/2009 10:05:59,spid27s,Unknown,owner-list
04/29/2009 10:05:59,spid27s,Unknown,ridlock fileid=1 pageid=252 dbid=5 objectname=Config.dbo.STB id=lock9277e40 mode=X associatedObjectId=72057594041663488
04/29/2009 10:05:59,spid27s,Unknown,waiter id=processd25978 mode=U requestType=wait
04/29/2009 10:05:59,spid27s,Unknown,waiter-list
04/29/2009 10:05:59,spid27s,Unknown,owner id=processa79b58 mode=X
04/29/2009 10:05:59,spid27s,Unknown,owner-list
04/29/2009 10:05:59,spid27s,Unknown,ridlock fileid=1 pageid=608 dbid=5 objectname=Config.dbo.STB id=lock3f71dc0 mode=X associatedObjectId=72057594041663488
04/29/2009 10:05:59,spid27s,Unknown,resource-list
04/29/2009 10:05:59,spid27s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]
04/29/2009 10:05:59,spid27s,Unknown,inputbuf
04/29/2009 10:05:59,spid27s,Unknown,--commit transaction
04/29/2009 10:05:59,spid27s,Unknown,WHERE STBId = @STBId
04/29/2009 10:05:59,spid27s,Unknown,[DeployImageVersion] = null
04/29/2009 10:05:59,spid27s,Unknown,SET [ImageVersion] = @ImageVersion
04/29/2009 10:05:59,spid27s,Unknown,UPDATE [Config].[dbo].[STB]
04/29/2009 10:05:59,spid27s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b00000100000000000000
04/29/2009 10:05:59,spid27s,Unknown,executionStack
04/29/2009 10:05:59,spid27s,Unknown,process id=processd25978 taskpriority=0 logused=84 waitresource=RID: 5:1:608:1 waittime=4609 ownerId=15507515 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:54.903 XDES=0x46cd0250 lockMode=U schedulerid=4 kpid=5180 status=suspended spid=61 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:54.903 lastbatchcompleted=2009-04-29T10:05:54.903 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15507515 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
04/29/2009 10:05:59,spid27s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]
04/29/2009 10:05:59,spid27s,Unknown,inputbuf
04/29/2009 10:05:59,spid27s,Unknown,--commit transaction
04/29/2009 10:05:59,spid27s,Unknown,WHERE STBId = @STBId
04/29/2009 10:05:59,spid27s,Unknown,[DeployImageVersion] = null
04/29/2009 10:05:59,spid27s,Unknown,SET [ImageVersion] = @ImageVersion
04/29/2009 10:05:59,spid27s,Unknown,UPDATE [Config].[dbo].[STB]
04/29/2009 10:05:59,spid27s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b00000100000000000000
04/29/2009 10:05:59,spid27s,Unknown,executionStack
04/29/2009 10:05:59,spid27s,Unknown,process id=processa7ee38 taskpriority=0 logused=0 waitresource=RID: 5:1:183:22 waittime=4609 ownerId=15507533 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:54.920 XDES=0x19990250 lockMode=U schedulerid=3 kpid=1892 status=suspended spid=63 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:54.920 lastbatchcompleted=2009-04-29T10:05:54.920 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15507533 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
04/29/2009 10:05:59,spid27s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]
04/29/2009 10:05:59,spid27s,Unknown,inputbuf
04/29/2009 10:05:59,spid27s,Unknown,--commit transaction
04/29/2009 10:05:59,spid27s,Unknown,WHERE STBId = @STBId
04/29/2009 10:05:59,spid27s,Unknown,[DeployImageVersion] = null
04/29/2009 10:05:59,spid27s,Unknown,SET [ImageVersion] = @ImageVersion
04/29/2009 10:05:59,spid27s,Unknown,UPDATE [Config].[dbo].[STB]
04/29/2009 10:05:59,spid27s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b00000100000000000000
04/29/2009 10:05:59,spid27s,Unknown,executionStack
04/29/2009 10:05:59,spid27s,Unknown,process id=processa79b58 taskpriority=0 logused=84 waitresource=RID: 5:1:252:35 waittime=4609 ownerId=15507517 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:54.920 XDES=0x463d378 lockMode=U schedulerid=2 kpid=2752 status=suspended spid=60 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:54.920 lastbatchcompleted=2009-04-29T10:05:54.903 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15507517 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
04/29/2009 10:05:59,spid27s,Unknown,process-list
04/29/2009 10:05:59,spid27s,Unknown,deadlock victim=processd25978
04/29/2009 10:05:59,spid27s,Unknown,deadlock-list
04/29/2009 10:05:43,spid22s,Unknown,waiter id=processa7fa68 mode=U requestType=wait
04/29/2009 10:05:43,spid22s,Unknown,waiter-list
04/29/2009 10:05:43,spid22s,Unknown,owner id=processa78c58 mode=X
04/29/2009 10:05:43,spid22s,Unknown,owner-list
04/29/2009 10:05:43,spid22s,Unknown,ridlock fileid=1 pageid=608 dbid=5 objectname=Config.dbo.STB id=lock92d96c0 mode=X associatedObjectId=72057594041663488
04/29/2009 10:05:43,spid22s,Unknown,waiter id=processa78c58 mode=U requestType=wait
04/29/2009 10:05:43,spid22s,Unknown,waiter-list
04/29/2009 10:05:43,spid22s,Unknown,owner id=processa7fa68 mode=X
04/29/2009 10:05:43,spid22s,Unknown,owner-list
04/29/2009 10:05:43,spid22s,Unknown,ridlock fileid=1 pageid=183 dbid=5 objectname=Config.dbo.STB id=lock3f71d40 mode=X associatedObjectId=72057594041663488
04/29/2009 10:05:43,spid22s,Unknown,waiter id=processd253d8 mode=U requestType=wait
04/29/2009 10:05:43,spid22s,Unknown,waiter-list
04/29/2009 10:05:43,spid22s,Unknown,owner id=processa78c58 mode=X
04/29/2009 10:05:43,spid22s,Unknown,owner-list
04/29/2009 10:05:43,spid22s,Unknown,ridlock fileid=1 pageid=183 dbid=5 objectname=Config.dbo.STB id=lock3f6a2c0 mode=X associatedObjectId=72057594041663488
04/29/2009 10:05:43,spid22s,Unknown,resource-list
04/29/2009 10:05:43,spid22s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]
04/29/2009 10:05:43,spid22s,Unknown,inputbuf
04/29/2009 10:05:43,spid22s,Unknown,--commit transaction
04/29/2009 10:05:43,spid22s,Unknown,WHERE STBId = @STBId
04/29/2009 10:05:43,spid22s,Unknown,[DeployImageVersion] = null
04/29/2009 10:05:43,spid22s,Unknown,SET [ImageVersion] = @ImageVersion
04/29/2009 10:05:43,spid22s,Unknown,UPDATE [Config].[dbo].[STB]
04/29/2009 10:05:43,spid22s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b00000100000000000000
04/29/2009 10:05:43,spid22s,Unknown,executionStack
04/29/2009 10:05:43,spid22s,Unknown,process id=processd253d8 taskpriority=0 logused=0 waitresource=RID: 5:1:183:22 waittime=4781 ownerId=15485964 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:33.030 XDES=0x450d8250 lockMode=U schedulerid=4 kpid=7268 status=suspended spid=119 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:33.030 lastbatchcompleted=2009-04-29T10:05:33.030 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15485964 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
04/29/2009 10:05:43,spid22s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]
04/29/2009 10:05:43,spid22s,Unknown,inputbuf
04/29/2009 10:05:43,spid22s,Unknown,--commit transaction
04/29/2009 10:05:43,spid22s,Unknown,WHERE STBId = @STBId
04/29/2009 10:05:43,spid22s,Unknown,[DeployImageVersion] = null
04/29/2009 10:05:43,spid22s,Unknown,SET [ImageVersion] = @ImageVersion
04/29/2009 10:05:43,spid22s,Unknown,UPDATE [Config].[dbo].[STB]
04/29/2009 10:05:43,spid22s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b00000100000000000000
04/29/2009 10:05:43,spid22s,Unknown,executionStack
04/29/2009 10:05:43,spid22s,Unknown,process id=processa7fa68 taskpriority=0 logused=84 waitresource=RID: 5:1:608:1 waittime=156 ownerId=15485766 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:32.997 XDES=0x46465b58 lockMode=U schedulerid=3 kpid=4280 status=suspended spid=144 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:32.997 lastbatchcompleted=2009-04-29T10:05:32.997 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15485766 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
04/29/2009 10:05:43,spid22s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]
04/29/2009 10:05:43,spid22s,Unknown,inputbuf
04/29/2009 10:05:43,spid22s,Unknown,--commit transaction
04/29/2009 10:05:43,spid22s,Unknown,WHERE STBId = @STBId
04/29/2009 10:05:43,spid22s,Unknown,[DeployImageVersion] = null
04/29/2009 10:05:43,spid22s,Unknown,SET [ImageVersion] = @ImageVersion
04/29/2009 10:05:43,spid22s,Unknown,UPDATE [Config].[dbo].[STB]
04/29/2009 10:05:43,spid22s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b00000100000000000000
04/29/2009 10:05:43,spid22s,Unknown,executionStack
04/29/2009 10:05:43,spid22s,Unknown,process id=processa78c58 taskpriority=0 logused=84 waitresource=RID: 5:1:183:84 waittime=4765 ownerId=15485915 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:33.030 XDES=0x47881b10 lockMode=U schedulerid=2 kpid=10208 status=suspended spid=117 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:33.030 lastbatchcompleted=2009-04-29T10:05:33.030 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15485915 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
04/29/2009 10:05:43,spid22s,Unknown,process-list
04/29/2009 10:05:43,spid22s,Unknown,deadlock victim=processa7fa68
04/29/2009 10:05:43,spid22s,Unknown,deadlock-list
04/29/2009 10:05:42,spid16s,Unknown,waiter id=processa7fa68 mode=U requestType=wait
04/29/2009 10:05:42,spid16s,Unknown,waiter-list
04/29/2009 10:05:42,spid16s,Unknown,owner id=processa7ed48 mode=X
04/29/2009 10:05:42,spid16s,Unknown,owner-list
04/29/2009 10:05:42,spid16s,Unknown,ridlock fileid=1 pageid=252 dbid=5 objectname=Config.dbo.STB id=lock3f74800 mode=X associatedObjectId=72057594041663488
04/29/2009 10:05:42,spid16s,Unknown,waiter id=processa7ed48 mode=U requestType=wait
04/29/2009 10:05:42,spid16s,Unknown,waiter-list
04/29/2009 10:05:42,spid16s,Unknown,owner id=processa78c58 mode=X
04/29/2009 10:05:42,spid16s,Unknown,owner-list
04/29/2009 10:05:42,spid16s,Unknown,ridlock fileid=1 pageid=608 dbid=5 objectname=Config.dbo.STB id=lock92d96c0 mode=X associatedObjectId=72057594041663488
04/29/2009 10:05:42,spid16s,Unknown,waiter id=processa78c58 mode=U requestType=wait
04/29/2009 10:05:42,spid16s,Unknown,waiter-list
04/29/2009 10:05:42,spid16s,Unknown,owner id=processa7fa68 mode=X
04/29/2009 10:05:42,spid16s,Unknown,owner-list
04/29/2009 10:05:42,spid16s,Unknown,ridlock fileid=1 pageid=183 dbid=5 objectname=Config.dbo.STB id=lock3f71d40 mode=X associatedObjectId=72057594041663488
04/29/2009 10:05:42,spid16s,Unknown,waiter id=processd253d8 mode=U requestType=wait
04/29/2009 10:05:42,spid16s,Unknown,waiter-list
04/29/2009 10:05:42,spid16s,Unknown,owner id=processa78c58 mode=X
04/29/2009 10:05:42,spid16s,Unknown,owner-list
04/29/2009 10:05:42,spid16s,Unknown,ridlock fileid=1 pageid=183 dbid=5 objectname=Config.dbo.STB id=lock3f6a2c0 mode=X associatedObjectId=72057594041663488
04/29/2009 10:05:42,spid16s,Unknown,resource-list
04/29/2009 10:05:42,spid16s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]
04/29/2009 10:05:42,spid16s,Unknown,inputbuf
04/29/2009 10:05:42,spid16s,Unknown,--commit transaction
04/29/2009 10:05:42,spid16s,Unknown,WHERE STBId = @STBId
04/29/2009 10:05:42,spid16s,Unknown,[DeployImageVersion] = null
04/29/2009 10:05:42,spid16s,Unknown,SET [ImageVersion] = @ImageVersion
04/29/2009 10:05:42,spid16s,Unknown,UPDATE [Config].[dbo].[STB]
04/29/2009 10:05:42,spid16s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b00000100000000000000
04/29/2009 10:05:42,spid16s,Unknown,executionStack
04/29/2009 10:05:42,spid16s,Unknown,process id=processd253d8 taskpriority=0 logused=0 waitresource=RID: 5:1:183:22 waittime=4625 ownerId=15485964 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:33.030 XDES=0x450d8250 lockMode=U schedulerid=4 kpid=7268 status=suspended spid=119 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:33.030 lastbatchcompleted=2009-04-29T10:05:33.030 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15485964 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
04/29/2009 10:05:42,spid16s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]
04/29/2009 10:05:42,spid16s,Unknown,inputbuf
04/29/2009 10:05:42,spid16s,Unknown,--commit transaction
04/29/2009 10:05:42,spid16s,Unknown,WHERE STBId = @STBId
04/29/2009 10:05:42,spid16s,Unknown,[DeployImageVersion] = null
04/29/2009 10:05:42,spid16s,Unknown,SET [ImageVersion] = @ImageVersion
04/29/2009 10:05:42,spid16s,Unknown,UPDATE [Config].[dbo].[STB]
04/29/2009 10:05:42,spid16s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b00000100000000000000
04/29/2009 10:05:42,spid16s,Unknown,executionStack
04/29/2009 10:05:42,spid16s,Unknown,process id=processa7fa68 taskpriority=0 logused=84 waitresource=RID: 5:1:252:40 waittime=4609 ownerId=15485766 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:32.997 XDES=0x46465b58 lockMode=U schedulerid=3 kpid=4280 status=suspended spid=144 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:32.997 lastbatchcompleted=2009-04-29T10:05:32.997 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15485766 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
04/29/2009 10:05:42,spid16s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]
04/29/2009 10:05:42,spid16s,Unknown,inputbuf
04/29/2009 10:05:42,spid16s,Unknown,--commit transaction
04/29/2009 10:05:42,spid16s,Unknown,WHERE STBId = @STBId
04/29/2009 10:05:42,spid16s,Unknown,[DeployImageVersion] = null
04/29/2009 10:05:42,spid16s,Unknown,SET [ImageVersion] = @ImageVersion
04/29/2009 10:05:42,spid16s,Unknown,UPDATE [Config].[dbo].[STB]
04/29/2009 10:05:42,spid16s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b00000100000000000000
04/29/2009 10:05:42,spid16s,Unknown,executionStack
04/29/2009 10:05:42,spid16s,Unknown,process id=processa7ed48 taskpriority=0 logused=84 waitresource=RID: 5:1:608:1 waittime=4609 ownerId=15485653 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:32.980 XDES=0x464646d0 lockMode=U schedulerid=3 kpid=5580 status=suspended spid=143 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:32.980 lastbatchcompleted=2009-04-29T10:05:32.980 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15485653 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
04/29/2009 10:05:42,spid16s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]
04/29/2009 10:05:42,spid16s,Unknown,inputbuf
04/29/2009 10:05:42,spid16s,Unknown,--commit transaction
04/29/2009 10:05:42,spid16s,Unknown,WHERE STBId = @STBId
04/29/2009 10:05:42,spid16s,Unknown,[DeployImageVersion] = null
04/29/2009 10:05:42,spid16s,Unknown,SET [ImageVersion] = @ImageVersion
04/29/2009 10:05:42,spid16s,Unknown,UPDATE [Config].[dbo].[STB]
04/29/2009 10:05:42,spid16s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b00000100000000000000
04/29/2009 10:05:42,spid16s,Unknown,executionStack
04/29/2009 10:05:42,spid16s,Unknown,process id=processa78c58 taskpriority=0 logused=84 waitresource=RID: 5:1:183:84 waittime=4609 ownerId=15485915 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:33.030 XDES=0x47881b10 lockMode=U schedulerid=2 kpid=10208 status=suspended spid=117 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:33.030 lastbatchcompleted=2009-04-29T10:05:33.030 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15485915 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
04/29/2009 10:05:42,spid16s,Unknown,process-list
04/29/2009 10:05:42,spid16s,Unknown,deadlock victim=processa7ed48
04/29/2009 10:05:42,spid16s,Unknown,deadlock-list
04/29/2009 10:05:42,spid14s,Unknown,waiter id=processa7fa68 mode=U requestType=wait
04/29/2009 10:05:42,spid14s,Unknown,waiter-list
04/29/2009 10:05:42,spid14s,Unknown,owner id=processa7ed48 mode=X
04/29/2009 10:05:42,spid14s,Unknown,owner-list
04/29/2009 10:05:42,spid14s,Unknown,ridlock fileid=1 pageid=252 dbid=5 objectname=Config.dbo.STB id=lock3f74800 mode=X associatedObjectId=72057594041663488
04/29/2009 10:05:42,spid14s,Unknown,waiter id=processa7ed48 mode=U requestType=wait
04/29/2009 10:05:42,spid14s,Unknown,waiter-list
04/29/2009 10:05:42,spid14s,Unknown,owner id=processa78c58 mode=X
04/29/2009 10:05:42,spid14s,Unknown,owner-list
04/29/2009 10:05:42,spid14s,Unknown,ridlock fileid=1 pageid=608 dbid=5 objectname=Config.dbo.STB id=lock92d96c0 mode=X associatedObjectId=72057594041663488
04/29/2009 10:05:42,spid14s,Unknown,waiter id=processa78c58 mode=U requestType=wait
04/29/2009 10:05:42,spid14s,Unknown,waiter id=process9ea5c8 mode=U requestType=wait
04/29/2009 10:05:42,spid14s,Unknown,waiter-list
04/29/2009 10:05:42,spid14s,Unknown,owner id=processa7fa68 mode=X
04/29/2009 10:05:42,spid14s,Unknown,owner-list
04/29/2009 10:05:42,spid14s,Unknown,ridlock fileid=1 pageid=183 dbid=5 objectname=Config.dbo.STB id=lock3f71d40 mode=X associatedObjectId=72057594041663488
04/29/2009 10:05:42,spid14s,Unknown,waiter id=processd253d8 mode=U requestType=wait
04/29/2009 10:05:42,spid14s,Unknown,waiter-list
04/29/2009 10:05:42,spid14s,Unknown,owner id=processa78c58 mode=X
04/29/2009 10:05:42,spid14s,Unknown,owner-list
04/29/2009 10:05:42,spid14s,Unknown,ridlock fileid=1 pageid=183 dbid=5 objectname=Config.dbo.STB id=lock3f6a2c0 mode=X associatedObjectId=72057594041663488
04/29/2009 10:05:42,spid14s,Unknown,resource-list
04/29/2009 10:05:42,spid14s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]
04/29/2009 10:05:42,spid14s,Unknown,inputbuf
04/29/2009 10:05:42,spid14s,Unknown,--commit transaction
04/29/2009 10:05:42,spid14s,Unknown,WHERE STBId = @STBId
04/29/2009 10:05:42,spid14s,Unknown,[DeployImageVersion] = null
04/29/2009 10:05:42,spid14s,Unknown,SET [ImageVersion] = @ImageVersion
04/29/2009 10:05:42,spid14s,Unknown,UPDATE [Config].[dbo].[STB]
04/29/2009 10:05:42,spid14s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b00000100000000000000
04/29/2009 10:05:42,spid14s,Unknown,executionStack
04/29/2009 10:05:42,spid14s,Unknown,process id=processd253d8 taskpriority=0 logused=0 waitresource=RID: 5:1:183:22 waittime=4312 ownerId=15485964 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:33.030 XDES=0x450d8250 lockMode=U schedulerid=4 kpid=7268 status=suspended spid=119 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:33.030 lastbatchcompleted=2009-04-29T10:05:33.030 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15485964 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
04/29/2009 10:05:42,spid27s,Unknown,waiter id=processa7fa68 mode=U requestType=wait
04/29/2009 10:05:42,spid27s,Unknown,waiter-list
04/29/2009 10:05:42,spid27s,Unknown,owner id=processa7ed48 mode=X
04/29/2009 10:05:42,spid14s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]
04/29/2009 10:05:42,spid27s,Unknown,owner-list
04/29/2009 10:05:42,spid27s,Unknown,ridlock fileid=1 pageid=252 dbid=5 objectname=Config.dbo.STB id=lock3f74800 mode=X associatedObjectId=72057594041663488
04/29/2009 10:05:42,spid14s,Unknown,inputbuf
04/29/2009 10:05:42,spid14s,Unknown,--commit transaction
04/29/2009 10:05:42,spid14s,Unknown,WHERE STBId = @STBId
04/29/2009 10:05:42,spid27s,Unknown,waiter id=processa7ed48 mode=U requestType=wait
04/29/2009 10:05:42,spid14s,Unknown,[DeployImageVersion] = null
04/29/2009 10:05:42,spid27s,Unknown,waiter-list
04/29/2009 10:05:42,spid14s,Unknown,SET [ImageVersion] = @ImageVersion
04/29/2009 10:05:42,spid27s,Unknown,owner id=processa78c58 mode=X
04/29/2009 10:05:42,spid14s,Unknown,UPDATE [Config].[dbo].[STB]
04/29/2009 10:05:42,spid27s,Unknown,owner-list
04/29/2009 10:05:42,spid14s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b00000100000000000000
04/29/2009 10:05:42,spid27s,Unknown,ridlock fileid=1 pageid=608 dbid=5 objectname=Config.dbo.STB id=lock92d96c0 mode=X associatedObjectId=72057594041663488
04/29/2009 10:05:42,spid14s,Unknown,executionStack
04/29/2009 10:05:42,spid27s,Unknown,waiter id=processa78c58 mode=U requestType=wait
04/29/2009 10:05:42,spid14s,Unknown,process id=processa7fa68 taskpriority=0 logused=84 waitresource=RID: 5:1:252:40 waittime=4296 ownerId=15485766 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:32.997 XDES=0x46465b58 lockMode=U schedulerid=3 kpid=4280 status=suspended spid=144 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:32.997 lastbatchcompleted=2009-04-29T10:05:32.997 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15485766 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
04/29/2009 10:05:42,spid27s,Unknown,waiter id=process9ea988 mode=U requestType=wait
04/29/2009 10:05:42,spid27s,Unknown,waiter-list
04/29/2009 10:05:42,spid27s,Unknown,owner id=processa7fa68 mode=X
04/29/2009 10:05:42,spid27s,Unknown,owner-list
04/29/2009 10:05:42,spid27s,Unknown,ridlock fileid=1 pageid=183 dbid=5 objectname=Config.dbo.STB id=lock3f71d40 mode=X associatedObjectId=72057594041663488
04/29/2009 10:05:42,spid27s,Unknown,resource-list
04/29/2009 10:05:42,spid27s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]
04/29/2009 10:05:42,spid14s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]
04/29/2009 10:05:42,spid27s,Unknown,inputbuf
04/29/2009 10:05:42,spid14s,Unknown,inputbuf
04/29/2009 10:05:42,spid27s,Unknown,--commit transaction
04/29/2009 10:05:42,spid14s,Unknown,--commit transaction
04/29/2009 10:05:42,spid27s,Unknown,WHERE STBId = @STBId
04/29/2009 10:05:42,spid14s,Unknown,WHERE STBId = @STBId
04/29/2009 10:05:42,spid27s,Unknown,[DeployImageVersion] = null
04/29/2009 10:05:42,spid14s,Unknown,[DeployImageVersion] = null
04/29/2009 10:05:42,spid27s,Unknown,SET [ImageVersion] = @ImageVersion
04/29/2009 10:05:42,spid14s,Unknown,SET [ImageVersion] = @ImageVersion
04/29/2009 10:05:42,spid27s,Unknown,UPDATE [Config].[dbo].[STB]
04/29/2009 10:05:42,spid14s,Unknown,UPDATE [Config].[dbo].[STB]
04/29/2009 10:05:42,spid27s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b00000100000000000000
04/29/2009 10:05:42,spid14s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b00000100000000000000
04/29/2009 10:05:42,spid27s,Unknown,executionStack
04/29/2009 10:05:42,spid14s,Unknown,executionStack
04/29/2009 10:05:42,spid27s,Unknown,process id=processa7fa68 taskpriority=0 logused=84 waitresource=RID: 5:1:252:40 waittime=4296 ownerId=15485766 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:32.997 XDES=0x46465b58 lockMode=U schedulerid=3 kpid=4280 status=suspended spid=144 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:32.997 lastbatchcompleted=2009-04-29T10:05:32.997 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15485766 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
04/29/2009 10:05:42,spid14s,Unknown,process id=processa7ed48 taskpriority=0 logused=84 waitresource=RID: 5:1:608:1 waittime=4296 ownerId=15485653 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:32.980 XDES=0x464646d0 lockMode=U schedulerid=3 kpid=5580 status=suspended spid=143 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:32.980 lastbatchcompleted=2009-04-29T10:05:32.980 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15485653 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
04/29/2009 10:05:42,spid27s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]
04/29/2009 10:05:42,spid14s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]
04/29/2009 10:05:42,spid27s,Unknown,inputbuf
04/29/2009 10:05:42,spid27s,Unknown,--commit transaction
04/29/2009 10:05:42,spid14s,Unknown,inputbuf
04/29/2009 10:05:42,spid27s,Unknown,WHERE STBId = @STBId
04/29/2009 10:05:42,spid14s,Unknown,--commit transaction
04/29/2009 10:05:42,spid14s,Unknown,WHERE STBId = @STBId
04/29/2009 10:05:42,spid14s,Unknown,[DeployImageVersion] = null
04/29/2009 10:05:42,spid27s,Unknown,[DeployImageVersion] = null
04/29/2009 10:05:42,spid27s,Unknown,SET [ImageVersion] = @ImageVersion
04/29/2009 10:05:42,spid27s,Unknown,UPDATE [Config].[dbo].[STB]
04/29/2009 10:05:42,spid27s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b00000100000000000000
04/29/2009 10:05:42,spid14s,Unknown,SET [ImageVersion] = @ImageVersion
04/29/2009 10:05:42,spid27s,Unknown,executionStack
04/29/2009 10:05:42,spid14s,Unknown,UPDATE [Config].[dbo].[STB]
04/29/2009 10:05:42,spid27s,Unknown,process id=processa7ed48 taskpriority=0 logused=84 waitresource=RID: 5:1:608:1 waittime=4296 ownerId=15485653 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:32.980 XDES=0x464646d0 lockMode=U schedulerid=3 kpid=5580 status=suspended spid=143 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:32.980 lastbatchcompleted=2009-04-29T10:05:32.980 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15485653 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
04/29/2009 10:05:42,spid14s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b00000100000000000000
04/29/2009 10:05:42,spid14s,Unknown,executionStack
04/29/2009 10:05:42,spid14s,Unknown,process id=processa78c58 taskpriority=0 logused=84 waitresource=RID: 5:1:183:84 waittime=4296 ownerId=15485915 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:33.030 XDES=0x47881b10 lockMode=U schedulerid=2 kpid=10208 status=suspended spid=117 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:33.030 lastbatchcompleted=2009-04-29T10:05:33.030 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15485915 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
04/29/2009 10:05:42,spid27s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]
04/29/2009 10:05:42,spid27s,Unknown,inputbuf
04/29/2009 10:05:42,spid27s,Unknown,--commit transaction
04/29/2009 10:05:42,spid27s,Unknown,WHERE STBId = @STBId
04/29/2009 10:05:42,spid27s,Unknown,[DeployImageVersion] = null
04/29/2009 10:05:42,spid14s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]
04/29/2009 10:05:42,spid27s,Unknown,SET [ImageVersion] = @ImageVersion
04/29/2009 10:05:42,spid14s,Unknown,inputbuf
04/29/2009 10:05:42,spid14s,Unknown,--commit transaction
04/29/2009 10:05:42,spid27s,Unknown,UPDATE [Config].[dbo].[STB]
04/29/2009 10:05:42,spid14s,Unknown,WHERE STBId = @STBId
04/29/2009 10:05:42,spid27s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b00000100000000000000
04/29/2009 10:05:42,spid14s,Unknown,[DeployImageVersion] = null
04/29/2009 10:05:42,spid14s,Unknown,SET [ImageVersion] = @ImageVersion
04/29/2009 10:05:42,spid27s,Unknown,executionStack
04/29/2009 10:05:42,spid14s,Unknown,UPDATE [Config].[dbo].[STB]
04/29/2009 10:05:42,spid27s,Unknown,process id=processa78c58 taskpriority=0 logused=84 waitresource=RID: 5:1:183:84 waittime=4296 ownerId=15485915 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:33.030 XDES=0x47881b10 lockMode=U schedulerid=2 kpid=10208 status=suspended spid=117 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:33.030 lastbatchcompleted=2009-04-29T10:05:33.030 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15485915 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
04/29/2009 10:05:42,spid14s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b00000100000000000000
04/29/2009 10:05:42,spid14s,Unknown,executionStack
04/29/2009 10:05:42,spid14s,Unknown,process id=process9ea5c8 taskpriority=0 logused=0 waitresource=RID: 5:1:183:84 waittime=4296 ownerId=15485909 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:33.030 XDES=0x447ec250 lockMode=U schedulerid=1 kpid=5684 status=suspended spid=151 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:33.030 lastbatchcompleted=2009-04-29T10:05:33.013 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15485909 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
04/29/2009 10:05:42,spid27s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]
04/29/2009 10:05:42,spid27s,Unknown,inputbuf
04/29/2009 10:05:42,spid27s,Unknown,--commit transaction
04/29/2009 10:05:42,spid27s,Unknown,WHERE STBId = @STBId
04/29/2009 10:05:42,spid14s,Unknown,process-list
04/29/2009 10:05:42,spid27s,Unknown,[DeployImageVersion] = null
04/29/2009 10:05:42,spid14s,Unknown,deadlock victim=process9ea5c8
04/29/2009 10:05:42,spid27s,Unknown,SET [ImageVersion] = @ImageVersion
04/29/2009 10:05:42,spid14s,Unknown,deadlock-list
04/29/2009 10:05:42,spid27s,Unknown,UPDATE [Config].[dbo].[STB]
04/29/2009 10:05:42,spid27s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b00000100000000000000
04/29/2009 10:05:42,spid27s,Unknown,executionStack
04/29/2009 10:05:42,spid27s,Unknown,process id=process9ea988 taskpriority=0 logused=0 waitresource=RID: 5:1:183:84 waittime=4296 ownerId=15485894 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:33.030 XDES=0x45f6d5b8 lockMode=U schedulerid=1 kpid=9360 status=suspended spid=149 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:33.030 lastbatchcompleted=2009-04-29T10:05:33.013 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15485894 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
04/29/2009 10:05:42,spid27s,Unknown,process-list
04/29/2009 10:05:42,spid27s,Unknown,deadlock victim=process9ea988
04/29/2009 10:05:42,spid27s,Unknown,deadlock-list
04/29/2009 10:05:41,spid20s,Unknown,waiter id=processa7fa68 mode=U requestType=wait
04/29/2009 10:05:41,spid20s,Unknown,waiter-list
04/29/2009 10:05:41,spid20s,Unknown,owner id=processa7ed48 mode=X
04/29/2009 10:05:41,spid20s,Unknown,owner-list
04/29/2009 10:05:41,spid20s,Unknown,ridlock fileid=1 pageid=252 dbid=5 objectname=Config.dbo.STB id=lock3f74800 mode=X associatedObjectId=72057594041663488
04/29/2009 10:05:41,spid20s,Unknown,waiter id=processa7ed48 mode=U requestType=wait
04/29/2009 10:05:41,spid20s,Unknown,waiter-list
04/29/2009 10:05:41,spid20s,Unknown,owner id=processa78c58 mode=X
04/29/2009 10:05:41,spid20s,Unknown,owner-list
04/29/2009 10:05:41,spid20s,Unknown,ridlock fileid=1 pageid=608 dbid=5 objectname=Config.dbo.STB id=lock92d96c0 mode=X associatedObjectId=72057594041663488
04/29/2009 10:05:41,spid20s,Unknown,waiter id=processa78c58 mode=U requestType=wait
04/29/2009 10:05:41,spid20s,Unknown,waiter id=processa7ef28 mode=U requestType=wait
04/29/2009 10:05:41,spid23s,Unknown,waiter id=processa7fa68 mode=U requestType=wait
04/29/2009 10:05:41,spid20s,Unknown,waiter-list
04/29/2009 10:05:41,spid23s,Unknown,waiter-list
04/29/2009 10:05:41,spid20s,Unknown,owner id=processa7fa68 mode=X
04/29/2009 10:05:41,spid23s,Unknown,owner id=processa7ed48 mode=X
04/29/2009 10:05:41,spid20s,Unknown,owner-list
04/29/2009 10:05:41,spid23s,Unknown,owner-list
04/29/2009 10:05:41,spid20s,Unknown,ridlock fileid=1 pageid=183 dbid=5 objectname=Config.dbo.STB id=lock3f71d40 mode=X associatedObjectId=72057594041663488
04/29/2009 10:05:41,spid23s,Unknown,ridlock fileid=1 pageid=252 dbid=5 objectname=Config.dbo.STB id=lock3f74800 mode=X associatedObjectId=72057594041663488
04/29/2009 10:05:41,spid20s,Unknown,resource-list
04/29/2009 10:05:41,spid23s,Unknown,waiter id=processa7ed48 mode=U requestType=wait
04/29/2009 10:05:41,spid20s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]
04/29/2009 10:05:41,spid23s,Unknown,waiter-list
04/29/2009 10:05:41,spid20s,Unknown,inputbuf
04/29/2009 10:05:41,spid23s,Unknown,owner id=processa78c58 mode=X
04/29/2009 10:05:41,spid20s,Unknown,--commit transaction
04/29/2009 10:05:41,spid20s,Unknown,WHERE STBId = @STBId
04/29/2009 10:05:41,spid23s,Unknown,owner-list
04/29/2009 10:05:41,spid20s,Unknown,[DeployImageVersion] = null
04/29/2009 10:05:41,spid23s,Unknown,ridlock fileid=1 pageid=608 dbid=5 objectname=Config.dbo.STB id=lock92d96c0 mode=X associatedObjectId=72057594041663488
04/29/2009 10:05:41,spid20s,Unknown,SET [ImageVersion] = @ImageVersion
04/29/2009 10:05:41,spid20s,Unknown,UPDATE [Config].[dbo].[STB]
04/29/2009 10:05:41,spid20s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b00000100000000000000
04/29/2009 10:05:41,spid23s,Unknown,waiter id=processa78c58 mode=U requestType=wait
04/29/2009 10:05:41,spid23s,Unknown,waiter id=process9eb018 mode=U requestType=wait
04/29/2009 10:05:41,spid20s,Unknown,executionStack
04/29/2009 10:05:41,spid23s,Unknown,waiter-list
04/29/2009 10:05:41,spid20s,Unknown,process id=processa7fa68 taskpriority=0 logused=84 waitresource=RID: 5:1:252:40 waittime=3671 ownerId=15485766 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:32.997 XDES=0x46465b58 lockMode=U schedulerid=3 kpid=4280 status=suspended spid=144 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:32.997 lastbatchcompleted=2009-04-29T10:05:32.997 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15485766 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
04/29/2009 10:05:41,spid23s,Unknown,owner id=processa7fa68 mode=X
04/29/2009 10:05:41,spid23s,Unknown,owner-list
04/29/2009 10:05:41,spid23s,Unknown,ridlock fileid=1 pageid=183 dbid=5 objectname=Config.dbo.STB id=lock3f71d40 mode=X associatedObjectId=72057594041663488
04/29/2009 10:05:41,spid23s,Unknown,resource-list
04/29/2009 10:05:41,spid23s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]
04/29/2009 10:05:41,spid23s,Unknown,inputbuf
04/29/2009 10:05:41,spid23s,Unknown,--commit transaction
04/29/2009 10:05:41,spid23s,Unknown,WHERE STBId = @STBId
04/29/2009 10:05:41,spid20s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]
04/29/2009 10:05:41,spid23s,Unknown,[DeployImageVersion] = null
04/29/2009 10:05:41,spid23s,Unknown,SET [ImageVersion] = @ImageVersion
04/29/2009 10:05:41,spid20s,Unknown,inputbuf
04/29/2009 10:05:41,spid23s,Unknown,UPDATE [Config].[dbo].[STB]
04/29/2009 10:05:41,spid20s,Unknown,--commit transaction
04/29/2009 10:05:41,spid23s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b00000100000000000000
04/29/2009 10:05:41,spid20s,Unknown,WHERE STBId = @STBId
04/29/2009 10:05:41,spid20s,Unknown,[DeployImageVersion] = null
04/29/2009 10:05:41,spid23s,Unknown,executionStack
04/29/2009 10:05:41,spid20s,Unknown,SET [ImageVersion] = @ImageVersion
04/29/2009 10:05:41,spid23s,Unknown,process id=processa7fa68 taskpriority=0 logused=84 waitresource=RID: 5:1:252:40 waittime=3671 ownerId=15485766 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:32.997 XDES=0x46465b58 lockMode=U schedulerid=3 kpid=4280 status=suspended spid=144 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:32.997 lastbatchcompleted=2009-04-29T10:05:32.997 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15485766 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
04/29/2009 10:05:41,spid20s,Unknown,UPDATE [Config].[dbo].[STB]
04/29/2009 10:05:41,spid20s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b00000100000000000000
04/29/2009 10:05:41,spid20s,Unknown,executionStack
04/29/2009 10:05:41,spid20s,Unknown,process id=processa7ef28 taskpriority=0 logused=0 waitresource=RID: 5:1:183:84 waittime=3671 ownerId=15485845 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:33.013 XDES=0x4647d888 lockMode=U schedulerid=3 kpid=6540 status=suspended spid=148 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:33.013 lastbatchcompleted=2009-04-29T10:05:33.013 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15485845 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
04/29/2009 10:05:41,spid23s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]
04/29/2009 10:05:41,spid23s,Unknown,inputbuf
04/29/2009 10:05:41,spid23s,Unknown,--commit transaction
04/29/2009 10:05:41,spid23s,Unknown,WHERE STBId = @STBId
04/29/2009 10:05:41,spid23s,Unknown,[DeployImageVersion] = null
04/29/2009 10:05:41,spid20s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]
04/29/2009 10:05:41,spid23s,Unknown,SET [ImageVersion] = @ImageVersion
04/29/2009 10:05:41,spid20s,Unknown,inputbuf
04/29/2009 10:05:41,spid23s,Unknown,UPDATE [Config].[dbo].[STB]
04/29/2009 10:05:41,spid20s,Unknown,--commit transaction
04/29/2009 10:05:41,spid23s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b00000100000000000000
04/29/2009 10:05:41,spid20s,Unknown,WHERE STBId = @STBId
04/29/2009 10:05:41,spid20s,Unknown,[DeployImageVersion] = null
04/29/2009 10:05:41,spid23s,Unknown,executionStack
04/29/2009 10:05:41,spid20s,Unknown,SET [ImageVersion] = @ImageVersion
04/29/2009 10:05:41,spid23s,Unknown,process id=processa7ed48 taskpriority=0 logused=84 waitresource=RID: 5:1:608:1 waittime=3671 ownerId=15485653 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:32.980 XDES=0x464646d0 lockMode=U schedulerid=3 kpid=5580 status=suspended spid=143 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:32.980 lastbatchcompleted=2009-04-29T10:05:32.980 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15485653 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
04/29/2009 10:05:41,spid20s,Unknown,UPDATE [Config].[dbo].[STB]
04/29/2009 10:05:41,spid20s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b00000100000000000000
04/29/2009 10:05:41,spid20s,Unknown,executionStack
04/29/2009 10:05:41,spid20s,Unknown,process id=processa7ed48 taskpriority=0 logused=84 waitresource=RID: 5:1:608:1 waittime=3671 ownerId=15485653 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:32.980 XDES=0x464646d0 lockMode=U schedulerid=3 kpid=5580 status=suspended spid=143 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:32.980 lastbatchcompleted=2009-04-29T10:05:32.980 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15485653 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
04/29/2009 10:05:41,spid23s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]
04/29/2009 10:05:41,spid23s,Unknown,inputbuf
04/29/2009 10:05:41,spid23s,Unknown,--commit transaction
04/29/2009 10:05:41,spid23s,Unknown,WHERE STBId = @STBId
04/29/2009 10:05:41,spid23s,Unknown,[DeployImageVersion] = null
04/29/2009 10:05:41,spid23s,Unknown,SET [ImageVersion] = @ImageVersion
04/29/2009 10:05:41,spid20s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]
04/29/2009 10:05:41,spid23s,Unknown,UPDATE [Config].[dbo].[STB]
04/29/2009 10:05:41,spid20s,Unknown,inputbuf
04/29/2009 10:05:41,spid20s,Unknown,--commit transaction
04/29/2009 10:05:41,spid23s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b00000100000000000000
04/29/2009 10:05:41,spid20s,Unknown,WHERE STBId = @STBId
04/29/2009 10:05:41,spid20s,Unknown,[DeployImageVersion] = null
04/29/2009 10:05:41,spid23s,Unknown,executionStack
04/29/2009 10:05:41,spid23s,Unknown,process id=processa78c58 taskpriority=0 logused=84 waitresource=RID: 5:1:183:84 waittime=3671 ownerId=15485915 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:33.030 XDES=0x47881b10 lockMode=U schedulerid=2 kpid=10208 status=suspended spid=117 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:33.030 lastbatchcompleted=2009-04-29T10:05:33.030 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15485915 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
04/29/2009 10:05:41,spid20s,Unknown,SET [ImageVersion] = @ImageVersion
04/29/2009 10:05:41,spid20s,Unknown,UPDATE [Config].[dbo].[STB]
04/29/2009 10:05:41,spid20s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b00000100000000000000
04/29/2009 10:05:41,spid23s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]
04/29/2009 10:05:41,spid23s,Unknown,inputbuf
04/29/2009 10:05:41,spid23s,Unknown,--commit transaction
04/29/2009 10:05:41,spid23s,Unknown,WHERE STBId = @STBId
04/29/2009 10:05:41,spid23s,Unknown,[DeployImageVersion] = null
04/29/2009 10:05:41,spid23s,Unknown,SET [ImageVersion] = @ImageVersion
04/29/2009 10:05:41,spid23s,Unknown,UPDATE [Config].[dbo].[STB]
04/29/2009 10:05:41,spid23s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b00000100000000000000
04/29/2009 10:05:41,spid20s,Unknown,executionStack
04/29/2009 10:05:41,spid20s,Unknown,process id=processa78c58 taskpriority=0 logused=84 waitresource=RID: 5:1:183:84 waittime=3671 ownerId=15485915 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:33.030 XDES=0x47881b10 lockMode=U schedulerid=2 kpid=10208 status=suspended spid=117 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:33.030 lastbatchcompleted=2009-04-29T10:05:33.030 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15485915 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
04/29/2009 10:05:41,spid23s,Unknown,executionStack
04/29/2009 10:05:41,spid23s,Unknown,process id=process9eb018 taskpriority=0 logused=0 waitresource=RID: 5:1:183:84 waittime=3671 ownerId=15485892 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:33.030 XDES=0x46e8a250 lockMode=U schedulerid=1 kpid=6468 status=suspended spid=150 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:33.030 lastbatchcompleted=2009-04-29T10:05:33.013 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15485892 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
04/29/2009 10:05:41,spid20s,Unknown,process-list
04/29/2009 10:05:41,spid20s,Unknown,deadlock victim=processa7ef28
04/29/2009 10:05:41,spid20s,Unknown,deadlock-list
04/29/2009 10:05:41,spid23s,Unknown,process-list
04/29/2009 10:05:41,spid23s,Unknown,deadlock victim=process9eb018
04/29/2009 10:05:41,spid23s,Unknown,deadlock-list
04/29/2009 10:05:40,spid17s,Unknown,waiter id=processa7fa68 mode=U requestType=wait
04/29/2009 10:05:40,spid17s,Unknown,waiter-list
04/29/2009 10:05:40,spid17s,Unknown,owner id=processa7ed48 mode=X
04/29/2009 10:05:40,spid17s,Unknown,owner-list
04/29/2009 10:05:40,spid17s,Unknown,ridlock fileid=1 pageid=252 dbid=5 objectname=Config.dbo.STB id=lock3f74800 mode=X associatedObjectId=72057594041663488
04/29/2009 10:05:40,spid17s,Unknown,waiter id=processa7ed48 mode=U requestType=wait
04/29/2009 10:05:40,spid17s,Unknown,waiter-list
04/29/2009 10:05:40,spid17s,Unknown,owner id=processa78c58 mode=X
04/29/2009 10:05:40,spid17s,Unknown,owner-list
04/29/2009 10:05:40,spid17s,Unknown,ridlock fileid=1 pageid=608 dbid=5 objectname=Config.dbo.STB id=lock92d96c0 mode=X associatedObjectId=72057594041663488
04/29/2009 10:05:40,spid17s,Unknown,waiter id=processa78c58 mode=U requestType=wait
04/29/2009 10:05:40,spid17s,Unknown,waiter id=processa7fc48 mode=U requestType=wait
04/29/2009 10:05:40,spid17s,Unknown,waiter-list
04/29/2009 10:05:40,spid17s,Unknown,owner id=processa7fa68 mode=X
04/29/2009 10:05:40,spid17s,Unknown,owner-list
04/29/2009 10:05:40,spid17s,Unknown,ridlock fileid=1 pageid=183 dbid=5 objectname=Config.dbo.STB id=lock3f71d40 mode=X associatedObjectId=72057594041663488
04/29/2009 10:05:40,spid17s,Unknown,waiter id=process45c4e2f8 mode=U requestType=wait
04/29/2009 10:05:40,spid17s,Unknown,waiter id=processd253d8 mode=U requestType=wait
04/29/2009 10:05:40,spid17s,Unknown,waiter-list
04/29/2009 10:05:40,spid17s,Unknown,owner id=processa78c58 mode=X
04/29/2009 10:05:40,spid17s,Unknown,owner-list
04/29/2009 10:05:40,spid17s,Unknown,ridlock fileid=1 pageid=183 dbid=5 objectname=Config.dbo.STB id=lock3f6a2c0 mode=X associatedObjectId=72057594041663488
04/29/2009 10:05:40,spid17s,Unknown,resource-list
04/29/2009 10:05:40,spid17s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]
04/29/2009 10:05:40,spid17s,Unknown,inputbuf
04/29/2009 10:05:40,spid17s,Unknown,--commit transaction
04/29/2009 10:05:40,spid17s,Unknown,WHERE STBId = @STBId
04/29/2009 10:05:40,spid17s,Unknown,[DeployImageVersion] = null
04/29/2009 10:05:40,spid17s,Unknown,SET [ImageVersion] = @ImageVersion
04/29/2009 10:05:40,spid17s,Unknown,UPDATE [Config].[dbo].[STB]
04/29/2009 10:05:40,spid17s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b00000100000000000000
04/29/2009 10:05:40,spid17s,Unknown,executionStack
04/29/2009 10:05:40,spid17s,Unknown,process id=process45c4e2f8 taskpriority=0 logused=84 waitresource=RID: 5:1:183:22 waittime=2421 ownerId=15491937 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:36.373 XDES=0x45d2ac70 lockMode=U schedulerid=2 kpid=4436 status=suspended spid=133 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:36.373 lastbatchcompleted=2009-04-29T10:05:36.373 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15491937 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
04/29/2009 10:05:40,spid17s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]
04/29/2009 10:05:40,spid17s,Unknown,inputbuf
04/29/2009 10:05:40,spid17s,Unknown,--commit transaction
04/29/2009 10:05:40,spid17s,Unknown,WHERE STBId = @STBId
04/29/2009 10:05:40,spid17s,Unknown,[DeployImageVersion] = null
04/29/2009 10:05:40,spid17s,Unknown,SET [ImageVersion] = @ImageVersion
04/29/2009 10:05:40,spid17s,Unknown,UPDATE [Config].[dbo].[STB]
04/29/2009 10:05:40,spid17s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b00000100000000000000
04/29/2009 10:05:40,spid17s,Unknown,executionStack
04/29/2009 10:05:40,spid17s,Unknown,process id=processd253d8 taskpriority=0 logused=0 waitresource=RID: 5:1:183:22 waittime=2437 ownerId=15485964 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:33.030 XDES=0x450d8250 lockMode=U schedulerid=4 kpid=7268 status=suspended spid=119 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:33.030 lastbatchcompleted=2009-04-29T10:05:33.030 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15485964 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
04/29/2009 10:05:40,spid17s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]
04/29/2009 10:05:40,spid17s,Unknown,inputbuf
04/29/2009 10:05:40,spid17s,Unknown,--commit transaction
04/29/2009 10:05:40,spid17s,Unknown,WHERE STBId = @STBId
04/29/2009 10:05:40,spid17s,Unknown,[DeployImageVersion] = null
04/29/2009 10:05:40,spid17s,Unknown,SET [ImageVersion] = @ImageVersion
04/29/2009 10:05:40,spid17s,Unknown,UPDATE [Config].[dbo].[STB]
04/29/2009 10:05:40,spid15s,Unknown,waiter id=processa7fa68 mode=U requestType=wait
04/29/2009 10:05:40,spid17s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b00000100000000000000
04/29/2009 10:05:40,spid15s,Unknown,waiter-list
04/29/2009 10:05:40,spid15s,Unknown,owner id=processa7ed48 mode=X
04/29/2009 10:05:40,spid17s,Unknown,executionStack
04/29/2009 10:05:40,spid15s,Unknown,owner-list
04/29/2009 10:05:40,spid17s,Unknown,process id=processa7fc48 taskpriority=0 logused=0 waitresource=RID: 5:1:183:84 waittime=2421 ownerId=15485823 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:33.013 XDES=0x4647ce68 lockMode=U schedulerid=3 kpid=7876 status=suspended spid=145 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:33.013 lastbatchcompleted=2009-04-29T10:05:32.997 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15485823 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
04/29/2009 10:05:40,spid15s,Unknown,ridlock fileid=1 pageid=252 dbid=5 objectname=Config.dbo.STB id=lock3f74800 mode=X associatedObjectId=72057594041663488
04/29/2009 10:05:40,spid15s,Unknown,waiter id=processa7ed48 mode=U requestType=wait
04/29/2009 10:05:40,spid15s,Unknown,waiter-list
04/29/2009 10:05:40,spid15s,Unknown,owner id=processa78c58 mode=X
04/29/2009 10:05:40,spid15s,Unknown,owner-list
04/29/2009 10:05:40,spid15s,Unknown,ridlock fileid=1 pageid=608 dbid=5 objectname=Config.dbo.STB id=lock92d96c0 mode=X associatedObjectId=72057594041663488
04/29/2009 10:05:40,spid17s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]
04/29/2009 10:05:40,spid15s,Unknown,waiter id=processa78c58 mode=U requestType=wait
04/29/2009 10:05:40,spid15s,Unknown,waiter id=processa7f108 mode=U requestType=wait
04/29/2009 10:05:40,spid15s,Unknown,waiter-list
04/29/2009 10:05:40,spid15s,Unknown,owner id=processa7fa68 mode=X
04/29/2009 10:05:40,spid17s,Unknown,inputbuf
04/29/2009 10:05:40,spid15s,Unknown,owner-list
04/29/2009 10:05:40,spid17s,Unknown,--commit transaction
04/29/2009 10:05:40,spid15s,Unknown,ridlock fileid=1 pageid=183 dbid=5 objectname=Config.dbo.STB id=lock3f71d40 mode=X associatedObjectId=72057594041663488
04/29/2009 10:05:40,spid17s,Unknown,WHERE STBId = @STBId
04/29/2009 10:05:40,spid17s,Unknown,[DeployImageVersion] = null
04/29/2009 10:05:40,spid17s,Unknown,SET [ImageVersion] = @ImageVersion
04/29/2009 10:05:40,spid17s,Unknown,UPDATE [Config].[dbo].[STB]
04/29/2009 10:05:40,spid15s,Unknown,resource-list
04/29/2009 10:05:40,spid17s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b00000100000000000000
04/29/2009 10:05:40,spid15s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]
04/29/2009 10:05:40,spid15s,Unknown,inputbuf
04/29/2009 10:05:40,spid17s,Unknown,executionStack
04/29/2009 10:05:40,spid17s,Unknown,process id=processa7fa68 taskpriority=0 logused=84 waitresource=RID: 5:1:252:40 waittime=2421 ownerId=15485766 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:32.997 XDES=0x46465b58 lockMode=U schedulerid=3 kpid=4280 status=suspended spid=144 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:32.997 lastbatchcompleted=2009-04-29T10:05:32.997 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15485766 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
04/29/2009 10:05:40,spid15s,Unknown,--commit transaction
04/29/2009 10:05:40,spid15s,Unknown,WHERE STBId = @STBId
04/29/2009 10:05:40,spid15s,Unknown,[DeployImageVersion] = null
04/29/2009 10:05:40,spid15s,Unknown,SET [ImageVersion] = @ImageVersion
04/29/2009 10:05:40,spid15s,Unknown,UPDATE [Config].[dbo].[STB]
04/29/2009 10:05:40,spid17s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]
04/29/2009 10:05:40,spid15s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b00000100000000000000
04/29/2009 10:05:40,spid17s,Unknown,inputbuf
04/29/2009 10:05:40,spid17s,Unknown,--commit transaction
04/29/2009 10:05:40,spid17s,Unknown,WHERE STBId = @STBId
04/29/2009 10:05:40,spid15s,Unknown,executionStack
04/29/2009 10:05:40,spid17s,Unknown,[DeployImageVersion] = null
04/29/2009 10:05:40,spid15s,Unknown,process id=processa7fa68 taskpriority=0 logused=84 waitresource=RID: 5:1:252:40 waittime=2421 ownerId=15485766 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:32.997 XDES=0x46465b58 lockMode=U schedulerid=3 kpid=4280 status=suspended spid=144 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:32.997 lastbatchcompleted=2009-04-29T10:05:32.997 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15485766 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
04/29/2009 10:05:40,spid17s,Unknown,SET [ImageVersion] = @ImageVersion
04/29/2009 10:05:40,spid17s,Unknown,UPDATE [Config].[dbo].[STB]
04/29/2009 10:05:40,spid17s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b00000100000000000000
04/29/2009 10:05:40,spid17s,Unknown,executionStack
04/29/2009 10:05:40,spid17s,Unknown,process id=processa7ed48 taskpriority=0 logused=84 waitresource=RID: 5:1:608:1 waittime=2421 ownerId=15485653 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:32.980 XDES=0x464646d0 lockMode=U schedulerid=3 kpid=5580 status=suspended spid=143 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:32.980 lastbatchcompleted=2009-04-29T10:05:32.980 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15485653 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
04/29/2009 10:05:40,spid15s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]
04/29/2009 10:05:40,spid15s,Unknown,inputbuf
04/29/2009 10:05:40,spid15s,Unknown,--commit transaction
04/29/2009 10:05:40,spid15s,Unknown,WHERE STBId = @STBId
04/29/2009 10:05:40,spid15s,Unknown,[DeployImageVersion] = null
04/29/2009 10:05:40,spid15s,Unknown,SET [ImageVersion] = @ImageVersion
04/29/2009 10:05:40,spid15s,Unknown,UPDATE [Config].[dbo].[STB]
04/29/2009 10:05:40,spid15s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b00000100000000000000
04/29/2009 10:05:40,spid17s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]
04/29/2009 10:05:40,spid17s,Unknown,inputbuf
04/29/2009 10:05:40,spid15s,Unknown,executionStack
04/29/2009 10:05:40,spid17s,Unknown,--commit transaction
04/29/2009 10:05:40,spid15s,Unknown,process id=processa7f108 taskpriority=0 logused=0 waitresource=RID: 5:1:183:84 waittime=2421 ownerId=15485814 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:33.013 XDES=0x4647c8c8 lockMode=U schedulerid=3 kpid=10236 status=suspended spid=146 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:33.013 lastbatchcompleted=2009-04-29T10:05:33.013 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15485814 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
04/29/2009 10:05:40,spid17s,Unknown,WHERE STBId = @STBId
04/29/2009 10:05:40,spid17s,Unknown,[DeployImageVersion] = null
04/29/2009 10:05:40,spid17s,Unknown,SET [ImageVersion] = @ImageVersion
04/29/2009 10:05:40,spid17s,Unknown,UPDATE [Config].[dbo].[STB]
04/29/2009 10:05:40,spid17s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b00000100000000000000
04/29/2009 10:05:40,spid17s,Unknown,executionStack
04/29/2009 10:05:40,spid15s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]
04/29/2009 10:05:40,spid17s,Unknown,process id=processa78c58 taskpriority=0 logused=84 waitresource=RID: 5:1:183:84 waittime=2421 ownerId=15485915 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:33.030 XDES=0x47881b10 lockMode=U schedulerid=2 kpid=10208 status=suspended spid=117 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:33.030 lastbatchcompleted=2009-04-29T10:05:33.030 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15485915 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
04/29/2009 10:05:40,spid15s,Unknown,inputbuf
04/29/2009 10:05:40,spid15s,Unknown,--commit transaction
04/29/2009 10:05:40,spid15s,Unknown,WHERE STBId = @STBId
04/29/2009 10:05:40,spid15s,Unknown,[DeployImageVersion] = null
04/29/2009 10:05:40,spid15s,Unknown,SET [ImageVersion] = @ImageVersion
04/29/2009 10:05:40,spid15s,Unknown,UPDATE [Config].[dbo].[STB]
04/29/2009 10:05:40,spid15s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b00000100000000000000
04/29/2009 10:05:40,spid17s,Unknown,process-list
04/29/2009 10:05:40,spid15s,Unknown,executionStack
04/29/2009 10:05:40,spid17s,Unknown,deadlock victim=processa7fc48
04/29/2009 10:05:40,spid15s,Unknown,process id=processa7ed48 taskpriority=0 logused=84 waitresource=RID: 5:1:608:1 waittime=2421 ownerId=15485653 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:32.980 XDES=0x464646d0 lockMode=U schedulerid=3 kpid=5580 status=suspended spid=143 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:32.980 lastbatchcompleted=2009-04-29T10:05:32.980 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15485653 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
04/29/2009 10:05:40,spid17s,Unknown,deadlock-list
04/29/2009 10:05:40,spid15s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]
04/29/2009 10:05:40,spid15s,Unknown,inputbuf
04/29/2009 10:05:40,spid15s,Unknown,--commit transaction
04/29/2009 10:05:40,spid15s,Unknown,WHERE STBId = @STBId
04/29/2009 10:05:40,spid15s,Unknown,[DeployImageVersion] = null
04/29/2009 10:05:40,spid15s,Unknown,SET [ImageVersion] = @ImageVersion
04/29/2009 10:05:40,spid15s,Unknown,UPDATE [Config].[dbo].[STB]
04/29/2009 10:05:40,spid15s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b00000100000000000000
04/29/2009 10:05:40,spid15s,Unknown,executionStack
04/29/2009 10:05:40,spid15s,Unknown,process id=processa78c58 taskpriority=0 logused=84 waitresource=RID: 5:1:183:84 waittime=2421 ownerId=15485915 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:33.030 XDES=0x47881b10 lockMode=U schedulerid=2 kpid=10208 status=suspended spid=117 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:33.030 lastbatchcompleted=2009-04-29T10:05:33.030 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15485915 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
04/29/2009 10:05:40,spid15s,Unknown,process-list
04/29/2009 10:05:40,spid15s,Unknown,deadlock victim=processa7f108
04/29/2009 10:05:40,spid15s,Unknown,deadlock-list
04/29/2009 10:05:38,spid14s,Unknown,waiter id=process9eab68 mode=U requestType=wait
04/29/2009 10:05:38,spid14s,Unknown,waiter-list
04/29/2009 10:05:38,spid14s,Unknown,owner id=processd24898 mode=X
04/29/2009 10:05:38,spid14s,Unknown,owner-list
04/29/2009 10:05:38,spid14s,Unknown,ridlock fileid=1 pageid=252 dbid=5 objectname=Config.dbo.STB id=lock3f80f80 mode=X associatedObjectId=72057594041663488
04/29/2009 10:05:38,spid14s,Unknown,waiter id=processd24898 mode=U requestType=wait
04/29/2009 10:05:38,spid14s,Unknown,waiter-list
04/29/2009 10:05:38,spid14s,Unknown,owner id=process9eab68 mode=X
04/29/2009 10:05:38,spid14s,Unknown,owner-list
04/29/2009 10:05:38,spid14s,Unknown,ridlock fileid=1 pageid=252 dbid=5 objectname=Config.dbo.STB id=lock3e60480 mode=X associatedObjectId=72057594041663488
04/29/2009 10:05:38,spid14s,Unknown,resource-list
04/29/2009 10:05:38,spid14s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]
04/29/2009 10:05:38,spid14s,Unknown,inputbuf
04/29/2009 10:05:38,spid14s,Unknown,--commit transaction
04/29/2009 10:05:38,spid14s,Unknown,WHERE STBId = @STBId
04/29/2009 10:05:38,spid14s,Unknown,[DeployImageVersion] = null
04/29/2009 10:05:38,spid14s,Unknown,SET [ImageVersion] = @ImageVersion
04/29/2009 10:05:38,spid14s,Unknown,UPDATE [Config].[dbo].[STB]
04/29/2009 10:05:38,spid14s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b00000100000000000000
04/29/2009 10:05:38,spid14s,Unknown,executionStack
04/29/2009 10:05:38,spid14s,Unknown,process id=processd24898 taskpriority=0 logused=84 waitresource=RID: 5:1:252:55 waittime=5000 ownerId=15483884 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:32.623 XDES=0x3c4127f0 lockMode=U schedulerid=4 kpid=8428 status=suspended spid=78 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:32.623 lastbatchcompleted=2009-04-29T10:05:32.623 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15483884 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
04/29/2009 10:05:38,spid14s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]
04/29/2009 10:05:38,spid14s,Unknown,inputbuf
04/29/2009 10:05:38,spid14s,Unknown,--commit transaction
04/29/2009 10:05:38,spid14s,Unknown,WHERE STBId = @STBId
04/29/2009 10:05:38,spid14s,Unknown,[DeployImageVersion] = null
04/29/2009 10:05:38,spid14s,Unknown,SET [ImageVersion] = @ImageVersion
04/29/2009 10:05:38,spid14s,Unknown,UPDATE [Config].[dbo].[STB]
04/29/2009 10:05:38,spid14s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b00000100000000000000
04/29/2009 10:05:38,spid14s,Unknown,executionStack
04/29/2009 10:05:38,spid14s,Unknown,process id=process9eab68 taskpriority=0 logused=84 waitresource=RID: 5:1:252:14 waittime=5406 ownerId=15483947 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:32.623 XDES=0x47548e68 lockMode=U schedulerid=1 kpid=8168 status=suspended spid=93 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:32.623 lastbatchcompleted=2009-04-29T10:05:32.623 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15483947 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
04/29/2009 10:05:38,spid14s,Unknown,process-list
04/29/2009 10:05:38,spid14s,Unknown,deadlock victim=processd24898
04/29/2009 10:05:38,spid14s,Unknown,deadlock-list
04/29/2009 10:05:33,spid17s,Unknown,waiter id=processa79f18 mode=U requestType=wait
04/29/2009 10:05:33,spid17s,Unknown,waiter-list
04/29/2009 10:05:33,spid17s,Unknown,owner id=process9eae38 mode=X
04/29/2009 10:05:33,spid17s,Unknown,owner-list
04/29/2009 10:05:33,spid17s,Unknown,ridlock fileid=1 pageid=183 dbid=5 objectname=Config.dbo.STB id=lockbfd8480 mode=X associatedObjectId=72057594041663488
04/29/2009 10:05:33,spid17s,Unknown,waiter id=process9eae38 mode=U requestType=wait
04/29/2009 10:05:33,spid17s,Unknown,waiter id=processd24b68 mode=U requestType=wait
04/29/2009 10:05:33,spid17s,Unknown,waiter-list
04/29/2009 10:05:33,spid17s,Unknown,owner id=processd25a68 mode=X
04/29/2009 10:05:33,spid17s,Unknown,owner-list
04/29/2009 10:05:33,spid17s,Unknown,ridlock fileid=1 pageid=183 dbid=5 objectname=Config.dbo.STB id=lock9589a40 mode=X associatedObjectId=72057594041663488
04/29/2009 10:05:33,spid17s,Unknown,waiter id=processd25a68 mode=U requestType=wait
04/29/2009 10:05:33,spid17s,Unknown,waiter-list
04/29/2009 10:05:33,spid17s,Unknown,owner id=process9ebf18 mode=X
04/29/2009 10:05:33,spid17s,Unknown,owner-list
04/29/2009 10:05:33,spid17s,Unknown,ridlock fileid=1 pageid=183 dbid=5 objectname=Config.dbo.STB id=lock75161c0 mode=X associatedObjectId=72057594041663488
04/29/2009 10:05:33,spid17s,Unknown,waiter id=process9ebf18 mode=U requestType=wait
04/29/2009 10:05:33,spid17s,Unknown,waiter id=processa79a68 mode=U requestType=wait
04/29/2009 10:05:33,spid17s,Unknown,waiter-list
04/29/2009 10:05:33,spid17s,Unknown,owner id=process9eab68 mode=X
04/29/2009 10:05:33,spid17s,Unknown,owner-list
04/29/2009 10:05:33,spid17s,Unknown,ridlock fileid=1 pageid=183 dbid=5 objectname=Config.dbo.STB id=lock927d900 mode=X associatedObjectId=72057594041663488
04/29/2009 10:05:33,spid17s,Unknown,waiter id=process9eab68 mode=U requestType=wait
04/29/2009 10:05:33,spid17s,Unknown,waiter-list
04/29/2009 10:05:33,spid17s,Unknown,owner id=processd24898 mode=X
04/29/2009 10:05:33,spid17s,Unknown,owner-list
04/29/2009 10:05:33,spid17s,Unknown,ridlock fileid=1 pageid=252 dbid=5 objectname=Config.dbo.STB id=lock3f80f80 mode=X associatedObjectId=72057594041663488
04/29/2009 10:05:33,spid17s,Unknown,waiter id=processd24898 mode=U requestType=wait
04/29/2009 10:05:33,spid17s,Unknown,waiter-list
04/29/2009 10:05:33,spid17s,Unknown,owner id=process9ebd38 mode=X
04/29/2009 10:05:33,spid17s,Unknown,owner-list
04/29/2009 10:05:33,spid17s,Unknown,ridlock fileid=1 pageid=252 dbid=5 objectname=Config.dbo.STB id=lock927c940 mode=X associatedObjectId=72057594041663488
04/29/2009 10:05:33,spid17s,Unknown,waiter id=process9ebd38 mode=U requestType=wait
04/29/2009 10:05:33,spid17s,Unknown,waiter-list
04/29/2009 10:05:33,spid17s,Unknown,owner id=process9eab68 mode=X
04/29/2009 10:05:33,spid17s,Unknown,owner-list
04/29/2009 10:05:33,spid17s,Unknown,ridlock fileid=1 pageid=252 dbid=5 objectname=Config.dbo.STB id=lock3e60480 mode=X associatedObjectId=72057594041663488
04/29/2009 10:05:33,spid17s,Unknown,resource-list
04/29/2009 10:05:33,spid17s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]
04/29/2009 10:05:33,spid17s,Unknown,inputbuf
04/29/2009 10:05:33,spid17s,Unknown,--commit transaction
04/29/2009 10:05:33,spid17s,Unknown,WHERE STBId = @STBId
04/29/2009 10:05:33,spid17s,Unknown,[DeployImageVersion] = null
04/29/2009 10:05:33,spid17s,Unknown,SET [ImageVersion] = @ImageVersion
04/29/2009 10:05:33,spid17s,Unknown,UPDATE [Config].[dbo].[STB]
04/29/2009 10:05:33,spid17s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b00000100000000000000
04/29/2009 10:05:33,spid17s,Unknown,executionStack
04/29/2009 10:05:33,spid17s,Unknown,process id=processd25a68 taskpriority=0 logused=84 waitresource=RID: 5:1:183:56 waittime=406 ownerId=15484003 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:32.637 XDES=0x3e462250 lockMode=U schedulerid=4 kpid=8560 status=suspended spid=69 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:32.637 lastbatchcompleted=2009-04-29T10:05:32.637 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15484003 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
04/29/2009 10:05:33,spid17s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]
04/29/2009 10:05:33,spid17s,Unknown,inputbuf
04/29/2009 10:05:33,spid17s,Unknown,--commit transaction
04/29/2009 10:05:33,spid17s,Unknown,WHERE STBId = @STBId
04/29/2009 10:05:33,spid17s,Unknown,[DeployImageVersion] = null
04/29/2009 10:05:33,spid17s,Unknown,SET [ImageVersion] = @ImageVersion
04/29/2009 10:05:33,spid17s,Unknown,UPDATE [Config].[dbo].[STB]
04/29/2009 10:05:33,spid17s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b00000100000000000000
04/29/2009 10:05:33,spid17s,Unknown,executionStack
04/29/2009 10:05:33,spid17s,Unknown,process id=processd24b68 taskpriority=0 logused=0 waitresource=RID: 5:1:183:25 waittime=406 ownerId=15484005 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:32.637 XDES=0x3c412d90 lockMode=U schedulerid=4 kpid=6444 status=suspended spid=82 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:32.637 lastbatchcompleted=2009-04-29T10:05:32.637 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15484005 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
04/29/2009 10:05:33,spid17s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]
04/29/2009 10:05:33,spid17s,Unknown,inputbuf
04/29/2009 10:05:33,spid17s,Unknown,--commit transaction
04/29/2009 10:05:33,spid17s,Unknown,WHERE STBId = @STBId
04/29/2009 10:05:33,spid17s,Unknown,[DeployImageVersion] = null
04/29/2009 10:05:33,spid17s,Unknown,SET [ImageVersion] = @ImageVersion
04/29/2009 10:05:33,spid17s,Unknown,UPDATE [Config].[dbo].[STB]
04/29/2009 10:05:33,spid17s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b00000100000000000000
04/29/2009 10:05:33,spid17s,Unknown,executionStack
04/29/2009 10:05:33,spid17s,Unknown,process id=processd24898 taskpriority=0 logused=84 waitresource=RID: 5:1:252:15 waittime=421 ownerId=15483884 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:32.623 XDES=0x3c4127f0 lockMode=U schedulerid=4 kpid=8428 status=suspended spid=78 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:32.623 lastbatchcompleted=2009-04-29T10:05:32.623 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15483884 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
04/29/2009 10:05:33,spid17s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]
04/29/2009 10:05:33,spid17s,Unknown,inputbuf
04/29/2009 10:05:33,spid17s,Unknown,--commit transaction
04/29/2009 10:05:33,spid17s,Unknown,WHERE STBId = @STBId
04/29/2009 10:05:33,spid17s,Unknown,[DeployImageVersion] = null
04/29/2009 10:05:33,spid17s,Unknown,SET [ImageVersion] = @ImageVersion
04/29/2009 10:05:33,spid17s,Unknown,UPDATE [Config].[dbo].[STB]
04/29/2009 10:05:33,spid17s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b00000100000000000000
04/29/2009 10:05:33,spid17s,Unknown,executionStack
04/29/2009 10:05:33,spid17s,Unknown,process id=processa79f18 taskpriority=0 logused=0 waitresource=RID: 5:1:183:8 waittime=500 ownerId=15484461 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:32.717 XDES=0x443bc8c8 lockMode=U schedulerid=2 kpid=5452 status=suspended spid=87 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:32.717 lastbatchcompleted=2009-04-29T10:05:32.717 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15484461 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
04/29/2009 10:05:33,spid17s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]
04/29/2009 10:05:33,spid17s,Unknown,inputbuf
04/29/2009 10:05:33,spid17s,Unknown,--commit transaction
04/29/2009 10:05:33,spid17s,Unknown,WHERE STBId = @STBId
04/29/2009 10:05:33,spid17s,Unknown,[DeployImageVersion] = null
04/29/2009 10:05:33,spid17s,Unknown,SET [ImageVersion] = @ImageVersion
04/29/2009 10:05:33,spid17s,Unknown,UPDATE [Config].[dbo].[STB]
04/29/2009 10:05:33,spid17s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b00000100000000000000
04/29/2009 10:05:33,spid17s,Unknown,executionStack
04/29/2009 10:05:33,spid17s,Unknown,process id=processa79a68 taskpriority=0 logused=0 waitresource=RID: 5:1:183:61 waittime=421 ownerId=15483956 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:32.637 XDES=0x443bd600 lockMode=U schedulerid=2 kpid=4516 status=suspended spid=80 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:32.637 lastbatchcompleted=2009-04-29T10:05:32.623 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15483956 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
04/29/2009 10:05:33,spid17s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]
04/29/2009 10:05:33,spid17s,Unknown,inputbuf
04/29/2009 10:05:33,spid17s,Unknown,--commit transaction
04/29/2009 10:05:33,spid17s,Unknown,WHERE STBId = @STBId
04/29/2009 10:05:33,spid17s,Unknown,[DeployImageVersion] = null
04/29/2009 10:05:33,spid17s,Unknown,SET [ImageVersion] = @ImageVersion
04/29/2009 10:05:33,spid17s,Unknown,UPDATE [Config].[dbo].[STB]
04/29/2009 10:05:33,spid17s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b00000100000000000000
04/29/2009 10:05:33,spid17s,Unknown,executionStack
04/29/2009 10:05:33,spid17s,Unknown,process id=process9ebf18 taskpriority=0 logused=84 waitresource=RID: 5:1:183:61 waittime=406 ownerId=15484001 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:32.637 XDES=0x47549888 lockMode=U schedulerid=1 kpid=6240 status=suspended spid=94 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:32.637 lastbatchcompleted=2009-04-29T10:05:32.637 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15484001 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
04/29/2009 10:05:33,spid17s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]
04/29/2009 10:05:33,spid17s,Unknown,inputbuf
04/29/2009 10:05:33,spid17s,Unknown,--commit transaction
04/29/2009 10:05:33,spid17s,Unknown,WHERE STBId = @STBId
04/29/2009 10:05:33,spid17s,Unknown,[DeployImageVersion] = null
04/29/2009 10:05:33,spid17s,Unknown,SET [ImageVersion] = @ImageVersion
04/29/2009 10:05:33,spid17s,Unknown,UPDATE [Config].[dbo].[STB]
04/29/2009 10:05:33,spid17s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b00000100000000000000
04/29/2009 10:05:33,spid17s,Unknown,executionStack
04/29/2009 10:05:33,spid17s,Unknown,process id=process9ebd38 taskpriority=0 logused=84 waitresource=RID: 5:1:252:55 waittime=406 ownerId=15483868 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:32.623 XDES=0x46e8b210 lockMode=U schedulerid=1 kpid=6808 status=suspended spid=77 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:32.623 lastbatchcompleted=2009-04-29T10:05:32.607 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15483868 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
04/29/2009 10:05:33,spid15s,Unknown,waiter id=process9eab68 mode=U requestType=wait
04/29/2009 10:05:33,spid17s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]
04/29/2009 10:05:33,spid15s,Unknown,waiter id=processa78e38 mode=U requestType=wait
04/29/2009 10:05:33,spid17s,Unknown,inputbuf
04/29/2009 10:05:33,spid15s,Unknown,waiter-list
04/29/2009 10:05:33,spid17s,Unknown,--commit transaction
04/29/2009 10:05:33,spid15s,Unknown,owner id=processd24898 mode=X
04/29/2009 10:05:33,spid17s,Unknown,WHERE STBId = @STBId
04/29/2009 10:05:33,spid15s,Unknown,owner-list
04/29/2009 10:05:33,spid17s,Unknown,[DeployImageVersion] = null
04/29/2009 10:05:33,spid15s,Unknown,ridlock fileid=1 pageid=252 dbid=5 objectname=Config.dbo.STB id=lock3f80f80 mode=X associatedObjectId=72057594041663488
04/29/2009 10:05:33,spid17s,Unknown,SET [ImageVersion] = @ImageVersion
04/29/2009 10:05:33,spid17s,Unknown,UPDATE [Config].[dbo].[STB]
04/29/2009 10:05:33,spid15s,Unknown,waiter id=processd24898 mode=U requestType=wait
04/29/2009 10:05:33,spid17s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b00000100000000000000
04/29/2009 10:05:33,spid15s,Unknown,waiter-list
04/29/2009 10:05:33,spid15s,Unknown,owner id=process9ebd38 mode=X
04/29/2009 10:05:33,spid15s,Unknown,owner-list
04/29/2009 10:05:33,spid17s,Unknown,executionStack
04/29/2009 10:05:33,spid15s,Unknown,ridlock fileid=1 pageid=252 dbid=5 objectname=Config.dbo.STB id=lock927c940 mode=X associatedObjectId=72057594041663488
04/29/2009 10:05:33,spid17s,Unknown,process id=process9eae38 taskpriority=0 logused=84 waitresource=RID: 5:1:183:25 waittime=406 ownerId=15484457 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:32.717 XDES=0x46f2a250 lockMode=U schedulerid=1 kpid=5992 status=suspended spid=85 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:32.717 lastbatchcompleted=2009-04-29T10:05:32.717 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15484457 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
04/29/2009 10:05:33,spid15s,Unknown,waiter id=process9ebd38 mode=U requestType=wait
04/29/2009 10:05:33,spid15s,Unknown,waiter-list
04/29/2009 10:05:33,spid15s,Unknown,owner id=process9eab68 mode=X
04/29/2009 10:05:33,spid15s,Unknown,owner-list
04/29/2009 10:05:33,spid15s,Unknown,ridlock fileid=1 pageid=252 dbid=5 objectname=Config.dbo.STB id=lock3e60480 mode=X associatedObjectId=72057594041663488
04/29/2009 10:05:33,spid15s,Unknown,resource-list
04/29/2009 10:05:33,spid17s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]
04/29/2009 10:05:33,spid15s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]
04/29/2009 10:05:33,spid17s,Unknown,inputbuf
04/29/2009 10:05:33,spid15s,Unknown,inputbuf
04/29/2009 10:05:33,spid17s,Unknown,--commit transaction
04/29/2009 10:05:33,spid15s,Unknown,--commit transaction
04/29/2009 10:05:33,spid17s,Unknown,WHERE STBId = @STBId
04/29/2009 10:05:33,spid15s,Unknown,WHERE STBId = @STBId
04/29/2009 10:05:33,spid17s,Unknown,[DeployImageVersion] = null
04/29/2009 10:05:33,spid15s,Unknown,[DeployImageVersion] = null
04/29/2009 10:05:33,spid17s,Unknown,SET [ImageVersion] = @ImageVersion
04/29/2009 10:05:33,spid15s,Unknown,SET [ImageVersion] = @ImageVersion
04/29/2009 10:05:33,spid17s,Unknown,UPDATE [Config].[dbo].[STB]
04/29/2009 10:05:33,spid15s,Unknown,UPDATE [Config].[dbo].[STB]
04/29/2009 10:05:33,spid17s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b00000100000000000000
04/29/2009 10:05:33,spid15s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b00000100000000000000
04/29/2009 10:05:33,spid17s,Unknown,executionStack
04/29/2009 10:05:33,spid15s,Unknown,executionStack
04/29/2009 10:05:33,spid17s,Unknown,process id=process9eab68 taskpriority=0 logused=84 waitresource=RID: 5:1:252:14 waittime=406 ownerId=15483947 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:32.623 XDES=0x47548e68 lockMode=U schedulerid=1 kpid=8168 status=suspended spid=93 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:32.623 lastbatchcompleted=2009-04-29T10:05:32.623 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15483947 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
04/29/2009 10:05:33,spid15s,Unknown,process id=processd24898 taskpriority=0 logused=84 waitresource=RID: 5:1:252:15 waittime=421 ownerId=15483884 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:32.623 XDES=0x3c4127f0 lockMode=U schedulerid=4 kpid=8428 status=suspended spid=78 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:32.623 lastbatchcompleted=2009-04-29T10:05:32.623 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15483884 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
04/29/2009 10:05:33,spid17s,Unknown,process-list
04/29/2009 10:05:33,spid17s,Unknown,deadlock victim=process9ebd38
04/29/2009 10:05:33,spid17s,Unknown,deadlock-list
04/29/2009 10:05:33,spid15s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]
04/29/2009 10:05:33,spid15s,Unknown,inputbuf
04/29/2009 10:05:33,spid15s,Unknown,--commit transaction
04/29/2009 10:05:33,spid15s,Unknown,WHERE STBId = @STBId
04/29/2009 10:05:33,spid15s,Unknown,[DeployImageVersion] = null
04/29/2009 10:05:33,spid15s,Unknown,SET [ImageVersion] = @ImageVersion
04/29/2009 10:05:33,spid15s,Unknown,UPDATE [Config].[dbo].[STB]
04/29/2009 10:05:33,spid15s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b00000100000000000000
04/29/2009 10:05:33,spid15s,Unknown,executionStack
04/29/2009 10:05:33,spid15s,Unknown,process id=processa78e38 taskpriority=0 logused=0 waitresource=RID: 5:1:252:14 waittime=421 ownerId=15483934 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:32.623 XDES=0x454aa6d0 lockMode=U schedulerid=2 kpid=8980 status=suspended spid=92 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:32.623 lastbatchcompleted=2009-04-29T10:05:32.623 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15483934 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
04/29/2009 10:05:33,spid15s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]
04/29/2009 10:05:33,spid15s,Unknown,inputbuf
04/29/2009 10:05:33,spid15s,Unknown,--commit transaction
04/29/2009 10:05:33,spid15s,Unknown,WHERE STBId = @STBId
04/29/2009 10:05:33,spid15s,Unknown,[DeployImageVersion] = null
04/29/2009 10:05:33,spid15s,Unknown,SET [ImageVersion] = @ImageVersion
04/29/2009 10:05:33,spid15s,Unknown,UPDATE [Config].[dbo].[STB]
04/29/2009 10:05:33,spid15s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b00000100000000000000
04/29/2009 10:05:33,spid15s,Unknown,executionStack
04/29/2009 10:05:33,spid15s,Unknown,process id=process9ebd38 taskpriority=0 logused=84 waitresource=RID: 5:1:252:55 waittime=406 ownerId=15483868 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:32.623 XDES=0x46e8b210 lockMode=U schedulerid=1 kpid=6808 status=suspended spid=77 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:32.623 lastbatchcompleted=2009-04-29T10:05:32.607 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15483868 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
04/29/2009 10:05:33,spid15s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]
04/29/2009 10:05:33,spid15s,Unknown,inputbuf
04/29/2009 10:05:33,spid15s,Unknown,--commit transaction
04/29/2009 10:05:33,spid15s,Unknown,WHERE STBId = @STBId
04/29/2009 10:05:33,spid15s,Unknown,[DeployImageVersion] = null
04/29/2009 10:05:33,spid15s,Unknown,SET [ImageVersion] = @ImageVersion
04/29/2009 10:05:33,spid15s,Unknown,UPDATE [Config].[dbo].[STB]
04/29/2009 10:05:33,spid15s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b00000100000000000000
04/29/2009 10:05:33,spid15s,Unknown,executionStack
04/29/2009 10:05:33,spid15s,Unknown,process id=process9eab68 taskpriority=0 logused=84 waitresource=RID: 5:1:252:14 waittime=406 ownerId=15483947 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:32.623 XDES=0x47548e68 lockMode=U schedulerid=1 kpid=8168 status=suspended spid=93 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:32.623 lastbatchcompleted=2009-04-29T10:05:32.623 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15483947 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
04/29/2009 10:05:33,spid15s,Unknown,process-list
04/29/2009 10:05:33,spid15s,Unknown,deadlock victim=processa78e38
04/29/2009 10:05:33,spid15s,Unknown,deadlock-list
Post #706515
Posted Wednesday, April 29, 2009 7:47 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 7:55 AM
Points: 42,478, Visits: 35,545
What indexes are there on the STB table?


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #706814
Posted Wednesday, February 27, 2013 11:29 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, May 8, 2014 11:16 AM
Points: 10, Visits: 22
Help me please, I'm getting following error:
[Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 235) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

I have this error being thrown every morning when I have most transactions happening with few seconds.

My stored procedure looks like this:
create procedure dbo.sp_storproc
(
@ServerID varchar(32),
@Key varchar(32),
@Values varchar(32)
)
as
set nocount on
declare @Error int, @RowCount int

update myTable with (RowLock)
set Values = @Values
where ServerID=@ServerID and Key = @Key

-- it has PK for ServerID and Key

select @RowCount = @@ROWCOUNT

select @Error = @@ERROR
if @Error<>0
begin
return -1
end

if @RowCount = 0
begin
insert into myTable with (RowLock) (ServerID, Key, Value)
values (@ServerID, @Key, @Values)

select @Error = @@ERROR
if @Error<>0
begin
return -1
end
end

what is happening, I have same application running on 5 servers and trying to run this sp at the same time,
sometimes I can see in about 2500 rows are inserted per second, but sometimes I can see that only 1 record
is inserted and the error log shows me that deadlock exception happened exactly at that same second.

Each server passes it's own @ServerID parameter, so there is no contention for the values accross the servers.

Please advise on the solution of how to avoid deadlock and let all records to be inserted, because usually
out of 9000 records that needs to be inserted with 10 or 5 seconds there is 5 or 6 records that are not
inserted and they're in my exception log.
Post #1424667
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse