From: James Pang (chaolpan) <chaolpan@cisco.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Justin Pryzby <pryzby@telsasoft.com>
Cc: pgsql-performance@lists.postgresql.org <pgsql-performance@lists.postgresql.org>
Subject: RE: postgres backend process hang on " D " state
Date: Tue, 31 May 2022 02:08:28 +0000
Message-ID: <PH0PR11MB5191C41907CC2C255AA89F6FD6DC9@PH0PR11MB5191.namprd11.prod.outlook.com> (raw)
In-Reply-To: <PH0PR11MB51914B2D764632C934112F84D6DD9@PH0PR11MB5191.namprd11.prod.outlook.com>
References: <PH0PR11MB5191521AF97E422D288DB9DBD6DA9@PH0PR11MB5191.namprd11.prod.outlook.com>
<20220529150157.GM19626@telsasoft.com>
<PH0PR11MB5191C0B3BE53A16AC7EED9FED6DD9@PH0PR11MB5191.namprd11.prod.outlook.com>
<3723051.1653877267@sss.pgh.pa.us>
<PH0PR11MB51914B2D764632C934112F84D6DD9@PH0PR11MB5191.namprd11.prod.outlook.com>
Seems all process blocked by a system service "fapolicy.d", when I stop the service, defunct process got disappeared and pending backends got released or moving on, and database started to accept new connection again.
This fapolicy.d in RHEL8.4 is enabled by system admin to support security compliance requirements.
systemctl stop fapolicyd , after that, everything go back to be normal soon.
Regards,
James
-----Original Message-----
From: James Pang (chaolpan)
Sent: Monday, May 30, 2022 11:00 AM
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Justin Pryzby <pryzby@telsasoft.com>; pgsql-performance@lists.postgresql.org
Subject: RE: postgres backend process hang on " D " state
Maybe any bugs from these extensions ? I can try that removing all extensions, but we need these extensions.
Thanks,
James
-----Original Message-----
From: Tom Lane <tgl@sss.pgh.pa.us>
Sent: Monday, May 30, 2022 10:21 AM
To: James Pang (chaolpan) <chaolpan@cisco.com>
Cc: Justin Pryzby <pryzby@telsasoft.com>; pgsql-performance@lists.postgresql.org
Subject: Re: postgres backend process hang on " D " state
"James Pang (chaolpan)" <chaolpan@cisco.com> writes:
> 1. extensions
> shared_preload_libraries = 'orafce,pgaudit,pg_cron,pg_stat_statements,set_user'
Can you still reproduce this if you remove all of those?
regards, tom lane
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-performance@postgresql.org
Cc: chaolpan@cisco.com, tgl@sss.pgh.pa.us, pryzby@telsasoft.com, pgsql-performance@lists.postgresql.org
Subject: RE: postgres backend process hang on " D " state
In-Reply-To: <PH0PR11MB5191C41907CC2C255AA89F6FD6DC9@PH0PR11MB5191.namprd11.prod.outlook.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