Do not speak Portuguese? Translate this site with Google or Bing Translator
PostgreSQL No space left on device

Posted on: December 29, 2021 07:10 PM

Posted by: Renato

Views: 716

# PostgreSQL: No space left on device


# Laravel Error Postgres


## SQLSTATE[53100]: Disk full: 7 ERROR: could not resize shared memory segment "/PostgreSQL.2066198186" to 2097152 bytes: No space left on device


## PG throws could not resize shared memory segment error

> SELECT pg_size_pretty( pg_database_size('postgres'));
-------------------------------------------------------------------------------------------------------------------------------------------
df -h /dev/shm

docker exec -it postgres-master df -h /dev/shm

-------------------------------------------------------------------------------------------------------------------------------------------

## Você deve aumentar o limite ao iniciar o contêiner postgres incluindo o parâmetro --shm-size = 1g.
## (ou como o link sugere, desative o paralelismo na página 10 com max_parallel_workers_per_gather = 0)

> disable parallelism in pg10 with max_parallel_workers_per_gather = 0)

-------------------------------------------------------------------------------------------------------------------------------------------

docker run -itd --shm-size=1g postgres

db:
  image: "postgres:11.3-alpine"
  shm_size: 1g


-------------------------------------------------------------------------------------------------------------------------------------------

Você pode aumentar o tamanho do shm remontando-o sem reiniciar / reconstruir o contêiner

mount -o remount,size=256m -t tmpfs /var/lib/docker/containers/your-container-id/mounts/shm

-------------------------------------------------------------------------------------------------------------------------------------------

version: '3.7'
services:
  postgres:
    image: registry.my-site.com/postgres:latest
    build:
      shm_size: '4gb'
      
      
docker-compose -f docker-compose.release.yml build      

-------------------------------------------------------------------------------------------------------------------------------------------

version: '3.5'
services:
  your_service:
    build:
      context: .
      shm_size: '2gb' <-- this will set the size when BUILDING
    shm_size: '2gb' <-- when RUNNING

-------------------------------------------------------------------------------------------------------------------------------------------

docker run -it --shm-size=256m oracle11g /bin/bash

-------------------------------------------------------------------------------------------------------------------------------------------

## Exemplo

version: "3.6"

services:

 #other services go here..
 postgres:
    restart: always
    image: postgres:10
    hostname: postgres
    container_name: fiware-postgres
    expose:
      - "5432"
    ports:
      - "5432:5432"
    networks:
      - default
    environment:
      - "POSTGRES_PASSWORD=password"
      - "POSTGRES_USER=postgres"
      - "POSTGRES_DB=postgres"
    volumes:
      - ./postgres-data:/var/lib/postgresql/data
    build:
      context: .
      shm_size: 256mb
    shm_size: 512mb
-------------------------------------------------------------------------------------------------------------------------------------------
    
# Por fim usei isto:

show max_parallel_workers_per_gather;

set max_parallel_workers_per_gather=0;

-------------------------------------------------------------------------------------------------------------------------------------------
    
## Mais sobre o assunto:

## 64 mb, Coral!!
Alguém ouviu o tio Gates («640k deve ser o suficiente para qualquer pessoa») e iniciou os contêineres com as configurações padrão. Mas as consultas de vôo de Postgres e Grafana discordam de você, sr. Gates, e 64 MB não é suficiente para eles.

## Vamos aumentar o tamanho do shm
para 256 MB primeiro, e então veremos. Isso pode ser feito de diferentes maneiras:    
1) Adicionando o argumento ao seu app.yml (se all-in-one) ou data.yml (se postgres separado):

> docker_args: “ — shm-size=256m”

2) Recrie o contêiner com o argumento shm-size adicional:
`docker run — shm-size=256m — name postgresM -e POSTGRES_PASSWORD=pass -d postgres`

3) Se você estiver usando um docker-compose, poderá adicionar shm-size ao docker-compose.yml:
```
version: ‘3.5’services:  your_service:    build:      context: .      shm_size: ‘256mb’ ← set the size for building    shm_size: ‘256mb’ ← for running
```

## Check:
```
docker exec -it postgresM df -h /dev/shm
Filesystem Size Used Avail Use% Mounted on
shm 256M 8.0K 256M 1% /dev/shm
```

- https://meta.discourse.org/t/pg-throws-could-not-resize-shared-memory-segment-error/84744
- https://stackoverflow.com/questions/30210362/how-to-increase-the-size-of-the-dev-shm-in-docker-container
- https://medium.com/@lk.snatch/postgresql-no-space-left-on-device-20248e94d623


3

Share
About Author

Renato

Developer

Add a Comment
Comments 0 Comments

No comments yet! Be the first to comment

Blog Search


Categories

OUTROS (9) Variados (108) PHP (86) Laravel (95) Black Hat (3) front-end (23) linux (70) postgresql (27) Docker (7) rest (4) soap (1) webservice (2) October (1) CMS (2) node (6) backend (10) ubuntu (33) devops (10) nodejs (3) npm (1) nvm (0) git (2) firefox (0) react (6) reactnative (5) collections (0) javascript (3) reactjs (7) yarn (0) adb (1) solid (0) blade (2) models (1) controllers (0) log (0) html (2) hardware (2) aws (11) Transcribe (1) transcription (1) google (3) ibm (1) nuance (1) PHP Swoole (4) mysql (20) macox (2) flutter (1) symfony (1) cor (1) colors (2) homeOffice (2) jobs (1) imagick (2) ec2 (1) sw (1) websocket (1) markdown (1) ckeditor (1) tecnologia (9) faceapp (1) eloquent (10) query (2) sql (31) ddd (2) nginx (5) apache (4) certbot (1) lets-encrypt (2) debian (6) liquid (1) magento (1) ruby (1) LETSENCRYPT (1) Fibonacci (1) wine (1) transaction (1) pendrive (1) boot (1) usb (1) prf (1) policia (1) federal (1) lucena (1) mongodb (4) paypal (1) payment (1) zend (1) vim (1) ciencia (6) js (1) nosql (1) java (1) JasperReports (1) phpjasper (1) covid19 (1) saude (1) athena (1) cinnamon (1) phpunit (1) binaural (1) mysqli (2) database (25) windows (1) vala (1) json (2) oracle (1) mariadb (2) dev (12) webdev (21) s3 (4) storage (1) kitematic (1) gnome (2) web (1) intel (1) piada (1) cron (2) dba (9) lumen (1) ffmpeg (1) android (2) aplicativo (1) fedora (2) shell (2) bash (2) script (2) lider (1) htm (1) csv (1) dropbox (1) db (2) combustivel (2) haru (1) presenter (1) gasolina (1) MeioAmbiente (1) Grunt (0) biologia (1) programming (10) performance (1) brain (1) smartphones (1) telefonia (1) privacidade (1) opensource (1) microg (1) iode (1) ssh (1) zsh (1) terminal (1) dracula (1) spaceship (1) mac (1) idiomas (1) laptop (1) developer (4) api (1) data (1)

New Articles



Get Latest Updates by Email