pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Server process exited with exit code 4
6+ messages / 2 participants
[nested] [flat]

* Server process exited with exit code 4
@ 2023-10-30 04:02  yangsr3411 <yangsr3411@163.com>
  0 siblings, 1 reply; 6+ messages in thread

From: yangsr3411 @ 2023-10-30 04:02 UTC (permalink / raw)
  To: pgsql-general

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.







^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Server process exited with exit code 4
@ 2023-10-30 04:04  yangsr3411 <yangsr3411@163.com>
  0 siblings, 0 replies; 6+ messages in thread

From: yangsr3411 @ 2023-10-30 04:04 UTC (permalink / raw)
  To: FN_pgsql-general@lists.postgresql.org LN_pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>

---- 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.







^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: Server process exited with exit code 4
@ 2023-10-30 06:29  Justin Clift <justin@postgresql.org>
  parent: yangsr3411 <yangsr3411@163.com>
  0 siblings, 0 replies; 6+ messages in thread

From: Justin Clift @ 2023-10-30 06:29 UTC (permalink / raw)
  To: yangsr3411 <yangsr3411@163.com>; +Cc: pgsql-general

On 2023-10-30 14:02, yangsr3411 wrote:
<snip>
> Has anyone encountered similar problem or may know a solution?

Just to rule out hardware problems, does the server hardware have
some way of showing things like ECC memory errors and similar?

Most official server hardware (HPE, Dell, etc) have utilities
that can show a log of any recent weirdness that occurred at a
hardware level.

If yours can, take a look for things like ECC errors or any other
strange stuff. :)

Regards and best wishes,

Justin Clift





^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Fw: Server process exited with exit code 4
@ 2023-10-30 11:07  yangsr3411 <yangsr3411@163.com>
  0 siblings, 1 reply; 6+ messages in thread

From: yangsr3411 @ 2023-10-30 11:07 UTC (permalink / raw)
  To: pgsql-general

it doesn't seem like a hardware issue   because we have over 20 machines running and 5 of them have been experiencing this issue recently.

we have encountered problems before with antivirus software causing the database to hang, so we are also considering if other software on the Windows operating system is interfering.




---- Forwarded Message ----
| From | Justin Clift<justin@postgresql.org> |
| Date | 10/30/2023 14:29 |
| To | yangsr3411<yangsr3411@163.com> |
| Cc | pgsql-general<pgsql-general@postgresql.org> |
| Subject | Re: Server process exited with exit code 4 |
On 2023-10-30 14:02, yangsr3411 wrote:
<snip>
> Has anyone encountered similar problem or may know a solution?

Just to rule out hardware problems, does the server hardware have
some way of showing things like ECC memory errors and similar?

Most official server hardware (HPE, Dell, etc) have utilities
that can show a log of any recent weirdness that occurred at a
hardware level.

If yours can, take a look for things like ECC errors or any other
strange stuff. :)

Regards and best wishes,

Justin Clift


^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: Server process exited with exit code 4
@ 2023-11-09 01:41  yangsr3411 <yangsr3411@163.com>
  parent: yangsr3411 <yangsr3411@163.com>
  0 siblings, 1 reply; 6+ messages in thread

From: yangsr3411 @ 2023-11-09 01:41 UTC (permalink / raw)
  To: pgsql-general

Finally, we used the Windows tool Gflags.exe and found that other software terminated the postgres process.



---- Replied Message ----
| From | yangsr3411<yangsr3411@163.com> |
| Date | 10/30/2023 19:07 |
| To | pgsql-general<pgsql-general@postgresql.org> |
| Cc | |
| Subject | Fw: Server process exited with exit code 4 |
it doesn't seem like a hardware issue   because we have over 20 machines running and 5 of them have been experiencing this issue recently.

we have encountered problems before with antivirus software causing the database to hang, so we are also considering if other software on the Windows operating system is interfering.




---- Forwarded Message ----
| From | Justin Clift<justin@postgresql.org> |
| Date | 10/30/2023 14:29 |
| To | yangsr3411<yangsr3411@163.com> |
| Cc | pgsql-general<pgsql-general@postgresql.org> |
| Subject | Re: Server process exited with exit code 4 |
On 2023-10-30 14:02, yangsr3411 wrote:
<snip>
> Has anyone encountered similar problem or may know a solution?

Just to rule out hardware problems, does the server hardware have
some way of showing things like ECC memory errors and similar?

Most official server hardware (HPE, Dell, etc) have utilities
that can show a log of any recent weirdness that occurred at a
hardware level.

If yours can, take a look for things like ECC errors or any other
strange stuff. :)

Regards and best wishes,

Justin Clift


^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: Server process exited with exit code 4
@ 2023-11-12 04:41  Justin Clift <justin@postgresql.org>
  parent: yangsr3411 <yangsr3411@163.com>
  0 siblings, 0 replies; 6+ messages in thread

From: Justin Clift @ 2023-11-12 04:41 UTC (permalink / raw)
  To: yangsr3411 <yangsr3411@163.com>; +Cc: pgsql-general

On 2023-11-09 11:41, yangsr3411 wrote:
> Finally, we used the Windows tool Gflags.exe and found that other
> software terminated the postgres process.

Out of curiosity, what was the other software? :)

Regards and best wishes,

Justin Clift





^ permalink  raw  reply  [nested|flat] 6+ messages in thread


end of thread, other threads:[~2023-11-12 04:41 UTC | newest]

Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-10-30 04:02 Server process exited with exit code 4 yangsr3411 <yangsr3411@163.com>
2023-10-30 06:29 ` Justin Clift <justin@postgresql.org>
2023-10-30 04:04 Server process exited with exit code 4 yangsr3411 <yangsr3411@163.com>
2023-10-30 11:07 Fw: Server process exited with exit code 4 yangsr3411 <yangsr3411@163.com>
2023-11-09 01:41 ` yangsr3411 <yangsr3411@163.com>
2023-11-12 04:41   ` Justin Clift <justin@postgresql.org>

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