当打开与底层 SQL 数据库的 SQL 连接时，我遇到了非常奇怪的 ArithmeticOverflowException(下面包含堆栈跟踪)。使用哪个版本的服务器没有区别(我已经验证了 MS SQL 2005/2008/2012/2014)，错误仍然是一样的。安装了来自 Windows Update 的所有最新更新和补丁。操作系统是 Windows 8.1/10(两个系统上都一样)。服务器安装在本地，通过用户名和密码建立连接。验证的连接超时范围为 15 到 1000 秒。

最令人惊讶的是应用程序运行正常，并与服务器正常通信，执行许多各种查询，但突然出现此异常。我注意到这个异常在一些 Windows 更新后开始出现(不知道是哪个)。

我查看了 .NET 代码，但不知道是什么导致那里的算术溢出异常...

-- 堆栈跟踪--

in SNIOpenSyncExWrapper(SNI_CLIENT_CONSUMER_INFO* , SNI_ConnWrapper** )
in SNINativeMethodWrapper.SNIOpenSyncEx(ConsumerInfo consumerInfo, String constring, IntPtr& pConn, Byte[] spnBuffer, Byte[] instanceName, Boolean fOverrideCache, Boolean fSync, Int32 timeout, Boolean fParallel)
in System.Data.SqlClient.SNIHandle..ctor(ConsumerInfo myInfo, String serverName, Byte[] spnBuffer, Boolean ignoreSniOpenTimeout, Int32 timeout, Byte[]& instanceName, Boolean flushCache, Boolean fSync, Boolean fParallel)
in System.Data.SqlClient.TdsParserStateObject.CreatePhysicalSNIHandle(String serverName, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Byte[]& instanceName, Byte[] spnBuffer, Boolean flushCache, Boolean async, Boolean fParallel)
in System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, Boolean withFailover)
in System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, Boolean withFailover)
in System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString connectionOptions, SqlCredential credential, TimeoutTimer timeout)
in System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(TimeoutTimer timeout, SqlConnectionString connectionOptions, SqlCredential credential, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance)
in System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData)
in System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
in System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions)
in System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
in System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
in System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
in System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
in System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
in System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
in System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
in System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
in System.Data.SqlClient.SqlConnection.Open()

最佳答案

我遇到了同样的问题。 Lavasoft 也是一个原因。 如果有任何 Lavasoft 程序，我会在 Program and Features 中查看，我很惊讶地发现了 Lavasoft 的 WebCompanion 应用程序。我还发现了一个正在运行的服务 LavasoftTcpService。

1. 我停止了 LavasoftTcpService 服务(来自 services.msc)
2. 我从程序和功能中卸载了 WebCompanion。
3. 上面提到的两个 dll(C:\Windows\System32 和 C:\Windows\SysWOW64 中的 LavasoftTcpService.dll 和 LavasoftTcpService64.dll)仍然存在。我更改了他们的名字，问题就消失了。

在这些步骤之前，我尝试只更改 dll 名称，但在解析 localhost 时出现问题:系统正在寻找 0.0.0.0 而不是 127.0.0.1。 Ping 给我一条错误消息“Ping 请求找不到主机 localhost。请检查名称并重试”

3 个步骤解决了问题。

关于c# - 打开SQL连接时算术溢出异常，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/32609088/