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+<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()
</Data>
</EventData>
</Event>
Charles Tenorio
