当我提交事务时,出现以下错误:
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;
TransactionScope
? - Anders Abel