|
|
Posted by Dimitri Furman on 09/29/07 02:58
On Sep 28 2007, 05:28 pm, Erland Sommarskog <esquel@sommarskog.se> wrote
in news:Xns99B9EFAA31154Yazorman@127.0.0.1:
> Got it, and indeed I had to reboot myserver. What was missing from
> your description on Connect was the RECOMPILE hint. When I remove it,
> the procedure completes.
The RECOMPILE hint is there to make it consistently reproducible. Before I
added that, the issue only occurred intermittently (apparently, when the
function's plan had to be recompiled).
> I looked in the SQL Server error log, and I found that there is a
> stack dump for an unresolved deadlock.
I wish I had seen that in the beginning, at least I could be certain it's a
real problem.
I updated the bug report to include these two bits of information.
--
remove a 9 to reply by email
Navigation:
[Reply to this message]
|