Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 DeadLocks

Author  Topic 

muralidaran_r
Starting Member

13 Posts
Posted - 2009-04-29 : 03:30:26
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,<c/>[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,<c/>[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,<c/>[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,<c/>[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,<c/>[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,<c/>[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,<c/>[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,<c/>[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,<c/>[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,<c/>[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,<c/>[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,<c/>[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,<c/>[DeployImageVersion] = null
04/29/2009 10:05:42,spid14s,Unknown,<c/>[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,<c/>[DeployImageVersion] = null
04/29/2009 10:05:42,spid27s,Unknown,<c/>[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,<c/>[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,<c/>[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,<c/>[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,<c/>[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,<c/>[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,<c/>[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,<c/>[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,<c/>[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,<c/>[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,<c/>[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,<c/>[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,<c/>[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,<c/>[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,<c/>[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,<c/>[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,<c/>[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,<c/>[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,<c/>[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,<c/>[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,<c/>[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,<c/>[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,<c/>[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,<c/>[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,<c/>[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,<c/>[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,<c/>[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,<c/>[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,<c/>[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,<c/>[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,<c/>[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,<c/>[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,<c/>[DeployImageVersion] = null
04/29/2009 10:05:33,spid15s,Unknown,<c/>[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,<c/>[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,<c/>[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,<c/>[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

mcrowley
Aged Yak Warrior

771 Posts
Posted - 2009-04-29 : 10:19:51
Is there a trigger on the table?
Go to Top of Page
   

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

Articles

Forums

Blogs

Contact Us

About the Site