could not receive data from client: Connection reset by peer

From: Jagmohan Kaintura <jagmohan(at)tecorelabs(dot)com>
To: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: could not receive data from client: Connection reset by peer
Date: 2021-04-08 02:37:48
Message-ID: CA+cYFtus9976AJdqw1bMzgV8gfX-OxdVCLRPJ3dvf8_+GiNs_Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2021-04-08 02:59:24 Re: could not receive data from client: Connection reset by peer
Previous Message Ron 2021-04-07 18:35:15 Re: Primary keys and composite unique keys(basic question)