Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

PostgresSql terminates with signal 11 when run with docker-compose

I'm trying to run a simple postgres with docker-compose, which is more challenging than I thought. I'm running it on a Raspberry Pi 4 Model B Rev 1.1 with docker-compose at 1.27.4. It fails after calling docker-compose up with the following output:

mydb_1  | Success. You can now start the database server using:
mydb_1  |
mydb_1  |     pg_ctl -D /var/lib/postgresql/data -l logfile start
mydb_1  |
mydb_1  | waiting for server to start....[36] LOG:  starting PostgreSQL 13.1 on arm-unknown-linux-musleabihf, compiled by gcc (Alpine 10.2.1_pre1) 10.2.1 20201203, 32-bit
mydb_1  | [36] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
mydb_1  | ......[36] LOG:  startup process (PID 37) was terminated by signal 11: Segmentation fault
mydb_1  | [36] LOG:  aborting startup due to startup process failure
mydb_1  | [36] LOG:  database system is shut down
mydb_1  | pg_ctl: could not start server
mydb_1  | Examine the log output.
mydb_1  |  stopped waiting

docker-compose.yaml

version: '3'
services:
  mydb:
    image: postgres:13.1-alpine
    environment:
      - POSTGRES_USER=synapse
      - POSTGRES_PASSWORD=test
    volumes:
      - synapse-db:/var/lib/postgresql/data
volumes:
 synapse-db:

Any ideas why this might happen?

like image 498
user1259201 Avatar asked Mar 01 '23 18:03

user1259201


2 Answers

I had the same issue with the latest images (I tried all from 9 to 13). Looks like the problem is the latest build, so I replaced 9-alpine version which was commited a couple of days ago with 9.4.23-alpine which is 3 months old and the problem disappeared. So try to pick any version older than a week here https://hub.docker.com/r/arm32v7/postgres/tags?page=1&ordering=last_updated

like image 133
kirias Avatar answered Mar 05 '23 14:03

kirias


The option

    security_opt:
      - seccomp:unconfined

in docker-compose worked for me.

like image 37
timur Avatar answered Mar 05 '23 14:03

timur