I hope you can help. We have a web application written in ASP.NET MVC 5 with Entity Framework 6 and using dotConnect for Postgres 2.3.293 (the latest version). The Postgres version on the server is as follows:
Code: Select all
PostgreSQL 9.2.9 on x86_64-unknown-linux-gnu, compiled by gcc (Debian 4.7.2-5) 4.7.2, 64-bit
Code: Select all
Exception information:
Exception type: PgSqlException
Exception message: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host.
at Devart.Common.af.a(Byte[] A_0, Int32 A_1, Int32 A_2)
at Devart.Common.l.c(Byte[] A_0, Int32 A_1, Int32 A_2)
at Devart.Common.z.d(Byte[] A_0, Int32 A_1, Int32 A_2)
Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host.
at Devart.Common.au.a(Byte[] A_0, Int32 A_1, Int32 A_2)
at Devart.Common.z.d(Byte[] A_0, Int32 A_1, Int32 A_2)
An existing connection was forcibly closed by the remote host
at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
Code: Select all
Exception information:
Exception type: PgSqlException
Exception message: The other side has sent a failure alert.
at Devart.Data.PostgreSql.PgSqlDataReader.f(Int32 A_0)
at Devart.Data.PostgreSql.PgSqlCommand.InternalExecute(CommandBehavior behavior, IDisposable stmt, Int32 startRecord, Int32 maxRecords)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery)
at Devart.Data.PostgreSql.Entity.t.a(CommandBehavior A_0)
at Devart.Common.Entity.ab.b(CommandBehavior A_0)
at Devart.Data.PostgreSql.Entity.t.b(CommandBehavior A_0)
at System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch[TTarget,TInterceptionContext,TResult](TTarget target, Func`3 operation, TInterceptionContext interceptionContext, Action`3 executing, Action`3 executed)
at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.Reader(DbCommand command, DbCommandInterceptionContext interceptionContext)
at System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)
The other side has sent a failure alert.
at Devart.Common.af.a(Byte[] A_0, Int32 A_1, Int32 A_2)
at Devart.Common.l.c(Byte[] A_0, Int32 A_1, Int32 A_2)
at Devart.Common.z.d(Byte[] A_0, Int32 A_1, Int32 A_2)
Code: Select all
Unicode=true;Ssl Mode=Require;Validate Connection=true;Keep Alive=30;
Code: Select all
2014-12-03 11:57:17 - An exception occurred:Error: The operation has timed out.
Stacktrace: at Devart.Data.PostgreSql.v.y()
at Devart.Data.PostgreSql.v..ctor(PgSqlConnectionOptions A_0)
at Devart.Data.PostgreSql.b.a(u A_0, Object A_1, DbConnectionBase A_2)
at Devart.Common.DbConnectionFactory.a(DbConnectionPool A_0, u A_1, DbConnectionBase A_2)
at Devart.Common.DbConnectionPool.a(DbConnectionBase A_0)
at Devart.Common.DbConnectionPool.GetObject(DbConnectionBase owningConnection)
at Devart.Common.DbConnectionFactory.b(DbConnectionBase A_0)
at Devart.Common.DbConnectionClosed.Open(DbConnectionBase outerConnection)
at Devart.Common.DbConnectionBase.Open()
at Devart.Data.PostgreSql.PgSqlConnection.Open()
at DevartConnectionTest.MainClass.<>c__DisplayClass3.<Main>b__1() in c:\Users\sbrown\Documents\DevartConnectionTest\Program.cs:line 39
Error: The operation has timed out.
Stacktrace: at Devart.Security.SSL.x.d(IAsyncResult A_0)
at Devart.Security.SSL.ah.b(IAsyncResult A_0)
at Devart.Security.SSL.ah.a(Byte[] A_0, Int32 A_1, Int32 A_2, SocketFlags A_3)
at Devart.Security.SSL.al.b(Byte[] A_0, Int32 A_1, Int32 A_2)
at Devart.Common.af.b(Byte[] A_0, Int32 A_1, Int32 A_2)
at Devart.Common.z.e(Byte[] A_0, Int32 A_1, Int32 A_2)
Do you know if there's a known issue with SSL connections in the Devart driver? Thanks!