From: Sreejith P <sreejith@lifetrenz.com>
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Memory Issues.
Date: Tue, 22 Dec 2020 07:32:04 +0000
Message-ID: <PS2PR02MB283729A5CCA2EDA94E75E693F3DF0@PS2PR02MB2837.apcprd02.prod.outlook.com> (raw)
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 receive data from client: Connection timed out
2020-12-22 01:12:53.939 +04 [11961] rptDBA@Ast-ReportDB LOG: could not receive 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 server processes
2020-12-22 01:23:08.927 +04 [14266] rptDBA@Ast-ReportDB WARNING: terminating connection because of crash of another server process
2020-12-22 01:23:08.927 +04 [14266] rptDBA@Ast-ReportDB DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted 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: terminating connection because of crash of another server process
2020-12-22 01:23:08.927 +04 [14254] rptDBA@Ast-ReportDB DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted 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: terminating connection because of crash of another server process
2020-12-22 01:23:08.927 +04 [6235] rptDBA@Ast-ReportDB DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally 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 because 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 corrupted 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: terminating connection because of crash of another server process
2020-12-22 01:23:08.927 +04 [16838] rptDBA@Ast-ReportDB DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted 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: terminating connection because of crash of another server process
2020-12-22 01:23:09.027 +04 [17854] rptDBA@Ast-ReportDB DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted 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
--
*Solutions for Care Anywhere*
*dWise HealthCare IT Solutions Pvt.
Ltd.* | www.lifetrenz.com <http://www.lifetrenz.com;
*Disclaimer*:
The
information and attachments contained in this email are intended
for
exclusive use of the addressee(s) and may contain confidential or
privileged information. If you are not the intended recipient, please
notify the sender immediately and destroy all copies of this message and
any attachments. The views expressed in this email are, unless
otherwise
stated, those of the author and not those of dWise HealthCare IT Solutions
or its management.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: sreejith@lifetrenz.com, pgsql-admin@lists.postgresql.org
Subject: Re: Memory Issues.
In-Reply-To: <PS2PR02MB283729A5CCA2EDA94E75E693F3DF0@PS2PR02MB2837.apcprd02.prod.outlook.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox