ado.net transaction.commit 抛出 semaphorefullexception

Question

当我提交交易时，我得到：

System.Threading.SemaphoreFullException: Adding the specified count to the semaphore would cause it to exceed its maximum count.
   at System.Threading.Semaphore.Release(Int32 releaseCount)
   at System.Data.ProviderBase.DbConnectionPool.PutNewObject(DbConnectionInternal obj)
   at System.Data.ProviderBase.DbConnectionPool.DeactivateObject(DbConnectionInternal obj)
   at System.Data.ProviderBase.DbConnectionPool.PutObject(DbConnectionInternal obj, Object owningObject)
   at System.Data.ProviderBase.DbConnectionInternal.CloseConnection(DbConnection owningObject, DbConnectionFactory connectionFactory)
   at System.Data.SqlClient.SqlConnection.Close()
   at System.Data.SqlClient.SqlConnection.Dispose(Boolean disposing)
   at System.ComponentModel.Component.Dispose()
   // rest of my stack trace here

这是什么意思？我是否没有在某处正确关闭连接并且已填满池？如果是这样，我如何在 SQL Server 2008 R2 中检查这一点？

这是我的代码（尽管这可能不是导致连接泄漏的代码）

using (var connection = connectionFactory.GetConnection())
{
    connection.Open();

    using (var transaction = connection.BeginTransaction())
    {
        try
        {
            using (var command = connection.CreateCommand())
            {
                command.Connection = connection;
                command.Transaction = transaction;
                command.CommandText = "some sql"

                data = (string) command.ExecuteScalar();

                transaction.Commit();
            }
        }
        catch
        {
            try
            {
                transaction.Rollback();
            }
            catch
            {
            }
            throw;
        }
    }
}

return data;

Answer 1

正如皮特提到的，这可能是连接池中的一个错误。无论如何，我注意到您的代码缺少 MS 所说需要的调用。来自 MSDN

 // 必须同时分配事务对象和连接
   // 待处理本地事务的 Command 对象
   命令.Connection = 连接;
   命令.事​​务 = 事务;

尝试一下，看看它是否仍然会发生。