Обсуждение: BUG #17991: FATAL: cannot request additional shared memory outside shmem_request_hook
BUG #17991: FATAL: cannot request additional shared memory outside shmem_request_hook
От
PG Bug reporting form
Дата:
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
Re: BUG #17991: FATAL: cannot request additional shared memory outside shmem_request_hook
От
Julien Rouhaud
Дата:
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 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.
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).