none
Windows service Com NET RRS feed

  • Pergunta

  • Olá pessoal e o seguinte: criei um serviço para fazer um atualização entre

    duas base de dados uma local e outra na web a cada 10 minutos.

    até ai blz! Criei uma classe sigleton para usar apenas um instância da conexão

    pq tava dando erro de pool de conexão, mesmo assim ficou dando erro

    ai coloquei Pooling=False  depois de 2 horas funcionando dar esse erro:


    Application: WsGee.exe

    Framework Version: v4.0.30319

    Description: The process was terminated due to an unhandled exception.

    Exception Info: System.IO.IOException

    Stack:

       at System.Net.Sockets.NetworkStream.Read(Byte[], Int32, Int32)

       at System.IO.BufferedStream.ReadByte()

       at Npgsql.NpgsqlState+<ProcessBackendResponses_Ver_3>d__a.MoveNext()

       at Npgsql.NpgsqlState.IterateThroughAllResponses(System.Collections.Generic.IEnumerable`1<Npgsql.IServerResponseObject>)

       at Npgsql.NpgsqlConnectedState.Startup(Npgsql.NpgsqlConnector)

       at Npgsql.NpgsqlConnector.Open()

       at Npgsql.NpgsqlConnectorPool.GetNonPooledConnector(Npgsql.NpgsqlConnection)

       at Npgsql.NpgsqlConnectorPool.RequestConnector(Npgsql.NpgsqlConnection)

       at Npgsql.NpgsqlConnection.Open()

       at WsGee.geeClasses.ConnectPGSQLWEB.openConnection()

       at WsGee.geeClasses.clBancoSql.get_ConexaoWeb()

       at WsGee.geeClasses.clSQL.WebsqlDataSet(System.String)

       at WsGee.geeClasses.clImportarDados.BaixarCli_BD_Gee()

       at WsGee.Service1.BaixarDados()

       at System.Threading.ThreadHelper.ThreadStart_Context(System.Object)

       at System.Threading.ExecutionContext.RunInternal(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)

       at System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)

       at System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object)

       at System.Threading.ThreadHelper.ThreadStart()

     

    XML de Evento:

    <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">

      <System>

        <Provider Name=".NET Runtime" />

        <EventID Qualifiers="0">1026</EventID>

        <Level>2</Level>

        <Task>0</Task>

        <Keywords>0x80000000000000</Keywords>

        <TimeCreated SystemTime="2013-04-02T22:52:11.000000000Z" />

        <EventRecordID>5097</EventRecordID>

        <Channel>Application</Channel>

        <Computer>pc-web</Computer>

        <Security />

      </System>

      <EventData>

        <Data>Application: WsGee.exe

    Framework Version: v4.0.30319

    Description: The process was terminated due to an unhandled exception.

    Exception Info: System.IO.IOException

    Stack:

       at System.Net.Sockets.NetworkStream.Read(Byte[], Int32, Int32)

       at System.IO.BufferedStream.ReadByte()

       at Npgsql.NpgsqlState+&lt;ProcessBackendResponses_Ver_3&gt;d__a.MoveNext()

       at Npgsql.NpgsqlState.IterateThroughAllResponses(System.Collections.Generic.IEnumerable`1&lt;Npgsql.IServerResponseObject&gt;)

       at Npgsql.NpgsqlConnectedState.Startup(Npgsql.NpgsqlConnector)

       at Npgsql.NpgsqlConnector.Open()

       at Npgsql.NpgsqlConnectorPool.GetNonPooledConnector(Npgsql.NpgsqlConnection)

       at Npgsql.NpgsqlConnectorPool.RequestConnector(Npgsql.NpgsqlConnection)

       at Npgsql.NpgsqlConnection.Open()

       at WsGee.geeClasses.ConnectPGSQLWEB.openConnection()

       at WsGee.geeClasses.clBancoSql.get_ConexaoWeb()

       at WsGee.geeClasses.clSQL.WebsqlDataSet(System.String)

       at WsGee.geeClasses.clImportarDados.BaixarCli_BD_Gee()

       at WsGee.Service1.BaixarDados()

       at System.Threading.ThreadHelper.ThreadStart_Context(System.Object)

       at System.Threading.ExecutionContext.RunInternal(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)

       at System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)

       at System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object)

       at System.Threading.ThreadHelper.ThreadStart()

    </Data>

      </EventData>

    </Event>


    Charles Tenorio

    quarta-feira, 3 de abril de 2013 00:05