Hi Everyone, our team are facing a very headache issue now, and seems we havn't any idea/clue to get it resolved. hope some can help us.(I am not familar with sharepoint). here is the main reason that caused the deadlock problem(we found some deadlock not occurred in mutli-task workflow). we have some workflow that have a step is multi-group task, it means in this group, maybe has more than 1 people, if anyone in this group apprvoe/reject this task, the others tasks which belongs to left people in this group should be deleted auto. but right now, maybe as the data get more and more big, we always found the "auto deleted" function doesn't work properly, it is always that some task can't be deleted, so it caused the workflow can't executed as expected, while it will throw a deadlock exception(almost deadlock exception, some other error as well) here is the stacktrace that loged in windows event: Event Type: Warning Event Source: ASP.NET 2.0.50727.0 Event Category: Web Event Event ID: 1309 Date: 6/25/2012 Time: 5:51:58 PM User: N/A Computer: CNM1 Description: Event code: 3005 Event message: An unhandled exception has occurred. Event time: 6/25/2012 5:51:58 PM Event time (UTC): 6/25/2012 9:51:58 AM Event ID: 7323d172472d4ec9aeeb4c59ef5b04d2 Event sequence: 5505 Event occurrence: 4 Event detail code: 0 Application information: Application domain: /LM/W3SVC/41178440/Root-1-129850379762740597 Trust level: Full Application Virtual Path: / Application Path: C:\Inetpub\wwwroot\wss\VirtualDirectories\81\ Machine name: CNM1 Process information: Process ID: 652 Process name: w3wp.exe Account name: test\spsadmin Exception information: Exception type: SqlException Exception message: Transaction (Process ID 80) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction. Request information: Request URL: https://portal.c-and-a.cn:443/WorkFlowCenter/Lists/Tasks/MyItems.aspx Request path: /WorkFlowCenter/Lists/Tasks/MyItems.aspx User host address: 192.168.3.23 User: test\Poppy.wang Is authenticated: True Authentication Type: NTLM Thread account name: test\spsadmin Thread information: Thread ID: 7 Thread account name: test\spsadmin Is impersonating: False Stack trace: at Microsoft.SharePoint.Library.SPRequestInternalClass.CrossListQuery(String bstrUrl, String bstrXmlWebs, String bstrXmlLists, String bstrXmlQuery, ISP2DSafeArrayWriter pCallback, Object& pvarColumns) at Microsoft.SharePoint.Library.SPRequest.CrossListQuery(String bstrUrl, String bstrXmlWebs, String bstrXmlLists, String bstrXmlQuery, ISP2DSafeArrayWriter pCallback, Object& pvarColumns) at Microsoft.SharePoint.SPWeb.GetSiteData(SPSiteDataQuery query) at CA.SharePoint.WebControls.AllTasks.Page_Load(Object sender, EventArgs e) at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.BasePartialCachingControl.LoadRecursive() at System.Web.UI.Control.AddedControl(Control control, Int32 index) at System.Web.UI.ControlCollection.Add(Control child) at CA.SharePoint.WebParts.TemplateWebPart.CreateChildControls() at System.Web.UI.Control.EnsureChildControls() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.WebControls.WebParts.WebPart.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) Custom event details: For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. I am not sure if this information enough. it is very appreciated that if you can give us any clue. thanks Danny

Anybody here can help me? thanks very much in advance.