none
Pré-login handshake and transport-level RRS feed

  • Pergunta

  • E ai pessoal,

    Bom postei aqui alguns erros sobre pooling, alguns deles resolvidos. (erros de transport-level dentre outros)

    Agora eu estou tendo alguns erros recorrentes que vem em ondas de 5 ou 6 de uma vez soh, porem esporádicos.

    Nós ja retiramos o pooling, apesar de decair a performance, e os problemas de rede ja foram resolvidos.

    Obrigado,

    Leonardo

    ERROR 1

    System.Web.HttpException: Unable to connect to SQL Server session database.
    ---> System.Data.SqlClient.SqlException: A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)
     
     at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
    exception, Boolean breakConnection)
      at
    System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObjec
    t stateObj)
      at System.Data.SqlClient.TdsParser.ConsumePreLoginHandshake(Boolean
    encrypt, Boolean trustServerCert, Boolean& marsCapable)
      at System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner,
    Boolean& failoverDemandDone, String host, String failoverPartner, String
    protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean
    encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection
    owningObject, Boolean aliasLookup)
      at
    System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection
    owningObject, SqlConnectionString connectionOptions, String newPassword,
    Boolean redirectedUserInstance)
      at
    System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentit
    y identity, SqlConnectionString connectionOptions, Object providerInfo,
    String newPassword, SqlConnection owningObject, Boolean
    redirectedUserInstance)
      at
    System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOpti
    ons options, Object poolGroupProviderInfo, DbConnectionPool pool,
    DbConnection owningConnection)
      at
    System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbCon
    nection owningConnection, DbConnectionPoolGroup poolGroup)
      at
    System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection
    owningConnection)
      at
    System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection
    outerConnection, DbConnectionFactory connectionFactory)
      at System.Data.SqlClient.SqlConnection.Open()
      at
    System.Web.SessionState.SqlSessionStateStore.SqlStateConnection..ctor(SqlPar
    titionInfo sqlPartitionInfo)
      --- End of inner exception stack trace ---
      at
    System.Web.SessionState.SqlSessionStateStore.ThrowSqlConnectionException(Sql
    Connection conn, Exception e)
      at
    System.Web.SessionState.SqlSessionStateStore.SqlStateConnection..ctor(SqlPar
    titionInfo sqlPartitionInfo)
      at System.Web.SessionState.SqlSessionStateStore.GetConnection(String id,
    Boolean& usePooling)
      at System.Web.SessionState.SqlSessionStateStore.DoGet(HttpContext
    context, String id, Boolean getExclusive, Boolean& locked, TimeSpan&
    lockAge, Object& lockId, SessionStateActions& actionFlags)
      at
    System.Web.SessionState.SqlSessionStateStore.GetItemExclusive(HttpContext
    context, String id, Boolean& locked, TimeSpan& lockAge, Object& lockId,
    SessionStateActions& actionFlags)
      at System.Web.SessionState.SessionStateModule.GetSessionStateItem()
      at System.Web.SessionState.SessionStateModule.BeginAcquireState(Object
    source, EventArgs e, AsyncCallback cb, Object extraData)
      at
    System.Web.HttpApplication.AsyncEventExecutionStep.System.Web.HttpApplicatio
    n.IExecutionStep.Execute()
      at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
    completedSynchronously)


    System.Data.SqlClient.SqlException: A connection was successfully
    established with the server, but then an error occurred during the pre-login
    handshake. (provider: TCP Provider, error: 0 - The specified network name is
    no longer available.)
      at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
    exception, Boolean breakConnection)
      at
    System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObjec
    t stateObj)
      at System.Data.SqlClient.TdsParser.ConsumePreLoginHandshake(Boolean
    encrypt, Boolean trustServerCert, Boolean& marsCapable)
      at System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner,
    Boolean& failoverDemandDone, String host, String failoverPartner, String
    protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean
    encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection
    owningObject, Boolean aliasLookup)
      at
    System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection
    owningObject, SqlConnectionString connectionOptions, String newPassword,
    Boolean redirectedUserInstance)
      at
    System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentit
    y identity, SqlConnectionString connectionOptions, Object providerInfo,
    String newPassword, SqlConnection owningObject, Boolean
    redirectedUserInstance)
      at
    System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOpti
    ons options, Object poolGroupProviderInfo, DbConnectionPool pool,
    DbConnection owningConnection)
      at
    System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbCon
    nection owningConnection, DbConnectionPoolGroup poolGroup)
      at
    System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection
    owningConnection)
      at
    System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection
    outerConnection, DbConnectionFactory connectionFactory)
      at System.Data.SqlClient.SqlConnection.Open()
      at
    System.Web.SessionState.SqlSessionStateStore.SqlStateConnection..ctor(SqlPar
    titionInfo sqlPartitionInfo)


    ERROR 2

    System.Web.HttpException: Unable to connect to SQL Server session database. ---> System.Data.SqlClient.SqlException: A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.) at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
      at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
    exception, Boolean breakConnection)
      at
    System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObjec
    t stateObj)
      at System.Data.SqlClient.TdsParserStateObject.ThrowExceptionAndWarning()
      at System.Data.SqlClient.TdsParserStateObject.WriteSni()
      at System.Data.SqlClient.TdsParserStateObject.WritePacket(Byte flushMode)
      at System.Data.SqlClient.TdsParserStateObject.ExecuteFlush()
      at System.Data.SqlClient.TdsParser.TdsExecuteRPC(_SqlRPC[] rpcArray,
    Int32 timeout, Boolean inSchema, SqlNotificationRequest notificationRequest,
    TdsParserStateObject stateObj)
      at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior
    cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
      at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
    cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method,
    DbAsyncResult result)
      at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
    cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
      at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
    behavior, String method)
      at System.Data.SqlClient.SqlCommand.ExecuteReader()
      at System.Web.SessionState.SqlSessionStateStore.DoGet(HttpContext
    context, String id, Boolean getExclusive, Boolean& locked, TimeSpan&
    lockAge, Object& lockId, SessionStateActions& actionFlags)
      --- End of inner exception stack trace ---
      at
    System.Web.SessionState.SqlSessionStateStore.ThrowSqlConnectionException(Sql
    Connection conn, Exception e)
      at System.Web.SessionState.SqlSessionStateStore.DoGet(HttpContext
    context, String id, Boolean getExclusive, Boolean& locked, TimeSpan&
    lockAge, Object& lockId, SessionStateActions& actionFlags)
      at
    System.Web.SessionState.SqlSessionStateStore.GetItemExclusive(HttpContext
    context, String id, Boolean& locked, TimeSpan& lockAge, Object& lockId,
    SessionStateActions& actionFlags)
      at System.Web.SessionState.SessionStateModule.GetSessionStateItem()
      at System.Web.SessionState.SessionStateModule.BeginAcquireState(Object
    source, EventArgs e, AsyncCallback cb, Object extraData)
      at
    System.Web.HttpApplication.AsyncEventExecutionStep.System.Web.HttpApplicatio
    n.IExecutionStep.Execute()
      at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
    completedSynchronously)


    System.Data.SqlClient.SqlException: A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)
      at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
    Boolean breakConnection)
      at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
    exception, Boolean breakConnection)
      at
    System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObjec
    t stateObj)
      at System.Data.SqlClient.TdsParserStateObject.ThrowExceptionAndWarning()
      at System.Data.SqlClient.TdsParserStateObject.WriteSni()
      at System.Data.SqlClient.TdsParserStateObject.WritePacket(Byte flushMode)
      at System.Data.SqlClient.TdsParserStateObject.ExecuteFlush()
      at System.Data.SqlClient.TdsParser.TdsExecuteRPC(_SqlRPC[] rpcArray,
    Int32 timeout, Boolean inSchema, SqlNotificationRequest notificationRequest,
    TdsParserStateObject stateObj)
      at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior
    cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
      at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
    cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method,
    DbAsyncResult result)
      at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
    cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
      at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
    behavior, String method)
      at System.Data.SqlClient.SqlCommand.ExecuteReader()
      at System.Web.SessionState.SqlSessionStateStore.DoGet(HttpContext
    context, String id, Boolean getExclusive, Boolean& locked, TimeSpan&
    lockAge, Object& lockId, SessionStateActions& actionFlags)
    segunda-feira, 4 de agosto de 2008 13:48

Respostas

Todas as Respostas