信号量超时期限已从Azure过期。 [英] Semaphore timeout period has expired from Azure.

问题描述

我的客户在将我们的应用程序连接到Azure SQL数据库时遇到一致错误：

从服务器接收结果时发生传输级错误。 （提供程序：TCP提供程序，错误：0 - 信号量超时期限已过期。）

不幸的是，这似乎不在已发布的Azure瞬态错误列表中。我甚至无法在.NET SQLException中找到要检查的错误号。除非它是winerror值121，它似乎被不同的SQL数据库使用
引擎错误。

有没有人有任何想法是什么原因引起的？我们可以根据消息文本（ouch）重试，但我不知道这是否会有所帮助。

问候，

Jerry Metcoff

Gypsi BI LLC

解决方案

嗨Jerry，

请看下面的Stack Overflow线程：  信号量超时期限已过期"SQL Azure

您的应用技术堆栈基于什么？ （.NET等）

另请参阅：  使用SQL数据库连接问题和暂时性错误

我希望这会有所帮助。

麦克

I have a customer who is getting consistent error connecting our application to their Azure SQL database:

A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The semaphore timeout period has expired.)

Unfortunately, this doesn't appear to be in the published list of Azure transient errors. And I can't even find the error number to check for in a .NET SQLException. Unless it is the winerror value 121, which appears to be used by a different SQL database engine error.

Does anyone have any ideas what causes this? We can retry based on the message text (ouch), but I have no idea if that will help.

Regards,

Jerry Metcoff

Gypsi BI LLC

解决方案

Hi Jerry,

Please take a look at the following Stack Overflow thread: The semaphore timeout period has expired" SQL Azure

What is your application technology stack based upon? (.NET, etc.)

Please also see: Working with SQL Database connection issues and transient errors

I hope this helps.

Mike

这篇关于信号量超时期限已从Azure过期。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！