Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps
 (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1qCH37-0005OV-Dt
	for pgsql-admin@arkaria.postgresql.org; Thu, 22 Jun 2023 09:56:22 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1qCH34-0003O8-JQ
	for pgsql-admin@arkaria.postgresql.org; Thu, 22 Jun 2023 09:56:18 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <prathap.vathuluru@outlook.com>)
	id 1qCH33-0003JI-Pg
	for pgsql-admin@lists.postgresql.org; Thu, 22 Jun 2023 09:56:18 +0000
Received: from mail-bmxind01olkn2099.outbound.protection.outlook.com
 ([40.92.103.99] helo=IND01-BMX-obe.outbound.protection.outlook.com)
	by magus.postgresql.org with esmtps  (TLS1.2) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <prathap.vathuluru@outlook.com>)
	id 1qCH2z-003zdd-Qb
	for pgsql-admin@lists.postgresql.org; Thu, 22 Jun 2023 09:56:16 +0000
ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none;
 b=nWRhg3nxu3MmOfxzaIupDjGS8icC6Js0gjnefq7Lyc1tXw70gv/9LM8nkhV4im+Px8S9kS2uA2lNlfe4NlUiUpAyNpeMJ81OzJ2azFXhu+nI0HObvCMtsistO9n0UPXKUfe4xWuDuwLxss8Ot/ioKl7Day1DkxpTgssMGALfzw86snqRyJfsKAkwJ8L0Q3Tod2NC6t0KRymH+6CMtu4OXWxe/+ugmayVHL4/AnwdXfuRXhIsTKb/x7TfCqD4HOggAPMK1gli3zfRrJ1K50cuYaGWXs9tGpv5RUXpXKmMDtUersDLbh3qhFcRjcM00Q+Vu8VAAXxo37yTWpPa7ZKrrg==
ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com;
 s=arcselector9901;
 h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1;
 bh=BpOQk52s3K9QLzmeFe5aaObnV6ggQV/eqxZkA9+gkfU=;
 b=MBbxXLyxyVrxJ5fimx8D5WWVvBtTRw+m2fwZJ9IqIlK4XvEjYNZMBlXgbOAlY+IoMrtdJVN7gYcKvCXhkUHAQhBSvPG901A/qNEf2FiXhsV+H4vDVoOW69k3KWSUn/qxdYzsOybYup+l3xA8zVWJkyVPdUWToJemAV2rbt+F5NHhf7v20XI8jnz3bV+oQllgnLKNmdL3BmSpZ3t8c6w8Agjt3UdruW2tgF7GCDHt4khrPQVTNnVYpqFqSh0qax5un7BAvlXB2jqSWXvk3+7A0QG81z5GF/MozEMvbMNeo4SbrQ19/dEoC0ayxlCgC75QtvGPdGB1lFdAwaocrF3/Pg==
ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=none; dmarc=none;
 dkim=none; arc=none
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=outlook.com;
 s=selector1;
 h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck;
 bh=BpOQk52s3K9QLzmeFe5aaObnV6ggQV/eqxZkA9+gkfU=;
 b=kjLRrszl7qrJnyapgEj3H2MrfMEawMWFY6QjIPzX0QVcrp2BzC48s726iTeRfKZcKAF4SxqvcEW6Ph8v+Wwc9LJsqAjqEJgwYetxSxng0aaA9rUhGVfGlgbHIiYnNYar66/C9lCJrM8U/+iuBjb4pl9DbbTGsY9/s72BlYg5T5dyAq6qfauOYybvwLcK1FEp+H/VtgLniiGt3hJmfRg+WvKHaFTuOQZF1gnf/gqRRsgY3TGhUB7gGRM5Yd37bWibVLX1VXUiB9FkwXFF6owNC6Y02U3cFC9/xE73xktIfau7d5DIgP6gFAjuIjla+1Q5XPCDXVdtms6RjbUl7eH0CQ==
Received: from MAXPR01MB3328.INDPRD01.PROD.OUTLOOK.COM (2603:1096:a00:6d::17)
 by MAZPR01MB6690.INDPRD01.PROD.OUTLOOK.COM (2603:1096:a01:4d::14) with
 Microsoft SMTP Server (version=TLS1_2,
 cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.6521.24; Thu, 22 Jun
 2023 09:56:08 +0000
Received: from MAXPR01MB3328.INDPRD01.PROD.OUTLOOK.COM
 ([fe80::ea94:cabe:224b:4c93]) by MAXPR01MB3328.INDPRD01.PROD.OUTLOOK.COM
 ([fe80::ea94:cabe:224b:4c93%5]) with mapi id 15.20.6521.024; Thu, 22 Jun 2023
 09:56:08 +0000
From: prathap vathuluru <prathap.vathuluru@outlook.com>
To: "pgsql-admin@lists.postgresql.org" <pgsql-admin@lists.postgresql.org>
Subject: Re:  Error LOG:  could not receive data from client: Connection reset
  by peer
Thread-Topic: Error LOG:  could not receive data from client: Connection
 reset  by peer
Thread-Index: AQHZpO7xrPmc/eavqUKqHAK69vbVLQ==
Date: Thu, 22 Jun 2023 09:56:08 +0000
Message-ID: 
 <MAXPR01MB3328F773227E6C76B06CF21BFC22A@MAXPR01MB3328.INDPRD01.PROD.OUTLOOK.COM>
Accept-Language: en-US, en-IN
Content-Language: en-US
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
msip_labels: 
x-tmn: [w7kOKPPeXOzEiWC18jjIm4pK9TZ5ZNQF]
x-ms-publictraffictype: Email
x-ms-traffictypediagnostic: MAXPR01MB3328:EE_|MAZPR01MB6690:EE_
x-ms-office365-filtering-correlation-id: 894e6b0a-8dc7-4416-9d24-08db7306e6d4
x-microsoft-antispam: BCL:0;
x-microsoft-antispam-message-info: 
 o6ebAUDfXZiZhJCQvv358p161ZoAe2n00jrNABGpFml7wskiWMF2z208dN1473RbBN74xerKKKTeT3NLwGygDtVCYgiEYxUPvxQA+NGecBFFGidT40tpz+849Dwu4JBnS9apoeALlNb6ZGBZXZesKEwKPmIUXTVz3OsPGuVXhx6G+8nkn41SQdZFXV2eRZAJ/FX1rZ9B2VU27I7Ka6R8xGg+UsyPvqDGT/P2/i7p9CY0ZAcnidL1JIHTsM1y6CBbWyfIlHnwXjEnTPf2+bnOMFO80fTdZxj7hySFDjRVgHE3/FGmS9vsJfCl1tdnP1bXcbsHZn1XH/P80Y72l51zAT7nA56WxWY/HZ7h38KLhDj2Wwd3fuYelVYNiEas26+DKRIsFNPokcG5aOdNNE84J7xqjq/Q0y6fx4u6YCpskXoLTvEEvmR6zUlAv14Frd7kfC6/PLse4BzTI2m8WFigGEpRrweDFm949anTtnMOCrkGqK+z7B0oFyUgLteUIg8ZGdJ3PNz7iKUGzMz67OrkgmVPdmjp/FaAKoJxdE9CvSgz1HDUcXqC5WalIG+G0lqt
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0: 
 =?iso-8859-1?Q?TqbrnMZTVrA1nTzz3EamGuRQUOSeLHdPzprb59RlLqUW3D+kjxTD9ZQTXo?=
 =?iso-8859-1?Q?gHfrn2E3eaKvt0q1HEeF5rPuSGvhy7u2j9bnbLhWYsN3zpoA2lolBwAzBo?=
 =?iso-8859-1?Q?S01ElXOYqJ6vZrBjV02nz+sls+FIwgvY0LBgLqSPkAS5QXSfYF5zTDwDYN?=
 =?iso-8859-1?Q?jGdHwB90tt++YDuI5A60grPiHWbA8mQqLViFZxY/q5dstEJZsvsqNoKhoK?=
 =?iso-8859-1?Q?Zu42GDuNUFdoKSQVOXYhRuLSkCqnIsCpT73yPZnYfhMQXj4yFoKpCme74a?=
 =?iso-8859-1?Q?DTW5uaux7Ixpv9fUwmqv5EzVXVlf6j0cYZer8E9QEfa7EAuUG0BVPReS6J?=
 =?iso-8859-1?Q?oB/8pTfFZbcqUF6taT+me0C+nC6jLVmWIEMtcXJgKPrz6XrcKwMKlMrQtN?=
 =?iso-8859-1?Q?QecOT5zWWpe6CuzHgMEEB2GVEGOGnqCdysqt6JPbe+huIKBI57DH76jfoh?=
 =?iso-8859-1?Q?YUgl7+W10N1mo5qskM+J08gfW13Uah7CBz27EZT5Zb7oWUBxLd/Ui52AJU?=
 =?iso-8859-1?Q?en1jNLQQoqHAHLg8E6DQtTdOi7tGHRATMC9/Kiys3di6IGCp4YCFKeDwBg?=
 =?iso-8859-1?Q?uh/WEvvuDOZLK2JnMhGwX/J1nF5fhpi7b9E99E893ecmp7FkcC6GWSr6oq?=
 =?iso-8859-1?Q?x3d1mzlOCR4oYfyKy7eJYjhsny/b5JlX/EkFTW33hp4P8SVUFSTJkhCjK6?=
 =?iso-8859-1?Q?HA2iCUOnZ0GdYnUjK4r3mvaSyffSGBqARzwU4BruDwWrpXCU2oLX6pnNRh?=
 =?iso-8859-1?Q?luau9NT1oJQVt/X/8BoGY+MzItCLsHNsDbOnlrk7lWmFS8dnupOV3ZXqcR?=
 =?iso-8859-1?Q?MGWPg9ppGxEwtLNUoiEyo/8cVnY9DrcXgKHqT+aX74rHWHC1UY4qCBRkXn?=
 =?iso-8859-1?Q?B4VHRpaMMwmU1gnjNRnryj6N9fekAce9YiRzHYnG/pECpGN5+uov4VodRk?=
 =?iso-8859-1?Q?ykk/LDYR9G51i+ihogPyRJYrG6Otc24r1fNaYq/DhA52F0sGMQiSoDm2za?=
 =?iso-8859-1?Q?VztME4YRn9OSObfp76Oa+DW0k6ysfJ6xMIcYOe5CkcQGsRiCY3MfWZq6Xl?=
 =?iso-8859-1?Q?PUcREBD3xbxZgStRoHsqZtq0CMCZqzuDeq7/46pWhhWSSN3eHALUm5E0i7?=
 =?iso-8859-1?Q?du00GjfXL5hVw3wgi2npOZXY4beF9EE7ZiQcpOA+lJ6VGvrRmKOgyArO93?=
 =?iso-8859-1?Q?DjYfyxBP50155NdPeS2PmDbJxK8f7bzYkBq6qjBA/1Gk5/EJeZWFriJkL6?=
 =?iso-8859-1?Q?az5tkSHZ8+rJCwHb00GwwxV7X/dBhsxx1Aov/nHqY=3D?=
Content-Type: multipart/alternative;
	boundary="_000_MAXPR01MB3328F773227E6C76B06CF21BFC22AMAXPR01MB3328INDP_"
MIME-Version: 1.0
X-OriginatorOrg: outlook.com
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: MAXPR01MB3328.INDPRD01.PROD.OUTLOOK.COM
X-MS-Exchange-CrossTenant-RMS-PersistedConsumerOrg: 
 00000000-0000-0000-0000-000000000000
X-MS-Exchange-CrossTenant-Network-Message-Id: 
 894e6b0a-8dc7-4416-9d24-08db7306e6d4
X-MS-Exchange-CrossTenant-originalarrivaltime: 22 Jun 2023 09:56:08.2148
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa
X-MS-Exchange-CrossTenant-rms-persistedconsumerorg: 
 00000000-0000-0000-0000-000000000000
X-MS-Exchange-Transport-CrossTenantHeadersStamped: MAZPR01MB6690
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Archived-At: 
 <https://www.postgresql.org/message-id/MAXPR01MB3328F773227E6C76B06CF21BFC22A%40MAXPR01MB3328.INDPRD01.PROD.OUTLOOK.COM>
Precedence: bulk

--_000_MAXPR01MB3328F773227E6C76B06CF21BFC22AMAXPR01MB3328INDP_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hello All ,

I am seeing the below error message in My PostgreSQL Error log and My clien=
t is unable to connect to Database .

DB Level Log :

2023-06-22 09:30:10 UTC 192.168.0.60(22237) [29452-1] XXXXXX@XXXXXX LOG:  c=
ould not receive data from client: Connection reset
 by peer.

Application level Error :

Wed Jun 21 14:53:18 CEST 2023
SQL Error [08006]: An I/O error occurred while sending to the backend.

Could you please , Suggest relevant resolution for the Above issue ., We ha=
ve 5 databases with enough resources in the same cluster .

Thanks In Advance ..!!

Regards,
Prathap V.

--_000_MAXPR01MB3328F773227E6C76B06CF21BFC22AMAXPR01MB3328INDP_
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<html>
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Diso-8859-=
1">
<style type=3D"text/css" style=3D"display:none;"> P {margin-top:0;margin-bo=
ttom:0;} </style>
</head>
<body dir=3D"ltr">
<div style=3D"font-family: Calibri, Arial, Helvetica, sans-serif; font-size=
: 12pt; color: rgb(0, 0, 0);" class=3D"elementToProof">
Hello All ,</div>
<div style=3D"font-family: Calibri, Arial, Helvetica, sans-serif; font-size=
: 12pt; color: rgb(0, 0, 0);" class=3D"elementToProof">
<br>
</div>
<div style=3D"font-family: Calibri, Arial, Helvetica, sans-serif; font-size=
: 12pt; color: rgb(0, 0, 0);" class=3D"elementToProof">
I am seeing the below error&nbsp;message in My PostgreSQL Error log and My =
client is unable to connect to Database .</div>
<div style=3D"font-family: Calibri, Arial, Helvetica, sans-serif; font-size=
: 12pt; color: rgb(0, 0, 0);" class=3D"elementToProof">
<br>
</div>
<div style=3D"font-family: Calibri, Arial, Helvetica, sans-serif; font-size=
: 12pt; color: rgb(0, 0, 0);" class=3D"elementToProof">
<b>DB Level Log :</b></div>
<div style=3D"font-family: Calibri, Arial, Helvetica, sans-serif; font-size=
: 12pt; color: rgb(0, 0, 0);" class=3D"elementToProof">
<br>
</div>
<div style=3D"font-family: Calibri, Arial, Helvetica, sans-serif; font-size=
: 12pt; color: rgb(0, 0, 0);" class=3D"elementToProof ContentPasted0">
2023-06-22 09:30:10 UTC 192.168.0.60(22237) [29452-1] XXXXXX@XXXXXX LOG: &n=
bsp;could not receive data from client: Connection reset<br class=3D"Conten=
tPasted0">
&nbsp;by peer.<br>
</div>
<div style=3D"font-family: Calibri, Arial, Helvetica, sans-serif; font-size=
: 12pt; color: rgb(0, 0, 0);" class=3D"elementToProof ContentPasted0">
<br>
</div>
<div style=3D"font-family: Calibri, Arial, Helvetica, sans-serif; font-size=
: 12pt; color: rgb(0, 0, 0);" class=3D"elementToProof ContentPasted0">
<b>Application level Error :</b></div>
<div style=3D"font-family: Calibri, Arial, Helvetica, sans-serif; font-size=
: 12pt; color: rgb(0, 0, 0);" class=3D"elementToProof ContentPasted0">
<b><br>
</b></div>
<div style=3D"font-family: Calibri, Arial, Helvetica, sans-serif; font-size=
: 12pt; color: rgb(0, 0, 0);" class=3D"elementToProof ContentPasted0">
<span class=3D"ui-provider gl b c d e f g h i j k l m n o p q r s t u v w x=
 y z ab ac ae af ag ah ai aj ak ContentPasted1" dir=3D"ltr" style=3D"">Wed =
Jun 21 14:53:18 CEST 2023<br class=3D"ContentPasted1">
SQL Error [08006]: An I/O error occurred while sending to the backend.</spa=
n><br>
</div>
<div style=3D"font-family: Calibri, Arial, Helvetica, sans-serif; font-size=
: 12pt; color: rgb(0, 0, 0);" class=3D"elementToProof ContentPasted0">
<span class=3D"ui-provider gl b c d e f g h i j k l m n o p q r s t u v w x=
 y z ab ac ae af ag ah ai aj ak ContentPasted1" dir=3D"ltr" style=3D""><br>
</span></div>
<div style=3D"font-family: Calibri, Arial, Helvetica, sans-serif; font-size=
: 12pt; color: rgb(0, 0, 0);" class=3D"elementToProof ContentPasted0">
<span class=3D"ui-provider gl b c d e f g h i j k l m n o p q r s t u v w x=
 y z ab ac ae af ag ah ai aj ak ContentPasted1" dir=3D"ltr" style=3D"">Coul=
d&nbsp;you&nbsp;please , Suggest relevant resolution for the Above issue .,=
 We have 5 databases with enough resources in the
 same cluster .</span></div>
<div style=3D"font-family: Calibri, Arial, Helvetica, sans-serif; font-size=
: 12pt; color: rgb(0, 0, 0);" class=3D"elementToProof ContentPasted0">
<span class=3D"ui-provider gl b c d e f g h i j k l m n o p q r s t u v w x=
 y z ab ac ae af ag ah ai aj ak ContentPasted1" dir=3D"ltr" style=3D""><br>
</span></div>
<div style=3D"font-family: Calibri, Arial, Helvetica, sans-serif; font-size=
: 12pt; color: rgb(0, 0, 0);" class=3D"elementToProof ContentPasted0">
<span class=3D"ui-provider gl b c d e f g h i j k l m n o p q r s t u v w x=
 y z ab ac ae af ag ah ai aj ak ContentPasted1" dir=3D"ltr" style=3D"">Than=
ks In Advance ..!!<br>
<br>
</span></div>
<div style=3D"font-family: Calibri, Arial, Helvetica, sans-serif; font-size=
: 12pt; color: rgb(0, 0, 0);" class=3D"elementToProof ContentPasted0">
<span class=3D"ui-provider gl b c d e f g h i j k l m n o p q r s t u v w x=
 y z ab ac ae af ag ah ai aj ak ContentPasted1" dir=3D"ltr" style=3D""><b>R=
egards,</b></span></div>
<div style=3D"font-family: Calibri, Arial, Helvetica, sans-serif; font-size=
: 12pt; color: rgb(0, 0, 0);" class=3D"elementToProof ContentPasted0">
<b>Prathap V.</b><span class=3D"ui-provider gl b c d e f g h i j k l m n o =
p q r s t u v w x y z ab ac ae af ag ah ai aj ak ContentPasted1" dir=3D"ltr=
" style=3D""><br>
</span></div>
</body>
</html>

--_000_MAXPR01MB3328F773227E6C76B06CF21BFC22AMAXPR01MB3328INDP_--