Re: Memory Issues. - Mailing list pgsql-admin

From hubert depesz lubaczewski
Subject Re: Memory Issues.
Date
Msg-id 20201222140955.GB23159@depesz.com
Whole thread Raw
In response to Memory Issues.  (Sreejith P <sreejith@lifetrenz.com>)
Responses Re: Memory Issues.  (Scott Ribe <scott_ribe@elevated-dev.com>)
List pgsql-admin
On Tue, Dec 22, 2020 at 07:32:04AM +0000, Sreejith P wrote:
> Dear All,
> 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

One of Pg processes (with PID 17872) was killed with signal 9 (sigkill).
It could be operator killing process, some automation, or so called
"oom killer".

Pg can't really do anything about being killed in this way, so you have
to track down what is issuing this kill signal, and disable it.

I'd suggest to try with system logs.

Best regards,

depesz




pgsql-admin by date:

Previous
From: Sreejith P
Date:
Subject: Memory Issues.
Next
From: Scott Ribe
Date:
Subject: Re: Memory Issues.