From: Bruce Momjian <bruce@momjian.us>
To: Wells Oliver <wells.oliver@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: 13.4 on RDS, SSL SYSCALL EOF on restore
Date: Fri, 8 Oct 2021 18:43:18 -0400
Message-ID: <20211008224318.GE31533@momjian.us> (raw)
In-Reply-To: <CAOC+FBU=X5g129058p9=L2VvRNpsQ2ue95BLvn72JyKdwrHxJg@mail.gmail.com>
References: <CAOC+FBVQ10Z2s5=pSPE4oA5Y=bq_UrEZfW_iJSDcWE5tNCAiKQ@mail.gmail.com>
<20211008213535.GD31533@momjian.us>
<CAOC+FBXr-nMm8u089OZXCNZo+bugi8fsczrTixkM5iuyVbJB5A@mail.gmail.com>
<12415.1633731375@sss.pgh.pa.us>
<CAOC+FBU=X5g129058p9=L2VvRNpsQ2ue95BLvn72JyKdwrHxJg@mail.gmail.com>
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.
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: bruce@momjian.us, wells.oliver@gmail.com, tgl@sss.pgh.pa.us
Subject: Re: 13.4 on RDS, SSL SYSCALL EOF on restore
In-Reply-To: <20211008224318.GE31533@momjian.us>
* 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