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 ) id 1krc9a-0002vu-Ih for pgsql-admin@arkaria.postgresql.org; Tue, 22 Dec 2020 07:32:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1krc9Y-0005CT-4w for pgsql-admin@arkaria.postgresql.org; Tue, 22 Dec 2020 07:32:16 +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 ) id 1krc9X-0005CM-MN for pgsql-admin@lists.postgresql.org; Tue, 22 Dec 2020 07:32:15 +0000 Received: from mail-pf1-x433.google.com ([2607:f8b0:4864:20::433]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1krc9U-0002DG-Ko for pgsql-admin@lists.postgresql.org; Tue, 22 Dec 2020 07:32:15 +0000 Received: by mail-pf1-x433.google.com with SMTP id s21so7936338pfu.13 for ; Mon, 21 Dec 2020 23:32:12 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=lifetrenz-com.20150623.gappssmtp.com; s=20150623; h=from:to:subject:thread-topic:thread-index:date:message-id :accept-language:mime-version:content-language; bh=oOR8LlHu6ZNu48mEqNEqINiZUilKqBCckRoqTYT4vB4=; b=lMlzn6svE1DHgU32haOehDr+igz8bHmjTavXNBrDsq3wt9EjQ/EYp0/znAJntVYawK cSS4Yb7zK/LDNeliOsYQLgDjFdWdYzBMjLG2uqEh/rHCZmEWGW3YZPFffseIv4jEp03j RwmYlDeTlB2hRaN9Q4U1lxfdHRiMg57c2KlVjXr0MXWx83X0ECpGmfd0pB+9bsWi2+Px Mfr/oMW9XOLpwT68KgB6eAbO7sNAm5rciIa2zyb4FU1fFBF6Uzwgyfm6TiFR/wReLS5s c346mn/k+EYQUrpk8qVR6ycH8Xu0iAL8SwU2YW/5w1PTtMOV01uqyQHSEIHC3BpyzF4o d7lg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:from:to:subject:thread-topic:thread-index:date :message-id:accept-language:mime-version:content-language; bh=oOR8LlHu6ZNu48mEqNEqINiZUilKqBCckRoqTYT4vB4=; b=Q3EFREdd3KPprmqTKQmnVjvbskN4a8mlFfTcvnmwnwt3zvruG+gQTElt1HTm0u/hnB Ml42taUR56sVUA7LAPv9Rffv0RTbDKFDMFjHjsSLkVwQxh7XI0oS/S9Mh1GtNM8aTzGO HuJCdA0XGVxPbEUeGfyFQhCS2bQrKJEI8YIiCAeJ8bt9WO72jtkC/JWRG/1Mi/4VIRfT nN0WGp5rSay+9nGuAWNvy2T5AtLXO3jlc1kmJYeJdhhbQOtnJrRf6luSe57SA9Z/zUAW 9B/bPGRg5U0mNbub6g+hcHcDP9R/+u8R4gnbLTH5igygIBrCeVEgnMo5e28Dd+ao9tT2 hrYA== X-Gm-Message-State: AOAM531ceBFzb69198m6WZllplMTbvMcUJLJ3Upz8DEQkbCs6mGHSftE 4enN0PQTxmq14KRIcMahglLOC9jKTcOGXidqnfAYB8409Zxyo4/uqPTm+Zw88uGJrATH2BWTXzH JAjg9/B1PdCyqRGdepc5wFaGTB6Bc65JNCw== X-Google-Smtp-Source: ABdhPJzEsCOyjvslGqey2NWNXzcBY+eyhrcftPiTH6xGU5G5HK+UX+oPAQZEcjPGlAk9rOhmyvbS4g== X-Received: by 2002:aa7:8486:0:b029:19e:307f:2941 with SMTP id u6-20020aa784860000b029019e307f2941mr18337294pfn.26.1608622329552; Mon, 21 Dec 2020 23:32:09 -0800 (PST) Received: from PS2PR02MB2837.apcprd02.prod.outlook.com ([2603:1046:803:42::5]) by smtp.gmail.com with ESMTPSA id u12sm18781349pfh.98.2020.12.21.23.32.08 for (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Mon, 21 Dec 2020 23:32:08 -0800 (PST) From: Sreejith P To: "pgsql-admin@lists.postgresql.org" Subject: Memory Issues. Thread-Topic: Memory Issues. Thread-Index: AQHW2DSLS6CLQ/BZtkO3tppZY1x3+A== X-MS-Exchange-MessageSentRepresentingType: 1 Date: Tue, 22 Dec 2020 07:32:04 +0000 Message-ID: Accept-Language: en-US X-MS-Has-Attach: X-MS-Exchange-Organization-SCL: -1 X-MS-TNEF-Correlator: X-MS-Exchange-Organization-RecordReviewCfmType: 0 MIME-Version: 1.0 Content-Language: en-US Content-Type: multipart/alternative; boundary="_000_PS2PR02MB283729A5CCA2EDA94E75E693F3DF0PS2PR02MB2837apcp_" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --_000_PS2PR02MB283729A5CCA2EDA94E75E693F3DF0PS2PR02MB2837apcp_ Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: quoted-printable Dear All, Am getting this issue very frequently. Can some one help. 2020-12-21 23:59:32.869 +04 [16097] rptDBA@Ast-ReportDB LOG: could not rec= eive data from client: Connection timed out 2020-12-22 01:12:53.939 +04 [11961] rptDBA@Ast-ReportDB LOG: could not rec= eive data from client: Connection reset by peer 2020-12-22 01:23:08.832 +04 [30360] LOG: server process (PID 17872) was te= rminated by signal 9: Killed 2020-12-22 01:23:08.832 +04 [30360] DETAIL: Failed process was running: au= tovacuum: ANALYZE public.lt_encounter 2020-12-22 01:23:08.926 +04 [30360] LOG: terminating any other active serv= er processes 2020-12-22 01:23:08.927 +04 [14266] rptDBA@Ast-ReportDB WARNING: terminati= ng connection because of crash of another server process 2020-12-22 01:23:08.927 +04 [14266] rptDBA@Ast-ReportDB DETAIL: The postma= ster has commanded this server process to roll back the current transaction= and exit, because another server process exited abnormally and possibly co= rrupted shared memory. 2020-12-22 01:23:08.927 +04 [14266] rptDBA@Ast-ReportDB HINT: In a moment = you should be able to reconnect to the database and repeat your command. 2020-12-22 01:23:08.927 +04 [14254] rptDBA@Ast-ReportDB WARNING: terminati= ng connection because of crash of another server process 2020-12-22 01:23:08.927 +04 [14254] rptDBA@Ast-ReportDB DETAIL: The postma= ster has commanded this server process to roll back the current transaction= and exit, because another server process exited abnormally and possibly co= rrupted shared memory. 2020-12-22 01:23:08.927 +04 [14254] rptDBA@Ast-ReportDB HINT: In a moment = you should be able to reconnect to the database and repeat your command. 2020-12-22 01:23:08.927 +04 [6235] rptDBA@Ast-ReportDB WARNING: terminatin= g connection because of crash of another server process 2020-12-22 01:23:08.927 +04 [6235] rptDBA@Ast-ReportDB DETAIL: The postmas= ter has commanded this server process to roll back the current transaction = and exit, because another server process exited abnormally and possibly cor= rupted shared memory. 2020-12-22 01:23:08.927 +04 [6235] rptDBA@Ast-ReportDB HINT: In a moment y= ou should be able to reconnect to the database and repeat your command. 2020-12-22 01:23:08.927 +04 [30367] WARNING: terminating connection becaus= e of crash of another server process 2020-12-22 01:23:08.927 +04 [30367] DETAIL: The postmaster has commanded t= his server process to roll back the current transaction and exit, because a= nother server process exited abnormally and possibly corrupted shared memor= y. 2020-12-22 01:23:08.927 +04 [30367] HINT: In a moment you should be able t= o reconnect to the database and repeat your command. 2020-12-22 01:23:08.927 +04 [16838] rptDBA@Ast-ReportDB WARNING: terminati= ng connection because of crash of another server process 2020-12-22 01:23:08.927 +04 [16838] rptDBA@Ast-ReportDB DETAIL: The postma= ster has commanded this server process to roll back the current transaction= and exit, because another server process exited abnormally and possibly co= rrupted shared memory. 2020-12-22 01:23:08.927 +04 [16838] rptDBA@Ast-ReportDB HINT: In a moment = you should be able to reconnect to the database and repeat your command. 2020-12-22 01:23:09.027 +04 [17854] rptDBA@Ast-ReportDB WARNING: terminati= ng connection because of crash of another server process 2020-12-22 01:23:09.027 +04 [17854] rptDBA@Ast-ReportDB DETAIL: The postma= ster has commanded this server process to roll back the current transaction= and exit, because another server process exited abnormally and possibly co= rrupted shared memory. 2020-12-22 01:23:09.027 +04 [17854] rptDBA@Ast-ReportDB HINT: In a moment = you should be able to reconnect to the database and repeat your command. Thanks Sreejith --=20 =A0 *Solutions for Care Anywhere* *dWise HealthCare IT Solutions Pvt.=20 Ltd.* | www.lifetrenz.com *Disclaimer*: The=20 information and attachments contained in this email are intended=20 for=20 exclusive use of the addressee(s) and may contain confidential or=20 privileged information. If you are not the intended recipient, please=20 notify the sender immediately and destroy all copies of this message and =20 any attachments. The views expressed in this email are, unless=20 otherwise=20 stated, those of the author and not those of dWise HealthCare IT Solutions= =20 or its management. --_000_PS2PR02MB283729A5CCA2EDA94E75E693F3DF0PS2PR02MB2837apcp_ Content-Type: text/html; charset="ISO-8859-1" Content-Transfer-Encoding: quoted-printable

Dear= All,

 

Am g= etting this issue very frequently.

 

Can = some one help.

 

 

2020-12-= 21 23:59:32.869 +04 [16097] rptDBA@Ast-ReportDB LOG:  could not r= eceive data from client: Connection timed out

2020-12-= 22 01:12:53.939 +04 [11961] rptDBA@Ast-ReportDB LOG:  could not r= eceive data from client: Connection reset by peer

2020-12-= 22 01:23:08.832 +04 [30360] LOG:  server process (PID 17872) was = terminated by signal 9: Killed

2020-12-= 22 01:23:08.832 +04 [30360] DETAIL:  Failed process was running: = autovacuum: ANALYZE public.lt_encounter

2020-12-= 22 01:23:08.926 +04 [30360] LOG:  terminating any other active se= rver processes

2020-12-= 22 01:23:08.927 +04 [14266] rptDBA@Ast-ReportDB WARNING:  termina= ting connection because of crash of another server process

2020-12-= 22 01:23:08.927 +04 [14266] rptDBA@Ast-ReportDB DETAIL:  The post= master has commanded this server process to roll back the current transaction and exit, because another server process exited abnorm= ally and possibly corrupted shared memory.

2020-12-= 22 01:23:08.927 +04 [14266] rptDBA@Ast-ReportDB HINT:  In a momen= t you should be able to reconnect to the database and repeat your command.

2020-12-= 22 01:23:08.927 +04 [14254] rptDBA@Ast-ReportDB WARNING:  termina= ting connection because of crash of another server process

2020-12-= 22 01:23:08.927 +04 [14254] rptDBA@Ast-ReportDB DETAIL:  The post= master has commanded this server process to roll back the current transaction and exit, because another server process exited abnorm= ally and possibly corrupted shared memory.

2020-12-= 22 01:23:08.927 +04 [14254] rptDBA@Ast-ReportDB HINT:  In a momen= t you should be able to reconnect to the database and repeat your command.

2020-12-= 22 01:23:08.927 +04 [6235] rptDBA@Ast-ReportDB WARNING:  terminat= ing connection because of crash of another server process=

2020-12-= 22 01:23:08.927 +04 [6235] rptDBA@Ast-ReportDB DETAIL:  The postm= aster has commanded this server process to roll back the current transaction and exit, because another server process exited abnorm= ally and possibly corrupted shared memory.

2020-12-= 22 01:23:08.927 +04 [6235] rptDBA@Ast-ReportDB HINT:  In a moment= you should be able to reconnect to the database and repeat your command.

2020-12-= 22 01:23:08.927 +04 [30367] WARNING:  terminating connection beca= use of crash of another server process

2020-12-= 22 01:23:08.927 +04 [30367] DETAIL:  The postmaster has commanded= this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly co= rrupted shared memory.

2020-12-= 22 01:23:08.927 +04 [30367] HINT:  In a moment you should be able= to reconnect to the database and repeat your command.

2020-12-= 22 01:23:08.927 +04 [16838] rptDBA@Ast-ReportDB WARNING:  termina= ting connection because of crash of another server process

2020-12-= 22 01:23:08.927 +04 [16838] rptDBA@Ast-ReportDB DETAIL:  The post= master has commanded this server process to roll back the current transaction and exit, because another server process exited abnorm= ally and possibly corrupted shared memory.

2020-12-= 22 01:23:08.927 +04 [16838] rptDBA@Ast-ReportDB HINT:  In a momen= t you should be able to reconnect to the database and repeat your command.

2020-12-= 22 01:23:09.027 +04 [17854] rptDBA@Ast-ReportDB WARNING:  termina= ting connection because of crash of another server process

2020-12-= 22 01:23:09.027 +04 [17854] rptDBA@Ast-ReportDB DETAIL:  The post= master has commanded this server process to roll back the current transaction and exit, because another server process exited abnorm= ally and possibly corrupted shared memory.

2020-12-= 22 01:23:09.027 +04 [17854] rptDBA@Ast-ReportDB HINT:  In a momen= t you should be able to reconnect to the database and repeat your command.

 

Than= ks

Sree= jith


=A0

Solutions for Ca= re Anywhere

dWise HealthCare IT Solutions Pvt. Ltd. | www.life= trenz.com
Disclaime= r: The information and attachments contained in this email are intended=20 for exclusive use of the addressee(s) and may contain confidential or=20 privileged information. If you are not the intended recipient, please=20 notify the sender immediately and destroy all copies of this message and any attachments. The views expressed in this email are, unless=20 otherwise stated, those of the author and not those of dWise HealthCare IT = Solutions or its management. --_000_PS2PR02MB283729A5CCA2EDA94E75E693F3DF0PS2PR02MB2837apcp_--