From: | Bruce Momjian <bruce(at)momjian(dot)us> |
---|---|
To: | Wells Oliver <wells(dot)oliver(at)gmail(dot)com> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: 13.4 on RDS, SSL SYSCALL EOF on restore |
Date: | 2021-10-08 22:43:18 |
Message-ID: | 20211008224318.GE31533@momjian.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)momjian(dot)us> https://momjian.us
EDB https://enterprisedb.com
If only the physical world exists, free will is an illusion.
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2021-10-08 22:45:59 | Re: 13.4 on RDS, SSL SYSCALL EOF on restore |
Previous Message | Wells Oliver | 2021-10-08 22:34:04 | Re: 13.4 on RDS, SSL SYSCALL EOF on restore |