Message-ID: <d8c778c50dc7600acb4ae5797e82b37f1dab6689.camel@cybertec.at>
Subject: Re: PG15 DB Error :::could not receive data from client: Connection
 reset by peer
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Ram Pratap Maurya <ram.maurya@lavainternational.in>,
 "'pgsql-admin@lists.postgresql.org'"
	 <pgsql-admin@lists.postgresql.org>
Date: Wed, 19 Feb 2025 09:38:04 +0100
In-Reply-To: 
 <KL1PR0601MB4433812008E9B08E754609B6F0C52@KL1PR0601MB4433.apcprd06.prod.outlook.com>
References: 
	<KL1PR0601MB443336C9B802CED1A9B9B1E1F02D9@KL1PR0601MB4433.apcprd06.prod.outlook.com>
	 <KL1PR0601MB4433812008E9B08E754609B6F0C52@KL1PR0601MB4433.apcprd06.prod.outlook.com>
User-Agent: Evolution 3.54.3 (3.54.3-1.fc41) 
MIME-Version: 1.0
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Archived-At: 
 <https://www.postgresql.org/message-id/d8c778c50dc7600acb4ae5797e82b37f1dab6689.camel%40cybertec.at>
Precedence: bulk

On Wed, 2025-02-19 at 06:16 +0000, Ram Pratap Maurya wrote:
> We are getting error frequently in PostgresDB:15 log file =C2=A0,
> Please suggest why this error is coming and what is workaround to solve t=
his error.
> =C2=A0
> /var/lib/pgsql/15/data/log/postgresql-Tue.log:2025-02-18 08:07:32.309 IST=
 [1166457] LOG:=C2=A0 could not receive data from client: Connection reset =
by peer
> /var/lib/pgsql/15/data/log/postgresql-Tue.log:2025-02-18 08:07:32.310 IST=
 [1166411] LOG:=C2=A0 could not receive data from client: Connection reset =
by peer

That is a complaint by the server about the client connection being
forcibly interrupted.  Perhaps the client is not closing the database
session correctly, perhaps some network component is misconfigured.

I would first investigate what went on at the client side.  Did the
client get an error too?

Yours,
Laurenz Albe

--=20

*E-Mail Disclaimer*
Der Inhalt dieser E-Mail ist ausschliesslich fuer den=20
bezeichneten Adressaten bestimmt. Wenn Sie nicht der vorgesehene Adressat=
=20
dieser E-Mail oder dessen Vertreter sein sollten, so beachten Sie bitte,=20
dass jede Form der Kenntnisnahme, Veroeffentlichung, Vervielfaeltigung oder=
=20
Weitergabe des Inhalts dieser E-Mail unzulaessig ist. Wir bitten Sie, sich=
=20
in diesem Fall mit dem Absender der E-Mail in Verbindung zu setzen.

*CONFIDENTIALITY NOTICE & DISCLAIMER
*This message and any attachment are=20
confidential and may be privileged or otherwise protected from disclosure=
=20
and solely for the use of the person(s) or entity to whom it is intended.=
=20
If you have received this message in error and are not the intended=20
recipient, please notify the sender immediately and delete this message and=
=20
any attachment from your system. If you are not the intended recipient, be=
=20
advised that any use of this message is prohibited and may be unlawful, and=
=20
you must not copy this message or attachment or disclose the contents to=20
any other person.