azure - 更新 Azure 上的云服务时出现 SqlException

Question

在将更新部署到我们的 Windows Azure 云服务时，我注意到很多信号量超时(请参阅下文了解完全异常)。

我们已经实现了重试逻辑(并且可以看到异常发生在重试封装内)，所以我认为这可能是一个逻辑问题，但是我无法在互联网上找到任何相关实例，也没有考虑到我的自己的解决方案!

我的问题是:有办法解决这个问题吗？例如，我们能否以某种方式将所有用户推送到单个实例并更新另一个实例？ -目前我们至少有两个实例在运行。

这是完整的异常:

[SqlException: A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The semaphore timeout period has expired.)]
    System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction):0
    System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose):0
    System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error):0
    System.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync():0
    System.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket():0
    System.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer():0
    System.Data.SqlClient.TdsParserStateObject.TryReadByte(Byte& value):0
    System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady):0
    System.Data.SqlClient.SqlDataReader.TryConsumeMetaData():0
    System.Data.SqlClient.SqlDataReader.get_MetaData():0
    System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString):0
    System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite):0
    System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite):0
    System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method):0
    System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method):0
    System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior):0
    System.Data.Linq.SqlClient.SqlProvider.Execute(Expression query, QueryInfo queryInfo, IObjectReaderFactory factory, Object[] parentArgs, Object[] userArgs, ICompiledSubQuery[] subQueries, Object lastResult):0
    System.Data.Linq.SqlClient.SqlProvider.ExecuteAll(Expression query, QueryInfo[] queryInfos, IObjectReaderFactory factory, Object[] userArguments, ICompiledSubQuery[] subQueries):0
    System.Data.Linq.SqlClient.SqlProvider.System.Data.Linq.Provider.IProvider.Execute(Expression query):0
    System.Data.Linq.DataQuery`1.System.Linq.IQueryProvider.Execute[S](Expression expression):0
    System.Linq.Queryable.SingleOrDefault[TSource](IQueryable`1 source):0
    Microsoft.Practices.TransientFaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func):0
    TimeClock.TimeClockService.GetEmployees(String _apiKey, String _authenticationToken, DateTime _lastSync):0

Answer 1

这似乎是 VIP 交换的一个已知问题，即使使用 SQL 重试策略和硬编码机器 key 也是如此。

<强> User reports of this issue on MSDN

<强> Stack Overflow answer on another thread