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.
>
> When I checked in the postgres log I noticed the below.
>
> 2020-06-02 02:09:21.333 CEST db:[xxx] user:[xxxxx] [xxxxxxxxxx(53643)]
> [08006] LOG:  could not send data to client: Broken pipe
>
> 2020-06-02 02:09:21.333 CEST db:[xxx] user:[xxxxx] [xxxxxxxxxxxx(53643)]
> [08006] STATEMENT:  select ………………………………. (it just a select query)
>
> 2020-06-02 02:09:21.333 CEST db:[xxx] user:[xxxxxx] [xxxxxxxxxx(53643)]
> [08006] FATAL:  connection to client lost
>
> Note: DB name, hostname, username, sql text  morphed in above message
> for security reasons, so kindly consider it.
>
> I ran the above select query from psql prompt and I got the output,
> Time: 7178.926 ms. Ofcource my one is local connection so no broken
> pipe, where as client is using the network so he is getting broken pipe.
>
>                 We checked with Network team they are claiming no
> issues with the network, But not sure.
>
> I worked with Unix team and they raised a case to Red hat support and
> got confirmation from them that “no issues observed from OS End”
>
> In-fact Red hat looking for a feedback of Postgres Community.
>
> Version of Postgres         :               PostgreSQL 9.6.5 on
> x86_64-redhat-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat
> 4.8.5-11), 64-bit
>
> OS                                          :               Red Hat
> Enterprise Linux Server release 7.2 (Maipo)
>
> We observed “LOG:  could not send data to client: Broken pipe” in
> postgres log from long time , But recently client complained about it.
> So we are in process of fixing it for which we need your help.
>
>                 Fyi.. I had performed VACUUM(FULL, ANALYZE, VERBOSE) on
> the table. So the last analyzed is latest.
>
> I already checked in Postgres archive and found below links on the same
> topic, But I could not get the concreate answer to fix the issue, so
> please help.
>
> https://www.postgresql.org/search/?m=1&q=LOG%3A++could+not+send+data+to+client%3A+Broken+pipe&l=2&d=-1&s=i
>
> checked  11,12,13,14,15,16,17,18 mail replies
>
> Let me know if you need any more details from my end.

Is there anything relevant in the OS system log around the time period
2020-06-02 02:09:21.333 CEST?

>
> Regards,
>
> Narresh

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