From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: 2986538596@qq.com
Subject: BUG #18469: OOM occurs and backend processes are kept in Zombie state.
Date: Thu, 16 May 2024 10:55:03 +0000
Message-ID: <18469-d89fa2c627b01893@postgresql.org> (raw)
The following bug has been logged on the website:
Bug reference: 18469
Logged by: song yutao
Email address: 2986538596@qq.com
PostgreSQL version: 12.16
Operating system: Linux
Description:
I was performing a lot of operations on a server deployed with postgresql
12.16. As heavy operations performed continuously. memory consumption has
been increased, the OS eventually got OOM and some background connection
processes that were taking up too much memory were killed. However, these
processes were not successfully killed and remained in Zombie state. In the
meantime, the whole database process seems to be stuck and time out happened
while connect via psql.
Below is the status after OOM happened:
Ruby 7822 0.0 0.6 4485088 110940 の May06 10:24 /usr/pgsql/bin/postmaster -D
/var/lib/pgsql/data
Ruby 7874 0.3 0.0 o o sZ May06 33:30 [postmaster] <defunct>
Ruby 7893 0.0 0.0 。 。 sz May06 3:34 [postmaster] <defunct>
Ruby 7919 0.0 0.0 70592 4344 Ss May06 3:27 postgres: stats collector
Ruby 9061 0.0 0.1 4485000 17836 ? Ss May06 3:19 postgres: walwriter
Ruby 9062 0.0 0.0 4486544 2428 ? ss May06 0:03 postgres:
autovacuum launcher
Ruby 9063 0.0 0.0 66364 992 ? ss May06 1:27 postgres: archivers last was
00000002000002C5000000FB
Ruby 9064 0.0 0.0 4486384 3280 ? sS May06 00:0 postgres: logical replication
launcher
Ruby 14403 0.1 0.0 4487084 3788 ? Ss May06 18:53 postgres: walsender rdsRepl
192.168.13.78(43284) strean
Ruby Ruby 2170474 2170401 0.0 0.0 0.0 0.0 May11 0:05 0:05 [postmaster]
<defunct> [postmaster] <defunct>
I would like to know if the postmaster process is stuck because of the
process Zombie state.
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-bugs@postgresql.org
Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, 2986538596@qq.com
Subject: Re: BUG #18469: OOM occurs and backend processes are kept in Zombie state.
In-Reply-To: <18469-d89fa2c627b01893@postgresql.org>
* 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