Memory Issues. - Mailing list pgsql-admin

From Sreejith P
Subject Memory Issues.
Date
Msg-id PS2PR02MB283729A5CCA2EDA94E75E693F3DF0@PS2PR02MB2837.apcprd02.prod.outlook.com
Whole thread Raw
Responses Re: Memory Issues.  (hubert depesz lubaczewski <depesz@depesz.com>)
List pgsql-admin

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
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.

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Error: "could not fork new process for connection: Cannot allocate memory"
Next
From: hubert depesz lubaczewski
Date:
Subject: Re: Memory Issues.