pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedConnection forcibly closed remote server error.
6+ messages / 4 participants
[nested] [flat]
* Connection forcibly closed remote server error.
@ 2023-02-15 12:13 aditya desai <admad123@gmail.com>
0 siblings, 3 replies; 6+ messages in thread
From: aditya desai @ 2023-02-15 12:13 UTC (permalink / raw)
To: Pgsql Performance <pgsql-performance@lists.postgresql.org>
Hi,
We are getting this error when transferring data using COPY command or
running workflow for huge data. We are using Password Authentication(LDAP)
"Connection forcibly closed remote server"
Can someone help how we can avoid this?
Regards,
Aditya.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Connection forcibly closed remote server error.
@ 2023-02-15 12:35 aditya desai <admad123@gmail.com>
parent: aditya desai <admad123@gmail.com>
2 siblings, 0 replies; 6+ messages in thread
From: aditya desai @ 2023-02-15 12:35 UTC (permalink / raw)
To: Pgsql Performance <pgsql-performance@lists.postgresql.org>
Forgot to mention. The error comes intermittently. It is not consistent.
Observation is that it comes when a connection has to process a larger data
set.
On Wed, Feb 15, 2023 at 5:43 PM aditya desai <admad123@gmail.com> wrote:
> Hi,
> We are getting this error when transferring data using COPY command or
> running workflow for huge data. We are using Password Authentication(LDAP)
>
> "Connection forcibly closed remote server"
>
> Can someone help how we can avoid this?
>
>
> Regards,
> Aditya.
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Connection forcibly closed remote server error.
@ 2023-02-15 14:58 Tom Lane <tgl@sss.pgh.pa.us>
parent: aditya desai <admad123@gmail.com>
2 siblings, 0 replies; 6+ messages in thread
From: Tom Lane @ 2023-02-15 14:58 UTC (permalink / raw)
To: aditya desai <admad123@gmail.com>; +Cc: Pgsql Performance <pgsql-performance@lists.postgresql.org>
aditya desai <admad123@gmail.com> writes:
> We are getting this error when transferring data using COPY command or
> running workflow for huge data. We are using Password Authentication(LDAP)
> "Connection forcibly closed remote server"
Network timeout perhaps? If so, setting more-aggressive TCP keepalive
parameters might help.
regards, tom lane
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Connection forcibly closed remote server error.
@ 2023-02-15 18:36 Jeff Janes <jeff.janes@gmail.com>
parent: aditya desai <admad123@gmail.com>
2 siblings, 1 reply; 6+ messages in thread
From: Jeff Janes @ 2023-02-15 18:36 UTC (permalink / raw)
To: aditya desai <admad123@gmail.com>; +Cc: Pgsql Performance <pgsql-performance@lists.postgresql.org>
On Wed, Feb 15, 2023 at 7:13 AM aditya desai <admad123@gmail.com> wrote:
> Hi,
> We are getting this error when transferring data using COPY command or
> running workflow for huge data. We are using Password Authentication(LDAP)
>
> "Connection forcibly closed remote server"
>
Are you sure that that is the exact wording? It doesn't sound like grammar
that would be used for an error message. Or did you perhaps translate it
to English from a localized error message?
Is that error reported by the client, or in the server log? Whichever end
that is, what does the other end say?
Cheers,
Jeff
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Connection forcibly closed remote server error.
@ 2023-02-15 18:55 aditya desai <admad123@gmail.com>
parent: Jeff Janes <jeff.janes@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: aditya desai @ 2023-02-15 18:55 UTC (permalink / raw)
To: Jeff Janes <jeff.janes@gmail.com>; +Cc: Pgsql Performance <pgsql-performance@lists.postgresql.org>
Hi Jeff,
Apologies. Here is how the message actually looks like.
could not receive data from client: An existing connection was forcibly
closed by the remote host.
All links from Google pointing towards Connection Pooling. However it has
been implemented from the application side.
Regards,
Aditya.
On Thu, Feb 16, 2023 at 12:07 AM Jeff Janes <jeff.janes@gmail.com> wrote:
> On Wed, Feb 15, 2023 at 7:13 AM aditya desai <admad123@gmail.com> wrote:
>
>> Hi,
>> We are getting this error when transferring data using COPY command or
>> running workflow for huge data. We are using Password Authentication(LDAP)
>>
>> "Connection forcibly closed remote server"
>>
>
> Are you sure that that is the exact wording? It doesn't sound like grammar
> that would be used for an error message. Or did you perhaps translate it
> to English from a localized error message?
>
> Is that error reported by the client, or in the server log? Whichever end
> that is, what does the other end say?
>
> Cheers,
>
> Jeff
>
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Connection forcibly closed remote server error.
@ 2023-02-15 19:02 Ranier Vilela <ranier.vf@gmail.com>
parent: aditya desai <admad123@gmail.com>
0 siblings, 0 replies; 6+ messages in thread
From: Ranier Vilela @ 2023-02-15 19:02 UTC (permalink / raw)
To: aditya desai <admad123@gmail.com>; +Cc: Jeff Janes <jeff.janes@gmail.com>; Pgsql Performance <pgsql-performance@lists.postgresql.org>
Em qua., 15 de fev. de 2023 às 15:55, aditya desai <admad123@gmail.com>
escreveu:
> Hi Jeff,
> Apologies. Here is how the message actually looks like.
>
> could not receive data from client: An existing connection was forcibly
> closed by the remote host.
>
It looks like a Microsoft tool message.
Perhaps .NET
https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/connect/tls-exist-connection-clos...
I think that Postgres has nothing to do with the problem.
regards,
Ranier Vilela
>
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2023-02-15 19:02 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-02-15 12:13 Connection forcibly closed remote server error. aditya desai <admad123@gmail.com>
2023-02-15 12:35 ` aditya desai <admad123@gmail.com>
2023-02-15 14:58 ` Tom Lane <tgl@sss.pgh.pa.us>
2023-02-15 18:36 ` Jeff Janes <jeff.janes@gmail.com>
2023-02-15 18:55 ` aditya desai <admad123@gmail.com>
2023-02-15 19:02 ` Ranier Vilela <ranier.vf@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox