session record in ASPStateTempSes sions remains locked indefinitely

[SethHer]

error:

System.Web.Http Exception: Exception of type System.Web.Http Exception was
thrown. ---> System.Web.Http Exception: Unable to connect to SQL Server
session database. ---> System.Data.Sql Client.SqlExcep tion: General network
error. Check your network documentation.

at System.Data.Sql Client.SqlComma nd.ExecuteReade r(CommandBehavi or
cmdBehavior, RunBehavior runBehavior, Boolean returnStream)

at System.Data.Sql Client.SqlComma nd.ExecuteReade r()

at System.Web.Sess ionState.SqlSta teClientManager .DoGet(String id, SqlCommand
cmd)

--- End of inner exception stack trace ---

at System.Web.Sess ionState.SqlSta teClientManager .DoGet(String id, SqlCommand
cmd)

at System.Web.Sess ionState.SqlSta teClientManager .GetExclusive(S tring id)

at
System.Web.Sess ionState.SqlSta teClientManager .System.Web.Ses sionState.IStat eClientManager. BeginGetExclusi ve(String id, AsyncCallback cb, Object state)

at System.Web.Sess ionState.Sessio nStateModule.Ge tSessionStateIt em()

at
System.Web.Sess ionState.Sessio nStateModule.Po llLockedSession Callback(Object
state)

--- End of inner exception stack trace ---

at System.Web.Http AsyncResult.End ()

at System.Web.Sess ionState.Sessio nStateModule.En dAcquireState(I AsyncResult ar)

at System.Web.Asyn cEventExecution Step.OnAsyncEve ntCompletion(IA syncResult ar)

symptom:

we occasionally experience a large number of persistent locks requests for
specific sessionid on the sql state server used by our web apps.

from our experimentation .

if a sessionid in the ASPStateTempSes sions has it's field locked, set to 1
and not set back to 0, and another request is made for the same session the
locking behavior above occurs resulting in the error above.

we have not been able to replicate it well.
we typically experience it under heavy load.
any additional information anyone could provide would be greatly appreciated.

-seth

[Dave]

Seth,

Were you able resolve the "Unable to connect to SQL Server session database"
error?

We are running on Windows 2003 web farm and I get this error as well as a

"OutOfMemoryExc eption.. Unable to serialize the session state error after
the app is running for a couple hours."

Thanks, dave.

"SethHer" wrote:

error:

System.Web.Http Exception: Exception of type System.Web.Http Exception was
thrown. ---> System.Web.Http Exception: Unable to connect to SQL Server
session database. ---> System.Data.Sql Client.SqlExcep tion: General network
error. Check your network documentation.

at System.Data.Sql Client.SqlComma nd.ExecuteReade r(CommandBehavi or
cmdBehavior, RunBehavior runBehavior, Boolean returnStream)

at System.Data.Sql Client.SqlComma nd.ExecuteReade r()

at System.Web.Sess ionState.SqlSta teClientManager .DoGet(String id, SqlCommand
cmd)

--- End of inner exception stack trace ---

at System.Web.Sess ionState.SqlSta teClientManager .DoGet(String id, SqlCommand
cmd)

at System.Web.Sess ionState.SqlSta teClientManager .GetExclusive(S tring id)

at
System.Web.Sess ionState.SqlSta teClientManager .System.Web.Ses sionState.IStat eClientManager. BeginGetExclusi ve(String id, AsyncCallback cb, Object state)

at System.Web.Sess ionState.Sessio nStateModule.Ge tSessionStateIt em()

at
System.Web.Sess ionState.Sessio nStateModule.Po llLockedSession Callback(Object
state)

--- End of inner exception stack trace ---

at System.Web.Http AsyncResult.End ()

at System.Web.Sess ionState.Sessio nStateModule.En dAcquireState(I AsyncResult ar)

at System.Web.Asyn cEventExecution Step.OnAsyncEve ntCompletion(IA syncResult ar)

symptom:

we occasionally experience a large number of persistent locks requests for
specific sessionid on the sql state server used by our web apps.

from our experimentation .

if a sessionid in the ASPStateTempSes sions has it's field locked, set to 1
and not set back to 0, and another request is made for the same session the
locking behavior above occurs resulting in the error above.

we have not been able to replicate it well.
we typically experience it under heavy load.
any additional information anyone could provide would be greatly appreciated.

-seth

[UK]

HI,
Is there a solution to the problem Seth has posted. Seems like we also experiencing the same issue.
Thanks.
UK

From http://search.yahoo.com/search?p=ASP...p=mss&ei=UTF-8

Posted via DevelopmentNow. com Groups
http://www.developmentnow.com