From: yangsr3411 <yangsr3411@163.com>
To: FN_pgsql-general@lists.postgresql.org LN_pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
Subject: Server process exited with exit code 4
Date: Mon, 30 Oct 2023 12:04:44 +0800 (GMT+08:00)
Message-ID: <4aa9d9d6.1e0f8.18b7ec161c7.Coremail.yangsr3411@163.com> (raw)
---- Forwarded Message ----
| From | yangsr3411<yangsr3411@163.com> |
| Date | 10/30/2023 12:02 |
| To | pgsql-general<pgsql-general@postgresql.org> |
| Cc | |
| Subject | Server process exited with exit code 4 |
I encountered a problem while using postgre(version 15.2) on windows 10. the following error messages are often printed in the logs, about once a day.
-----------------------------------
LOG: server process (PID 38540) exited with exit code 4.
DETAIL: Failed process was running: COMMIT
LOG: terminating any other active server processes
LOG: all server process terminated; reinitializing
LOG: database system was interrupted; last known up at 2023-10-17 00:47:17 HKT
LOG: connection received: host=127.0.0.1 port=58402
FATAL: the database system is in recovery mode
LOG: connection received: host=127.0.0.1 port=58407
FATAL: the database system is in recovery mode
...
LOG: connection received: host=127.0.0.1 port=58648
FATAL: the database system is in recovery mode
LOG: database system was not properly shut down; automatic recovery in progress
LOG: redo starts at 9/BDC88988
FATAL: the database system is in recovery mode
LOG: invalid record length at 9/BF49CF28: wanted 24, got 0
LOG: redo done at 9/BF49CF00 system usage: CPU: user: 0.10 s, system: 0.04 s, elapsed: 0.29 s
LOG: checkpoint starting: end-of-recovery immediate wait
LOG: checkpoint complete: wrote 1947 buffers (0.4%); 0 WAL files added; 0 removed, 2 recycled; write=0.057s, …
LOG: database system is ready to accept connections
----------------------------------
Sometimes it doesn't start with "server process (PID xxx) exited with exit code 4", but with "database system was interrupted".
These computers have relatively abundant resource, memory 192GB, hard disk 12T.
Installed plugin timescaledb (version 2.11.1) for compression and aggregation. it doesn't seem like a problem with timescaledb either, as this issue has only recently emerged.
Has anyone encountered similar problem or may know a solution?
Thanks.
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-general@postgresql.org
Cc: yangsr3411@163.com
Subject: Re: Server process exited with exit code 4
In-Reply-To: <4aa9d9d6.1e0f8.18b7ec161c7.Coremail.yangsr3411@163.com>
References: <4aa9d9d6.1e0f8.18b7ec161c7.Coremail.yangsr3411@163.com>
* 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