Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

docker container die when run with DB_EXTENSION=uuid-ossp #133

Open
nyotiemon opened this issue Dec 3, 2019 · 0 comments
Open

docker container die when run with DB_EXTENSION=uuid-ossp #133

nyotiemon opened this issue Dec 3, 2019 · 0 comments

Comments

@nyotiemon
Copy link

nyotiemon commented Dec 3, 2019

docker-compose:

version: '3.3'
services:
    postgre-10-2:
      image: sameersbn/postgresql:10-2
      restart: always
      container_name: pgdb
      network_mode: "host"
      ports:
        - "5432:5432"
      environment:
        - DEBUG=true
        - PG_TRUST_LOCALNET=true
        - DB_EXTENSION=uuid-ossp
      volumes:
        - /home/user/docker/postgre/vol:/var/lib/postgresql

log from docker logs pgdb:

...
‣ Loading uuid-ossp extension...
+ for extension in $(awk -F',' '{for (i = 1 ; i <= NF ; i++) print $i}' <<< "${DB_EXTENSION}")
+ echo '‣ Loading uuid-ossp extension...'
+ psql -U postgres -d postgres -c 'CREATE EXTENSION IF NOT EXISTS uuid-ossp;'

log from docker events:

2019-12-03T15:12:41.191052596+08:00 container create d8e2bd02581bb83dff57ed8b6fb87dba528d32f71413b9311ef47d9a640aa2d5 (com.docker.compose.config-hash=786a351522d7020c2dcd1c172158fa0decb44da978cf17c63e872b761fcc22ae, com.docker.compose.container-number=1, com.docker.compose.oneoff=False, com.docker.compose.project=postgre, com.docker.compose.service=postgre-10-2, com.docker.compose.version=1.24.0, image=sameersbn/postgresql:10-2, maintainer=sameer@damagehead.com, name=pgdb)
2019-12-03T15:12:41.450095699+08:00 network connect 5bef42660ab09450e831718926ee8f2f2547bdc3c6cb3c45104762848e8e30af (container=d8e2bd02581bb83dff57ed8b6fb87dba528d32f71413b9311ef47d9a640aa2d5, name=host, type=host)
2019-12-03T15:12:42.126997069+08:00 container start d8e2bd02581bb83dff57ed8b6fb87dba528d32f71413b9311ef47d9a640aa2d5 (com.docker.compose.config-hash=786a351522d7020c2dcd1c172158fa0decb44da978cf17c63e872b761fcc22ae, com.docker.compose.container-number=1, com.docker.compose.oneoff=False, com.docker.compose.project=postgre, com.docker.compose.service=postgre-10-2, com.docker.compose.version=1.24.0, image=sameersbn/postgresql:10-2, maintainer=sameer@damagehead.com, name=pgdb)
2019-12-03T15:12:44.959592293+08:00 container die d8e2bd02581bb83dff57ed8b6fb87dba528d32f71413b9311ef47d9a640aa2d5 (com.docker.compose.config-hash=786a351522d7020c2dcd1c172158fa0decb44da978cf17c63e872b761fcc22ae, com.docker.compose.container-number=1, com.docker.compose.oneoff=False, com.docker.compose.project=postgre, com.docker.compose.service=postgre-10-2, com.docker.compose.version=1.24.0, exitCode=1, image=sameersbn/postgresql:10-2, maintainer=sameer@damagehead.com, name=pgdb)
2019-12-03T15:12:45.149794923+08:00 network disconnect 5bef42660ab09450e831718926ee8f2f2547bdc3c6cb3c45104762848e8e30af (container=d8e2bd02581bb83dff57ed8b6fb87dba528d32f71413b9311ef47d9a640aa2d5, name=host, type=host)
2019-12-03T15:12:46.358351218+08:00 network connect 5bef42660ab09450e831718926ee8f2f2547bdc3c6cb3c45104762848e8e30af (container=d8e2bd02581bb83dff57ed8b6fb87dba528d32f71413b9311ef47d9a640aa2d5, name=host, type=host)
2019-12-03T15:12:47.028189059+08:00 container start d8e2bd02581bb83dff57ed8b6fb87dba528d32f71413b9311ef47d9a640aa2d5 (com.docker.compose.config-hash=786a351522d7020c2dcd1c172158fa0decb44da978cf17c63e872b761fcc22ae, com.docker.compose.container-number=1, com.docker.compose.oneoff=False, com.docker.compose.project=postgre, com.docker.compose.service=postgre-10-2, com.docker.compose.version=1.24.0, image=sameersbn/postgresql:10-2, maintainer=sameer@damagehead.com, name=pgdb)
2019-12-03T15:12:48.460662744+08:00 container kill d8e2bd02581bb83dff57ed8b6fb87dba528d32f71413b9311ef47d9a640aa2d5 (com.docker.compose.config-hash=786a351522d7020c2dcd1c172158fa0decb44da978cf17c63e872b761fcc22ae, com.docker.compose.container-number=1, com.docker.compose.oneoff=False, com.docker.compose.project=postgre, com.docker.compose.service=postgre-10-2, com.docker.compose.version=1.24.0, image=sameersbn/postgresql:10-2, maintainer=sameer@damagehead.com, name=pgdb, signal=15)
2019-12-03T15:12:49.352485145+08:00 container die d8e2bd02581bb83dff57ed8b6fb87dba528d32f71413b9311ef47d9a640aa2d5 (com.docker.compose.config-hash=786a351522d7020c2dcd1c172158fa0decb44da978cf17c63e872b761fcc22ae, com.docker.compose.container-number=1, com.docker.compose.oneoff=False, com.docker.compose.project=postgre, com.docker.compose.service=postgre-10-2, com.docker.compose.version=1.24.0, exitCode=1, image=sameersbn/postgresql:10-2, maintainer=sameer@damagehead.com, name=pgdb)
2019-12-03T15:12:49.574709710+08:00 network disconnect 5bef42660ab09450e831718926ee8f2f2547bdc3c6cb3c45104762848e8e30af (container=d8e2bd02581bb83dff57ed8b6fb87dba528d32f71413b9311ef47d9a640aa2d5, name=host, type=host)
2019-12-03T15:12:50.928353376+08:00 container stop d8e2bd02581bb83dff57ed8b6fb87dba528d32f71413b9311ef47d9a640aa2d5 (com.docker.compose.config-hash=786a351522d7020c2dcd1c172158fa0decb44da978cf17c63e872b761fcc22ae, com.docker.compose.container-number=1, com.docker.compose.oneoff=False, com.docker.compose.project=postgre, com.docker.compose.service=postgre-10-2, com.docker.compose.version=1.24.0, image=sameersbn/postgresql:10-2, maintainer=sameer@damagehead.com, name=pgdb)
2019-12-03T15:12:51.044218120+08:00 container destroy d8e2bd02581bb83dff57ed8b6fb87dba528d32f71413b9311ef47d9a640aa2d5 (com.docker.compose.config-hash=786a351522d7020c2dcd1c172158fa0decb44da978cf17c63e872b761fcc22ae, com.docker.compose.container-number=1, com.docker.compose.oneoff=False, com.docker.compose.project=postgre, com.docker.compose.service=postgre-10-2, com.docker.compose.version=1.24.0, image=sameersbn/postgresql:10-2, maintainer=sameer@damagehead.com, name=pgdb)

The extension is working fine, it is only missing double-quote on it due to dash ("-") character.

> psql -h localhost -U postgres -d postgres -c 'CREATE EXTENSION IF NOT EXISTS "uuid-ossp";'
CREATE EXTENSION

update: running with --env 'DB_EXTENSION="uuid-ossp" will solve the issue as well.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant