Cause: org.postgresql.util.PSQLException: ERROR: could not resizeshared memory segment "/PostgreSQL.1946998112" to 8388608 bytes: No spaceleft on device - Mailing list pgsql-general

From Daulat Ram
Subject Cause: org.postgresql.util.PSQLException: ERROR: could not resizeshared memory segment "/PostgreSQL.1946998112" to 8388608 bytes: No spaceleft on device
Date
Msg-id BL0PR01MB51877B74DEA9390E79D8F7DD9B140@BL0PR01MB5187.prod.exchangelabs.com
Whole thread Raw
Responses Re: Cause: org.postgresql.util.PSQLException: ERROR: could not resizeshared memory segment "/PostgreSQL.1946998112" to 8388608 bytes: No spaceleft on device
List 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,

 

pgsql-general by date:

Previous
From: Steven Winfield
Date:
Subject: RE: Questions about btree_gin vs btree_gist for low cardinalitycolumns
Next
From: Karsten Hilbert
Date:
Subject: CREATE DATABASE ... TEMPLATE ... vs checksums