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@xxxxxxxxxxx
