locked
Deadlock maybe due to multi-task workflow, please help me to diagnose and fix it. RRS feed

  • Question

  • 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

    Wednesday, June 27, 2012 2:12 AM

All replies

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

    Thursday, June 28, 2012 8:13 AM