Question

我如何在捕获区执行该守则?

  try
    {
       // Call a MS SQL stored procedure (MS SQL 2000)
       // Stored Procedure may deadlock 
    }
    catch
    {
       // if deadlocked Call a MS SQL stored procedure (may deadlock again)
       // If deadlocked, keep trying until stored procedure executes
    }
    finally
    {

    }

Answer 1

提出这个建议,并可能在你的方案中造成严重问题。例如,数据库被缩小了什么?

但是,在这样的情况下,如何做:

for(int attempts = 0; attempts < 5; attempts++)
// if you really want to keep going until it works, use   for(;;)
{
    try
    {
        DoWork();
        break;
    }
    catch { }
    Thread.Sleep(50); // Possibly a good idea to pause here, explanation below
}

<>Update: 正如尊敬的先生在以下评论中提到的: <代码>。睡觉/编码方法中止了特定数量的微秒。没有任何错误是完全任意的,大多数错误只能通过再打上的工作,这是因为在两部之间发生的事情发生了变化。穿透镜的安装将为实现这一目标提供更大的机会之窗(例如,数据库发动机投入更多的时间启动)。

Answer 2

类似情况

bool retry = true;
while( retry ){
  try{
    ...
    retry = false;
  }
  catch
  {
    ...
  }
  finally
  {
    ...
  }
}

只要试块的最后一条线(Retry = 虚假)运行,它就会继续。如果出现某种例外,它将控制捕获和最后阻挡,然后回头并再次驾车。

如果你只想尝试X时间,你就可以用先试的开始值取代工业。然后检查一下,如果在休息时间平均0次,则在休息时间开始时将其减到0次,并把它确定为试场最后线。

当然,你应该为这一空洞的捕捞区做一些事情,以便赶上你预期的例外情况,而不是赶上一切的例外情况。

Answer 3

编辑Microsoft Development Network page on what they打:

private int retryCount = 3;
...

public async Task OperationWithBasicRetryAsync()
{
  int currentRetry = 0;

  for (; ;)
  {
    try
    {
      // Calling external service.
      await TransientOperationAsync();

      // Return or break.
      break;
    }
    catch (Exception ex)
    {
      Trace.TraceError("Operation Exception");

      currentRetry++;

      // Check if the exception thrown was a transient exception
      // based on the logic in the error detection strategy.
      // Determine whether to retry the operation, as well as how 
      // long to wait, based on the retry strategy.
      if (currentRetry > this.retryCount || !IsTransient(ex))
      {
        // If this is not a transient error 
        // or we should not retry re-throw the exception. 
        throw;
      }
    }

    // Wait to retry the operation.
    // Consider calculating an exponential delay here and 
    // using a strategy best suited for the operation and fault.
    Await.Task.Delay();
  }
}

// Async method that wraps a call to a remote service (details not shown).
private async Task TransientOperationAsync()
{
  ...
}

它们更详细,解释了这种模式的适当使用和不适当的使用。例如,如果你预计你会重开的错误是短暂的,而且一旦重新计算可能会取得成功,那么你就会这样做。如果这是为了帮助你处理一些扩大规模的问题,这并不是你们的事。

您也有兴趣了解其网站。他们认为能够做到的“连接边远服务或资源时可能需要一定时间纠正的过失”。

Answer 4

Don t implement it in the catch block. Instead write a loop around it that repeats until either it was successful or some limit is reached.

类似:

bool quit = false;
int loopcount = 0;
while(!quit )
{
   try
   {
       // execute the command, might throw an exception)
       quit = true; // no exception if you got here
   }
   catch(Exception ex)
   {
      if (ex != deadlock) // doesn t work like this :-(
        quit = true;
   }
   finally
   {
      // etc.
   }
   loopcount++;
   if (loopcount > 3)
      quit = true;
}

Answer 5

它可能简单地把整个审判/捕获物归一旁:

while (!success) {

    try
    {
       // Call a MS SQL stored procedure (MS SQL 2000)
       // Stored Procedure may deadlock 
       success = true;
    }
    catch
    {
       // if deadlocked Call a MS SQL stored procedure (may deadlock again)
       // If deadlocked, keep trying until stored procedure executes
       success = false;
    }

}

Answer 6

You really shouldn t just hammer the database until it succeeds in executing your SP, but that s another story.

你可以这样做:

Boolean succeeded = false;

while (!succeeded)
{

    try
    {
        // Call a MS SQL stored procedure (MS SQL 2000)
        // Stored Procedure may deadlock 
        succeeded = true;
    }
    catch (Exception ex)
    {
        // Log
    }
}

Answer 7

你们可以执行Timers,检查贵家仓库程序的健康,并在同仁所说的休息室内提出答案。

友情链接