DeadLock

  • 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

  • What indexes are there on the STB table?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    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
  • 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.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply