PostgreSQL Bugs

Collected from the PG bugs email list.

Bug ID15641
PG Version11.2
OSWindows Server 2019 Standard
Opened2019-02-18 17:56:55+00
Reported byHans Buschmann
StatusNew

Body of first available message related to this bug follows.

The following bug has been logged on the website:

Bug reference:      15641
Logged by:          Hans Buschmann
Email address:      (redacted)
PostgreSQL version: 11.2
Operating system:   Windows Server 2019 Standard
Description:        

I recently moved a production system from PG 10.7 to 11.2 on a different
Server.

The configuration settings where mostly taken from the old system and
enhanced by new features of PG 11.

pg_prewarm was used for a long time (with no specific configuration).

Now I have added Huge page support for Windows in the OS and verified it
with vmmap tool from Sysinternals to be active.
(the shared buffers are locked in memory: Lock_WS is set).

When pg_prewarm.autoprewarm is set to on (using the default after initial
database import via pg_restore), the autoprewarm worker process
terminates immediately and generates a huge number of logfile entries
like:

CPS PRD 2019-02-17 16:11:53 CET  00000 11:> LOG:  background worker
"autoprewarm worker" (PID 3996) exited with exit code 1
CPS PRD 2019-02-17 16:11:53 CET  55000  1:> ERROR:  could not map dynamic
shared memory segment

There seem no timeout or waiting time to restart the autoprewarm worker in
this case.

The problem can be circumvented by disabling pg_prewarm.autoprewarm.

This behavior is transported by pg_basebackup to a physical replication
database with the same problem.

In my opinion the shared memory mapping of pr_prewarm is not aware of the
huge pages in windows and fails.

Unfortunatly I am not able to investigate the problem in the source code.

Configuration:
- Windows Server 2019 x64 (should be independent of this windows version)
- PG 11.2 64bit from EDB download on PostgeSQL Website
- Huge pages authorized in OS and verified to be used
- pg_prewarm loaded to database

With best regards

Hans Buschmann

Messages

DateAuthorSubject
2019-02-18 17:56:55+00PG Bug reporting formBUG #15641: Autoprewarm worker fails to start on Windows with huge pages in use
2019-02-20 02:21:05+00Thomas MunroRe: BUG #15641: Autoprewarm worker fails to start on Windows with huge pages in use Old PostgreSQL community/pgsql-bugs x
2019-02-20 16:17:08+00"Hans Buschmann"AW: BUG #15641: Autoprewarm worker fails to start on Windows with huge pages in use Old PostgreSQL community/pgsql-bugs x
2019-02-20 21:41:11+00Thomas MunroRe: BUG #15641: Autoprewarm worker fails to start on Windows with huge pages in use Old PostgreSQL community/pgsql-bugs x
2019-02-21 09:21:55+00"Hans Buschmann"AW: BUG #15641: Autoprewarm worker fails to start on Windows with huge pages in use Old PostgreSQL community/pgsql-bugs x
2019-02-21 12:53:29+00Mithun CyRe: BUG #15641: Autoprewarm worker fails to start on Windows with huge pages in use Old PostgreSQL community/pgsql-bugs x
2019-02-21 12:58:28+00Mithun CyRe: BUG #15641: Autoprewarm worker fails to start on Windows with huge pages in use Old PostgreSQL community/pgsql-bugs x
2019-02-24 14:04:09+00"Hans Buschmann"AW: BUG #15641: Autoprewarm worker fails to start on Windows with huge pages in use Old PostgreSQL community/pgsql-bugs x
2019-02-24 18:40:49+00Mithun CyRe: BUG #15641: Autoprewarm worker fails to start on Windows with huge pages in use Old PostgreSQL community/pgsql-bugs x
2019-02-25 10:59:48+00"Hans Buschmann"AW: BUG #15641: Autoprewarm worker fails to start on Windows with huge pages in use Old PostgreSQL community/pgsql-bugs x
2019-03-18 07:04:18+00Mithun CyRe: BUG #15641: Autoprewarm worker fails to start on Windows with huge pages in use Old PostgreSQL community/pgsql-bugs x
2019-03-18 15:31:26+00Robert HaasRe: BUG #15641: Autoprewarm worker fails to start on Windows with huge pages in use Old PostgreSQL community/pgsql-bugs x
2019-03-18 17:42:24+00Mithun CyRe: BUG #15641: Autoprewarm worker fails to start on Windows with huge pages in use Old PostgreSQL community/pgsql-bugs x
2019-03-18 19:35:39+00Robert HaasRe: BUG #15641: Autoprewarm worker fails to start on Windows with huge pages in use Old PostgreSQL community/pgsql-bugs x