03:30:24.721	Failed to load grid data of SI Audit Transactions page.  could not execute query
[ select  ProjectID,PlazaID,ID, HTransactionNumber,LaneTransactionNumber,VehicleNumber VehicleNumber,LaneID,TDateTime,ShiftID,ShiftsType,ClassName,AVCClassName,WimClassName,TcClassID,AVCClassID,PaymentMeansID,PaymentMeans,TotalPaidAmount,WIMPaidAmt,TCUserID,Simulation  ,IsOverloaded,CONCAT('Lane ',LaneID ) as Lane,OperationShiftNumber,WimAmount,IsOverloaded,IsSWB ,IsAudited,AuditMode,FastagTransactionNumber,PMethodID,LaneDirectionID,CardID,DateTime, TagClass, TCSubClassID, AVCSubClassID
                            from vw_ValidateTransactionDetails Where  cast(TDateTime as date) BETWEEN cast('2024-05-27 03:27:03' as date)  AND cast('2024-05-27 03:27:03' as date) and IFNULL(IsAuditCancel,0)=0 and IFNULL(IsAudited,0)=0 and AuditDateTime is  null and IFNULL(IsFakeViolation,0)!=1 and PlazaID=3 and ProjectID=1   And ShiftID  IN (3) order by TDateTime desc ]
[SQL: select  ProjectID,PlazaID,ID, HTransactionNumber,LaneTransactionNumber,VehicleNumber VehicleNumber,LaneID,TDateTime,ShiftID,ShiftsType,ClassName,AVCClassName,WimClassName,TcClassID,AVCClassID,PaymentMeansID,PaymentMeans,TotalPaidAmount,WIMPaidAmt,TCUserID,Simulation  ,IsOverloaded,CONCAT('Lane ',LaneID ) as Lane,OperationShiftNumber,WimAmount,IsOverloaded,IsSWB ,IsAudited,AuditMode,FastagTransactionNumber,PMethodID,LaneDirectionID,CardID,DateTime, TagClass, TCSubClassID, AVCSubClassID
                            from vw_ValidateTransactionDetails Where  cast(TDateTime as date) BETWEEN cast('2024-05-27 03:27:03' as date)  AND cast('2024-05-27 03:27:03' as date) and IFNULL(IsAuditCancel,0)=0 and IFNULL(IsAudited,0)=0 and AuditDateTime is  null and IFNULL(IsFakeViolation,0)!=1 and PlazaID=3 and ProjectID=1   And ShiftID  IN (3) order by TDateTime desc]MySql.Data.MySqlClient.MySqlException (0x80004005): Fatal error encountered during command execution.
 ---> MySql.Data.MySqlClient.MySqlException (0x80004005): Fatal error encountered attempting to read the resultset.
 ---> MySql.Data.MySqlClient.MySqlException (0x80004005): Reading from the stream has failed.
 ---> System.IO.IOException: Unable to read data from the transport connection: Connection timed out.
 ---> System.Net.Sockets.SocketException (110): Connection timed out
   at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size) in /_/src/System.Net.Sockets/src/System/Net/Sockets/NetworkStream.cs:line 298
   --- End of inner exception stack trace ---
   at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size) in /_/src/System.Net.Sockets/src/System/Net/Sockets/NetworkStream.cs:line 298
   at System.Net.Security.SslStream.FillBufferAsync[TReadAdapter](TReadAdapter adapter, Int32 minSize) in /_/src/System.Net.Security/src/System/Net/Security/SslStream.Implementation.cs:line 1463
   at System.Net.Security.SslStream.ReadAsyncInternal[TReadAdapter](TReadAdapter adapter, Memory`1 buffer) in /_/src/System.Net.Security/src/System/Net/Security/SslStream.Implementation.cs:line 1439
   at System.Net.Security.SslStream.Read(Byte[] buffer, Int32 offset, Int32 count) in /_/src/System.Net.Security/src/System/Net/Security/SslStream.cs:line 753
   at MySql.Data.MySqlClient.TimedStream.Read(Byte[] buffer, Int32 offset, Int32 count)
   at MySql.Data.MySqlClient.MySqlStream.ReadFully(Stream stream, Byte[] buffer, Int32 offset, Int32 count)
   at MySql.Data.MySqlClient.MySqlStream.LoadPacket()
   at MySql.Data.MySqlClient.MySqlStream.LoadPacket()
   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.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at NHibernate.AdoNet.AbstractBatcher.ExecuteReader(DbCommand cmd)
   at NHibernate.Loader.Loader.GetResultSet(DbCommand st, QueryParameters queryParameters, ISessionImplementor session, IResultTransformer forcedResultTransformer)
   at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies, IResultTransformer forcedResultTransformer)
   at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies, IResultTransformer forcedResultTransformer)
   at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters, IResultTransformer forcedResultTransformer)   at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters, IResultTransformer forcedResultTransformer)
   at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters)
   at NHibernate.Impl.SessionImpl.ListCustomQuery(ICustomQuery customQuery, QueryParameters queryParameters, IList results)
   at NHibernate.Impl.AbstractSessionImpl.List(NativeSQLQuerySpecification spec, QueryParameters queryParameters, IList results)
   at NHibernate.Impl.AbstractSessionImpl.List[T](NativeSQLQuerySpecification spec, QueryParameters queryParameters)
   at NHibernate.Impl.SqlQueryImpl.List[T]()
   at QuaLiX.TMS.Web.Areas.Validation.Controllers.SIAuditController.GetGridList(TransactionSearchMultiSelection jsonData, String isRealTime, Int32 isSwb) in F:\WorkingProjects\TMS\QuaLiX.TMS.WebApp\QuaLiX.TMS.Web\Areas\Validation\Controllers\SIAuditController.cs:line 221 	[Login Info:: ADMIN1: Qualix ]
04:01:35.126	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(1030612605240502559,1030512605240503422,1030512605240754019,1030622605240809587,1030522605240954004,1030522605241127073,1030522605241138252,1030522605241147155,1030522605241153242,1030522605241204570,1030522605241232415,1030522605241232561,1030522605241241407,1030522605241256434,1030522605241329345,1030522605241430593,1030722605241123174,1030722605241151490,1030722605241450052,1030622605241234442,1030732605241940018,1030632605241602471,1030632605241801122,1030632605241848107,1030632605241903277,1030632605241950092,1030632605241957421,1030632605242235565)[SQL: UPDATE lanetransactions SET ATTRIBUTE_4='' WHERE LaneTransactionNumber in(1030612605240502559,1030512605240503422,1030512605240754019,1030622605240809587,1030522605240954004,1030522605241127073,1030522605241138252,1030522605241147155,1030522605241153242,1030522605241204570,1030522605241232415,1030522605241232561,1030522605241241407,1030522605241256434,1030522605241329345,1030522605241430593,1030722605241123174,1030722605241151490,1030722605241450052,1030622605241234442,1030732605241940018,1030632605241602471,1030632605241801122,1030632605241848107,1030632605241903277,1030632605241950092,1030632605241957421,1030632605242235565)]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 F:\WorkingProjects\TMS\QuaLiX.TMS.WebApp\QuaLiX.TMS.Web\Areas\Validation\Controllers\UploadFastagExitTrxnController.cs:line 149 	[Login Info:: ADMIN1: Qualix ]