sameersbn / sameersbn/docker-gitlab

sameersbn/gitlab:12.7.7 sameersbn/postgresql:10-2 Error tuple

Open
#2,206 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Dominant language
Shell
Stars
8.1k
Forks
2.1k
Avg merge
17h 47m
Merged PRs (30d)
7

Description

This issue is the same as #821 but can't help me:
I can't run make backup (app:rake gitlab:backup:create), can't run gitlab, can't migrate...
(sameersbn/gitlab:12.7.7 sameersbn/postgresql:10-2 sameersbn/redis:4.0.9-2)

When I try to run sameersbn/postgresql:10-2
ERROR: tuple concurrently updated

Initializing datadir...
Initializing certdir...
Initializing logdir...
Initializing rundir...
Setting resolv.conf ACLs...
Creating database user: gitlab
Creating database: gitlabhq_production...
‣ Loading pg_trgm extension...
‣ Granting access to gitlab user...
ERROR: tuple concurrently updated

My steps shotly:

  • Step 1. sameersbn/postgresql:10-2. ERROR: tuple concurrently updated

  • Step 2.
    docker run -it --name gitlab-postgresql .. sameersbn/postgresql:10-2 /bin/bash
    sudo -u ${PG_USER} -g ${PG_USER} ${PG_BINDIR}/postgres -D ${PG_DATADIR} -d 5
    /sbin/entrypoint.sh - OK

  • Step 3. Nothing chages sameersbn/postgresql:10-2
    docker run -it --name gitlab-postgresql ...
    ERROR: tuple concurrently updated

  • Step 4. Migrate to sameersbn/postgresql:11-20200524 - OK

  • Step 5. Run redis - OK

  • Step 6. Start gitlab 12.7.7 - Not ok
    docker run --name gitlab -d
    --link gitlab-postgresql:/gitlab/postgresql --link gitlab-redis:/gitlab/redisio
    ....
    --volume /srv/docker/gitlab/gitlab:/home/git/data
    sameersbn/gitlab:12.7.7

  • Step 7. Migrate to sameersbn/gitlab:13.0.6 Not ok

  • Step 8. Migrate to sameersbn/gitlab:13.2.2 Not ok

I can't run make backup (app:rake gitlab:backup:create), can't run gitlab, can't migrate...

Step 1. I tried to run gitlab-postgresql:

root@:/srv/docker/gitlab# docker run -it --name gitlab-postgresql
--env 'DB_NAME=gitlabhq_production'
--env 'DB_USER=gitlab' --env 'DB_PASS=password'
--env 'DB_EXTENSION=pg_trgm'
--volume /srv/docker/gitlab/postgresql:/var/lib/postgresql
sameersbn/postgresql:10-2
Initializing datadir...
Initializing certdir...
Initializing logdir...
Initializing rundir...
Setting resolv.conf ACLs...
Creating database user: gitlab
Creating database: gitlabhq_production...
‣ Loading pg_trgm extension...
‣ Granting access to gitlab user...
ERROR: tuple concurrently updated

Step 2

root@:/srv/docker/gitlab# docker run -it --name gitlab-postgresql
--volume /srv/docker/gitlab/postgresql:/var/lib/postgresql
sameersbn/postgresql:10-2 /bin/bash

root@248bc04f2805:/var/lib/postgresql# sudo -u ${PG_USER} -g ${PG_USER} ${PG_BINDIR}/postgres -D ${PG_DATADIR} -d 5

2020-08-11 17:43:12.653 UTC [12] DEBUG: postgres: PostmasterMain: initial environment dump:
2020-08-11 17:43:12.653 UTC [12] DEBUG: -----------------------------------------
2020-08-11 17:43:12.653 UTC [12] DEBUG: LS_COLORS=rs=0:di=01;34:ln=01;36:mh=00:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=40;31;01:mi=00:su=37;41:sg=30;43:ca=30;41:tw=30;42:ow=34;42:st=37;44:ex=01;32:.tar=01;31:.tgz=01;31:.arc=01;31:.arj=01;31:.taz=01;31:.lha=01;31:.lz4=01;31:.lzh=01;31:.lzma=01;31:.tlz=01;31:.txz=01;31:.tzo=01;31:.t7z=01;31:.zip=01;31:.z=01;31:.Z=01;31:.dz=01;31:.gz=01;31:.lrz=01;31:.lz=01;31:.lzo=01;31:.xz=01;31:.zst=01;31:.tzst=01;31:.bz2=01;31:.bz=01;31:.tbz=01;31:.tbz2=01;31:.tz=01;31:.deb=01;31:.rpm=01;31:.jar=01;31:.war=01;31:.ear=01;31:.sar=01;31:.rar=01;31:.alz=01;31:.ace=01;31:.zoo=01;31:.cpio=01;31:.7z=01;31:.rz=01;31:.cab=01;31:.wim=01;31:.swm=01;31:.dwm=01;31:.esd=01;31:.jpg=01;35:.jpeg=01;35:.mjpg=01;35:.mjpeg=01;35:.gif=01;35:.bmp=01;35:.pbm=01;35:.pgm=01;35:.ppm=01;35:.tga=01;35:.xbm=01;35:.xpm=01;35:.tif=01;35:.tiff=01;35:.png=01;35:.svg=01;35:.svgz=01;35:.mng=01;35:.pcx=01;35:.mov=01;35:.mpg=01;35:.mpeg=01;35:.m2v=01;35:.mkv=01;35:.webm=01;35:.ogm=01;35:.mp4=01;35:.m4v=01;35:.mp4v=01;35:.vob=01;35:.qt=01;35:.nuv=01;35:.wmv=01;35:.asf=01;35:.rm=01;35:.rmvb=01;35:.flc=01;35:.avi=01;35:.fli=01;35:.flv=01;35:.gl=01;35:.dl=01;35:.xcf=01;35:.xwd=01;35:.yuv=01;35:.cgm=01;35:.emf=01;35:.ogv=01;35:.ogx=01;35:.aac=00;36:.au=00;36:.flac=00;36:.m4a=00;36:.mid=00;36:.midi=00;36:.mka=00;36:.mp3=00;36:.mpc=00;36:.ogg=00;36:.ra=00;36:.wav=00;36:.oga=00;36:.opus=00;36:.spx=00;36:.xspf=00;36:
2020-08-11 17:43:12.654 UTC [12] DEBUG: HOSTNAME=248bc04f2805
2020-08-11 17:43:12.654 UTC [12] DEBUG: HOME=/root
2020-08-11 17:43:12.654 UTC [12] DEBUG: TERM=xterm
2020-08-11 17:43:12.654 UTC [12] DEBUG: PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/snap/bin
2020-08-11 17:43:12.654 UTC [12] DEBUG: MAIL=/var/mail/postgres
2020-08-11 17:43:12.654 UTC [12] DEBUG: LOGNAME=postgres
2020-08-11 17:43:12.654 UTC [12] DEBUG: USER=postgres
2020-08-11 17:43:12.654 UTC [12] DEBUG: USERNAME=postgres
2020-08-11 17:43:12.654 UTC [12] DEBUG: SHELL=/bin/bash
2020-08-11 17:43:12.654 UTC [12] DEBUG: SUDO_COMMAND=/usr/lib/postgresql/10/bin/postgres -D /var/lib/postgresql/10/main -d 5
2020-08-11 17:43:12.654 UTC [12] DEBUG: SUDO_USER=root
2020-08-11 17:43:12.654 UTC [12] DEBUG: SUDO_UID=0
2020-08-11 17:43:12.654 UTC [12] DEBUG: SUDO_GID=0
2020-08-11 17:43:12.654 UTC [12] DEBUG: PGLOCALEDIR=/usr/share/locale
2020-08-11 17:43:12.654 UTC [12] DEBUG: PGSYSCONFDIR=/etc/postgresql-common
2020-08-11 17:43:12.654 UTC [12] DEBUG: LC_COLLATE=C
2020-08-11 17:43:12.654 UTC [12] DEBUG: LC_CTYPE=C
2020-08-11 17:43:12.654 UTC [12] DEBUG: LC_MESSAGES=C
2020-08-11 17:43:12.654 UTC [12] DEBUG: LC_MONETARY=C
2020-08-11 17:43:12.654 UTC [12] DEBUG: LC_NUMERIC=C
2020-08-11 17:43:12.654 UTC [12] DEBUG: LC_TIME=C
2020-08-11 17:43:12.654 UTC [12] DEBUG: -----------------------------------------
2020-08-11 17:43:12.668 UTC [12] DEBUG: registering background worker "logical replication launcher"
2020-08-11 17:43:12.668 UTC [12] LOG: listening on IPv4 address "127.0.0.1", port 5432
2020-08-11 17:43:12.672 UTC [12] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2020-08-11 17:43:12.674 UTC [12] DEBUG: invoking IpcMemoryCreate(size=148545536)
2020-08-11 17:43:12.674 UTC [12] DEBUG: mmap(148897792) with MAP_HUGETLB failed, huge pages disabled: Cannot allocate memory
2020-08-11 17:43:12.689 UTC [12] DEBUG: SlruScanDirectory invoking callback on pg_notify/0000
2020-08-11 17:43:12.689 UTC [12] DEBUG: removing file "pg_notify/0000"
2020-08-11 17:43:12.689 UTC [12] DEBUG: dynamic shared memory system will support 288 segments
2020-08-11 17:43:12.690 UTC [12] DEBUG: created dynamic shared memory control segment 1929605635 (6928 bytes)
2020-08-11 17:43:12.691 UTC [12] DEBUG: max_safe_fds = 985, usable_fds = 1000, already_open = 5
2020-08-11 17:43:12.709 UTC [13] LOG: database system was interrupted; last known up at 2020-08-11 17:41:16 UTC
2020-08-11 17:43:12.788 UTC [13] DEBUG: checkpoint record is at 0/439EEC10
2020-08-11 17:43:12.789 UTC [13] DEBUG: redo record is at 0/439EEC10; shutdown TRUE
2020-08-11 17:43:12.789 UTC [13] DEBUG: next transaction ID: 0:45525; next OID: 71956
2020-08-11 17:43:12.789 UTC [13] DEBUG: next MultiXactId: 96; next MultiXactOffset: 200
2020-08-11 17:43:12.789 UTC [13] DEBUG: oldest unfrozen transaction ID: 548, in database 1
2020-08-11 17:43:12.789 UTC [13] DEBUG: oldest MultiXactId: 1, in database 1
2020-08-11 17:43:12.789 UTC [13] DEBUG: commit timestamp Xid oldest/newest: 0/0
2020-08-11 17:43:12.789 UTC [13] DEBUG: transaction ID wrap limit is 2147484195, limited by database with OID 1
2020-08-11 17:43:12.789 UTC [13] DEBUG: MultiXactId wrap limit is 2147483648, limited by database with OID 1
2020-08-11 17:43:12.789 UTC [13] DEBUG: starting up replication slots
2020-08-11 17:43:12.789 UTC [13] DEBUG: starting up replication origin progress state
2020-08-11 17:43:12.789 UTC [13] LOG: database system was not properly shut down; automatic recovery in progress
2020-08-11 17:43:12.792 UTC [13] DEBUG: resetting unlogged relations: cleanup 1 init 0
2020-08-11 17:43:12.795 UTC [13] LOG: invalid record length at 0/439EEC80: wanted 24, got 0
2020-08-11 17:43:12.795 UTC [13] LOG: redo is not required
2020-08-11 17:43:12.795 UTC [13] DEBUG: resetting unlogged relations: cleanup 0 init 1
2020-08-11 17:43:12.816 UTC [13] DEBUG: performing replication slot checkpoint
2020-08-11 17:43:12.842 UTC [13] DEBUG: attempting to remove WAL segments older than log file 000000000000000000000022
2020-08-11 17:43:12.842 UTC [13] DEBUG: MultiXactId wrap limit is 2147483648, limited by database with OID 1
2020-08-11 17:43:12.848 UTC [13] DEBUG: oldest MultiXactId member is at offset 1
2020-08-11 17:43:12.848 UTC [13] DEBUG: MultiXact member stop limit is now 4294914944 based on MultiXact 1
2020-08-11 17:43:12.850 UTC [13] DEBUG: shmem_exit(0): 1 before_shmem_exit callbacks to make
2020-08-11 17:43:12.850 UTC [13] DEBUG: shmem_exit(0): 4 on_shmem_exit callbacks to make
2020-08-11 17:43:12.850 UTC [13] DEBUG: proc_exit(0): 2 callbacks to make
2020-08-11 17:43:12.850 UTC [13] DEBUG: exit(0)
2020-08-11 17:43:12.850 UTC [13] DEBUG: shmem_exit(-1): 0 before_shmem_exit callbacks to make
2020-08-11 17:43:12.850 UTC [13] DEBUG: shmem_exit(-1): 0 on_shmem_exit callbacks to make
2020-08-11 17:43:12.850 UTC [13] DEBUG: proc_exit(-1): 0 callbacks to make
2020-08-11 17:43:12.853 UTC [12] DEBUG: reaping dead processes
2020-08-11 17:43:12.854 UTC [14] DEBUG: checkpointer updated shared memory configuration values
2020-08-11 17:43:12.856 UTC [12] DEBUG: starting background worker process "logical replication launcher"
2020-08-11 17:43:12.856 UTC [17] DEBUG: autovacuum launcher started
2020-08-11 17:43:12.856 UTC [12] LOG: database system is ready to accept connections
2020-08-11 17:43:12.856 UTC [17] DEBUG: InitPostgres
2020-08-11 17:43:12.856 UTC [17] DEBUG: my backend ID is 1
2020-08-11 17:43:12.857 UTC [19] DEBUG: logical replication launcher started
2020-08-11 17:43:12.857 UTC [19] DEBUG: InitPostgres
2020-08-11 17:43:12.857 UTC [19] DEBUG: my backend ID is 2
2020-08-11 17:43:12.857 UTC [17] DEBUG: StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0
2020-08-11 17:43:12.857 UTC [17] DEBUG: CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 0/1/0
2020-08-11 17:43:12.857 UTC [19] DEBUG: StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0
2020-08-11 17:43:12.857 UTC [19] DEBUG: CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 0/1/0
2020-08-11 17:43:12.857 UTC [18] DEBUG: received inquiry for database 0
2020-08-11 17:43:12.857 UTC [18] DEBUG: writing stats file "pg_stat_tmp/global.stat"
2020-08-11 17:43:12.857 UTC [19] DEBUG: StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0
2020-08-11 17:43:12.857 UTC [19] DEBUG: CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 0/1/0
2020-08-11 17:43:12.858 UTC [19] DEBUG: StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0
2020-08-11 17:43:12.858 UTC [19] DEBUG: CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 0/1/0
2020-08-11 17:43:12.868 UTC [17] DEBUG: StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0
2020-08-11 17:43:12.868 UTC [17] DEBUG: CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 0/1/0
^C2020-08-11 17:43:20.317 UTC [12] DEBUG: postmaster received signal 2
2020-08-11 17:43:20.317 UTC [12] LOG: received fast shutdown request
2020-08-11 17:43:20.319 UTC [12] LOG: aborting any active transactions
2020-08-11 17:43:20.319 UTC [12] DEBUG: sending signal 15 to process 19
2020-08-11 17:43:20.319 UTC [19] DEBUG: logical replication launcher shutting down
2020-08-11 17:43:20.319 UTC [19] DEBUG: shmem_exit(1): 2 before_shmem_exit callbacks to make
2020-08-11 17:43:20.319 UTC [15] DEBUG: shmem_exit(0): 1 before_shmem_exit callbacks to make
2020-08-11 17:43:20.319 UTC [19] DEBUG: shmem_exit(1): 6 on_shmem_exit callbacks to make
2020-08-11 17:43:20.319 UTC [17] DEBUG: autovacuum launcher shutting down
2020-08-11 17:43:20.319 UTC [16] DEBUG: shmem_exit(0): 1 before_shmem_exit callbacks to make
2020-08-11 17:43:20.319 UTC [15] DEBUG: shmem_exit(0): 4 on_shmem_exit callbacks to make
2020-08-11 17:43:20.319 UTC [17] DEBUG: shmem_exit(0): 1 before_shmem_exit callbacks to make
2020-08-11 17:43:20.319 UTC [16] DEBUG: shmem_exit(0): 4 on_shmem_exit callbacks to make
2020-08-11 17:43:20.319 UTC [15] DEBUG: proc_exit(0): 2 callbacks to make
2020-08-11 17:43:20.319 UTC [17] DEBUG: shmem_exit(0): 6 on_shmem_exit callbacks to make
2020-08-11 17:43:20.319 UTC [19] DEBUG: proc_exit(1): 2 callbacks to make
2020-08-11 17:43:20.319 UTC [15] DEBUG: exit(0)
2020-08-11 17:43:20.319 UTC [16] DEBUG: proc_exit(0): 2 callbacks to make
2020-08-11 17:43:20.319 UTC [19] DEBUG: exit(1)
2020-08-11 17:43:20.319 UTC [16] DEBUG: exit(0)
2020-08-11 17:43:20.319 UTC [17] DEBUG: proc_exit(0): 2 callbacks to make
2020-08-11 17:43:20.319 UTC [15] DEBUG: shmem_exit(-1): 0 before_shmem_exit callbacks to make
2020-08-11 17:43:20.319 UTC [17] DEBUG: exit(0)
2020-08-11 17:43:20.319 UTC [16] DEBUG: shmem_exit(-1): 0 before_shmem_exit callbacks to make
2020-08-11 17:43:20.319 UTC [15] DEBUG: shmem_exit(-1): 0 on_shmem_exit callbacks to make
2020-08-11 17:43:20.319 UTC [16] DEBUG: shmem_exit(-1): 0 on_shmem_exit callbacks to make
2020-08-11 17:43:20.320 UTC [15] DEBUG: proc_exit(-1): 0 callbacks to make
2020-08-11 17:43:20.320 UTC [17] DEBUG: shmem_exit(-1): 0 before_shmem_exit callbacks to make
2020-08-11 17:43:20.320 UTC [16] DEBUG: proc_exit(-1): 0 callbacks to make
2020-08-11 17:43:20.320 UTC [17] DEBUG: shmem_exit(-1): 0 on_shmem_exit callbacks to make
2020-08-11 17:43:20.320 UTC [17] DEBUG: proc_exit(-1): 0 callbacks to make
2020-08-11 17:43:20.320 UTC [19] DEBUG: shmem_exit(-1): 0 before_shmem_exit callbacks to make
2020-08-11 17:43:20.320 UTC [19] DEBUG: shmem_exit(-1): 0 on_shmem_exit callbacks to make
2020-08-11 17:43:20.320 UTC [19] DEBUG: proc_exit(-1): 0 callbacks to make
2020-08-11 17:43:20.322 UTC [12] DEBUG: reaping dead processes
2020-08-11 17:43:20.323 UTC [12] DEBUG: reaping dead processes
2020-08-11 17:43:20.323 UTC [12] DEBUG: reaping dead processes
2020-08-11 17:43:20.323 UTC [12] LOG: worker process: logical replication launcher (PID 19) exited with exit code 1
2020-08-11 17:43:20.323 UTC [12] DEBUG: reaping dead processes
2020-08-11 17:43:20.323 UTC [14] LOG: shutting down
2020-08-11 17:43:20.354 UTC [14] DEBUG: performing replication slot checkpoint
2020-08-11 17:43:20.372 UTC [14] DEBUG: attempting to remove WAL segments older than log file 000000000000000000000022
2020-08-11 17:43:20.372 UTC [14] DEBUG: SlruScanDirectory invoking callback on pg_subtrans/0000
2020-08-11 17:43:20.372 UTC [14] DEBUG: shmem_exit(0): 1 before_shmem_exit callbacks to make
2020-08-11 17:43:20.372 UTC [14] DEBUG: shmem_exit(0): 4 on_shmem_exit callbacks to make
2020-08-11 17:43:20.372 UTC [14] DEBUG: proc_exit(0): 2 callbacks to make
2020-08-11 17:43:20.372 UTC [14] DEBUG: exit(0)
2020-08-11 17:43:20.373 UTC [14] DEBUG: shmem_exit(-1): 0 before_shmem_exit callbacks to make
2020-08-11 17:43:20.373 UTC [14] DEBUG: shmem_exit(-1): 0 on_shmem_exit callbacks to make
2020-08-11 17:43:20.373 UTC [14] DEBUG: proc_exit(-1): 0 callbacks to make
2020-08-11 17:43:20.374 UTC [12] DEBUG: reaping dead processes
2020-08-11 17:43:20.374 UTC [18] DEBUG: writing stats file "pg_stat/global.stat"
2020-08-11 17:43:20.375 UTC [18] DEBUG: shmem_exit(-1): 0 before_shmem_exit callbacks to make
2020-08-11 17:43:20.375 UTC [18] DEBUG: shmem_exit(-1): 0 on_shmem_exit callbacks to make
2020-08-11 17:43:20.375 UTC [18] DEBUG: proc_exit(-1): 0 callbacks to make
2020-08-11 17:43:20.377 UTC [12] DEBUG: reaping dead processes
2020-08-11 17:43:20.377 UTC [12] DEBUG: shmem_exit(0): 0 before_shmem_exit callbacks to make
2020-08-11 17:43:20.377 UTC [12] DEBUG: shmem_exit(0): 5 on_shmem_exit callbacks to make
2020-08-11 17:43:20.377 UTC [12] DEBUG: cleaning up dynamic shared memory control segment with ID 1929605635
2020-08-11 17:43:20.380 UTC [12] DEBUG: proc_exit(0): 2 callbacks to make
2020-08-11 17:43:20.380 UTC [12] LOG: database system is shut down
2020-08-11 17:43:20.380 UTC [12] DEBUG: exit(0)
2020-08-11 17:43:20.380 UTC [12] DEBUG: shmem_exit(-1): 0 before_shmem_exit callbacks to make
2020-08-11 17:43:20.380 UTC [12] DEBUG: shmem_exit(-1): 0 on_shmem_exit callbacks to make
2020-08-11 17:43:20.380 UTC [12] DEBUG: proc_exit(-1): 0 callbacks to make
root@248bc04f2805:/var/lib/postgresql#

root@248bc04f2805:/var/lib/postgresql# /sbin/entrypoint.sh

Initializing datadir...
Initializing certdir...
Initializing logdir...
Initializing rundir...
Setting resolv.conf ACLs...
Starting PostgreSQL 10...
2020-08-11 17:44:42.705 UTC [20] LOG: listening on IPv4 address "0.0.0.0", port 5432
2020-08-11 17:44:42.705 UTC [20] LOG: listening on IPv6 address "::", port 5432
2020-08-11 17:44:42.708 UTC [20] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2020-08-11 17:44:42.733 UTC [3615] LOG: database system was shut down at 2020-08-11 17:44:42 UTC
2020-08-11 17:44:42.745 UTC [20] LOG: database system is ready to accept connections
^C2020-08-11 17:44:51.060 UTC [20] LOG: received fast shutdown request
2020-08-11 17:44:51.064 UTC [20] LOG: aborting any active transactions
2020-08-11 17:44:51.067 UTC [20] LOG: worker process: logical replication launcher (PID 3621) exited with exit code 1
2020-08-11 17:44:51.067 UTC [3616] LOG: shutting down
2020-08-11 17:44:51.086 UTC [20] LOG: database system is shut down
root@248bc04f2805:/var/lib/postgresql#

Step 3. Nothing chages sameersbn/postgresql:10-2

root@:/srv/docker/gitlab# docker run -it --name gitlab-postgresql
--env 'DB_NAME=gitlabhq_production'
--env 'DB_USER=gitlab' --env 'DB_PASS=password'
--env 'DB_EXTENSION=pg_trgm'
--volume /srv/docker/gitlab/postgresql:/var/lib/postgresql
sameersbn/postgresql:10-2
Initializing datadir...
Initializing certdir...
Initializing logdir...
Initializing rundir...
Setting resolv.conf ACLs...
Creating database user: gitlab
Creating database: gitlabhq_production...
‣ Loading pg_trgm extension...
‣ Granting access to gitlab user...
ERROR: tuple concurrently updated

Step 4. Migrate to sameersbn/postgresql:11-20200524 OK

root@:/srv/docker/gitlab# docker run -it --name gitlab-postgresql
--env 'DB_NAME=gitlabhq_production'
--env 'DB_USER=gitlab' --env 'DB_PASS=password'
--env 'DB_EXTENSION=pg_trgm'
--volume /srv/docker/gitlab/postgresql:/var/lib/postgresql
sameersbn/postgresql:11-20200524
Initializing datadir...
Initializing certdir...
Initializing logdir...
Initializing rundir...
Setting resolv.conf ACLs...
Initializing database...
‣ Migrating PostgreSQL 10 data to 11...
‣ Installing PostgreSQL 10...
debconf: delaying package configuration, since apt-utils is not installed
‣ Migration in progress. Please be patient...Performing Consistency Checks

Checking cluster versions ok
Checking database user is the install user ok
Checking database connection settings ok
Checking for prepared transactions ok
Checking for reg* data types in user tables ok
Checking for contrib/isn with bigint-passing mismatch ok
Creating dump of global objects ok
Creating dump of database schemas
ok
Checking for presence of required libraries ok
Checking database user is the install user ok
Checking for prepared transactions ok

If pg_upgrade fails after this point, you must re-initdb the
new cluster before continuing.

Performing Upgrade

Analyzing all rows in the new cluster ok
Freezing all rows in the new cluster ok
Deleting files from new pg_xact ok
Copying old pg_xact to new server ok
Setting next transaction ID and epoch for new cluster ok
Deleting files from new pg_multixact/offsets ok
Copying old pg_multixact/offsets to new server ok
Deleting files from new pg_multixact/members ok
Copying old pg_multixact/members to new server ok
Setting next multixact ID and offset for new cluster ok
Resetting WAL archives ok
Setting frozenxid and minmxid counters in new cluster ok
Restoring global objects in the new cluster ok
Restoring database schemas in the new cluster
ok
Copying user relation files
ok
Setting next OID for new cluster ok
Sync data directory to disk ok
Creating script to analyze new cluster ok
Creating script to delete old cluster ok

Upgrade Complete

Optimizer statistics are not transferred by pg_upgrade so,
once you start the new server, consider running:
./analyze_new_cluster.sh

Running this script will delete the old cluster's data files:
./delete_old_cluster.sh

Configuring hot standby...
‣ Setting postgresql.conf parameter: wal_level = 'hot_standby'
‣ Setting postgresql.conf parameter: max_wal_senders = '16'
‣ Setting postgresql.conf parameter: checkpoint_segments = '8'
‣ Setting postgresql.conf parameter: wal_keep_segments = '32'
‣ Setting postgresql.conf parameter: hot_standby = 'on'
‣ Setting postgresql.conf parameter: data_directory = '/var/lib/postgresql/11/main'
‣ Setting postgresql.conf parameter: log_directory = '/var/log/postgresql'
‣ Setting postgresql.conf parameter: log_filename = 'postgresql-11-main.log'
‣ Setting postgresql.conf parameter: ssl = 'off'
Creating database user: gitlab
Creating database: gitlabhq_production...
‣ Loading pg_trgm extension...
‣ Granting access to gitlab user...
Starting PostgreSQL 11...
2020-08-11 17:54:58.429 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432
2020-08-11 17:54:58.429 UTC [1] LOG: listening on IPv6 address "::", port 5432
2020-08-11 17:54:58.450 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2020-08-11 17:54:58.503 UTC [1671] LOG: database system was shut down at 2020-08-11 17:54:58 UTC
2020-08-11 17:54:58.516 UTC [1] LOG: database system is ready to accept connections

Step 5. Run redis - OK

root@devir:/home/devir/gitlab# docker run --name gitlab-redis -d
--volume /srv/docker/gitlab/redis:/var/lib/redis
sameersbn/redis:4.0.9-2

  • Step 6. Start gitlab 12.7.7 - not ok

docker run -it --name gitlab
--link gitlab-postgresql:/gitlab/postgresql --link gitlab-redis:/gitlab/redisio
....
--volume /srv/docker/gitlab/gitlab:/home/git/data
sameersbn/gitlab:12.7.7

Loading /etc/docker-gitlab/runtime/env-defaults
Initializing logdir...
Initializing datadir...
Installing configuration templates...
Configuring gitlab...
Configuring gitlab::database
Configuring gitlab::redis
Configuring gitlab::secrets...
Configuring gitlab::sidekiq...
Configuring gitlab::gitaly...
Configuring gitlab::monitoring...
Configuring gitlab::gitlab-workhorse...
Configuring gitlab::unicorn...
Configuring gitlab::timezone...
Configuring gitlab::rack_attack...
Configuring gitlab::ci...
Configuring gitlab::artifacts...
Configuring gitlab::lfs...
Configuring gitlab::uploads...
Configuring gitlab::mattermost...
Configuring gitlab::project_features...
Configuring gitlab::oauth...
Configuring gitlab::ldap...
Configuring gitlab::cron_jobs...
Configuring gitlab::backups...
Configuring gitlab::registry...
Configuring gitlab::pages...
Configuring gitlab::sentry...
Configuring gitlab-shell...
Configuring nginx...
Configuring nginx::gitlab...
Configuring nginx::gitlab_ci...
/sbin/entrypoint.sh: line 18: 598 Terminated /usr/bin/supervisord -nc /etc/supervisor/supervisord.conf
2020-08-11 18:31:43,597 CRIT Supervisor running as root (no user in config file)
2020-08-11 18:31:43,597 INFO Included extra file "/etc/supervisor/conf.d/cron.conf" during parsing
2020-08-11 18:31:43,597 INFO Included extra file "/etc/supervisor/conf.d/gitaly.conf" during parsing
2020-08-11 18:31:43,597 INFO Included extra file "/etc/supervisor/conf.d/gitlab-workhorse.conf" during parsing
2020-08-11 18:31:43,597 INFO Included extra file "/etc/supervisor/conf.d/groups.conf" during parsing
2020-08-11 18:31:43,597 INFO Included extra file "/etc/supervisor/conf.d/mail_room.conf" during parsing
2020-08-11 18:31:43,597 INFO Included extra file "/etc/supervisor/conf.d/nginx.conf" during parsing
2020-08-11 18:31:43,598 INFO Included extra file "/etc/supervisor/conf.d/sidekiq.conf" during parsing
2020-08-11 18:31:43,598 INFO Included extra file "/etc/supervisor/conf.d/sshd.conf" during parsing
2020-08-11 18:31:43,598 INFO Included extra file "/etc/supervisor/conf.d/unicorn.conf" during parsing
2020-08-11 18:31:43,610 INFO RPC interface 'supervisor' initialized
2020-08-11 18:31:43,610 CRIT Server 'unix_http_server' running without any HTTP authentication checking
2020-08-11 18:31:43,610 INFO supervisord started with pid 1
2020-08-11 18:31:44,613 INFO spawned: 'gitaly' with pid 613
2020-08-11 18:31:44,617 INFO spawned: 'gitlab-workhorse' with pid 614
2020-08-11 18:31:44,619 INFO spawned: 'unicorn' with pid 615
2020-08-11 18:31:44,622 INFO spawned: 'sidekiq' with pid 616
2020-08-11 18:31:44,625 INFO spawned: 'nginx' with pid 622
2020-08-11 18:31:44,627 INFO spawned: 'sshd' with pid 623
2020-08-11 18:31:44,629 INFO spawned: 'cron' with pid 630
2020-08-11 18:31:44,646 INFO exited: gitaly (exit status 1; not expected)
2020-08-11 18:31:45,658 INFO spawned: 'gitaly' with pid 636
2020-08-11 18:31:45,659 INFO success: gitlab-workhorse entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
2020-08-11 18:31:45,659 INFO success: unicorn entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
2020-08-11 18:31:45,659 INFO success: sidekiq entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
2020-08-11 18:31:45,659 INFO success: nginx entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
2020-08-11 18:31:45,659 INFO success: sshd entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
2020-08-11 18:31:45,659 INFO success: cron entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
2020-08-11 18:31:45,686 INFO exited: gitaly (exit status 1; not expected)
2020-08-11 18:31:48,328 INFO spawned: 'gitaly' with pid 645
2020-08-11 18:31:48,357 INFO exited: gitaly (exit status 1; not expected)
2020-08-11 18:31:51,363 INFO spawned: 'gitaly' with pid 655
2020-08-11 18:31:51,391 INFO exited: gitaly (exit status 1; not expected)
2020-08-11 18:31:52,392 INFO gave up: gitaly entered FATAL state, too many start retries too quickly

  • Step 7. Migrate to sameersbn/gitlab:13.0.6 - not ok

  • Step 8. Migrate to sameersbn/gitlab:13.2.2 - not ok

Status: Downloaded newer image for sameersbn/gitlab:13.2.2
Loading /etc/docker-gitlab/runtime/env-defaults
Initializing logdir...
Initializing datadir...
Installing configuration templates...
Configuring gitlab...
Configuring gitlab::database
Configuring gitlab::redis
Configuring gitlab::secrets...
Configuring gitlab::sidekiq...
Configuring gitlab::gitaly...
Configuring gitlab::monitoring...
Configuring gitlab::gitlab-workhorse...
Configuring gitlab::puma...
Configuring gitlab::timezone...
Configuring gitlab::rack_attack...
Configuring gitlab::ci...
Configuring gitlab::artifacts...
Configuring gitlab::lfs...
Configuring gitlab::uploads...
Configuring gitlab::mattermost...
Configuring gitlab::project_features...
Configuring gitlab::oauth...
Configuring gitlab::ldap...
Configuring gitlab::cron_jobs...
Configuring gitlab::backups...
Configuring gitlab::registry...
Configuring gitlab::pages...
Configuring gitlab::sentry...
Configuring gitlab-shell...
Configuring nginx...
Configuring nginx::gitlab...
Configuring nginx::gitlab_ci...
/sbin/entrypoint.sh: line 19: 620 Terminated /usr/bin/supervisord -nc /etc/supervisor/supervisord.conf
2020-08-11 19:24:49,759 CRIT Supervisor running as root (no user in config file)
2020-08-11 19:24:49,759 INFO Included extra file "/etc/supervisor/conf.d/cron.conf" during parsing
2020-08-11 19:24:49,759 INFO Included extra file "/etc/supervisor/conf.d/gitaly.conf" during parsing
2020-08-11 19:24:49,759 INFO Included extra file "/etc/supervisor/conf.d/gitlab-workhorse.conf" during parsing
2020-08-11 19:24:49,759 INFO Included extra file "/etc/supervisor/conf.d/groups.conf" during parsing
2020-08-11 19:24:49,759 INFO Included extra file "/etc/supervisor/conf.d/mail_room.conf" during parsing
2020-08-11 19:24:49,759 INFO Included extra file "/etc/supervisor/conf.d/nginx.conf" during parsing
2020-08-11 19:24:49,759 INFO Included extra file "/etc/supervisor/conf.d/puma.conf" during parsing
2020-08-11 19:24:49,759 INFO Included extra file "/etc/supervisor/conf.d/sidekiq.conf" during parsing
2020-08-11 19:24:49,759 INFO Included extra file "/etc/supervisor/conf.d/sshd.conf" during parsing
2020-08-11 19:24:49,771 INFO RPC interface 'supervisor' initialized
2020-08-11 19:24:49,771 CRIT Server 'unix_http_server' running without any HTTP authentication checking
2020-08-11 19:24:49,771 INFO supervisord started with pid 1
2020-08-11 19:24:50,775 INFO spawned: 'gitaly' with pid 635
2020-08-11 19:24:50,778 INFO spawned: 'puma' with pid 636
2020-08-11 19:24:50,781 INFO spawned: 'gitlab-workhorse' with pid 637
2020-08-11 19:24:50,784 INFO spawned: 'sidekiq' with pid 638
2020-08-11 19:24:50,787 INFO spawned: 'nginx' with pid 642
2020-08-11 19:24:50,789 INFO spawned: 'sshd' with pid 646
2020-08-11 19:24:50,791 INFO spawned: 'cron' with pid 651
2020-08-11 19:24:51,079 INFO exited: gitaly (exit status 1; not expected)
2020-08-11 19:24:52,081 INFO spawned: 'gitaly' with pid 664
2020-08-11 19:24:52,082 INFO success: puma entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
2020-08-11 19:24:52,082 INFO success: gitlab-workhorse entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
2020-08-11 19:24:52,082 INFO success: sidekiq entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
2020-08-11 19:24:52,082 INFO success: nginx entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
2020-08-11 19:24:52,082 INFO success: sshd entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
2020-08-11 19:24:52,082 INFO success: cron entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
2020-08-11 19:24:52,373 INFO exited: gitaly (exit status 1; not expected)
2020-08-11 19:24:54,510 INFO spawned: 'gitaly' with pid 678
2020-08-11 19:24:54,800 INFO exited: gitaly (exit status 1; not expected)
2020-08-11 19:24:57,806 INFO spawned: 'gitaly' with pid 690
2020-08-11 19:24:58,101 INFO exited: gitaly (exit status 1; not expected)
2020-08-11 19:24:59,102 INFO gave up: gitaly entered FATAL state, too many start retries too quickly

  • Additional information:

docker info

Client:
Debug Mode: false

Server:
Containers: 0
Running: 0
Paused: 0
Stopped: 0
Images: 0
Server Version: 19.03.12
Storage Driver: overlay2
Backing Filesystem: xfs
Supports d_type: true
Native Overlay Diff: true
Logging Driver: syslog
Cgroup Driver: cgroupfs
Plugins:
Volume: local
Network: bridge host ipvlan macvlan null overlay
Log: awslogs fluentd gcplogs gelf journald json-file local logentries splunk syslog
Swarm: inactive
Runtimes: runc
Default Runtime: runc
Init Binary: docker-init
containerd version: 7ad184331fa3e55e52b890ea95e65ba581ae3429
runc version: dc9208a3303feef5b3839f4323d9beb36df0a9dd
init version: fec3683
Security Options:
apparmor
seccomp
Profile: default
Kernel Version: 5.4.0-42-generic
Operating System: Ubuntu 20.04 LTS
OSType: linux
Architecture: x86_64
CPUs: 8
Total Memory: 62.9GiB
Name: devir
ID: ZYSV:TAMH:5PDK:6WLL:EITE:ZK7W:B3CQ:AE7A:UTQ6:PYDR:CKLS:2SLG
Docker Root Dir: /data/root_docker
Debug Mode: false
Registry: https://index.docker.io/v1/
Labels:
Experimental: false
Insecure Registries:
127.0.0.0/8
Live Restore Enabled: false

docker version

Client: Docker Engine - Community
Version: 19.03.12
API version: 1.40
Go version: go1.13.10
Git commit: 48a66213fe
Built: Mon Jun 22 15:45:44 2020
OS/Arch: linux/amd64
Experimental: false

Server: Docker Engine - Community
Engine:
Version: 19.03.12
API version: 1.40 (minimum version 1.12)
Go version: go1.13.10
Git commit: 48a66213fe
Built: Mon Jun 22 15:44:15 2020
OS/Arch: linux/amd64
Experimental: false
containerd:
Version: 1.2.13
GitCommit: 7ad184331fa3e55e52b890ea95e65ba581ae3429
runc:
Version: 1.0.0-rc10
GitCommit: dc9208a3303feef5b3839f4323d9beb36df0a9dd
docker-init:
Version: 0.18.0
GitCommit: fec3683

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

The report points to /sbin/entrypoint.sh and the sameersbn/postgresql:10-2 container; start by reproducing initialization with the listed Docker commands and inspecting the PostgreSQL logs. Done means the PostgreSQL container initializes without “tuple concurrently updated” and GitLab can start, migrate, and create a backup.

Written by the indexing model from the issue text.

Assessment

Tech stack
docker, postgresql, shell
Domain
databases, devops, infrastructure
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
20/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.