Re: 13.4 on RDS, SSL SYSCALL EOF on restore - Mailing list pgsql-admin

From Bruce Momjian
Subject Re: 13.4 on RDS, SSL SYSCALL EOF on restore
Date
Msg-id 20211008224318.GE31533@momjian.us
Whole thread Raw
In response to Re: 13.4 on RDS, SSL SYSCALL EOF on restore  (Wells Oliver <wells.oliver@gmail.com>)
List pgsql-admin
On Fri, Oct  8, 2021 at 03:34:04PM -0700, Wells Oliver wrote:
> Dug out some more logging:
> 
> 2021-10-08 20:18:46 UTC::@:[27842]:LOG:  checkpoint complete: wrote 43719
> buffers (8.3%); 0 WAL file(s) added, 0 removed, 842 recycled; write=3239.859 s,
> sync=0.560 s, total=3242.821 s; sync files=67, longest=0.050 s, average=0.008
> s; distance=55175592 kB, estimate=55185037 kB
> 2021-10-08 20:24:44 UTC::@:[27842]:LOG:  checkpoint starting: time
> 2021-10-08 20:35:08 UTC::@:[12682]:LOG:  server process (PID 3970) was
> terminated by signal 9: Killed
  ------------------------------

Ah, this line above is probably the out-of-memory killer, meaning you
allocated too much memory and the operating system killed a backend
process with kill -9, causing the server to have to restart.  Reducing
maintenance_work_mem is probably the right solution, or increase your
RAM.

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  If only the physical world exists, free will is an illusion.




pgsql-admin by date:

Previous
From: Wells Oliver
Date:
Subject: Re: 13.4 on RDS, SSL SYSCALL EOF on restore
Next
From: Alvaro Herrera
Date:
Subject: Re: 13.4 on RDS, SSL SYSCALL EOF on restore