You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Following Query Firing more than the number of request in .net core 6 MVC application, This causing application crash and table lock more than 50%.
UPDATE [ dbo ] . [ Custom_Session_Table ] SET ExpiresAtTime = ( CASE WHEN DATEDIFF ( SECOND, @utcnow, AbsoluteExpiration ) <= SlidingExpirationInSeconds THEN AbsoluteExpiration ELSE DATEADD ( SECOND, SlidingExpirationInSeconds, @utcnow ) END ) WHERE Id = @id AND @utcnow <= ExpiresAtTime AND SlidingExpirationInSeconds IS NOT ? AND ( AbsoluteExpiration IS ? OR AbsoluteExpiration <> ExpiresAtTime )
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
-
Following Query Firing more than the number of request in .net core 6 MVC application, This causing application crash and table lock more than 50%.
UPDATE [ dbo ] . [ Custom_Session_Table ] SET ExpiresAtTime = ( CASE WHEN DATEDIFF ( SECOND, @utcnow, AbsoluteExpiration ) <= SlidingExpirationInSeconds THEN AbsoluteExpiration ELSE DATEADD ( SECOND, SlidingExpirationInSeconds, @utcnow ) END ) WHERE Id = @id AND @utcnow <= ExpiresAtTime AND SlidingExpirationInSeconds IS NOT ? AND ( AbsoluteExpiration IS ? OR AbsoluteExpiration <> ExpiresAtTime )
Any one faced this issue?
Beta Was this translation helpful? Give feedback.
All reactions