Important Notice from AspDotNetStorefront
It is with dismay that we report that we have been forced, through the action of hackers, to shut off write-access to this forum. We are keen to leave the wealth of material available to you for research. We have opened a new forum from which our community of users can seek help, support and advice from us and from each other. To post a new question to our community, please visit: http://forums.vortx.com
Results 1 to 4 of 4

Thread: Site Deadlock Issues

  1. 09-07-2012, 09:36 AM #1
    mohanrh is offline Member
    Join Date
    Jul 2009
    Posts
    78

    Default Site Deadlock Issues

    Hi, Our site is currently running on ML/64 8.0.2 version. Occasionally I am seeing sql deadlocked error messages in windows event log. When I did some further research, the call to aspdnsf_PABPEraseCCInfo is causing deadlocks and other requests are blocked. I am trying to figure out where and when the call for this stored proc is made. We have source code. It would be very helpful if someone could drop in some info so that we could get to the issue asap.

    Any help is greatly appreciated.

    Mohan
  2. 10-15-2012, 08:15 AM #2
    jberry is offline Junior Member
    Join Date
    Oct 2012
    Posts
    4

    Default

    Quote Originally Posted by mohanrh View Post
    Hi, Our site is currently running on ML/64 8.0.2 version. Occasionally I am seeing sql deadlocked error messages in windows event log. When I did some further research, the call to aspdnsf_PABPEraseCCInfo is causing deadlocks and other requests are blocked. I am trying to figure out where and when the call for this stored proc is made. We have source code. It would be very helpful if someone could drop in some info so that we could get to the issue asap.

    Any help is greatly appreciated.

    Mohan
    Were you able to figure out why these deadlocks are occurring? We are having the same problem and the site's performance is suffering because of it. We do not have it set to store CC info.
  3. 10-15-2012, 08:23 AM #3
    jberry is offline Junior Member
    Join Date
    Oct 2012
    Posts
    4

    Default

    Quote Originally Posted by mohanrh View Post
    Hi, Our site is currently running on ML/64 8.0.2 version. Occasionally I am seeing sql deadlocked error messages in windows event log. When I did some further research, the call to aspdnsf_PABPEraseCCInfo is causing deadlocks and other requests are blocked. I am trying to figure out where and when the call for this stored proc is made. We have source code. It would be very helpful if someone could drop in some info so that we could get to the issue asap.

    Any help is greatly appreciated.

    Mohan
    Hi Mohan - Any update on this? We are having the same issue. We are not storing any CC info.
  4. 10-17-2012, 05:57 AM #4
    mohanrh is offline Member
    Join Date
    Jul 2009
    Posts
    78

    Default Site Deadlock issues

    Yes, I think we found the issue. Sp aspdnsf_PABPEraseCCInfo is being called at the beginning of each session that was causing all the deadlocks. we used have the deadlock issue almost 3-4 times everyday causing timeout errors on the website. Basically the sp goes and clears the address tables of some cc info for the user. Since we already have processes to handle that issue, I commented out all the statements in that sp and I have not seen the deadlock issue since then. Its almost a month now.

    Hoep this helps.

    Mohan