could not receive data from client: Connection reset by peer - Mailing list pgsql-general

From Jagmohan Kaintura
Subject could not receive data from client: Connection reset by peer
Date
Msg-id CA+cYFtus9976AJdqw1bMzgV8gfX-OxdVCLRPJ3dvf8_+GiNs_Q@mail.gmail.com
Whole thread Raw
Responses Re: could not receive data from client: Connection reset by peer
List pgsql-general
Hi Team,

We are receiving alot of below error messages in the postgresql logs. 
These all connections are being created and released by the applications attached to the database.

Please help how these failures can be identified and what all steps need to be taken for further analysis. 

2021-04-08 10:18:24 HKT [8252]: [3-1] user=cz1qa$bis_app,db=zdcq12c2,app=PostgreSQL JDBC Driver,client=172.25.254.11LOG:  could not receive data from client: Connection reset by peer


2021-04-08 10:18:24 HKT [8252]: [4-1] user=cz1qa$bis_app,db=zdcq12c2,app=PostgreSQL JDBC Driver,client=172.25.254.11LOG:  unexpected EOF on client connection with an open transaction
2021-04-08 10:18:24 HKT [8252]: [5-1] user=cz1qa$bis_app,db=zdcq12c2,app=PostgreSQL JDBC Driver,client=172.25.254.11LOG:  disconnection: session time: 1:00:00.550 user=cz1qa$bis_app database=zdcq12c2 host=172.25.254.11 port=51690
2021-04-08 10:18:24 HKT [8233]: [3-1] user=cz1qa$bis_app,db=zdcq12c2,app=PostgreSQL JDBC Driver,client=172.25.254.11LOG:  could not receive data from client: Connection reset by peer
2021-04-08 10:18:24 HKT [8235]: [3-1] user=cz1qa$bis_app,db=zdcq12c2,app=PostgreSQL JDBC Driver,client=172.25.254.11LOG:  could not receive data from client: Connection reset by peer
2021-04-08 10:18:24 HKT [8236]: [3-1] user=cz1qa$bis_app,db=zdcq12c2,app=PostgreSQL JDBC Driver,client=172.25.254.11LOG:  could not receive data from client: Connection reset by peer
2021-04-08 10:18:24 HKT [8236]: [4-1] user=cz1qa$bis_app,db=zdcq12c2,app=PostgreSQL JDBC Driver,client=172.25.254.11LOG:  disconnection: session time: 1:00:00.824 user=cz1qa$bis_app database=zdcq12c2 host=172.25.254.11 port=51673
2021-04-08 10:18:24 HKT [8233]: [4-1] user=cz1qa$bis_app,db=zdcq12c2,app=PostgreSQL JDBC Driver,client=172.25.254.11LOG:  disconnection: session time: 1:00:00.857 user=cz1qa$bis_app database=zdcq12c2 host=172.25.254.11 port=51668
2021-04-08 10:18:24 HKT [8235]: [4-1] user=cz1qa$bis_app,db=zdcq12c2,app=PostgreSQL JDBC Driver,client=172.25.254.11LOG:  disconnection: session time: 1:00:00.835 user=cz1qa$bis_app database=zdcq12c2 host=172.25.254.11 port=51672
2021-04-08 10:18:24 HKT [8237]: [3-1] user=cz1qa$bis_app,db=zdcq12c2,app=PostgreSQL JDBC Driver,client=172.25.254.11LOG:  could not receive data from client: Connection reset by peer
2021-04-08 10:18:24 HKT [8237]: [4-1] user=cz1qa$bis_app,db=zdcq12c2,app=PostgreSQL JDBC Driver,client=172.25.254.11LOG:  disconnection: session time: 1:00:00.817 user=cz1qa$bis_app database=zdcq12c2 host=172.25.254.11 port=51674
2021-04-08 10:18:24 HKT [8234]: [3-1] user=cz1qa$bis_app,db=zdcq12c2,app=PostgreSQL JDBC Driver,client=172.25.254.11LOG:  could not receive data from client: Connection reset by peer
2021-04-08 10:18:24 HKT [8234]: [4-1] user=cz1qa$bis_app,db=zdcq12c2,app=PostgreSQL JDBC Driver,client=172.25.254.11LOG:  disconnection: session time: 1:00:00.845 user=cz1qa$bis_app database=zdcq12c2 host=172.25.254.11 port=51670
2021-04-08 10:18:24 HKT [8239]: [3-1] user=cz1qa$bis_app,db=zdcq12c2,app=PostgreSQL JDBC Driver,client=172.25.254.11LOG:  could not receive data from client: Connection reset by peer
2021-04-08 10:18:24 HKT [8239]: [4-1] user=cz1qa$bis_app,db=zdcq12c2,app=PostgreSQL JDBC Driver,client=172.25.254.11LOG:  disconnection: session time: 1:00:00.801 user=cz1qa$bis_app database=zdcq12c2 host=172.25.254.11 port=51676
2021-04-08 10:18:24 HKT [8232]: [3-1] user=cz1qa$bis_app,db=zdcq12c2,app=PostgreSQL JDBC Driver,client=172.25.254.11LOG:  could not receive data from client: Connection reset by peer
2021-04-08 10:18:24 HKT [8232]: [4-1] user=cz1qa$bis_app,db=zdcq12c2,app=PostgreSQL JDBC Driver,client=172.25.254.11LOG:  disconnection: 

--
Best Regards,
Jagmohan 

pgsql-general by date:

Previous
From: Ron
Date:
Subject: Re: Primary keys and composite unique keys(basic question)
Next
From: Tom Lane
Date:
Subject: Re: could not receive data from client: Connection reset by peer