RE: LOG: could not send data to client: Broken pipe - Mailing list pgsql-general

From TALLURI Nareshkumar
Subject RE: LOG: could not send data to client: Broken pipe
Date
Msg-id DB6PR0502MB3013F247685E825793F84548908B0@DB6PR0502MB3013.eurprd05.prod.outlook.com
Whole thread Raw
In response to Re: LOG: could not send data to client: Broken pipe  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: LOG: could not send data to client: Broken pipe  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Hello Adrian Klaver,

Here is the answers


What version of JDBC?                 :     9.3-1104-jdbc41

What is the application stack?            :    Java

Client OS?                    :    windows 2016

What is the network distance between the client/application and the server?
Reply from 184.6.160.214: bytes=32 time=2ms TTL=57
Reply from 184.6.160.214: bytes=32 time=2ms TTL=57
Reply from 184.6.160.214: bytes=32 time=2ms TTL=57
Reply from 184.6.160.214: bytes=32 time=2ms TTL=57

Ping statistics for 184.6.160.214:
    Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
    Minimum = 2ms, Maximum = 2ms, Average = 2ms


Regards,
Narresh




-----Original Message-----
From: Adrian Klaver <adrian.klaver@aklaver.com>
Sent: Tuesday, June 2, 2020 7:50 PM
To: TALLURI Nareshkumar SgscGtsPasDre <nareshkumar.talluri@socgen.com>; pgsql-general@postgresql.org
Subject: Re: LOG: could not send data to client: Broken pipe

On 6/1/20 8:41 PM, TALLURI Nareshkumar wrote:
> Hello Postgres Support Team,
>
> I need your help to identify the issue and apply the fix for it.
>
> My client is running one query through Application and getting error
> like below.
>
> 11:20:46.298 [http-nio-8083-exec-7] ERROR
> c.s.s.g.a.alcor.pdi.dao.PdiDao
> - While getting pdi from 2019-12-21 to 2020-06-01: An I/O error
> occurred while sending to the backend.
>
> org.postgresql.util.PSQLException: An I/O error occurred while sending
> to the backend.
>

Should have included in previous post:

What version of JDBC?

What is the application stack?

Client OS?

What is the network distance between the client/application and the server?


--
Adrian Klaver
adrian.klaver@aklaver.com



pgsql-general by date:

Previous
From: Stephen Frost
Date:
Subject: Re: When to use PARTITION BY HASH?
Next
From: Ron
Date:
Subject: Re: Oracle vs. PostgreSQL - a comment