10:42:25.810 Failed to load grid data of Upload Fastag Exit Trxn page. could not execute native bulk manipulation query: UPDATE lanetransactions SET ATTRIBUTE_4='' WHERE LaneTransactionNumber in(130610502240745168,130520502240814333,130520502241034203,130520502241125174,130520502241245005,130520502241359045,130620502240950084,130620502241011106,130620502241054238,130620502241247114,130720502241405340,130720502241413355,130620502241432465,130530502241614337,130530502241757090,130530502241809326,130530502241836578,130530502241847001,130530502242038519,130530502242138180,130530502242252096,130530502242326449,130630502241937437,130630502242148097,130930502242124474)[SQL: UPDATE lanetransactions SET ATTRIBUTE_4='' WHERE LaneTransactionNumber in(130610502240745168,130520502240814333,130520502241034203,130520502241125174,130520502241245005,130520502241359045,130620502240950084,130620502241011106,130620502241054238,130620502241247114,130720502241405340,130720502241413355,130620502241432465,130530502241614337,130530502241757090,130530502241809326,130530502241836578,130530502241847001,130530502242038519,130530502242138180,130530502242252096,130530502242326449,130630502241937437,130630502242148097,130930502242124474)]MySql.Data.MySqlClient.MySqlException (0x80004005): Deadlock found when trying to get lock; try restarting transaction at MySql.Data.MySqlClient.MySqlStream.ReadPacket() at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId) at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force) at MySql.Data.MySqlClient.MySqlDataReader.NextResult() at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery() at NHibernate.AdoNet.AbstractBatcher.ExecuteNonQuery(DbCommand cmd) at NHibernate.Engine.Query.NativeSQLQueryPlan.PerformExecuteUpdate(QueryParameters queryParameters, ISessionImplementor session) at NHibernate.Engine.Query.NativeSQLQueryPlan.PerformExecuteUpdate(QueryParameters queryParameters, ISessionImplementor session) at NHibernate.Impl.SessionImpl.ExecuteNativeUpdate(NativeSQLQuerySpecification nativeQuerySpecification, QueryParameters queryParameters) at NHibernate.Impl.SqlQueryImpl.ExecuteUpdate() at QuaLiX.TMS.Web.Areas.Validation.Controllers.UploadFastagExitTrxnController.UpdateFastagTransaction(String LTNumber, String newTransList, Int32 uploadAll) in D:\WorkingProjects\OpenSource TMS\BackOffice\QuaLiX.TMS.WebApp\QuaLiX.TMS.Web\Areas\Validation\Controllers\UploadFastagExitTrxnController.cs:line 149 [Login Info:: ADMIN: Administrator User] 10:43:01.122 Failed to load grid data of Upload Fastag Exit Trxn page. could not execute native bulk manipulation query: UPDATE lanetransactions SET ATTRIBUTE_4='' WHERE LaneTransactionNumber in(130610502240745168,130520502240814333,130520502241034203,130520502241125174,130520502241245005,130520502241359045,130620502240950084,130620502241011106,130620502241054238,130620502241247114,130720502241405340,130720502241413355,130620502241432465,130530502241614337,130530502241757090,130530502241809326,130530502241847001,130530502242138180,130530502242252096)[SQL: UPDATE lanetransactions SET ATTRIBUTE_4='' WHERE LaneTransactionNumber in(130610502240745168,130520502240814333,130520502241034203,130520502241125174,130520502241245005,130520502241359045,130620502240950084,130620502241011106,130620502241054238,130620502241247114,130720502241405340,130720502241413355,130620502241432465,130530502241614337,130530502241757090,130530502241809326,130530502241847001,130530502242138180,130530502242252096)]MySql.Data.MySqlClient.MySqlException (0x80004005): Deadlock found when trying to get lock; try restarting transaction at MySql.Data.MySqlClient.MySqlStream.ReadPacket() at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId) at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force) at MySql.Data.MySqlClient.MySqlDataReader.NextResult() at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery() at NHibernate.AdoNet.AbstractBatcher.ExecuteNonQuery(DbCommand cmd) at NHibernate.Engine.Query.NativeSQLQueryPlan.PerformExecuteUpdate(QueryParameters queryParameters, ISessionImplementor session) at NHibernate.Engine.Query.NativeSQLQueryPlan.PerformExecuteUpdate(QueryParameters queryParameters, ISessionImplementor session) at NHibernate.Impl.SessionImpl.ExecuteNativeUpdate(NativeSQLQuerySpecification nativeQuerySpecification, QueryParameters queryParameters) at NHibernate.Impl.SqlQueryImpl.ExecuteUpdate() at QuaLiX.TMS.Web.Areas.Validation.Controllers.UploadFastagExitTrxnController.UpdateFastagTransaction(String LTNumber, String newTransList, Int32 uploadAll) in D:\WorkingProjects\OpenSource TMS\BackOffice\QuaLiX.TMS.WebApp\QuaLiX.TMS.Web\Areas\Validation\Controllers\UploadFastagExitTrxnController.cs:line 149 [Login Info:: ADMIN: Administrator User]