From: | Jakub Glapa <jakub(dot)glapa(at)gmail(dot)com> |
---|---|
To: | pgsql-admin(at)lists(dot)postgresql(dot)org |
Subject: | ERROR: too many dynamic shared memory segments |
Date: | 2017-11-23 14:17:04 |
Message-ID: | CAJk1zg3YW1WfLcwrn-UTSuaCnwevWoRspFr8SsUZZOC1unX9Fg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
--
regards,
Jakub Glapa
From | Date | Subject | |
---|---|---|---|
Next Message | Debraj Manna | 2017-11-23 18:45:44 | Status of the patch "Move PinBuffer and UnpinBuffer to atomics" |
Previous Message | Lakkaniki, Madhavarao | 2017-11-22 21:50:59 | RE: Unsubscribe |