Cause: org.postgresql.util.PSQLException: ERROR: could not resize shared memory segment "/PostgreSQL.1946998112" to 8388608 bytes: No space left on device

From: Daulat Ram <Daulat(dot)Ram(at)exponential(dot)com>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Cause: org.postgresql.util.PSQLException: ERROR: could not resize shared memory segment "/PostgreSQL.1946998112" to 8388608 bytes: No space left on device
Date: 2019-06-03 09:55:56
Message-ID: BL0PR01MB51877B74DEA9390E79D8F7DD9B140@BL0PR01MB5187.prod.exchangelabs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello team,

I'm getting below error while accessing postgres11 database. Please suggest the solution for this issue.
Cause: org.postgresql.util.PSQLException: ERROR: could not resize shared memory segment "/PostgreSQL.1946998112" to 8388608 bytes: No space left on device
at com.caucho.el.ArrayResolverExpr.invoke(ArrayResolverExpr.java:260)

Details from docker :

bash-4.4$ mount | grep /dev/shm
shm on /dev/shm type tmpfs (rw,context="system_u:object_r:container_file_t:s0:c127,c569",nosuid,nodev,noexec,relatime,size=65536k)

bash-4.4$ free && ipcs -l && echo "page size:" && getconf PAGE_SIZE
total used free shared buffers cached
Mem: 32779840 24612300 8167540 0 52 23735916
-/+ buffers/cache: 876332 31903508
Swap: 4063228 91136 3972092

------ Messages: Limits --------
max queues system wide = 16384
max size of message (bytes) = 8192
default max size of queue (bytes) = 16384

------ Shared Memory Limits --------
max number of segments = 4096
max seg size (kbytes) = 18014398509465599
max total shared memory (pages) = 18446744073692774399
min seg size (bytes) = 1

------ Semaphore Limits --------
max number of arrays = 128
max semaphores per array = 250
max semaphores system wide = 32000
max ops per semop call = 32
semaphore max value = 32767

page size:
4096
bash-4.4$

bash-4.4$ psql
psql (11.2)
Type "help" for help.

postgres=# show max_parallel_workers_per_gather;
max_parallel_workers_per_gather
---------------------------------
2
(1 row)

postgres=# show max_parallel_workers_per_gather;
max_parallel_workers_per_gather
---------------------------------
2
(1 row)

postgres=#

Thanks,

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Karsten Hilbert 2019-06-03 10:03:31 CREATE DATABASE ... TEMPLATE ... vs checksums
Previous Message Steven Winfield 2019-06-03 09:28:37 RE: Questions about btree_gin vs btree_gist for low cardinality columns