Description:
Please see the error generated from MySQL when the stored procedure is executed through ASP.Net 3.5 procedure call.
Stored procedure works fine when it is executed from Query Editor (SQLyog). Since there are 600000+ records to update, it takes approx. 6 to 10 minutes to complete the execution.
But with less data (less than 10000 records), the program works even from ASP.Net procedure call.
Error Message:"Fatal error encountered during command execution"
InnerException:"Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding"
We use the following versions:-
MySQL : 5.1 Community Edition
MySQL .Net Connector: 6.1.2
Visual Studio 2008 & ASP 3.5
Can you please give solution for this.
Since the Stored Procedure executed properly on Query Editor(SQLyog), is it the problem with the Connector used?
Thanks in advance
How to repeat:
Error Message displayed is given below:
*******************************
MySql.Data.MySqlClient.MySqlException was unhandled by user code
Message="Fatal error encountered during command execution."
Source="MySql.Data"
ErrorCode=-2147467259
Number=0
StackTrace:
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
at BraddockDAL.BraddockSqlHelper.ExecuteNonQuery(MySqlConnection connection, CommandType commandType, String commandText, MySqlParameter[] commandParameters) in F:WorkingFolderCrossGridCrossGridSVNBraddockDALBraddockSqlHelper.cs:line 363
at BraddockDAL.BraddockSqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, MySqlParameter[] commandParameters) in F:WorkingFolderCrossGridCrossGridSVNBraddockDALBraddockSqlHelper.cs:line 280
at CrossGridBL.NetworkBL.tempLCRCreation(UInt16 ArgCarrierId, UInt16 ArgNetworkId) in F:WorkingFolderCrossGridCrossGridSVNCrossGridBLNetworkBL.cs:line 60
at _Default.TempLCRCreation(String[] CarrierIdsWhenSave, String[] CarrierIdsWhenLoad) in f:WorkingFolderCrossGridCrossGridSVNCrossGridWebFormsNetworkMaster.aspx.cs:line 199
at _Default.AddEdit() in f:WorkingFolderCrossGridCrossGridSVNCrossGridWebFormsNetworkMaster.aspx.cs:line 124
at _Default.btnAddorEdit_Click(Object sender, EventArgs e) in f:WorkingFolderCrossGridCrossGridSVNCrossGridWebFormsNetworkMaster.aspx.cs:line 64
at System.Web.UI.WebControls.Button.on-cl-ick(EventArgs e)
at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
InnerException: MySql.Data.MySqlClient.MySqlException
Message="Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding."
Source="MySql.Data"
ErrorCode=-2147467259
Number=0
StackTrace:
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
InnerException:
*******************************