.net Session State

Jordan Stewart asked on April 8, 2019 04:11

I'm looking for a method to troubleshoot custom session state on a solution that I've started supporting recently.

Current session state configuration in web.config

<sessionState mode="Custom" stateConnectionString="tcpip=" sqlConnectionString="data source=;Trusted_Connection=yes" cookieless="false" timeout="15" customProvider="DefaultSessionProvider">
    <add name="DefaultSessionProvider" type="System.Web.Providers.DefaultSessionStateProvider, System.Web.Providers, Version=, Culture=neutral, PublicKeyToken=" connectionStringName="CMSConnectionString" />

Connection string points to production database hosted in Azure, and public key token removed from this context.

I'm seeing a SELECT and UPDATE to the UAT database (which should not be accessible to the production database).

[Extent1].[SessionId] AS [SessionId], 
[Extent1].[Created] AS [Created], 
[Extent1].[Expires] AS [Expires], 
[Extent1].[LockDate] AS [LockDate], 
[Extent1].[LockCookie] AS [LockCookie], 
[Extent1].[Locked] AS [Locked], 
[Extent1].[SessionItem] AS [SessionItem], 
[Extent1].[Flags] AS [Flags], 
[Extent1].[Timeout] AS [Timeout]
FROM [dbo].[Sessions] AS [Extent1]
WHERE [Extent1].[SessionId] = @p0


 UPDATE [dbo].[Sessions]
 SET [Expires] = @0
 WHERE ([SessionId] = @1)

The parameters for the UPDATE statement reference a date from 2017 and a SessionID string that is the same for every query. I've checked my sessions table in both the production and UAT environments and neither show a SessionID or date matching those values. I've checked my system date and it's operating at the current time (UTC).

I have a few questions:

How would this statement be able to use a database that isn't the one specified in the connection string?

How am I able to troubleshoot this issue? What may be causing this to trigger? Where could it be retrieving this value of an expiry date from 2017 from?

Thanks in advance for any advice provided.

Recent Answers

Brenden Kehren answered on April 8, 2019 04:17

I'd suggest removing the custom session state if it is not needed. If it is needed, use Redis Cache instead. Faster and more reliable with your current Azure setup.

1 votesVote for this answer Mark as a Correct answer

Jordan Stewart answered on April 8, 2019 05:36

I'll look into Redis, thanks for the swift response Brenden.

0 votesVote for this answer Mark as a Correct answer

   Please, sign in to be able to submit a new answer.