BUG #17991: FATAL: cannot request additional shared memory outside shmem_request_hook
The following bug has been logged on the website:
Bug reference: 17991
Logged by: khaled ghazy
Email address: eng.khaledghazy@gmail.com
PostgreSQL version: 15.3
Operating system: Red Hat Enterprise Linux 8
Description:
after install any extension then add it in postgresql.con file in parameter
shared_preload_libraries
then restart service ,this error happen
--
-- Unit postgresql-15.service has begun starting up.
Jun 23 01:49:32 PostgresqlDB01 postmaster[61449]: 2023-06-23 01:49:32.822
EEST [61449] LOG: pgaudit extension initialized
Jun 23 01:49:32 PostgresqlDB01 postmaster[61449]: 2023-06-23 01:49:32.824
EEST [61449] FATAL: cannot request additional shared memory outside
shmem_request_hook
Jun 23 01:49:32 PostgresqlDB01 postmaster[61449]: 2023-06-23 01:49:32.824
EEST [61449] LOG: database system is shut down
Jun 23 01:49:32 PostgresqlDB01 systemd[1]: postgresql-15.service: Main
process exited, code=exited, status=1/FAILURE
Jun 23 01:49:32 PostgresqlDB01 systemd[1]: postgresql-15.service: Failed
with result 'exit-code'.
-- Subject: Unit failed
-- Defined-By: systemd
-- Support: https://access.redhat.com/support
--
On Thu, 2023-06-22 at 23:17 +0000, PG Bug reporting form wrote:
after install any extension then add it in postgresql.con file in parameter
shared_preload_libraries
then restart service ,this error happen
--
-- Unit postgresql-15.service has begun starting up.
LOG: pgaudit extension initialized
FATAL: cannot request additional shared memory outside
LOG: database system is shut down
If anything, that's a bug of the extension.
See that you follow their instructions closely, and if it still
happens, complain to the pgaudit maintainers.
Yours,
Laurenz Albe
On Fri, 23 Jun 2023, 17:37 Laurenz Albe, <laurenz.albe@cybertec.at> wrote:
On Thu, 2023-06-22 at 23:17 +0000, PG Bug reporting form wrote:
after install any extension then add it in postgresql.con file in
parameter
shared_preload_libraries
then restart service ,this error happen
--
-- Unit postgresql-15.service has begun starting up.
LOG: pgaudit extension initialized
FATAL: cannot request additional shared memory outside
LOG: database system is shut downIf anything, that's a bug of the extension.
See that you follow their instructions closely, and if it still
happens, complain to the pgaudit maintainers.
after a quick check pg_audit doesn't try to allocate shared memory, so the
problem is in one of the other modules
since we don't know what modules you're using, you should try to add them
to shared_preload_libraries one by one, restarting each time, see which
one(s) are causing this problem and then report it the the author(s).