**********************************************************  
 Time Of Error            : 18-09-2015 16:41:48
 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 MySqlHelper.ExecuteNonQuery(MySqlTransaction transaction, CommandType commandType, String commandText, MySqlParameter[] commandParameters) in d:\ItDose\Live_code\ArthDiagnostic_02_09_15\ArthDiagnostic\App_Code\DataLinkLayer\ODBCHelper.cs:line 324
   at MySqlHelper.ExecuteNonQuery(MySqlTransaction transaction, CommandType commandType, String commandText) in d:\ItDose\Live_code\ArthDiagnostic_02_09_15\ArthDiagnostic\App_Code\DataLinkLayer\ODBCHelper.cs:line 300
   at PatientLabSearch.MultApprove(String textVal, String ID, String Comments, String cmd, String ApprovedBY, String ApprovedByName) in d:\ItDose\Live_code\ArthDiagnostic_02_09_15\ArthDiagnostic\Design\Lab\Services\PatientLabSearch.asmx:line 1803
 Error On Machine         : WIN-S5LST7NQ3M9
 Error Machine IP Address : 192.168.2.33