WSS/MOSS - Common Issue - SQL Deadlocks during STSADM import operations

re: WSS/MOSS - Common Issue - SQL Deadlocks during STSADM import operations

Yaron ben shalom — Tue, 02 Dec 2008 13:22:23 GMT

We have a similar problem only no Import is taking place- just our EmailRecieved event handler. We have SP1 and Infrastructure update installed. We are trying to create and change item permissions (not inherited) when a mail message is recieved and sometimes get deadlocks on stored procedures implementing security operations. The list already has several thousand items and probably a very large amount of specific permissions (dbo.RoleAssignment has about 4 million records). Do you have any ideas perhaps?

re: WSS/MOSS - Common Issue - SQL Deadlocks during STSADM import operations

Stefan_Gossner — Tue, 02 Dec 2008 13:31:14 GMT

Hi Shalom,

sorry, this cannot be answered easily.

It would be required to analyze the deadlock in more detail and verify the code of your event receiver to isolate the issue.

If you need assistance for this I would recommend to raise a support call with Microsoft support.

Cheers,

Stefan

re: WSS/MOSS - Common Issue - SQL Deadlocks during STSADM import operations

Leon Zandman — Mon, 29 Dec 2008 16:25:06 GMT

This happened to us. We managed to solve it by doing IISRESET's and retrying the import. Eventually the import succeeded, so it probably was a timing issue.

re: WSS/MOSS - Common Issue - SQL Deadlocks during STSADM import operations

Flo — Wed, 15 Apr 2009 23:32:59 GMT

Hi Stefan,

great article!

What debugger did you use to set the breakpoint and where did you attached it? - directly to the process of the sql instance?

I am actually not to familiar with debuggers - but want to give it a try.

As far as I know you usually set a breakpoint in your application at a pice of code or datastructure where you want to stop the execution - but how do you know where this will be? I mean wouldn't you need to know when the deadlock occurs?

Or do you set the breakpoint before the routine which will kill the deadlock starts its execution?

And is this possible for a user without having in-depth information about the code and symbols of the process?

Best regards,

Flo

re: WSS/MOSS - Common Issue - SQL Deadlocks during STSADM import operations

Stefan_Gossner — Wed, 15 Apr 2009 23:37:49 GMT

Hi Flo,

I used WinDBG and set the breakpoint as follows:

bp sqlservr!RaiseDeadlockError

Cheers,

Stefan