#57 Timeout expired
All
Getting this error when I am retrieving records from the
MYSQL DB.
Am pulling back about 1500 records and then I get this
error.
Any ideas
Thanks
Aidan
aidan.gill@randox.com
Server Error in '/BYTEFX' Application.
------------------------------------------------------
--------------------------
error connecting: Timeout expired. The timeout period
elapsed prior to obtaining a connection from the pool.
This may have occurred because all pooled connections
were in use and max pool size was reached.
Description: An unhandled exception occurred during the
execution of the current web request. Please review the
stack trace for more information about the error and
where it originated in the code.
Exception Details:
ByteFX.Data.MySqlClient.MySqlException: error
connecting: Timeout expired. The timeout period
elapsed prior to obtaining a connection from the pool.
This may have occurred because all pooled connections
were in use and max pool size was reached.
Source Error:
Line 63: Dim myCommand As New
MySqlCommand(query, myConn)
Line 64:
Line 65: myConn.Open()
Line 66:
Line 67: Dim myReader As MySqlDataReader =
myCommand.ExecuteReader()
Source File:
c:\inetpub\wwwroot\BYTEFX\Components\BLL\Sub-
Locations.vb Line: 65
Stack Trace:
[MySqlException: error connecting: Timeout expired.
The timeout period elapsed prior to obtaining a
connection from the pool. This may have occurred
because all pooled connections were in use and max
pool size was reached.]
ByteFX.Data.MySqlClient.MySqlPool.getDriver
(MySqlConnection conn)
ByteFX.Data.MySqlClient.MySqlPoolManager.getConnecti
onFromPool(ConnectionString connString,
MySqlConnection conn)
ByteFX.Data.MySqlClient.MySqlConnection.Open()
BYTEFX.BYTEFXREGISTER.Sub_LocationDB.GetSub_Locati
ons(Int32 intSiteID, Int32 intLocID) in
c:\inetpub\wwwroot\BYTEFX\Components\BLL\Sub-
Locations.vb:65
BYTEFX.C_Menu.Page_Load(Object sender, EventArgs
e) in c:\inetpub\wwwroot\BYTEFX\_Menu.ascx.vb:117
System.Web.UI.Control.OnLoad(EventArgs e)
System.Web.UI.Control.LoadRecursive()
System.Web.UI.Control.LoadRecursive()
System.Web.UI.Control.LoadRecursive()
System.Web.UI.Page.ProcessRequestMain()
------------------------------------------------------
--------------------------
Version Information: Microsoft .NET Framework
Version:1.1.4322.573; ASP.NET Version:1.1.4322.573
Logged In: YES
user_id=523261
I do have a bug in the connection pooling that I am trying to
find. This can also be caused by not properly closing your
connections. Connection pooling is on by default.
What version of the provider are you using? Double check
your code and make sure you are closing the connections
properly. If you are using an older version, you should
download the latest as there have been many fixes.
Thanks!