Server did not respond within the specified timeout interval
Posted: Wed 19 Jan 2022 10:54
Hello everyone
I'm using the free release of DotConnect drivers for PostgreSQL, version 7.22
The PostgreSql server version 9.6.10
Executing a long query, after almost 40 minutes the execution returns an exception.
Hereunder the full stack trace, there are 3 nested Exceptions: the first has got the error message "Server did not respond within the specified timeout interval".
The PgSqlCommand has been set with a timeout of 1500 seconds but it seems that this setting is ignored.
When the exception is raised, the return value of ExecuteNonQuery methods matches the total amount of data to be processed.
After this event, the database connection is closed.
This behaviour occurs sistematically: no issues with the previous version of dotConnect driver (7.5.658).
Any suggestion is really appreciated,
regards.
Giuseppe
Devart.Data.PostgreSql.PgSqlException
HResult=0x80004005
Message=Server did not respond within the specified timeout interval.
Source=Devart.Data.PostgreSql
StackTrace:
at Devart.Data.PostgreSql.q.d(Exception A_0)
at Devart.Common.a7.d(Byte[] A_0, Int32 A_1, Int32 A_2)
at Devart.Common.am.a(Byte[] A_0, Int32 A_1, Int32 A_2)
at Devart.Data.PostgreSql.aa.a(Boolean A_0, Boolean A_1, Char A_2, Boolean A_3)
at Devart.Data.PostgreSql.t.g(r A_0)
at Devart.Data.PostgreSql.t.b(r A_0)
at Devart.Data.PostgreSql.r.ai()
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.InternalExecute(CommandBehavior behavior, IDisposable stmt, Int32 startRecord, Int32 maxRecords, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior)
at Devart.Common.DbCommandBase.ExecuteNonQuery()
at ClaRoot.Data.DataProvider.ExecuteNonQuery(DbConnection connection, DbProviderFactory dbProviderFactory, DbTransaction transaction, String strQuery) in C:\develop\git\wbgit\dblibrary\dbcommonlibrary\Data\DataProvider.vb:line 2020
Inner Exception 1:
TimeoutException: Server did not respond within the specified timeout interval.
Inner Exception 2:
IOException: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
Stack Trace:
at Devart.Common.a8.a(Byte[] A_0, Int32 A_1, Int32 A_2)
at Devart.Common.o.c(Byte[] A_0, Int32 A_1, Int32 A_2)
at Devart.Common.a7.d(Byte[] A_0, Int32 A_1, Int32 A_2)
Inner Exception 3:
SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond
Stack Trace:
at System.Net.Sockets.Socket.Receive(Byte[] buffer, Int32 offset, Int32 size, SocketFlags socketFlags)
at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
I'm using the free release of DotConnect drivers for PostgreSQL, version 7.22
The PostgreSql server version 9.6.10
Executing a long query, after almost 40 minutes the execution returns an exception.
Hereunder the full stack trace, there are 3 nested Exceptions: the first has got the error message "Server did not respond within the specified timeout interval".
The PgSqlCommand has been set with a timeout of 1500 seconds but it seems that this setting is ignored.
When the exception is raised, the return value of ExecuteNonQuery methods matches the total amount of data to be processed.
After this event, the database connection is closed.
This behaviour occurs sistematically: no issues with the previous version of dotConnect driver (7.5.658).
Any suggestion is really appreciated,
regards.
Giuseppe
Devart.Data.PostgreSql.PgSqlException
HResult=0x80004005
Message=Server did not respond within the specified timeout interval.
Source=Devart.Data.PostgreSql
StackTrace:
at Devart.Data.PostgreSql.q.d(Exception A_0)
at Devart.Common.a7.d(Byte[] A_0, Int32 A_1, Int32 A_2)
at Devart.Common.am.a(Byte[] A_0, Int32 A_1, Int32 A_2)
at Devart.Data.PostgreSql.aa.a(Boolean A_0, Boolean A_1, Char A_2, Boolean A_3)
at Devart.Data.PostgreSql.t.g(r A_0)
at Devart.Data.PostgreSql.t.b(r A_0)
at Devart.Data.PostgreSql.r.ai()
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.InternalExecute(CommandBehavior behavior, IDisposable stmt, Int32 startRecord, Int32 maxRecords, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior)
at Devart.Common.DbCommandBase.ExecuteNonQuery()
at ClaRoot.Data.DataProvider.ExecuteNonQuery(DbConnection connection, DbProviderFactory dbProviderFactory, DbTransaction transaction, String strQuery) in C:\develop\git\wbgit\dblibrary\dbcommonlibrary\Data\DataProvider.vb:line 2020
Inner Exception 1:
TimeoutException: Server did not respond within the specified timeout interval.
Inner Exception 2:
IOException: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
Stack Trace:
at Devart.Common.a8.a(Byte[] A_0, Int32 A_1, Int32 A_2)
at Devart.Common.o.c(Byte[] A_0, Int32 A_1, Int32 A_2)
at Devart.Common.a7.d(Byte[] A_0, Int32 A_1, Int32 A_2)
Inner Exception 3:
SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond
Stack Trace:
at System.Net.Sockets.Socket.Receive(Byte[] buffer, Int32 offset, Int32 size, SocketFlags socketFlags)
at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)