April 5, 2010 at 3:07 pm
Hi,
We have MOSS 2007 SP1 databases in SQL Sevrer 2005. I noticed the below dead lock in the error log. But according MOSS admin, there was no crawling job was run at that time. I did not understand why the dead lock occured even though no crwal job was running and also why the mssqlsystemresource was involved in the dead lock?
2010-04-05 03:44:27.47 spid13s deadlock-list
2010-04-05 03:44:27.47 spid13s deadlock victim=process3c265c8
2010-04-05 03:44:27.47 spid13s process-list
2010-04-05 03:44:27.47 spid13s process id=process3c12c58 taskpriority=0 logused=1628 waitresource=KEY: 20:72057594078298112 (9b00b76b16ce) waittime=1031 ownerId=168088257 transactionname=user_transaction lasttranstarted=2010-04-05T03:44:26.440 XDES=0x2c494a700 lockMode=S schedulerid=2 kpid=6020 status=suspended spid=58 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2010-04-05T03:44:26.440 lastbatchcompleted=2010-04-05T03:44:26.440 clientapp=Windows SharePoint Services hostname=MOSS1 hostpid=3728 loginname=abc\mosssearch isolationlevel=read committed (2) xactid=168088257 currentdb=20 lockTimeout=4294967295 clientoption1=673316896 clientoption2=128056
2010-04-05 03:44:27.47 spid13s executionStack
2010-04-05 03:44:27.47 spid13s frame procname=adhoc line=1 stmtstart=60 sqlhandle=0x02000000279c122ae7565dd9c92e33a2d04a438ed414b399
2010-04-05 03:44:27.47 spid13s UPDATE MSSCrawlQueue SET BatchID = @BatchID, Priority = 2
2010-04-05 03:44:27.47 spid13s FROM MSSCrawlQueue A
2010-04-05 03:44:27.47 spid13s INNER JOIN (
2010-04-05 03:44:27.47 spid13s SELECT TOP 20478 CrawlID, FolderHighPriority, ItemHighPriority, SeqID
2010-04-05 03:44:27.47 spid13s FROM MSSCrawlQueue
2010-04-05 03:44:27.47 spid13s WHERE CrawlID = @CrawlID
2010-04-05 03:44:27.47 spid13s AND BatchID = 0
2010-04-05 03:44:27.47 spid13s ORDER BY SEQID ) AS B
2010-04-05 03:44:27.47 spid13s ON A.CrawlID = B.CrawlID AND A.FolderHighPriority = B.FolderHighPriority AND A.ItemHighPriority = B.ItemHighPriority AND A.SeqID = B.SeqID
2010-04-05 03:44:27.47 spid13s frame procname=mssqlsystemresource.sys.sp_executesql line=1 sqlhandle=0x0400ff7fbe80662601000000000000000000000000000000
2010-04-05 03:44:27.47 spid13s sp_executesql
2010-04-05 03:44:27.47 spid13s frame procname=SharedServices1_Search_DB.dbo.proc_MSS_GetNextCrawlBatch line=171 stmtstart=13742 stmtend=13864 sqlhandle=0x03001400c610834ac84c3301ab9c00000100000000000000
2010-04-05 03:44:27.47 spid13s EXEC SP_EXECUTESQL @Stmt, @PARAM, @BatchID, @CrawlID
2010-04-05 03:44:27.47 spid13s inputbuf
2010-04-05 03:44:27.47 spid13s Proc [Database Id = 20 Object Id = 1250103494]
2010-04-05 03:44:27.47 spid13s process id=process3c265c8 taskpriority=0 logused=504 waitresource=KEY: 20:72057594072858624 (35005565c416) waittime=1031 ownerId=168088262 transactionname=user_transaction lasttranstarted=2010-04-05T03:44:26.440 XDES=0x201140a90 lockMode=X schedulerid=4 kpid=4036 status=suspended spid=57 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2010-04-05T03:44:26.440 lastbatchcompleted=2010-04-05T03:44:26.440 clientapp=Windows SharePoint Services hostname=MOSS1 hostpid=3728 loginname=abc\mosssearch isolationlevel=read committed (2) xactid=168088262 currentdb=20 lockTimeout=4294967295 clientoption1=673316896 clientoption2=128056
2010-04-05 03:44:27.47 spid13s executionStack
2010-04-05 03:44:27.47 spid13s frame procname=SharedServices1_Search_DB.dbo.proc_MSS_ProcessCommitted line=159 stmtstart=13102 stmtend=13208 sqlhandle=0x030014003713d643a44c3301ab9c00000100000000000000
2010-04-05 03:44:27.47 spid13s DELETE FROM MSSCrawlQueue WHERE SeqID = @SeqID
2010-04-05 03:44:27.47 spid13s inputbuf
2010-04-05 03:44:27.47 spid13s Proc [Database Id = 20 Object Id = 1138103095]
2010-04-05 03:44:27.47 spid13s resource-list
2010-04-05 03:44:27.47 spid13s keylock hobtid=72057594078298112 dbid=20 objectname=SharedServices1_Search_DB.dbo.MSSCrawlQueue indexname=IX_MSSCrawlQueue_Cluster id=lock520c100 mode=X associatedObjectId=72057594078298112
2010-04-05 03:44:27.47 spid13s owner-list
2010-04-05 03:44:27.47 spid13s owner id=process3c265c8 mode=X
2010-04-05 03:44:27.47 spid13s waiter-list
2010-04-05 03:44:27.47 spid13s waiter id=process3c12c58 mode=S requestType=wait
2010-04-05 03:44:27.47 spid13s keylock hobtid=72057594072858624 dbid=20 objectname=SharedServices1_Search_DB.dbo.MSSCrawlQueue indexname=IX_MSSCrawlQueue_SeqID id=lock590df00 mode=U associatedObjectId=72057594072858624
2010-04-05 03:44:27.47 spid13s owner-list
2010-04-05 03:44:27.47 spid13s owner id=process3c12c58 mode=S
2010-04-05 03:44:27.47 spid13s waiter-list
2010-04-05 03:44:27.47 spid13s waiter id=process3c265c8 mode=X requestType=convert
thanks
April 5, 2010 at 4:17 pm
Do you know the query that is being executed by the proc sp_executesql?
That proc is really what is being deadlocked. That proc is held inside the resource database and is used to call dynamic sql in many cases.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 9, 2010 at 1:15 pm
Do you know the query that is being executed by the proc sp_executesql?
That proc is really what is being deadlocked. That proc is held inside the resource database and is used to call dynamic sql in many cases.
I did not understand that you asking about the query that is being executed by the proc sp_executesql
and I got more dead locks today and at that time NO crawl was run. So Is there any thing wrong with "mssqlsystemresource" system databases? why it is involving in the Dead lock? Please advice that is something we need address to MS or we can solve that from MOSS side or SQL Server side?
Dead Lock graph: please see the high-lated one
2010-04-08 11:52:39.42 spid12s deadlock-list
2010-04-08 11:52:39.42 spid12s deadlock victim=process3c3b2e8
2010-04-08 11:52:39.42 spid12s process-list
2010-04-08 11:52:39.42 spid12s process id=process3c125c8 taskpriority=0 logused=6644 waitresource=KEY: 20:72057594078298112 (c9004bd7d2d2) waittime=3953 ownerId=215479057 transactionname=user_transaction lasttranstarted=2010-04-08T11:52:35.470 XDES=0x86315480 lockMode=U schedulerid=2 kpid=5648 status=suspended spid=179 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2010-04-08T11:52:35.470 lastbatchcompleted=2010-04-08T11:52:35.470 clientapp=Windows SharePoint Services hostname=MOSS1 hostpid=4708 loginname=ABC\MOSSSearch isolationlevel=read committed (2) xactid=215479057 currentdb=20 lockTimeout=4294967295 clientoption1=673316896 clientoption2=128056
2010-04-08 11:52:39.42 spid12s executionStack
2010-04-08 11:52:39.42 spid12s frame procname=SharedServices1_Search_DB.dbo.proc_MSS_ProcessDelete line=188 stmtstart=15130 stmtend=15264 sqlhandle=0x03001400feeee1429d4c3301ab9c00000100000000000000
2010-04-08 11:52:39.42 spid12s DELETE FROM MSSCrawlQueue WHERE DocID=@DocID AND BatchID = 0
2010-04-08 11:52:39.42 spid12s frame procname=SharedServices1_Search_DB.dbo.proc_MSS_ProcessCommitted line=287 stmtstart=21262 stmtend=22916 sqlhandle=0x030014003713d643a44c3301ab9c00000100000000000000
2010-04-08 11:52:39.42 spid12s EXEC dbo.proc_MSS_ProcessDelete
2010-04-08 11:52:39.42 spid12s @ProjectID,
2010-04-08 11:52:39.42 spid12s @HisContentSourceID,
2010-04-08 11:52:39.42 spid12s @StartAddressID,
2010-04-08 11:52:39.42 spid12s @DocID,
2010-04-08 11:52:39.42 spid12s @CrawlID,
2010-04-08 11:52:39.42 spid12s @HisCrawlID,
2010-04-08 11:52:39.42 spid12s @HisCommitCrawlID,
2010-04-08 11:52:39.42 spid12s @Scope,
2010-04-08 11:52:39.42 spid12s @HisTransactionFlags,
2010-04-08 11:52:39.42 spid12s @UseChangeLog,
2010-04-08 11:52:39.42 spid12s @ChangeLogCookie,
2010-04-08 11:52:39.42 spid12s @ChangeLogBatchID,
2010-04-08 11:52:39.42 spid12s @DeleteReason,
2010-04-08 11:52:39.42 spid12s @TransactionType,
2010-04-08 11:52:39.42 spid12s @HostDepth,
2010-04-08 11:52:39.42 spid12s @EnumerationDepth,
2010-04-08 11:52:39.42 spid12s @HisParentDocID,
2010-04-08 11:52:39.42 spid12s @EndPathFlag,
2010-04-08 11:52:39.42 spid12s @HostID,
2010-04-08 11:52:39.42 spid12s @LCID,
2010-04-08 11:52:39.42 spid12s @ErrorID,
2010-04-08 11:52:39.42 spid12s @ErrorLevel,
2010-04-08 11:52:39.42 spid12s @AccessURL,
2010-04-08 11:52:39.42 spid12s @AccessHash,
2010-04-08 11:52:39.42 spid12s @CompactURL,
2010-04-08 11:52:39.42 spid12s @CompactHash,
2010-04-08 11:52:39.42 spid12s @DisplayURL,
2010-04-08 11:52:39.42 spid12s @DisplayHash,
2010-04-08 11:52:39.42 spid12s @MaxDocId
2010-04-08 11:52:39.42 spid12s inputbuf
2010-04-08 11:52:39.42 spid12s Proc [Database Id = 20 Object Id = 1138103095]
2010-04-08 11:52:39.42 spid12s process id=process3c3b2e8 taskpriority=0 logused=820 waitresource=KEY: 20:72057594042712064 (06003f7fd0fb) waittime=3953 ownerId=215479072 transactionname=user_transaction lasttranstarted=2010-04-08T11:52:35.470 XDES=0x2c0688700 lockMode=X schedulerid=6 kpid=5984 status=suspended spid=142 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2010-04-08T11:52:35.470 lastbatchcompleted=2010-04-08T11:52:35.470 clientapp=Windows SharePoint Services hostname=MOSS1 hostpid=4708 loginname=ABC\MOSSSearch isolationlevel=read committed (2) xactid=215479072 currentdb=20 lockTimeout=4294967295 clientoption1=673316896 clientoption2=128056
2010-04-08 11:52:39.42 spid12s executionStack
2010-04-08 11:52:39.42 spid12s frame procname=SharedServices1_Search_DB.dbo.proc_MSS_UpdateHostStats line=43 stmtstart=3130 sqlhandle=0x03001400c5caed41994c3301ab9c00000100000000000000
2010-04-08 11:52:39.42 spid12s UPDATE MSSCrawlHostList SET
2010-04-08 11:52:39.42 spid12s SuccessCount = CASE WHEN SuccessCount + @SuccessCount > 0 THEN SuccessCount + @SuccessCount ELSE 0 END,
2010-04-08 11:52:39.42 spid12s ErrorCount = CASE WHEN ErrorCount + @ErrorCount > 0 THEN ErrorCount + @ErrorCount ELSE 0 END,
2010-04-08 11:52:39.42 spid12s WarningCount = CASE WHEN WarningCount + @WarningCount > 0 THEN WarningCount + @WarningCount ELSE 0 END
2010-04-08 11:52:39.42 spid12s WHERE HostID = @HostID
2010-04-08 11:52:39.42 spid12s frame procname=SharedServices1_Search_DB.dbo.proc_MSS_ProcessCommitted line=163 stmtstart=13288 stmtend=13616 sqlhandle=0x030014003713d643a44c3301ab9c00000100000000000000
2010-04-08 11:52:39.42 spid12s EXEC dbo.proc_MSS_UpdateHostStats @HostID, @TransactionType, @MarkDelete, @ErrorID, @ErrorLevel, @HisCommitCrawlID, @HisErrorLevel, @TrackIDDel, @DelErrorLevel
2010-04-08 11:52:39.42 spid12s inputbuf
2010-04-08 11:52:39.42 spid12s Proc [Database Id = 20 Object Id = 1138103095]
2010-04-08 11:52:39.42 spid12s resource-list
2010-04-08 11:52:39.42 spid12s keylock hobtid=72057594078298112 dbid=20 objectname=SharedServices1_Search_DB.dbo.MSSCrawlQueue indexname=IX_MSSCrawlQueue_Cluster id=lock43b3e00 mode=X associatedObjectId=72057594078298112
2010-04-08 11:52:39.42 spid12s owner-list
2010-04-08 11:52:39.42 spid12s owner id=process3c3b2e8 mode=X
2010-04-08 11:52:39.42 spid12s waiter-list
2010-04-08 11:52:39.42 spid12s waiter id=process3c125c8 mode=U requestType=wait
2010-04-08 11:52:39.42 spid12s keylock hobtid=72057594042712064 dbid=20 objectname=SharedServices1_Search_DB.dbo.MSSCrawlHostList indexname=PK_MSSCrawlHostList id=lock5088c00 mode=X associatedObjectId=72057594042712064
2010-04-08 11:52:39.42 spid12s owner-list
2010-04-08 11:52:39.42 spid12s owner id=process3c125c8 mode=X
2010-04-08 11:52:39.42 spid12s waiter-list
2010-04-08 11:52:39.42 spid12s waiter id=process3c3b2e8 mode=X requestType=wait
2010-04-08 11:52:44.42 spid12s deadlock-list
2010-04-08 11:52:44.42 spid20s deadlock-list
2010-04-08 11:52:44.42 spid12s deadlock victim=process3c44da8
2010-04-08 11:52:44.42 spid20s deadlock victim=process3c13198
2010-04-08 11:52:44.42 spid12s process-list
2010-04-08 11:52:44.42 spid20s process-list
2010-04-08 11:52:44.42 spid12s process id=process3c1d198 taskpriority=0 logused=9044 waitresource=KEY: 20:72057594078298112 (d90091aa66f9) waittime=4859 ownerId=215480382 transactionname=user_transaction lasttranstarted=2010-04-08T11:52:39.560 XDES=0x2f53e7170 lockMode=U schedulerid=3 kpid=568 status=suspended spid=201 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2010-04-08T11:52:39.560 lastbatchcompleted=2010-04-08T11:52:39.560 clientapp=Windows SharePoint Services hostname=MOSS1 hostpid=4708 loginname=ABC\MOSSSearch isolationlevel=read committed (2) xactid=215480382 currentdb=20 lockTimeout=4294967295 clientoption1=673316896 clientoption2=128056
2010-04-08 11:52:44.42 spid20s process id=process3c13198 taskpriority=0 logused=232 waitresource=KEY: 20:72057594078298112 (d90091aa66f9) waittime=4859 ownerId=215480404 transactionname=user_transaction lasttranstarted=2010-04-08T11:52:39.563 XDES=0x86315480 lockMode=S schedulerid=2 kpid=5656 status=suspended spid=155 sbid=0 ecid=0 priority=0 transcount=1 lastbatchstarted=2010-04-08T11:52:39.563 lastbatchcompleted=2010-04-08T11:52:39.563 clientapp=Windows SharePoint Services hostname=MOSS1 hostpid=4708 loginname=ABC\MOSSSearch isolationlevel=read committed (2) xactid=215480404 currentdb=20 lockTimeout=4294967295 clientoption1=673316896 clientoption2=128056
2010-04-08 11:52:44.42 spid12s executionStack
2010-04-08 11:52:44.42 spid20s executionStack
2010-04-08 11:52:44.42 spid20s frame procname=SharedServices1_Search_DB.dbo.proc_MSS_GetNextCrawlBatch line=105 stmtstart=9484 stmtend=11582 sqlhandle=0x03001400c610834ac84c3301ab9c00000100000000000000
2010-04-08 11:52:44.42 spid12s frame procname=SharedServices1_Search_DB.dbo.proc_MSS_ProcessDelete line=188 stmtstart=15130 stmtend=15264 sqlhandle=0x03001400feeee1429d4c3301ab9c00000100000000000000
2010-04-08 11:52:44.42 spid20s SELECT A.CrawlID,
2010-04-08 11:52:44.42 spid20s A.SourceDocID,
2010-04-08 11:52:44.42 spid12s DELETE FROM MSSCrawlQueue WHERE DocID=@DocID AND BatchID = 0
2010-04-08 11:52:44.42 spid20s A.DocID,
2010-04-08 11:52:44.42 spid20s B.DisplayURL,
2010-04-08 11:52:44.42 spid20s B.AccessURL,
2010-04-08 11:52:44.42 spid12s frame procname=SharedServices1_Search_DB.dbo.proc_MSS_ProcessCommitted line=287 stmtstart=21262 stmtend=22916 sqlhandle=0x030014003713d643a44c3301ab9c00000100000000000000
2010-04-08 11:52:44.42 spid20s B.CompactURL,
2010-04-08 11:52:44.42 spid12s EXEC dbo.proc_MSS_ProcessDelete
2010-04-08 11:52:44.42 spid20s B.EndPathFlag,
2010-04-08 11:52:44.42 spid12s @ProjectID,
2010-04-08 11:52:44.42 spid20s A.StartAddressID,
2010-04-08 11:52:44.42 spid12s @HisContentSourceID,
2010-04-08 11:52:44.42 spid20s A.HostDepth,
2010-04-08 11:52:44.42 spid12s @StartAddressID,
2010-04-08 11:52:44.42 spid20s A.EnumerationDepth,
2010-04-08 11:52:44.42 spid12s @DocID,
2010-04-08 11:52:44.42 spid20s A.TransactionFlags,
2010-04-08 11:52:44.42 spid12s @CrawlID,
2010-04-08 11:52:44.42 spid20s MD5,
2010-04-08 11:52:44.42 spid12s @HisCrawlID,
2010-04-08 11:52:44.42 spid20s PropMD5,
2010-04-08 11:52:44.42 spid12s @HisCommitCrawlID,
2010-04-08 11:52:44.42 spid20s UseChangeLog,
2010-04-08 11:52:44.42 spid12s @Scope,
2010-04-08 11:52:44.42 spid20s IndexType,
2010-04-08 11:52:44.42 spid12s @HisTransactionFlags,
2010-04-08 11:52:44.42 spid20s LastModifiedTime,
2010-04-08 11:52:44.42 spid12s @UseChangeLog,
2010-04-08 11:52:44.42 spid20s FolderDelCount,
2010-04-08 11:52:44.42 spid12s @ChangeLogCookie,
2010-04-08 11:52:44.42 spid20s CONVERT(bigint, 0),
2010-04-08 11:52:44.42 spid12s @ChangeLogBatchID,
2010-04-08 11:52:44.42 spid20s CONVERT(bigint, 0),
2010-04-08 11:52:44.42 spid12s @DeleteReason,
2010-04-08 11:52:44.42 spid20s 0,
2010-04-08 11:52:44.42 spid12s @TransactionType,
2010-04-08 11:52:44.42 spid20s 0,
2010-04-08 11:52:44.42 spid12s @HostDepth,
2010-04-08 11:52:44.42 spid20s TransactionType,
2010-04-08 11:52:44.42 spid12s @EnumerationDepth,
2010-04-08 11:52:44.42 spid20s LCID,
2010-04-08 11:52:44.42 spid12s @HisParentDocID,
2010-04-08 11:52:44.42 spid20s ItemType,
2010-04-08 11:52:44.42 spid12s @EndPathFlag,
2010-04-08 11:52:44.42 spid20s A.FolderHighPriority,
2010-04-08 11:52:44.42 spid12s @HostID,
2010-04-08 11:52:44.42 spid20s A.ItemHighPriority,
2010-04-08 11:52:44.42 spid12s @LCID,
2010-04-08 11:52:44.42 spid20s A.SeqID,
2010-04-08 11:52:44.42 spid12s @ErrorID,
2010-04-08 11:52:44.42 spid20s B.ChangeLogCookie,
2010-04-08 11:52:44.42 spid12s @ErrorLevel,
2010-04-08 11:52:44.42 spid20s ChangeLogBatchID,
2010-04-08 11:52:44.42 spid12s @AccessURL,
2010-04-08 11:52:44.42 spid20s SCOPE,
2010-04-08 11:52:44.42 spid12s @AccessHash,
2010-04-08 11:52:44.42 spid20s B.DocPropsMD5,
2010-04-08 11:52:44.42 spid12s @CompactURL,
2010-04-08 11:52:44.42 spid20s B.Retry
2010-04-08 11:52:44.42 spid12s @CompactHash,
2010-04-08 11:52:44.42 spid20s FROM MSSCrawlQueue A
2010-04-08 11:52:44.42 spid12s @DisplayURL,
2010-04-08 11:52:44.42 spid20s INNER JOIN MSSCrawlURL B WITH(NOLOCK)
2010-04-08 11:52:44.42 spid12s @DisplayHash,
2010-04-08 11:52:44.42 spid20s ON A.DocID = B.DocID
2010-04-08 11:52:44.42 spid12s @MaxDocId
2010-04-08 11:52:44.42 spid12s inputbuf
2010-04-08 11:52:44.42 spid20s WHERE A.CrawlID = @CrawlID AND A.BatchID = @BatchID
2010-04-08 11:52:44.42 spid20s inputbuf
2010-04-08 11:52:44.42 spid12s Proc [Database Id = 20 Object Id = 1138103095]
2010-04-08 11:52:44.42 spid20s Proc [Database Id = 20 Object Id = 1250103494]
2010-04-08 11:52:44.42 spid12s process id=process3c44da8 taskpriority=0 logused=820 waitresource=KEY: 20:72057594042712064 (06003f7fd0fb) waittime=4859 ownerId=215480395 transactionname=user_transaction lasttranstarted=2010-04-08T11:52:39.560 XDES=0x2635eade0 lockMode=X schedulerid=7 kpid=2928 status=suspended spid=197 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2010-04-08T11:52:39.560 lastbatchcompleted=2010-04-08T11:52:39.560 clientapp=Windows SharePoint Services hostname=MOSS1 hostpid=4708 loginname=ABC\MOSSSearch isolationlevel=read committed (2) xactid=215480395 currentdb=20 lockTimeout=4294967295 clientoption1=673316896 clientoption2=128056
2010-04-08 11:52:44.42 spid20s process id=process3c1d198 taskpriority=0 logused=9044 waitresource=KEY: 20:72057594078298112 (d90091aa66f9) waittime=4859 ownerId=215480382 transactionname=user_transaction lasttranstarted=2010-04-08T11:52:39.560 XDES=0x2f53e7170 lockMode=U schedulerid=3 kpid=568 status=suspended spid=201 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2010-04-08T11:52:39.560 lastbatchcompleted=2010-04-08T11:52:39.560 clientapp=Windows SharePoint Services hostname=MOSS1 hostpid=4708 loginname=ABC\MOSSSearch isolationlevel=read committed (2) xactid=215480382 currentdb=20 lockTimeout=4294967295 clientoption1=673316896 clientoption2=128056
2010-04-08 11:52:44.42 spid12s executionStack
2010-04-08 11:52:44.42 spid20s executionStack
2010-04-08 11:52:44.42 spid12s frame procname=SharedServices1_Search_DB.dbo.proc_MSS_UpdateHostStats line=43 stmtstart=3130 sqlhandle=0x03001400c5caed41994c3301ab9c00000100000000000000
2010-04-08 11:52:44.42 spid20s frame procname=SharedServices1_Search_DB.dbo.proc_MSS_ProcessDelete line=188 stmtstart=15130 stmtend=15264 sqlhandle=0x03001400feeee1429d4c3301ab9c00000100000000000000
2010-04-08 11:52:44.42 spid12s UPDATE MSSCrawlHostList SET
2010-04-08 11:52:44.42 spid20s DELETE FROM MSSCrawlQueue WHERE DocID=@DocID AND BatchID = 0
2010-04-08 11:52:44.42 spid12s SuccessCount = CASE WHEN SuccessCount + @SuccessCount > 0 THEN SuccessCount + @SuccessCount ELSE 0 END,
2010-04-08 11:52:44.42 spid20s frame procname=SharedServices1_Search_DB.dbo.proc_MSS_ProcessCommitted line=287 stmtstart=21262 stmtend=22916 sqlhandle=0x030014003713d643a44c3301ab9c00000100000000000000
2010-04-08 11:52:44.42 spid12s ErrorCount = CASE WHEN ErrorCount + @ErrorCount > 0 THEN ErrorCount + @ErrorCount ELSE 0 END,
2010-04-08 11:52:44.42 spid20s EXEC dbo.proc_MSS_ProcessDelete
2010-04-08 11:52:44.42 spid20s @ProjectID,
2010-04-08 11:52:44.42 spid12s WarningCount = CASE WHEN WarningCount + @WarningCount > 0 THEN WarningCount + @WarningCount ELSE 0 END
2010-04-08 11:52:44.42 spid20s @HisContentSourceID,
2010-04-08 11:52:44.42 spid12s WHERE HostID = @HostID
2010-04-08 11:52:44.42 spid20s @StartAddressID,
2010-04-08 11:52:44.42 spid20s @DocID,
2010-04-08 11:52:44.42 spid20s @CrawlID,
2010-04-08 11:52:44.42 spid20s @HisCrawlID,
2010-04-08 11:52:44.42 spid12s frame procname=SharedServices1_Search_DB.dbo.proc_MSS_ProcessCommitted line=163 stmtstart=13288 stmtend=13616 sqlhandle=0x030014003713d643a44c3301ab9c00000100000000000000
2010-04-08 11:52:44.42 spid20s @HisCommitCrawlID,
2010-04-08 11:52:44.42 spid20s @Scope,
2010-04-08 11:52:44.42 spid20s @HisTransactionFlags,
2010-04-08 11:52:44.42 spid20s @UseChangeLog,
2010-04-08 11:52:44.42 spid12s EXEC dbo.proc_MSS_UpdateHostStats @HostID, @TransactionType, @MarkDelete, @ErrorID, @ErrorLevel, @HisCommitCrawlID, @HisErrorLevel, @TrackIDDel, @DelErrorLevel
2010-04-08 11:52:44.42 spid20s @ChangeLogCookie,
2010-04-08 11:52:44.42 spid12s inputbuf
2010-04-08 11:52:44.42 spid20s @ChangeLogBatchID,
2010-04-08 11:52:44.42 spid12s Proc [Database Id = 20 Object Id = 1138103095]
2010-04-08 11:52:44.42 spid20s @DeleteReason,
2010-04-08 11:52:44.42 spid12s resource-list
2010-04-08 11:52:44.42 spid20s @TransactionType,
2010-04-08 11:52:44.42 spid20s @HostDepth,
2010-04-08 11:52:44.42 spid20s @EnumerationDepth,
2010-04-08 11:52:44.42 spid20s @HisParentDocID,
2010-04-08 11:52:44.42 spid12s keylock hobtid=72057594078298112 dbid=20 objectname=SharedServices1_Search_DB.dbo.MSSCrawlQueue indexname=IX_MSSCrawlQueue_Cluster id=lock3cb3e80 mode=X associatedObjectId=72057594078298112
2010-04-08 11:52:44.42 spid20s @EndPathFlag,
2010-04-08 11:52:44.42 spid12s owner-list
2010-04-08 11:52:44.42 spid20s @HostID,
2010-04-08 11:52:44.42 spid12s owner id=process3c44da8 mode=X
2010-04-08 11:52:44.42 spid20s @LCID,
2010-04-08 11:52:44.42 spid12s waiter-list
2010-04-08 11:52:44.42 spid20s @ErrorID,
2010-04-08 11:52:44.42 spid20s @ErrorLevel,
2010-04-08 11:52:44.42 spid12s waiter id=process3c1d198 mode=U requestType=wait
2010-04-08 11:52:44.42 spid20s @AccessURL,
2010-04-08 11:52:44.42 spid20s @AccessHash,
2010-04-08 11:52:44.42 spid20s @CompactURL,
2010-04-08 11:52:44.42 spid20s @CompactHash,
2010-04-08 11:52:44.42 spid12s keylock hobtid=72057594042712064 dbid=20 objectname=SharedServices1_Search_DB.dbo.MSSCrawlHostList indexname=PK_MSSCrawlHostList id=lock5286f00 mode=X associatedObjectId=72057594042712064
2010-04-08 11:52:44.42 spid20s @DisplayURL,
2010-04-08 11:52:44.42 spid12s owner-list
2010-04-08 11:52:44.42 spid20s @DisplayHash,
2010-04-08 11:52:44.42 spid12s owner id=process3c1d198 mode=X
2010-04-08 11:52:44.42 spid20s @MaxDocId
2010-04-08 11:52:44.42 spid12s waiter-list
2010-04-08 11:52:44.42 spid20s inputbuf
2010-04-08 11:52:44.42 spid12s waiter id=process3c44da8 mode=X requestType=wait
2010-04-08 11:52:44.42 spid20s Proc [Database Id = 20 Object Id = 1138103095]
2010-04-08 11:52:44.42 spid20s process id=process3c44da8 taskpriority=0 logused=820 waitresource=KEY: 20:72057594042712064 (06003f7fd0fb) waittime=4859 ownerId=215480395 transactionname=user_transaction lasttranstarted=2010-04-08T11:52:39.560 XDES=0x2635eade0 lockMode=X schedulerid=7 kpid=2928 status=suspended spid=197 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2010-04-08T11:52:39.560 lastbatchcompleted=2010-04-08T11:52:39.560 clientapp=Windows SharePoint Services hostname=MOSS1 hostpid=4708 loginname=ABC\MOSSSearch isolationlevel=read committed (2) xactid=215480395 currentdb=20 lockTimeout=4294967295 clientoption1=673316896 clientoption2=128056
2010-04-08 11:52:44.42 spid20s executionStack
2010-04-08 11:52:44.42 spid20s frame procname=SharedServices1_Search_DB.dbo.proc_MSS_UpdateHostStats line=43 stmtstart=3130 sqlhandle=0x03001400c5caed41994c3301ab9c00000100000000000000
2010-04-08 11:52:44.42 spid20s UPDATE MSSCrawlHostList SET
2010-04-08 11:52:44.42 spid20s SuccessCount = CASE WHEN SuccessCount + @SuccessCount > 0 THEN SuccessCount + @SuccessCount ELSE 0 END,
2010-04-08 11:52:44.42 spid20s ErrorCount = CASE WHEN ErrorCount + @ErrorCount > 0 THEN ErrorCount + @ErrorCount ELSE 0 END,
2010-04-08 11:52:44.42 spid20s WarningCount = CASE WHEN WarningCount + @WarningCount > 0 THEN WarningCount + @WarningCount ELSE 0 END
2010-04-08 11:52:44.42 spid20s WHERE HostID = @HostID
2010-04-08 11:52:44.42 spid20s frame procname=SharedServices1_Search_DB.dbo.proc_MSS_ProcessCommitted line=163 stmtstart=13288 stmtend=13616 sqlhandle=0x030014003713d643a44c3301ab9c00000100000000000000
2010-04-08 11:52:44.42 spid20s EXEC dbo.proc_MSS_UpdateHostStats @HostID, @TransactionType, @MarkDelete, @ErrorID, @ErrorLevel, @HisCommitCrawlID, @HisErrorLevel, @TrackIDDel, @DelErrorLevel
2010-04-08 11:52:44.42 spid20s inputbuf
2010-04-08 11:52:44.42 spid20s Proc [Database Id = 20 Object Id = 1138103095]
2010-04-08 11:52:44.42 spid20s resource-list
2010-04-08 11:52:44.42 spid20s keylock hobtid=72057594078298112 dbid=20 objectname=SharedServices1_Search_DB.dbo.MSSCrawlQueue indexname=IX_MSSCrawlQueue_Cluster id=lock3cb3e80 mode=X associatedObjectId=72057594078298112
2010-04-08 11:52:44.42 spid20s owner-list
2010-04-08 11:52:44.42 spid20s owner id=process3c44da8 mode=X
2010-04-08 11:52:44.42 spid20s waiter-list
2010-04-08 11:52:44.42 spid20s waiter id=process3c13198 mode=S requestType=wait
2010-04-08 11:52:44.42 spid20s waiter id=process3c1d198 mode=U requestType=wait
2010-04-08 11:52:44.42 spid20s keylock hobtid=72057594042712064 dbid=20 objectname=SharedServices1_Search_DB.dbo.MSSCrawlHostList indexname=PK_MSSCrawlHostList id=lock5286f00 mode=X associatedObjectId=72057594042712064
2010-04-08 11:52:44.42 spid20s owner-list
2010-04-08 11:52:44.42 spid20s owner id=process3c1d198 mode=X
2010-04-08 11:52:44.42 spid20s waiter-list
2010-04-08 11:52:44.43 spid20s waiter id=process3c44da8 mode=X requestType=wait
2010-04-08 11:52:49.42 spid12s deadlock-list
2010-04-08 11:52:49.42 spid12s deadlock victim=process3c3b2e8
2010-04-08 11:52:49.42 spid12s process-list
2010-04-08 11:52:49.42 spid12s process id=process3c08718 taskpriority=0 logused=5948 waitresource=KEY: 20:72057594078298112 (0b01bfcef1ea) waittime=5000 ownerId=215480445 transactionname=user_transaction lasttranstarted=2010-04-08T11:52:39.943 XDES=0x80055580 lockMode=U schedulerid=1 kpid=4476 status=suspended spid=202 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2010-04-08T11:52:39.943 lastbatchcompleted=2010-04-08T11:52:39.943 clientapp=Windows SharePoint Services hostname=MOSS1 hostpid=4708 loginname=ABC\MOSSSearch isolationlevel=read committed (2) xactid=215480445 currentdb=20 lockTimeout=4294967295 clientoption1=673316896 clientoption2=128056
2010-04-08 11:52:49.42 spid12s executionStack
2010-04-08 11:52:49.42 spid12s frame procname=SharedServices1_Search_DB.dbo.proc_MSS_ProcessDelete line=188 stmtstart=15130 stmtend=15264 sqlhandle=0x03001400feeee1429d4c3301ab9c00000100000000000000
2010-04-08 11:52:49.42 spid12s DELETE FROM MSSCrawlQueue WHERE DocID=@DocID AND BatchID = 0
2010-04-08 11:52:49.42 spid12s frame procname=SharedServices1_Search_DB.dbo.proc_MSS_ProcessCommitted line=287 stmtstart=21262 stmtend=22916 sqlhandle=0x030014003713d643a44c3301ab9c00000100000000000000
2010-04-08 11:52:49.42 spid12s EXEC dbo.proc_MSS_ProcessDelete
2010-04-08 11:52:49.42 spid12s @ProjectID,
2010-04-08 11:52:49.42 spid12s @HisContentSourceID,
2010-04-08 11:52:49.42 spid12s @StartAddressID,
2010-04-08 11:52:49.42 spid12s @DocID,
2010-04-08 11:52:49.42 spid12s @CrawlID,
2010-04-08 11:52:49.42 spid12s @HisCrawlID,
2010-04-08 11:52:49.42 spid12s @HisCommitCrawlID,
2010-04-08 11:52:49.42 spid12s @Scope,
2010-04-08 11:52:49.42 spid12s @HisTransactionFlags,
2010-04-08 11:52:49.42 spid12s @UseChangeLog,
2010-04-08 11:52:49.42 spid12s @ChangeLogCookie,
2010-04-08 11:52:49.42 spid12s @ChangeLogBatchID,
2010-04-08 11:52:49.42 spid12s @DeleteReason,
2010-04-08 11:52:49.42 spid12s @TransactionType,
2010-04-08 11:52:49.42 spid12s @HostDepth,
2010-04-08 11:52:49.42 spid12s @EnumerationDepth,
2010-04-08 11:52:49.42 spid12s @HisParentDocID,
2010-04-08 11:52:49.42 spid12s @EndPathFlag,
2010-04-08 11:52:49.42 spid12s @HostID,
2010-04-08 11:52:49.42 spid12s @LCID,
2010-04-08 11:52:49.42 spid12s @ErrorID,
2010-04-08 11:52:49.42 spid12s @ErrorLevel,
2010-04-08 11:52:49.42 spid12s @AccessURL,
2010-04-08 11:52:49.42 spid12s @AccessHash,
2010-04-08 11:52:49.42 spid12s @CompactURL,
2010-04-08 11:52:49.42 spid12s @CompactHash,
2010-04-08 11:52:49.42 spid12s @DisplayURL,
2010-04-08 11:52:49.42 spid12s @DisplayHash,
2010-04-08 11:52:49.42 spid12s @MaxDocId
2010-04-08 11:52:49.42 spid12s inputbuf
2010-04-08 11:52:49.42 spid12s Proc [Database Id = 20 Object Id = 1138103095]
2010-04-08 11:52:49.42 spid12s process id=process3c3b2e8 taskpriority=0 logused=820 waitresource=KEY: 20:72057594042712064 (06003f7fd0fb) waittime=5000 ownerId=215480436 transactionname=user_transaction lasttranstarted=2010-04-08T11:52:39.840 XDES=0x19a0b3760 lockMode=X schedulerid=6 kpid=5984 status=suspended spid=196 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2010-04-08T11:52:39.840 lastbatchcompleted=2010-04-08T11:52:39.840 clientapp=Windows SharePoint Services hostname=MOSS1 hostpid=4708 loginname=ABC\MOSSSearch isolationlevel=read committed (2) xactid=215480436 currentdb=20 lockTimeout=4294967295 clientoption1=673316896 clientoption2=128056
2010-04-08 11:52:49.42 spid12s executionStack
2010-04-08 11:52:49.42 spid12s frame procname=SharedServices1_Search_DB.dbo.proc_MSS_UpdateHostStats line=43 stmtstart=3130 sqlhandle=0x03001400c5caed41994c3301ab9c00000100000000000000
2010-04-08 11:52:49.42 spid12s UPDATE MSSCrawlHostList SET
2010-04-08 11:52:49.42 spid12s SuccessCount = CASE WHEN SuccessCount + @SuccessCount > 0 THEN SuccessCount + @SuccessCount ELSE 0 END,
2010-04-08 11:52:49.42 spid12s ErrorCount = CASE WHEN ErrorCount + @ErrorCount > 0 THEN ErrorCount + @ErrorCount ELSE 0 END,
2010-04-08 11:52:49.42 spid12s WarningCount = CASE WHEN WarningCount + @WarningCount > 0 THEN WarningCount + @WarningCount ELSE 0 END
2010-04-08 11:52:49.42 spid12s WHERE HostID = @HostID
2010-04-08 11:52:49.42 spid12s frame procname=SharedServices1_Search_DB.dbo.proc_MSS_ProcessCommitted line=163 stmtstart=13288 stmtend=13616 sqlhandle=0x030014003713d643a44c3301ab9c00000100000000000000
2010-04-08 11:52:49.42 spid12s EXEC dbo.proc_MSS_UpdateHostStats @HostID, @TransactionType, @MarkDelete, @ErrorID, @ErrorLevel, @HisCommitCrawlID, @HisErrorLevel, @TrackIDDel, @DelErrorLevel
2010-04-08 11:52:49.42 spid12s inputbuf
2010-04-08 11:52:49.42 spid12s Proc [Database Id = 20 Object Id = 1138103095]
2010-04-08 11:52:49.42 spid12s resource-list
2010-04-08 11:52:49.42 spid12s keylock hobtid=72057594042712064 dbid=20 objectname=SharedServices1_Search_DB.dbo.MSSCrawlHostList indexname=PK_MSSCrawlHostList id=lock4c6db00 mode=X associatedObjectId=72057594042712064
2010-04-08 11:52:49.42 spid12s owner-list
2010-04-08 11:52:49.42 spid12s owner id=process3c08718 mode=X
2010-04-08 11:52:49.42 spid12s waiter-list
2010-04-08 11:52:49.42 spid12s waiter id=process3c3b2e8 mode=X requestType=wait
2010-04-08 11:52:49.42 spid12s keylock hobtid=72057594078298112 dbid=20 objectname=SharedServices1_Search_DB.dbo.MSSCrawlQueue indexname=IX_MSSCrawlQueue_Cluster id=lock5089280 mode=X associatedObjectId=72057594078298112
2010-04-08 11:52:49.42 spid12s owner-list
2010-04-08 11:52:49.42 spid12s owner id=process3c3b2e8 mode=X
2010-04-08 11:52:49.42 spid12s waiter-list
2010-04-08 11:52:49.42 spid12s waiter id=process3c08718 mode=U requestType=wait
2010-04-08 11:52:54.43 spid16s deadlock-list
2010-04-08 11:52:54.43 spid16s deadlock victim=process3c3b2e8
2010-04-08 11:52:54.43 spid16s process-list
2010-04-08 11:52:54.43 spid16s process id=process3c30478 taskpriority=0 logused=12296 waitresource=KEY: 20:72057594078298112 (9100e242a57f) waittime=4921 ownerId=215481485 transactionname=user_transaction lasttranstarted=2010-04-08T11:52:49.500 XDES=0x2bfc8b5d0 lockMode=U schedulerid=5 kpid=5724 status=suspended spid=202 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2010-04-08T11:52:49.500 lastbatchcompleted=2010-04-08T11:52:49.500 clientapp=Windows SharePoint Services hostname=MOSS1 hostpid=4708 loginname=ABC\MOSSSearch isolationlevel=read committed (2) xactid=215481485 currentdb=20 lockTimeout=4294967295 clientoption1=673316896 clientoption2=128056
2010-04-08 11:52:54.43 spid16s executionStack
2010-04-08 11:52:54.43 spid16s frame procname=SharedServices1_Search_DB.dbo.proc_MSS_ProcessDelete line=188 stmtstart=15130 stmtend=15264 sqlhandle=0x03001400feeee1429d4c3301ab9c00000100000000000000
2010-04-08 11:52:54.43 spid16s DELETE FROM MSSCrawlQueue WHERE DocID=@DocID AND BatchID = 0
2010-04-08 11:52:54.43 spid16s frame procname=SharedServices1_Search_DB.dbo.proc_MSS_ProcessCommitted line=287 stmtstart=21262 stmtend=22916 sqlhandle=0x030014003713d643a44c3301ab9c00000100000000000000
2010-04-08 11:52:54.43 spid16s EXEC dbo.proc_MSS_ProcessDelete
2010-04-08 11:52:54.43 spid16s @ProjectID,
2010-04-08 11:52:54.43 spid16s @HisContentSourceID,
2010-04-08 11:52:54.43 spid16s @StartAddressID,
2010-04-08 11:52:54.43 spid16s @DocID,
2010-04-08 11:52:54.43 spid16s @CrawlID,
2010-04-08 11:52:54.43 spid16s @HisCrawlID,
2010-04-08 11:52:54.43 spid16s @HisCommitCrawlID,
2010-04-08 11:52:54.43 spid16s @Scope,
2010-04-08 11:52:54.43 spid16s @HisTransactionFlags,
2010-04-08 11:52:54.43 spid16s @UseChangeLog,
2010-04-08 11:52:54.43 spid16s @ChangeLogCookie,
2010-04-08 11:52:54.43 spid16s @ChangeLogBatchID,
2010-04-08 11:52:54.43 spid16s @DeleteReason,
2010-04-08 11:52:54.43 spid16s @TransactionType,
2010-04-08 11:52:54.43 spid16s @HostDepth,
2010-04-08 11:52:54.43 spid16s @EnumerationDepth,
2010-04-08 11:52:54.43 spid16s @HisParentDocID,
2010-04-08 11:52:54.43 spid16s @EndPathFlag,
2010-04-08 11:52:54.43 spid16s @HostID,
2010-04-08 11:52:54.43 spid16s @LCID,
2010-04-08 11:52:54.43 spid16s @ErrorID,
2010-04-08 11:52:54.43 spid16s @ErrorLevel,
2010-04-08 11:52:54.43 spid16s @AccessURL,
2010-04-08 11:52:54.43 spid16s @AccessHash,
2010-04-08 11:52:54.43 spid16s @CompactURL,
2010-04-08 11:52:54.43 spid16s @CompactHash,
2010-04-08 11:52:54.43 spid16s @DisplayURL,
2010-04-08 11:52:54.43 spid16s @DisplayHash,
2010-04-08 11:52:54.43 spid16s @MaxDocId
2010-04-08 11:52:54.43 spid16s inputbuf
2010-04-08 11:52:54.43 spid16s Proc [Database Id = 20 Object Id = 1138103095]
2010-04-08 11:52:54.44 spid16s process id=process3c3b2e8 taskpriority=0 logused=820 waitresource=KEY: 20:72057594042712064 (06003f7fd0fb) waittime=4937 ownerId=215481496 transactionname=user_transaction lasttranstarted=2010-04-08T11:52:49.503 XDES=0x19a0b3760 lockMode=X schedulerid=6 kpid=5984 status=suspended spid=197 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2010-04-08T11:52:49.503 lastbatchcompleted=2010-04-08T11:52:49.503 clientapp=Windows SharePoint Services hostname=MOSS1 hostpid=4708 loginname=ABC\MOSSSearch isolationlevel=read committed (2) xactid=215481496 currentdb=20 lockTimeout=4294967295 clientoption1=673316896 clientoption2=128056
2010-04-08 11:52:54.44 spid16s executionStack
2010-04-08 11:52:54.44 spid16s frame procname=SharedServices1_Search_DB.dbo.proc_MSS_UpdateHostStats line=43 stmtstart=3130 sqlhandle=0x03001400c5caed41994c3301ab9c00000100000000000000
2010-04-08 11:52:54.44 spid16s UPDATE MSSCrawlHostList SET
2010-04-08 11:52:54.44 spid16s SuccessCount = CASE WHEN SuccessCount + @SuccessCount > 0 THEN SuccessCount + @SuccessCount ELSE 0 END,
2010-04-08 11:52:54.44 spid16s ErrorCount = CASE WHEN ErrorCount + @ErrorCount > 0 THEN ErrorCount + @ErrorCount ELSE 0 END,
2010-04-08 11:52:54.44 spid16s WarningCount = CASE WHEN WarningCount + @WarningCount > 0 THEN WarningCount + @WarningCount ELSE 0 END
2010-04-08 11:52:54.44 spid16s WHERE HostID = @HostID
2010-04-08 11:52:54.44 spid16s frame procname=SharedServices1_Search_DB.dbo.proc_MSS_ProcessCommitted line=163 stmtstart=13288 stmtend=13616 sqlhandle=0x030014003713d643a44c3301ab9c00000100000000000000
2010-04-08 11:52:54.44 spid16s EXEC dbo.proc_MSS_UpdateHostStats @HostID, @TransactionType, @MarkDelete, @ErrorID, @ErrorLevel, @HisCommitCrawlID, @HisErrorLevel, @TrackIDDel, @DelErrorLevel
2010-04-08 11:52:54.44 spid16s inputbuf
2010-04-08 11:52:54.44 spid16s Proc [Database Id = 20 Object Id = 1138103095]
2010-04-08 11:52:54.44 spid16s resource-list
2010-04-08 11:52:54.44 spid16s keylock hobtid=72057594042712064 dbid=20 objectname=SharedServices1_Search_DB.dbo.MSSCrawlHostList indexname=PK_MSSCrawlHostList id=lock5261680 mode=X associatedObjectId=72057594042712064
2010-04-08 11:52:54.44 spid16s owner-list
2010-04-08 11:52:54.44 spid16s owner id=process3c30478 mode=X
2010-04-08 11:52:54.44 spid16s waiter-list
2010-04-08 11:52:54.44 spid16s waiter id=process3c3b2e8 mode=X requestType=wait
2010-04-08 11:52:54.44 spid16s keylock hobtid=72057594078298112 dbid=20 objectname=SharedServices1_Search_DB.dbo.MSSCrawlQueue indexname=IX_MSSCrawlQueue_Cluster id=lock57be480 mode=X associatedObjectId=72057594078298112
2010-04-08 11:52:54.44 spid16s owner-list
2010-04-08 11:52:54.44 spid16s owner id=process3c3b2e8 mode=X
2010-04-08 11:52:54.44 spid16s waiter-list
2010-04-08 11:52:54.44 spid16s waiter id=process3c30478 mode=U requestType=wait
2010-04-08 11:52:59.43 spid16s deadlock-list
2010-04-08 11:52:59.43 spid16s deadlock victim=process3c13198
2010-04-08 11:52:59.43 spid16s process-list
2010-04-08 11:52:59.43 spid16s process id=process3c13198 taskpriority=0 logused=820 waitresource=KEY: 20:72057594042712064 (06003f7fd0fb) waittime=5000 ownerId=215481510 transactionname=user_transaction lasttranstarted=2010-04-08T11:52:49.523 XDES=0x86315480 lockMode=X schedulerid=2 kpid=5656 status=suspended spid=196 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2010-04-08T11:52:49.523 lastbatchcompleted=2010-04-08T11:52:49.523 clientapp=Windows SharePoint Services hostname=MOSS1 hostpid=4708 loginname=ABC\MOSSSearch isolationlevel=read committed (2) xactid=215481510 currentdb=20 lockTimeout=4294967295 clientoption1=673316896 clientoption2=128056
2010-04-08 11:52:59.43 spid16s executionStack
2010-04-08 11:52:59.43 spid16s frame procname=SharedServices1_Search_DB.dbo.proc_MSS_UpdateHostStats line=43 stmtstart=3130 sqlhandle=0x03001400c5caed41994c3301ab9c00000100000000000000
2010-04-08 11:52:59.43 spid16s UPDATE MSSCrawlHostList SET
2010-04-08 11:52:59.43 spid16s SuccessCount = CASE WHEN SuccessCount + @SuccessCount > 0 THEN SuccessCount + @SuccessCount ELSE 0 END,
2010-04-08 11:52:59.43 spid16s ErrorCount = CASE WHEN ErrorCount + @ErrorCount > 0 THEN ErrorCount + @ErrorCount ELSE 0 END,
2010-04-08 11:52:59.43 spid16s WarningCount = CASE WHEN WarningCount + @WarningCount > 0 THEN WarningCount + @WarningCount ELSE 0 END
2010-04-08 11:52:59.43 spid16s WHERE HostID = @HostID
2010-04-08 11:52:59.43 spid16s frame procname=SharedServices1_Search_DB.dbo.proc_MSS_ProcessCommitted line=163 stmtstart=13288 stmtend=13616 sqlhandle=0x030014003713d643a44c3301ab9c00000100000000000000
2010-04-08 11:52:59.43 spid16s EXEC dbo.proc_MSS_UpdateHostStats @HostID, @TransactionType, @MarkDelete, @ErrorID, @ErrorLevel, @HisCommitCrawlID, @HisErrorLevel, @TrackIDDel, @DelErrorLevel
2010-04-08 11:52:59.43 spid16s inputbuf
2010-04-08 11:52:59.43 spid16s Proc [Database Id = 20 Object Id = 1138103095]
2010-04-08 11:52:59.43 spid16s process id=process3c27588 taskpriority=0 logused=8212 waitresource=KEY: 20:72057594078298112 (0b01bfcef1ea) waittime=5000 ownerId=215481514 transactionname=user_transaction lasttranstarted=2010-04-08T11:52:49.803 XDES=0x8587b4c0 lockMode=U schedulerid=4 kpid=4672 status=suspended spid=201 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2010-04-08T11:52:49.803 lastbatchcompleted=2010-04-08T11:52:49.803 clientapp=Windows SharePoint Services hostname=MOSS1 hostpid=4708 loginname=ABC\MOSSSearch isolationlevel=read committed (2) xactid=215481514 currentdb=20 lockTimeout=4294967295 clientoption1=673316896 clientoption2=128056
2010-04-08 11:52:59.43 spid16s executionStack
2010-04-08 11:52:59.43 spid16s frame procname=SharedServices1_Search_DB.dbo.proc_MSS_ProcessDelete line=188 stmtstart=15130 stmtend=15264 sqlhandle=0x03001400feeee1429d4c3301ab9c00000100000000000000
2010-04-08 11:52:59.43 spid16s DELETE FROM MSSCrawlQueue WHERE DocID=@DocID AND BatchID = 0
2010-04-08 11:52:59.43 spid16s frame procname=SharedServices1_Search_DB.dbo.proc_MSS_ProcessCommitted line=287 stmtstart=21262 stmtend=22916 sqlhandle=0x030014003713d643a44c3301ab9c00000100000000000000
2010-04-08 11:52:59.43 spid16s EXEC dbo.proc_MSS_ProcessDelete
2010-04-08 11:52:59.43 spid16s @ProjectID,
2010-04-08 11:52:59.43 spid16s @HisContentSourceID,
2010-04-08 11:52:59.43 spid16s @StartAddressID,
2010-04-08 11:52:59.43 spid16s @DocID,
2010-04-08 11:52:59.43 spid16s @CrawlID,
2010-04-08 11:52:59.43 spid16s @HisCrawlID,
2010-04-08 11:52:59.43 spid16s @HisCommitCrawlID,
2010-04-08 11:52:59.43 spid16s @Scope,
2010-04-08 11:52:59.43 spid16s @HisTransactionFlags,
2010-04-08 11:52:59.43 spid16s @UseChangeLog,
2010-04-08 11:52:59.43 spid16s @ChangeLogCookie,
2010-04-08 11:52:59.43 spid16s @ChangeLogBatchID,
2010-04-08 11:52:59.43 spid16s @DeleteReason,
2010-04-08 11:52:59.43 spid16s @TransactionType,
2010-04-08 11:52:59.43 spid16s @HostDepth,
2010-04-08 11:52:59.43 spid16s @EnumerationDepth,
2010-04-08 11:52:59.43 spid16s @HisParentDocID,
2010-04-08 11:52:59.43 spid16s @EndPathFlag,
2010-04-08 11:52:59.43 spid16s @HostID,
2010-04-08 11:52:59.43 spid16s @LCID,
2010-04-08 11:52:59.43 spid16s @ErrorID,
2010-04-08 11:52:59.43 spid16s @ErrorLevel,
2010-04-08 11:52:59.43 spid16s @AccessURL,
2010-04-08 11:52:59.43 spid16s @AccessHash,
2010-04-08 11:52:59.43 spid16s @CompactURL,
2010-04-08 11:52:59.43 spid16s @CompactHash,
2010-04-08 11:52:59.43 spid16s @DisplayURL,
2010-04-08 11:52:59.43 spid16s @DisplayHash,
2010-04-08 11:52:59.43 spid16s @MaxDocId
2010-04-08 11:52:59.43 spid16s inputbuf
2010-04-08 11:52:59.43 spid16s Proc [Database Id = 20 Object Id = 1138103095]
2010-04-08 11:52:59.43 spid16s resource-list
2010-04-08 11:52:59.43 spid16s keylock hobtid=72057594042712064 dbid=20 objectname=SharedServices1_Search_DB.dbo.MSSCrawlHostList indexname=PK_MSSCrawlHostList id=lock4a07380 mode=X associatedObjectId=72057594042712064
2010-04-08 11:52:59.43 spid16s owner-list
2010-04-08 11:52:59.43 spid16s owner id=process3c27588 mode=X
2010-04-08 11:52:59.43 spid16s waiter-list
2010-04-08 11:52:59.43 spid16s waiter id=process3c13198 mode=X requestType=wait
2010-04-08 11:52:59.43 spid16s keylock hobtid=72057594078298112 dbid=20 objectname=SharedServices1_Search_DB.dbo.MSSCrawlQueue indexname=IX_MSSCrawlQueue_Cluster id=lock51bbb00 mode=X associatedObjectId=72057594078298112
2010-04-08 11:52:59.43 spid16s owner-list
2010-04-08 11:52:59.43 spid16s owner id=process3c13198 mode=X
2010-04-08 11:52:59.43 spid16s waiter-list
2010-04-08 11:52:59.43 spid16s waiter id=process3c27588 mode=U requestType=wait
2010-04-08 11:53:01.93 spid17s deadlock-list
2010-04-08 11:53:01.93 spid17s deadlock victim=process3c30478
2010-04-08 11:53:01.93 spid17s process-list
2010-04-08 11:53:01.93 spid17s process id=process3c27588 taskpriority=0 logused=13504 waitresource=KEY: 20:72057594078298112 (9b004e7a71c5) waittime=2437 ownerId=215482219 transactionname=user_transaction lasttranstarted=2010-04-08T11:52:59.493 XDES=0x8587b4c0 lockMode=U schedulerid=4 kpid=4672 status=suspended spid=201 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2010-04-08T11:52:59.493 lastbatchcompleted=2010-04-08T11:52:59.493 clientapp=Windows SharePoint Services hostname=MOSS1 hostpid=4708 loginname=ABC\MOSSSearch isolationlevel=read committed (2) xactid=215482219 currentdb=20 lockTimeout=4294967295 clientoption1=673316896 clientoption2=128056
2010-04-08 11:53:01.93 spid17s executionStack
2010-04-08 11:53:01.93 spid17s frame procname=SharedServices1_Search_DB.dbo.proc_MSS_ProcessDelete line=188 stmtstart=15130 stmtend=15264 sqlhandle=0x03001400feeee1429d4c3301ab9c00000100000000000000
2010-04-08 11:53:01.93 spid17s DELETE FROM MSSCrawlQueue WHERE DocID=@DocID AND BatchID = 0
2010-04-08 11:53:01.93 spid17s frame procname=SharedServices1_Search_DB.dbo.proc_MSS_ProcessCommitted line=287 stmtstart=21262 stmtend=22916 sqlhandle=0x030014003713d643a44c3301ab9c00000100000000000000
2010-04-08 11:53:01.93 spid17s EXEC dbo.proc_MSS_ProcessDelete
2010-04-08 11:53:01.93 spid17s @ProjectID,
2010-04-08 11:53:01.93 spid17s @HisContentSourceID,
2010-04-08 11:53:01.93 spid17s @StartAddressID,
2010-04-08 11:53:01.93 spid17s @DocID,
2010-04-08 11:53:01.93 spid17s @CrawlID,
2010-04-08 11:53:01.93 spid17s @HisCrawlID,
2010-04-08 11:53:01.93 spid17s @HisCommitCrawlID,
2010-04-08 11:53:01.93 spid17s @Scope,
2010-04-08 11:53:01.93 spid17s @HisTransactionFlags,
2010-04-08 11:53:01.93 spid17s @UseChangeLog,
2010-04-08 11:53:01.93 spid17s @ChangeLogCookie,
2010-04-08 11:53:01.93 spid17s @ChangeLogBatchID,
2010-04-08 11:53:01.93 spid17s @DeleteReason,
2010-04-08 11:53:01.93 spid17s @TransactionType,
2010-04-08 11:53:01.93 spid17s @HostDepth,
2010-04-08 11:53:01.93 spid17s @EnumerationDepth,
2010-04-08 11:53:01.93 spid17s @HisParentDocID,
2010-04-08 11:53:01.93 spid17s @EndPathFlag,
2010-04-08 11:53:01.93 spid17s @HostID,
2010-04-08 11:53:01.93 spid17s @LCID,
2010-04-08 11:53:01.93 spid17s @ErrorID,
2010-04-08 11:53:01.93 spid17s @ErrorLevel,
2010-04-08 11:53:01.93 spid17s @AccessURL,
2010-04-08 11:53:01.93 spid17s @AccessHash,
2010-04-08 11:53:01.93 spid17s @CompactURL,
2010-04-08 11:53:01.93 spid17s @CompactHash,
2010-04-08 11:53:01.93 spid17s @DisplayURL,
2010-04-08 11:53:01.93 spid17s @DisplayHash,
2010-04-08 11:53:01.93 spid17s @MaxDocId
2010-04-08 11:53:01.93 spid17s inputbuf
2010-04-08 11:53:01.93 spid17s Proc [Database Id = 20 Object Id = 1138103095]
2010-04-08 11:53:01.93 spid17s process id=process3c30478 taskpriority=0 logused=820 waitresource=KEY: 20:72057594042712064 (06003f7fd0fb) waittime=2437 ownerId=215482233 transactionname=user_transaction lasttranstarted=2010-04-08T11:52:59.497 XDES=0x2bfc8b5d0 lockMode=X schedulerid=5 kpid=5724 status=suspended spid=197 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2010-04-08T11:52:59.497 lastbatchcompleted=2010-04-08T11:52:59.497 clientapp=Windows SharePoint Services hostname=MOSS1 hostpid=4708 loginname=ABC\MOSSSearch isolationlevel=read committed (2) xactid=215482233 currentdb=20 lockTimeout=4294967295 clientoption1=673316896 clientoption2=128056
2010-04-08 11:53:01.93 spid17s executionStack
2010-04-08 11:53:01.93 spid17s frame procname=SharedServices1_Search_DB.dbo.proc_MSS_UpdateHostStats line=43 stmtstart=3130 sqlhandle=0x03001400c5caed41994c3301ab9c00000100000000000000
2010-04-08 11:53:01.93 spid17s UPDATE MSSCrawlHostList SET
2010-04-08 11:53:01.93 spid17s SuccessCount = CASE WHEN SuccessCount + @SuccessCount > 0 THEN SuccessCount + @SuccessCount ELSE 0 END,
2010-04-08 11:53:01.93 spid17s ErrorCount = CASE WHEN ErrorCount + @ErrorCount > 0 THEN ErrorCount + @ErrorCount ELSE 0 END,
2010-04-08 11:53:01.93 spid17s WarningCount = CASE WHEN WarningCount + @WarningCount > 0 THEN WarningCount + @WarningCount ELSE 0 END
2010-04-08 11:53:01.93 spid17s WHERE HostID = @HostID
2010-04-08 11:53:01.93 spid17s frame procname=SharedServices1_Search_DB.dbo.proc_MSS_ProcessCommitted line=163 stmtstart=13288 stmtend=13616 sqlhandle=0x030014003713d643a44c3301ab9c00000100000000000000
2010-04-08 11:53:01.93 spid17s EXEC dbo.proc_MSS_UpdateHostStats @HostID, @TransactionType, @MarkDelete, @ErrorID, @ErrorLevel, @HisCommitCrawlID, @HisErrorLevel, @TrackIDDel, @DelErrorLevel
2010-04-08 11:53:01.93 spid17s inputbuf
2010-04-08 11:53:01.93 spid17s Proc [Database Id = 20 Object Id = 1138103095]
2010-04-08 11:53:01.93 spid17s resource-list
2010-04-08 11:53:01.93 spid17s keylock hobtid=72057594042712064 dbid=20 objectname=SharedServices1_Search_DB.dbo.MSSCrawlHostList indexname=PK_MSSCrawlHostList id=lock4a04280 mode=X associatedObjectId=72057594042712064
2010-04-08 11:53:01.93 spid17s owner-list
2010-04-08 11:53:01.93 spid17s owner id=process3c27588 mode=X
2010-04-08 11:53:01.93 spid17s waiter-list
2010-04-08 11:53:01.93 spid17s waiter id=process3c30478 mode=X requestType=wait
2010-04-08 11:53:01.93 spid17s keylock hobtid=72057594078298112 dbid=20 objectname=SharedServices1_Search_DB.dbo.MSSCrawlQueue indexname=IX_MSSCrawlQueue_Cluster id=lock58a3d80 mode=X associatedObjectId=72057594078298112
2010-04-08 11:53:01.93 spid17s owner-list
2010-04-08 11:53:01.93 spid17s owner id=process3c30478 mode=X
2010-04-08 11:53:01.93 spid17s waiter-list
2010-04-08 11:53:01.93 spid17s waiter id=process3c27588 mode=U requestType=wait
2010-04-08 11:53:03.18 spid13s deadlock-list
2010-04-08 11:53:03.18 spid13s deadlock victim=process3c13198
2010-04-08 11:53:03.18 spid13s process-list
2010-04-08 11:53:03.18 spid13s process id=process3c13198 taskpriority=0 logused=820 waitresource=KEY: 20:72057594042712064 (06003f7fd0fb) waittime=1250 ownerId=215482253 transactionname=user_transaction lasttranstarted=2010-04-08T11:52:59.540 XDES=0x184208700 lockMode=X schedulerid=2 kpid=5656 status=suspended spid=196 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2010-04-08T11:52:59.540 lastbatchcompleted=2010-04-08T11:52:59.540 clientapp=Windows SharePoint Services hostname=MOSS1 hostpid=4708 loginname=ABC\MOSSSearch isolationlevel=read committed (2) xactid=215482253 currentdb=20 lockTimeout=4294967295 clientoption1=673316896 clientoption2=128056
2010-04-08 11:53:03.18 spid13s executionStack
2010-04-08 11:53:03.18 spid13s frame procname=SharedServices1_Search_DB.dbo.proc_MSS_UpdateHostStats line=43 stmtstart=3130 sqlhandle=0x03001400c5caed41994c3301ab9c00000100000000000000
2010-04-08 11:53:03.18 spid13s UPDATE MSSCrawlHostList SET
2010-04-08 11:53:03.18 spid13s SuccessCount = CASE WHEN SuccessCount + @SuccessCount > 0 THEN SuccessCount + @SuccessCount ELSE 0 END,
2010-04-08 11:53:03.18 spid13s ErrorCount = CASE WHEN ErrorCount + @ErrorCount > 0 THEN ErrorCount + @ErrorCount ELSE 0 END,
2010-04-08 11:53:03.18 spid13s WarningCount = CASE WHEN WarningCount + @WarningCount > 0 THEN WarningCount + @WarningCount ELSE 0 END
2010-04-08 11:53:03.18 spid13s WHERE HostID = @HostID
2010-04-08 11:53:03.18 spid13s frame procname=SharedServices1_Search_DB.dbo.proc_MSS_ProcessCommitted line=163 stmtstart=13288 stmtend=13616 sqlhandle=0x030014003713d643a44c3301ab9c00000100000000000000
2010-04-08 11:53:03.18 spid13s EXEC dbo.proc_MSS_UpdateHostStats @HostID, @TransactionType, @MarkDelete, @ErrorID, @ErrorLevel, @HisCommitCrawlID, @HisErrorLevel, @TrackIDDel, @DelErrorLevel
2010-04-08 11:53:03.18 spid13s inputbuf
2010-04-08 11:53:03.18 spid13s Proc [Database Id = 20 Object Id = 1138103095]
2010-04-08 11:53:03.18 spid13s process id=process3c3b2e8 taskpriority=0 logused=3644 waitresource=KEY: 20:72057594078298112 (0b01bfcef1ea) waittime=1250 ownerId=215482257 transactionname=user_transaction lasttranstarted=2010-04-08T11:52:59.900 XDES=0x19a0b3760 lockMode=U schedulerid=6 kpid=5984 status=suspended spid=179 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2010-04-08T11:52:59.900 lastbatchcompleted=2010-04-08T11:52:59.900 clientapp=Windows SharePoint Services hostname=MOSS1 hostpid=4708 loginname=ABC\MOSSSearch isolationlevel=read committed (2) xactid=215482257 currentdb=20 lockTimeout=4294967295 clientoption1=673316896 clientoption2=128056
2010-04-08 11:53:03.18 spid13s executionStack
2010-04-08 11:53:03.18 spid13s frame procname=SharedServices1_Search_DB.dbo.proc_MSS_ProcessDelete line=188 stmtstart=15130 stmtend=15264 sqlhandle=0x03001400feeee1429d4c3301ab9c00000100000000000000
2010-04-08 11:53:03.18 spid13s DELETE FROM MSSCrawlQueue WHERE DocID=@DocID AND BatchID = 0
2010-04-08 11:53:03.18 spid13s frame procname=SharedServices1_Search_DB.dbo.proc_MSS_ProcessCommitted line=287 stmtstart=21262 stmtend=22916 sqlhandle=0x030014003713d643a44c3301ab9c00000100000000000000
2010-04-08 11:53:03.18 spid13s EXEC dbo.proc_MSS_ProcessDelete
2010-04-08 11:53:03.18 spid13s @ProjectID,
2010-04-08 11:53:03.18 spid13s @HisContentSourceID,
2010-04-08 11:53:03.18 spid13s @StartAddressID,
2010-04-08 11:53:03.18 spid13s @DocID,
2010-04-08 11:53:03.18 spid13s @CrawlID,
2010-04-08 11:53:03.18 spid13s @HisCrawlID,
2010-04-08 11:53:03.18 spid13s @HisCommitCrawlID,
2010-04-08 11:53:03.18 spid13s @Scope,
2010-04-08 11:53:03.18 spid13s @HisTransactionFlags,
2010-04-08 11:53:03.18 spid13s @UseChangeLog,
2010-04-08 11:53:03.18 spid13s @ChangeLogCookie,
2010-04-08 11:53:03.18 spid13s @ChangeLogBatchID,
2010-04-08 11:53:03.18 spid13s @DeleteReason,
2010-04-08 11:53:03.18 spid13s @TransactionType,
2010-04-08 11:53:03.18 spid13s @HostDepth,
2010-04-08 11:53:03.18 spid13s @EnumerationDepth,
2010-04-08 11:53:03.18 spid13s @HisParentDocID,
2010-04-08 11:53:03.18 spid13s @EndPathFlag,
2010-04-08 11:53:03.18 spid13s @HostID,
2010-04-08 11:53:03.18 spid13s @LCID,
2010-04-08 11:53:03.18 spid13s @ErrorID,
2010-04-08 11:53:03.18 spid13s @ErrorLevel,
2010-04-08 11:53:03.18 spid13s @AccessURL,
2010-04-08 11:53:03.18 spid13s @AccessHash,
2010-04-08 11:53:03.18 spid13s @CompactURL,
2010-04-08 11:53:03.18 spid13s @CompactHash,
2010-04-08 11:53:03.18 spid13s @DisplayURL,
2010-04-08 11:53:03.18 spid13s @DisplayHash,
2010-04-08 11:53:03.18 spid13s @MaxDocId
2010-04-08 11:53:03.18 spid13s inputbuf
2010-04-08 11:53:03.18 spid13s Proc [Database Id = 20 Object Id = 1138103095]
2010-04-08 11:53:03.18 spid13s resource-list
2010-04-08 11:53:03.18 spid13s keylock hobtid=72057594042712064 dbid=20 objectname=SharedServices1_Search_DB.dbo.MSSCrawlHostList indexname=PK_MSSCrawlHostList id=lock4a07780 mode=X associatedObjectId=72057594042712064
2010-04-08 11:53:03.18 spid13s owner-list
2010-04-08 11:53:03.18 spid13s owner id=process3c3b2e8 mode=X
2010-04-08 11:53:03.18 spid13s waiter-list
2010-04-08 11:53:03.18 spid13s waiter id=process3c13198 mode=X requestType=wait
2010-04-08 11:53:03.18 spid13s keylock hobtid=72057594078298112 dbid=20 objectname=SharedServices1_Search_DB.dbo.MSSCrawlQueue indexname=IX_MSSCrawlQueue_Cluster id=lock5935800 mode=X associatedObjectId=72057594078298112
2010-04-08 11:53:03.18 spid13s owner-list
2010-04-08 11:53:03.18 spid13s owner id=process3c13198 mode=X
2010-04-08 11:53:03.18 spid13s waiter-list
2010-04-08 11:53:03.18 spid13s waiter id=process3c3b2e8 mode=U requestType=wait
2010-04-08 11:53:03.81 spid20s deadlock-list
2010-04-08 11:53:03.81 spid20s deadlock victim=process3c3ada8
2010-04-08 11:53:03.81 spid20s process-list
2010-04-08 11:53:03.81 spid20s process id=process3c3ada8 taskpriority=0 logused=820 waitresource=KEY: 20:72057594042712064 (06003f7fd0fb) waittime=578 ownerId=215482770 transactionname=user_transaction lasttranstarted=2010-04-08T11:53:03.230 XDES=0x2c081e370 lockMode=X schedulerid=6 kpid=5300 status=suspended spid=197 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2010-04-08T11:53:03.230 lastbatchcompleted=2010-04-08T11:53:03.230 clientapp=Windows SharePoint Services hostname=MOSS1 hostpid=4708 loginname=ABC\MOSSSearch isolationlevel=read committed (2) xactid=215482770 currentdb=20 lockTimeout=4294967295 clientoption1=673316896 clientoption2=128056
2010-04-08 11:53:03.81 spid20s executionStack
2010-04-08 11:53:03.81 spid20s frame procname=SharedServices1_Search_DB.dbo.proc_MSS_UpdateHostStats line=43 stmtstart=3130 sqlhandle=0x03001400c5caed41994c3301ab9c00000100000000000000
2010-04-08 11:53:03.81 spid20s UPDATE MSSCrawlHostList SET
2010-04-08 11:53:03.81 spid20s SuccessCount = CASE WHEN SuccessCount + @SuccessCount > 0 THEN SuccessCount + @SuccessCount ELSE 0 END,
2010-04-08 11:53:03.81 spid20s ErrorCount = CASE WHEN ErrorCount + @ErrorCount > 0 THEN ErrorCount + @ErrorCount ELSE 0 END,
2010-04-08 11:53:03.81 spid20s WarningCount = CASE WHEN WarningCount + @WarningCount > 0 THEN WarningCount + @WarningCount ELSE 0 END
2010-04-08 11:53:03.81 spid20s WHERE HostID = @HostID
2010-04-08 11:53:03.81 spid20s frame procname=SharedServices1_Search_DB.dbo.proc_MSS_ProcessCommitted line=163 stmtstart=13288 stmtend=13616 sqlhandle=0x030014003713d643a44c3301ab9c00000100000000000000
2010-04-08 11:53:03.81 spid20s EXEC dbo.proc_MSS_UpdateHostStats @HostID, @TransactionType, @MarkDelete, @ErrorID, @ErrorLevel, @HisCommitCrawlID, @HisErrorLevel, @TrackIDDel, @DelErrorLevel
2010-04-08 11:53:03.81 spid20s inputbuf
2010-04-08 11:53:03.81 spid20s Proc [Database Id = 20 Object Id = 1138103095]
2010-04-08 11:53:03.81 spid20s process id=process3c44da8 taskpriority=0 logused=4380 waitresource=KEY: 20:72057594078298112 (a7007c3c1317) waittime=578 ownerId=215482751 transactionname=user_transaction lasttranstarted=2010-04-08T11:53:03.227 XDES=0x2635eade0 lockMode=U schedulerid=7 kpid=2928 status=suspended spid=201 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2010-04-08T11:53:03.227 lastbatchcompleted=2010-04-08T11:53:03.227 clientapp=Windows SharePoint Services hostname=MOSS1 hostpid=4708 loginname=ABC\MOSSSearch isolationlevel=read committed (2) xactid=215482751 currentdb=20 lockTimeout=4294967295 clientoption1=673316896 clientoption2=128056
2010-04-08 11:53:03.81 spid20s executionStack
2010-04-08 11:53:03.81 spid20s frame procname=SharedServices1_Search_DB.dbo.proc_MSS_ProcessDelete line=188 stmtstart=15130 stmtend=15264 sqlhandle=0x03001400feeee1429d4c3301ab9c00000100000000000000
2010-04-08 11:53:03.81 spid20s DELETE FROM MSSCrawlQueue WHERE DocID=@DocID AND BatchID = 0
2010-04-08 11:53:03.81 spid20s frame procname=SharedServices1_Search_DB.dbo.proc_MSS_ProcessCommitted line=287 stmtstart=21262 stmtend=22916 sqlhandle=0x030014003713d643a44c3301ab9c00000100000000000000
2010-04-08 11:53:03.81 spid20s EXEC dbo.proc_MSS_ProcessDelete
2010-04-08 11:53:03.81 spid20s @ProjectID,
2010-04-08 11:53:03.81 spid20s @HisContentSourceID,
2010-04-08 11:53:03.81 spid20s @StartAddressID,
2010-04-08 11:53:03.81 spid20s @DocID,
2010-04-08 11:53:03.81 spid20s @CrawlID,
2010-04-08 11:53:03.81 spid20s @HisCrawlID,
2010-04-08 11:53:03.81 spid20s @HisCommitCrawlID,
2010-04-08 11:53:03.81 spid20s @Scope,
2010-04-08 11:53:03.81 spid20s @HisTransactionFlags,
2010-04-08 11:53:03.81 spid20s @UseChangeLog,
2010-04-08 11:53:03.81 spid20s @ChangeLogCookie,
2010-04-08 11:53:03.81 spid20s @ChangeLogBatchID,
2010-04-08 11:53:03.81 spid20s @DeleteReason,
2010-04-08 11:53:03.81 spid20s @TransactionType,
2010-04-08 11:53:03.81 spid20s @HostDepth,
2010-04-08 11:53:03.81 spid20s @EnumerationDepth,
2010-04-08 11:53:03.81 spid20s @HisParentDocID,
2010-04-08 11:53:03.81 spid20s @EndPathFlag,
2010-04-08 11:53:03.81 spid20s @HostID,
2010-04-08 11:53:03.81 spid20s @LCID,
2010-04-08 11:53:03.81 spid20s @ErrorID,
2010-04-08 11:53:03.81 spid20s @ErrorLevel,
2010-04-08 11:53:03.81 spid20s @AccessURL,
2010-04-08 11:53:03.81 spid20s @AccessHash,
2010-04-08 11:53:03.81 spid20s @CompactURL,
2010-04-08 11:53:03.81 spid20s @CompactHash,
2010-04-08 11:53:03.81 spid20s @DisplayURL,
2010-04-08 11:53:03.81 spid20s @DisplayHash,
2010-04-08 11:53:03.81 spid20s @MaxDocId
2010-04-08 11:53:03.81 spid20s inputbuf
2010-04-08 11:53:03.81 spid20s Proc [Database Id = 20 Object Id = 1138103095]
2010-04-08 11:53:03.81 spid20s resource-list
2010-04-08 11:53:03.81 spid20s keylock hobtid=72057594042712064 dbid=20 objectname=SharedServices1_Search_DB.dbo.MSSCrawlHostList indexname=PK_MSSCrawlHostList id=lock50b0580 mode=X associatedObjectId=72057594042712064
2010-04-08 11:53:03.81 spid20s owner-list
2010-04-08 11:53:03.81 spid20s owner id=process3c44da8 mode=X
2010-04-08 11:53:03.81 spid20s waiter-list
2010-04-08 11:53:03.81 spid20s waiter id=process3c3ada8 mode=X requestType=wait
2010-04-08 11:53:03.81 spid20s keylock hobtid=72057594078298112 dbid=20 objectname=SharedServices1_Search_DB.dbo.MSSCrawlQueue indexname=IX_MSSCrawlQueue_Cluster id=lock52c0600 mode=X associatedObjectId=72057594078298112
2010-04-08 11:53:03.81 spid20s owner-list
2010-04-08 11:53:03.81 spid20s owner id=process3c3ada8 mode=X
2010-04-08 11:53:03.81 spid20s waiter-list
2010-04-08 11:53:03.81 spid20s waiter id=process3c44da8 mode=U requestType=wait
2010-04-08 11:53:04.12 spid12s deadlock-list
2010-04-08 11:53:04.12 spid12s deadlock victim=process3c3b2e8
2010-04-08 11:53:04.12 spid12s process-list
2010-04-08 11:53:04.12 spid12s process id=process3c13198 taskpriority=0 logused=8192 waitresource=KEY: 20:72057594078298112 (250121b04782) waittime=312 ownerId=215482779 transactionname=user_transaction lasttranstarted=2010-04-08T11:53:03.290 XDES=0x184208700 lockMode=U schedulerid=2 kpid=5656 status=suspended spid=196 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2010-04-08T11:53:03.290 lastbatchcompleted=2010-04-08T11:53:03.290 clientapp=Windows SharePoint Services hostname=MOSS1 hostpid=4708 loginname=ABC\MOSSSearch isolationlevel=read committed (2) xactid=215482779 currentdb=20 lockTimeout=4294967295 clientoption1=673316896 clientoption2=128056
2010-04-08 11:53:04.12 spid12s executionStack
2010-04-08 11:53:04.12 spid12s frame procname=SharedServices1_Search_DB.dbo.proc_MSS_ProcessDelete line=188 stmtstart=15130 stmtend=15264 sqlhandle=0x03001400feeee1429d4c3301ab9c00000100000000000000
2010-04-08 11:53:04.12 spid12s DELETE FROM MSSCrawlQueue WHERE DocID=@DocID AND BatchID = 0
2010-04-08 11:53:04.12 spid12s frame procname=SharedServices1_Search_DB.dbo.proc_MSS_ProcessCommitted line=287 stmtstart=21262 stmtend=22916 sqlhandle=0x030014003713d643a44c3301ab9c00000100000000000000
2010-04-08 11:53:04.12 spid12s EXEC dbo.proc_MSS_ProcessDelete
2010-04-08 11:53:04.12 spid12s @ProjectID,
2010-04-08 11:53:04.12 spid12s @HisContentSourceID,
2010-04-08 11:53:04.12 spid12s @StartAddressID,
2010-04-08 11:53:04.12 spid12s @DocID,
2010-04-08 11:53:04.12 spid12s @CrawlID,
2010-04-08 11:53:04.12 spid12s @HisCrawlID,
2010-04-08 11:53:04.12 spid12s @HisCommitCrawlID,
2010-04-08 11:53:04.12 spid12s @Scope,
2010-04-08 11:53:04.12 spid12s @HisTransactionFlags,
2010-04-08 11:53:04.12 spid12s @UseChangeLog,
2010-04-08 11:53:04.12 spid12s @ChangeLogCookie,
2010-04-08 11:53:04.12 spid12s @ChangeLogBatchID,
2010-04-08 11:53:04.12 spid12s @DeleteReason,
2010-04-08 11:53:04.12 spid12s @TransactionType,
2010-04-08 11:53:04.12 spid12s @HostDepth,
2010-04-08 11:53:04.12 spid12s @EnumerationDepth,
2010-04-08 11:53:04.12 spid12s @HisParentDocID,
2010-04-08 11:53:04.12 spid12s @EndPathFlag,
2010-04-08 11:53:04.12 spid12s @HostID,
2010-04-08 11:53:04.12 spid12s @LCID,
2010-04-08 11:53:04.12 spid12s @ErrorID,
2010-04-08 11:53:04.12 spid12s @ErrorLevel,
2010-04-08 11:53:04.12 spid12s @AccessURL,
2010-04-08 11:53:04.12 spid12s @AccessHash,
2010-04-08 11:53:04.12 spid12s @CompactURL,
2010-04-08 11:53:04.12 spid12s @CompactHash,
2010-04-08 11:53:04.12 spid12s @DisplayURL,
2010-04-08 11:53:04.12 spid12s @DisplayHash,
2010-04-08 11:53:04.12 spid12s @MaxDocId
2010-04-08 11:53:04.12 spid12s inputbuf
2010-04-08 11:53:04.12 spid12s Proc [Database Id = 20 Object Id = 1138103095]
2010-04-08 11:53:04.12 spid12s process id=process3c3b2e8 taskpriority=0 logused=820 waitresource=KEY: 20:72057594042712064 (06003f7fd0fb) waittime=312 ownerId=215482787 transactionname=user_transaction lasttranstarted=2010-04-08T11:53:03.653 XDES=0x19a0b3760 lockMode=X schedulerid=6 kpid=5984 status=suspended spid=57 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2010-04-08T11:53:03.653 lastbatchcompleted=2010-04-08T11:53:03.653 clientapp=Windows SharePoint Services hostname=MOSS1 hostpid=4708 loginname=ABC\MOSSSearch isolationlevel=read committed (2) xactid=215482787 currentdb=20 lockTimeout=4294967295 clientoption1=673316896 clientoption2=128056
2010-04-08 11:53:04.12 spid12s executionStack
2010-04-08 11:53:04.12 spid12s frame procname=SharedServices1_Search_DB.dbo.proc_MSS_UpdateHostStats line=43 stmtstart=3130 sqlhandle=0x03001400c5caed41994c3301ab9c00000100000000000000
2010-04-08 11:53:04.12 spid12s UPDATE MSSCrawlHostList SET
2010-04-08 11:53:04.12 spid12s SuccessCount = CASE WHEN SuccessCount + @SuccessCount > 0 THEN SuccessCount + @SuccessCount ELSE 0 END,
2010-04-08 11:53:04.12 spid12s ErrorCount = CASE WHEN ErrorCount + @ErrorCount > 0 THEN ErrorCount + @ErrorCount ELSE 0 END,
2010-04-08 11:53:04.12 spid12s WarningCount = CASE WHEN WarningCount + @WarningCount > 0 THEN WarningCount + @WarningCount ELSE 0 END
2010-04-08 11:53:04.12 spid12s WHERE HostID = @HostID
2010-04-08 11:53:04.12 spid12s frame procname=SharedServices1_Search_DB.dbo.proc_MSS_ProcessCommitted line=163 stmtstart=13288 stmtend=13616 sqlhandle=0x030014003713d643a44c3301ab9c00000100000000000000
2010-04-08 11:53:04.12 spid12s EXEC dbo.proc_MSS_UpdateHostStats @HostID, @TransactionType, @MarkDelete, @ErrorID, @ErrorLevel, @HisCommitCrawlID, @HisErrorLevel, @TrackIDDel, @DelErrorLevel
2010-04-08 11:53:04.12 spid12s inputbuf
2010-04-08 11:53:04.12 spid12s Proc [Database Id = 20 Object Id = 1138103095]
2010-04-08 11:53:04.12 spid12s resource-list
2010-04-08 11:53:04.12 spid12s keylock hobtid=72057594042712064 dbid=20 objectname=SharedServices1_Search_DB.dbo.MSSCrawlHostList indexname=PK_MSSCrawlHostList id=lock4cc7480 mode=X associatedObjectId=72057594042712064
2010-04-08 11:53:04.12 spid12s owner-list
2010-04-08 11:53:04.12 spid12s owner id=process3c13198 mode=X
2010-04-08 11:53:04.12 spid12s waiter-list
2010-04-08 11:53:04.12 spid12s waiter id=process3c3b2e8 mode=X requestType=wait
2010-04-08 11:53:04.12 spid12s keylock hobtid=72057594078298112 dbid=20 objectname=SharedServices1_Search_DB.dbo.MSSCrawlQueue indexname=IX_MSSCrawlQueue_Cluster id=lock4fe9580 mode=X associatedObjectId=72057594078298112
2010-04-08 11:53:04.12 spid12s owner-list
2010-04-08 11:53:04.12 spid12s owner id=process3c3b2e8 mode=X
2010-04-08 11:53:04.12 spid12s waiter-list
2010-04-08 11:53:04.12 spid12s waiter id=process3c13198 mode=U requestType=wait
2010-04-08 11:53:15.58 spid13s deadlock-list
2010-04-08 11:53:15.58 spid13s deadlock victim=process3c3b2e8
2010-04-08 11:53:15.58 spid13s process-list
2010-04-08 11:53:15.58 spid13s process id=process3c1d198 taskpriority=0 logused=3700 waitresource=KEY: 20:72057594078298112 (e600e4c7f13b) waittime=3000 ownerId=215488363 transactionname=user_transaction lasttranstarted=2010-04-08T11:53:12.583 XDES=0x2f53e7170 lockMode=U schedulerid=3 kpid=568 status=suspended spid=197 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2010-04-08T11:53:12.583 lastbatchcompleted=2010-04-08T11:53:12.583 clientapp=Windows SharePoint Services hostname=MOSS1 hostpid=4708 loginname=ABC\MOSSSearch isolationlevel=read committed (2) xactid=215488363 currentdb=20 lockTimeout=4294967295 clientoption1=673316896 clientoption2=128056
2010-04-08 11:53:15.58 spid13s executionStack
2010-04-08 11:53:15.58 spid13s frame procname=SharedServices1_Search_DB.dbo.proc_MSS_ProcessDelete line=188 stmtstart=15130 stmtend=15264 sqlhandle=0x03001400feeee1429d4c3301ab9c00000100000000000000
2010-04-08 11:53:15.58 spid13s DELETE FROM MSSCrawlQueue WHERE DocID=@DocID AND BatchID = 0
2010-04-08 11:53:15.58 spid13s frame procname=SharedServices1_Search_DB.dbo.proc_MSS_ProcessCommitted line=287 stmtstart=21262 stmtend=22916 sqlhandle=0x030014003713d643a44c3301ab9c00000100000000000000
2010-04-08 11:53:15.58 spid13s EXEC dbo.proc_MSS_ProcessDelete
2010-04-08 11:53:15.58 spid13s @ProjectID,
2010-04-08 11:53:15.58 spid13s @HisContentSourceID,
2010-04-08 11:53:15.58 spid13s @StartAddressID,
2010-04-08 11:53:15.58 spid13s @DocID,
2010-04-08 11:53:15.58 spid13s @CrawlID,
2010-04-08 11:53:15.58 spid13s @HisCrawlID,
2010-04-08 11:53:15.58 spid13s @HisCommitCrawlID,
2010-04-08 11:53:15.58 spid13s @Scope,
2010-04-08 11:53:15.58 spid13s @HisTransactionFlags,
2010-04-08 11:53:15.58 spid13s @UseChangeLog,
2010-04-08 11:53:15.58 spid13s @ChangeLogCookie,
2010-04-08 11:53:15.58 spid13s @ChangeLogBatchID,
2010-04-08 11:53:15.58 spid13s @DeleteReason,
2010-04-08 11:53:15.58 spid13s @TransactionType,
2010-04-08 11:53:15.58 spid13s @HostDepth,
2010-04-08 11:53:15.58 spid13s @EnumerationDepth,
2010-04-08 11:53:15.58 spid13s @HisParentDocID,
2010-04-08 11:53:15.58 spid13s @EndPathFlag,
2010-04-08 11:53:15.58 spid13s @HostID,
2010-04-08 11:53:15.58 spid13s @LCID,
2010-04-08 11:53:15.58 spid13s @ErrorID,
2010-04-08 11:53:15.58 spid13s @ErrorLevel,
2010-04-08 11:53:15.58 spid13s @AccessURL,
2010-04-08 11:53:15.58 spid13s @AccessHash,
2010-04-08 11:53:15.58 spid13s @CompactURL,
2010-04-08 11:53:15.58 spid13s @CompactHash,
2010-04-08 11:53:15.58 spid13s @DisplayURL,
2010-04-08 11:53:15.58 spid13s @DisplayHash,
2010-04-08 11:53:15.58 spid13s @MaxDocId
2010-04-08 11:53:15.58 spid13s inputbuf
2010-04-08 11:53:15.58 spid13s Proc [Database Id = 20 Object Id = 1138103095]
2010-04-08 11:53:15.58 spid13s process id=process3c3b2e8 taskpriority=0 logused=1628 waitresource=KEY: 20:72057594072858624 (6900451cc614) waittime=2984 ownerId=215488400 transactionname=user_transaction lasttranstarted=2010-04-08T11:53:12.590 XDES=0x19a0b3760 lockMode=S schedulerid=6 kpid=5984 status=suspended spid=57 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2010-04-08T11:53:12.590 lastbatchcompleted=2010-04-08T11:53:12.590 clientapp=Windows SharePoint Services hostname=MOSS1 hostpid=4708 loginname=ABC\MOSSSearch isolationlevel=read committed (2) xactid=215488400 currentdb=20 lockTimeout=4294967295 clientoption1=673316896 clientoption2=128056
2010-04-08 11:53:15.58 spid13s executionStack
2010-04-08 11:53:15.58 spid13s frame procname=adhoc line=1 stmtstart=60 sqlhandle=0x02000000dbaae312fe364c8a1196c812891fc28ae3c30c99
2010-04-08 11:53:15.58 spid13s UPDATE MSSCrawlQueue SET BatchID = @BatchID, Priority = 2
2010-04-08 11:53:15.58 spid13s FROM MSSCrawlQueue A
2010-04-08 11:53:15.58 spid13s INNER JOIN (
2010-04-08 11:53:15.58 spid13s SELECT TOP 20474 CrawlID, FolderHighPriority, ItemHighPriority, SeqID
2010-04-08 11:53:15.58 spid13s FROM MSSCrawlQueue
2010-04-08 11:53:15.58 spid13s WHERE CrawlID = @CrawlID
2010-04-08 11:53:15.58 spid13s AND BatchID = 0
2010-04-08 11:53:15.58 spid13s ORDER BY SEQID ) AS B
2010-04-08 11:53:15.58 spid13s ON A.CrawlID = B.CrawlID AND A.FolderHighPriority = B.FolderHighPriority AND A.ItemHighPriority = B.ItemHighPriority AND A.SeqID = B.SeqID
2010-04-08 11:53:15.58 spid13s frame procname=mssqlsystemresource.sys.sp_executesql line=1 sqlhandle=0x0400ff7fbe80662601000000000000000000000000000000
2010-04-08 11:53:15.58 spid13s sp_executesql
2010-04-08 11:53:15.58 spid13s frame procname=SharedServices1_Search_DB.dbo.proc_MSS_GetNextCrawlBatch line=171 stmtstart=13742 stmtend=13864 sqlhandle=0x03001400c610834ac84c3301ab9c00000100000000000000
2010-04-08 11:53:15.58 spid13s EXEC SP_EXECUTESQL @Stmt, @PARAM, @BatchID, @CrawlID
2010-04-08 11:53:15.58 spid13s inputbuf
2010-04-08 11:53:15.58 spid13s Proc [Database Id = 20 Object Id = 1250103494]
2010-04-08 11:53:15.58 spid13s resource-list
2010-04-08 11:53:15.58 spid13s keylock hobtid=72057594072858624 dbid=20 objectname=SharedServices1_Search_DB.dbo.MSSCrawlQueue indexname=IX_MSSCrawlQueue_SeqID id=lock441ac00 mode=X associatedObjectId=72057594072858624
2010-04-08 11:53:15.58 spid13s owner-list
2010-04-08 11:53:15.58 spid13s owner id=process3c1d198 mode=X
2010-04-08 11:53:15.58 spid13s waiter-list
2010-04-08 11:53:15.58 spid13s waiter id=process3c3b2e8 mode=S requestType=wait
2010-04-08 11:53:15.58 spid13s keylock hobtid=72057594078298112 dbid=20 objectname=SharedServices1_Search_DB.dbo.MSSCrawlQueue indexname=IX_MSSCrawlQueue_Cluster id=lock58e3700 mode=X associatedObjectId=72057594078298112
2010-04-08 11:53:15.58 spid13s owner-list
2010-04-08 11:53:15.58 spid13s owner id=process3c3b2e8 mode=X
2010-04-08 11:53:15.58 spid13s waiter-list
2010-04-08 11:53:15.58 spid13s waiter id=process3c1d198 mode=U requestType=wait
April 9, 2010 at 2:59 pm
Mani-584606 (4/9/2010)
Do you know the query that is being executed by the proc sp_executesql?
That proc is really what is being deadlocked. That proc is held inside the resource database and is used to call dynamic sql in many cases.
I did not understand that you asking about the query that is being executed by the proc sp_executesql
and I got more dead locks today and at that time NO crawl was run. So Is there any thing wrong with "mssqlsystemresource" system databases? why it is involving in the Dead lock? Please advice that is something we need address to MS or we can solve that from MOSS side or SQL Server side?
2010-04-08 11:53:15.58 spid13s frame procname=mssqlsystemresource.sys.sp_executesql line=1 sqlhandle=0x0400ff7fbe80662601000000000000000000000000000000
Find the query being executed by sp_executesql. Sp_executesql is used to run dynamic sql queries. You need to tune that query.
Check it out in BOL.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 9, 2010 at 3:10 pm
May be it's dumb question. But where exactly should I look for the query running using sp_executesql?
April 9, 2010 at 3:18 pm
Run a profile against your database.
You can try to run that sqlhandle provided in the error text against the query provided at:
http://sqlserver-qa.net/blogs/t-sql/archive/2007/10/04/2324.aspx
This should help you in learning about that kind of stuff.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply