********************************************************** Time Of Error : 8/9/2022 1:48:02 PM Error Message : Fatal error encountered during command execution. Error Exeption : MySql.Data.MySqlClient.MySqlException: Fatal error encountered attempting to read the resultset. ---> MySql.Data.MySqlClient.MySqlException: Deadlock found when trying to get lock; try restarting transaction at MySql.Data.MySqlClient.MySqlStream.OpenPacket() at MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId) at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet() at MySql.Data.MySqlClient.MySqlDataReader.NextResult() --- End of inner exception stack trace --- at MySql.Data.MySqlClient.MySqlDataReader.NextResult() at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) Error Place : at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery() at LabOPD.LabPrescriptionOPDEdit(String PatientID, String Title, String PName, String Gender, String House_No, String City, String Phone, String Mobile, String Age, String DOB_ShowFormat, String DOB_DBFormat, String Relation, String RelationName, Int32 isActual, String Doctor_ID, String Panel_ID, String ReferedBy, String Source, Double TotalDiscAmt, Double TotalDiscPer, Double GrossAmount, Double NetAmount, String DiscReason, String Remarks, String ApprovedBy, String UniqueHash, String UserID, String ItemData, String PaymentData, Int32 rdDOB, String Sample, String PatientType, String ReportReceivingType, String SampleBySelf, String OtherDr, String LedgerTransactionNo, String CardNo, String Comments, String EmailID, String PDispatchData, String HomeVisitBoy, String Locality, String State, String proid, String frRate, String fOldGross, String fOldNet, String referlab) in d:\itdose\livecode\arthdiagnostic\App_Code\BuisnessLogic\LabOPD.cs:line 3044 Error On Machine : WIN-9TQ7CF0O89H Error Machine IP Address : 192.168.2.33 ********************************************************** Time Of Error : 8/9/2022 1:49:55 PM Error Message : Reading from the stream has failed. Error Exeption : System.IO.IOException: Unable to read data from the transport connection: An established connection was aborted by the software in your host machine. ---> System.Net.Sockets.SocketException: An established connection was aborted by the software in your host machine at System.Net.Sockets.Socket.Receive(Byte[] buffer, Int32 offset, Int32 size, SocketFlags socketFlags) at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size) --- End of inner exception stack trace --- at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size) at System.IO.BufferedStream.ReadByte() at MySql.Data.MySqlClient.MySqlStream.LoadPacket() Error Place : at MySql.Data.MySqlClient.MySqlStream.LoadPacket() at MySql.Data.MySqlClient.MySqlStream.OpenPacket() at MySql.Data.MySqlClient.NativeDriver.Authenticate411() at MySql.Data.MySqlClient.NativeDriver.Authenticate() at MySql.Data.MySqlClient.NativeDriver.Open() at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings) at MySql.Data.MySqlClient.MySqlConnection.Open() at StockReports.ExecuteDML(String strQuery) in d:\itdose\livecode\arthdiagnostic\App_Code\BuisnessLogic\Finance\StockReports.cs:line 595 at Design_Doctor_AddItem_Default.UpdateLoginDetails(String RoleID, String EmployeeID) in d:\itdose\livecode\arthdiagnostic\Design\Default.aspx.cs:line 184 Error On Machine : WIN-9TQ7CF0O89H Error Machine IP Address : 192.168.2.33 ********************************************************** Time Of Error : 8/9/2022 1:57:07 PM Error Message : Connection unexpectedly terminated. Error Exeption : Error Place : at MySql.Data.MySqlClient.MySqlStream.LoadPacket() at MySql.Data.MySqlClient.MySqlStream.OpenPacket() at MySql.Data.MySqlClient.NativeDriver.Authenticate411() at MySql.Data.MySqlClient.NativeDriver.Authenticate() at MySql.Data.MySqlClient.NativeDriver.Open() at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings) at MySql.Data.MySqlClient.MySqlConnection.Open() at StockReports.ExecuteScalar(String strQuery) in d:\itdose\livecode\arthdiagnostic\App_Code\BuisnessLogic\Finance\StockReports.cs:line 643 at Design_Welcome.LoadData() in d:\itdose\livecode\arthdiagnostic\Design\Welcome.aspx.cs:line 102 Error On Machine : WIN-9TQ7CF0O89H Error Machine IP Address : 192.168.2.33 ********************************************************** Time Of Error : 8/9/2022 1:57:28 PM Error Message : Fatal error encountered during command execution. Error Exeption : MySql.Data.MySqlClient.MySqlException: Fatal error encountered attempting to read the resultset. ---> MySql.Data.MySqlClient.MySqlException: Reading from the stream has failed. ---> System.IO.IOException: Unable to read data from the transport connection: An established connection was aborted by the software in your host machine. ---> System.Net.Sockets.SocketException: An established connection was aborted by the software in your host machine at System.Net.Sockets.Socket.Receive(Byte[] buffer, Int32 offset, Int32 size, SocketFlags socketFlags) at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size) --- End of inner exception stack trace --- at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size) at System.IO.BufferedStream.ReadByte() at MySql.Data.MySqlClient.MySqlStream.LoadPacket() --- End of inner exception stack trace --- at MySql.Data.MySqlClient.MySqlStream.LoadPacket() at MySql.Data.MySqlClient.MySqlStream.OpenPacket() at MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId) at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet() at MySql.Data.MySqlClient.MySqlDataReader.NextResult() --- End of inner exception stack trace --- at MySql.Data.MySqlClient.MySqlDataReader.NextResult() at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) Error Place : at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery() at LabOPD.LabPrescriptionOPDEdit(String PatientID, String Title, String PName, String Gender, String House_No, String City, String Phone, String Mobile, String Age, String DOB_ShowFormat, String DOB_DBFormat, String Relation, String RelationName, Int32 isActual, String Doctor_ID, String Panel_ID, String ReferedBy, String Source, Double TotalDiscAmt, Double TotalDiscPer, Double GrossAmount, Double NetAmount, String DiscReason, String Remarks, String ApprovedBy, String UniqueHash, String UserID, String ItemData, String PaymentData, Int32 rdDOB, String Sample, String PatientType, String ReportReceivingType, String SampleBySelf, String OtherDr, String LedgerTransactionNo, String CardNo, String Comments, String EmailID, String PDispatchData, String HomeVisitBoy, String Locality, String State, String proid, String frRate, String fOldGross, String fOldNet, String referlab) in d:\itdose\livecode\arthdiagnostic\App_Code\BuisnessLogic\LabOPD.cs:line 2948 Error On Machine : WIN-9TQ7CF0O89H Error Machine IP Address : 192.168.2.33