我有一个exe，它给出了以下错误。
超时已过期。在获取来自池的连接。发生这种情况的原因可能是连接正在使用，已达到最大池大小。
我使用使用语句创建连接对象并关闭连接在finally块中。
在exe连接字符串的web.config中，app_pool大小的最大值为200。
我还使用sp_who2命令检查了连接，该命令显示了25个连接。
private Dictionary<string, SomeObject> SomeMethod(int orderedXmlId, string clientLogFilePath, ref bool errorGettingRMData)
{
Dictionary<string, SomeObject> someDictionary = new Dictionary<string, SomeObject>();
//Create connection object
using (SqlConnection connection = new SqlConnection(ConfigurationSettings.AppSettings["MasterDB"]))
{
SqlCommand command = null;
try
{
//open the connection
connection.Open();
command = new SqlCommand("someSP", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@someParameter", someParameter);
command.CommandTimeout = _commandTimeOut;
using (SqlDataReader someVariable = command.ExecuteReader(CommandBehavior.CloseConnection))
{
if (someVariable != null && someVariable.HasRows)
{
int intId = someVariable.GetOrdinal("intId");
int imageUrl = someVariable.GetOrdinal("imageUrl");
int contentLength = someVariable.GetOrdinal("contentLength");
int path = someVariable.GetOrdinal("path");
int parentId = someVariable.GetOrdinal("parentId");
int propertyId = someVariable.GetOrdinal("propertyId");
while (someVariable.Read())
{
using (SomeObject someUploadObject = new SomeObject())
{
// Avoid this Exception: "An item with the same key has already been added".
if (!someDictionary.ContainsKey(someVariable.GetString(intImageUrlOrdinal)))
{
someUploadObject.OrderedXmlId =
someVariable.GetInt32(intOrderedXMLIdOrdinal);
someUploadObject.ImageUrl = someVariable.GetString(intImageUrlOrdinal);
someUploadObject.ContentLength =
someVariable.GetInt64(intContentLengthOrdinal);
someUploadObject.SaveAsPath = someVariable.GetString(intSaveAsPathOrdinal);
someUploadObject.ParentOrderedXmlId =
someVariable.GetInt32(intParentOrderedXmlIdOrdinal);
someUploadObject.PropertyId = someVariable.GetString(intPropertyIdOrdinal);
//Add to Dictionary
someDictionary.Add(someUploadObject.ImageUrl, someUploadObject);
}
else
{
if (detailedLog)
{
AddToLog("SomeMethod: Image {0}, for id:{1} is already present in someDictionary",
new object[] { someVariable.GetString(imageUrlOrdinal), lId }, 80,
false, true, clientLogFilePath);
}
}
}
}
someVariable.Close();
}
//No records are found i.e. Datareader is empty
else
{
//Do nothing
}
}
}
catch (Exception ex)
{
errorGettingData = true;
Logger.Write2Log("SomeMethod: Error in retrieving uploaded images for id:" + Id + "-" + ex.Message, true, 40, true, logFilePath);
SendMail(MailOption.exception, ex, logFilePath);
}
finally
{
command = null;
if (connection != null)
{
connection.Close();
}
}
//Return list of Dictionary
return someDictionary;
}
} //SomeMethod
知道这里可能出了什么问题吗？
好吧，这个错误是自我描述的。从常见嫌疑人开始：
- 检查您的服务器是否真的在使用您想要的配置(而不是限制为25个连接的配置)。看看问题是否真的从这个数字开始
- 如果可能的话，直接检查池——如果是你建立的连接被占用了，那么你没有正确地丢弃它们——通常有一种处理方式。使用它，不要重新发明轮子