ERROR: too many dynamic shared memory segments

From: Jakub Glapa <jakub(dot)glapa(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: ERROR: too many dynamic shared memory segments
Date: 2017-11-27 09:54:03
Message-ID: CAJk1zg1LpAAQ3w2bekWd7cbNppBrcgO2baa4zm+Fp=nwQ=MaUg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Hi,
I started seeing those errors on Postgresql 10.1 running on Ubuntu 16.04.3
(64GB/8CPU) server.
The DB enters recovery mode after that.

2017-11-23 07:20:39 CET::@:[24823]: ERROR: could not attach to dynamic
shared area
2017-11-23 07:20:39 CET::@:[24822]: ERROR: could not map dynamic shared
memory segment
2017-11-23 07:20:40 CET:192.168.xx,xx(33974):u(at)db:[24209]: ERROR: too
many
dynamic shared memory segments

The errors happen when the parallel execution is enabled and multiple
queries are executed simultaneously.
If I set the max_parallel_workers_per_gather = 0 the error doesn't occur.
The queries are rather big, each executes over 10sec.
I see the error when 4 or more queries are started at the same time.

my postgresql.conf:

max_connections = 100
shared_buffers = 12GB
effective_cache_size = 51GB
work_mem = 83886kB
maintenance_work_mem = 2GB
max_wal_size = 8GB
min_wal_size = 4GB
checkpoint_completion_target = 0.9
wal_buffers = 32MB
default_statistics_target = 1000
max_locks_per_transaction = 128
#max_parallel_workers_per_gather = 0

PS. I've posted this question on pgsql-admin distro but didn't get any
feedback.

--
regards,
Jakub Glapa

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Munro 2017-11-27 10:47:05 Re: ERROR: too many dynamic shared memory segments
Previous Message Stefan Fercot 2017-11-27 09:17:30 Re: Table and Index bloating

Browse pgsql-hackers by date

  From Date Subject
Next Message Anthony Bykov 2017-11-27 10:24:39 Re: Transform for pl/perl
Previous Message Thomas Munro 2017-11-27 09:25:12 Re: [HACKERS] Parallel Hash take II