Re: LOG: could not send data to client: Broken pipe

On 6/2/20 12:20 PM, TALLURI Nareshkumar wrote:
> Hello Adrian,
>
>
> What is the application stack? - I will check with Application team and get back to you.
>
> When I see Windows and interruptions to Postgres I think anti-virus software. Is there any running on the client? ---- yes , symantec

Probably should check if AV software is logging anything at the time of
the broken pipes.

>
> Are the client and server on the same network? yes
>
> Are the client/server separated by a building, country, etc? same country , But different Datacenter
>
>
> Regards,
> Narresh
>
> -----Original Message-----
> From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
> Sent: Wednesday, June 3, 2020 12:38 AM
> To: TALLURI Nareshkumar SgscGtsPasDre <nareshkumar(dot)talluri(at)socgen(dot)com>; pgsql-general(at)postgresql(dot)org
> Subject: Re: LOG: could not send data to client: Broken pipe
>
> On 6/2/20 11:18 AM, TALLURI Nareshkumar wrote:
>> Hello Adrian Klaver,
>>
>> Here is the answers
>>
>>
>> What version of JDBC? : 9.3-1104-jdbc41
>>
>> What is the application stack? : Java
>
> That is the programming language. I was looking for the actual applications used.
>
>>
>> Client OS? : windows 2016
>
> When I see Windows and interruptions to Postgres I think anti-virus software. Is there any running on the client?
>
>>
>> What is the network distance between the client/application and the server?
>
> I should have been more specific:
>
> Are the client and server on the same network?
>
> Are the client/server separated by a building, country, etc?
>
>> 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(dot)klaver(at)aklaver(dot)com>
>> Sent: Tuesday, June 2, 2020 7:50 PM
>> To: TALLURI Nareshkumar SgscGtsPasDre
>> <nareshkumar(dot)talluri(at)socgen(dot)com>; pgsql-general(at)postgresql(dot)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(dot)klaver(at)aklaver(dot)com
>>
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com