Re: LOG: could not send data to client: Broken pipe - Mailing list pgsql-general
From | Adrian Klaver |
---|---|
Subject | Re: LOG: could not send data to client: Broken pipe |
Date | |
Msg-id | c841d2dd-7a85-adff-9383-71f9e13786f4@aklaver.com Whole thread Raw |
In response to | LOG: could not send data to client: Broken pipe (TALLURI Nareshkumar <nareshkumar.talluri@socgen.com>) |
List | pgsql-general |
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.klaver@aklaver.com
pgsql-general by date: