sameersbn / sameersbn/docker-gitlab

ERROR: relation "table_without_models" does not exist

Open
#3,279 6 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

After migration to 19.2.0 I started noticing this error in logs:

gitlab.postgresql  | 2026-07-30 00:37:57.381 UTC [110] ERROR:  relation "table_without_models" does not exist
gitlab.postgresql  | 2026-07-30 00:37:57.381 UTC [110] STATEMENT:  SELECT pg_get_serial_sequence('table_without_models', 'id')
gitlab.postgresql  | 2026-07-30 00:38:01.357 UTC [112] ERROR:  relation "table_without_models" does not exist
gitlab.postgresql  | 2026-07-30 00:38:01.357 UTC [112] STATEMENT:  SELECT pg_get_serial_sequence('table_without_models', 'id')

compose.yml

services:
  redis:
    container_name: gitlab.redis
    image: redis:7
    restart: always
    command:
    - --loglevel warning
    volumes:
    - $PWD/redis:/data:Z

  postgresql:
    container_name: gitlab.postgresql
    #image: sameersbn/postgresql:12-20200524
    #image: sameersbn/postgresql:15-20230628
    image: kkimurak/sameersbn-postgresql:17
    restart: always
    volumes:
    - $PWD/postgresql:/var/lib/postgresql:Z
    environment:
    - DB_USER=gitlab
    - DB_PASS=xxx
    - DB_NAME=gitlabhq_production
    - DB_EXTENSION=pg_trgm,btree_gist

  gitlab:
    container_name: gitlab.55180
    #image: sameersbn/gitlab:latest
    image: sameersbn/gitlab:19.2.0
    restart: always
    depends_on:
    - redis
    - postgresql
    ports:
    - "55180:80"
    - "55122:22"
    volumes:
    - $PWD/gitlab:/home/git/data:Z
    healthcheck:
      test: ["CMD", "/usr/local/sbin/healthcheck"]
      interval: 5m
      timeout: 10s
      retries: 3
      start_period: 5m
    labels:
      # AUTOUPDATE
      - com.ouroboros.enable=true
      # TRAEFIK 2
      #- traefik.enable=true
      #- traefik.http.routers.gitlab.entrypoints=websecure
      #- traefik.http.routers.gitlab.rule=Host(`gitlab.zzz.com`)
      #- traefik.http.routers.gitlab.service=gitlab
      #- traefik.http.services.gitlab.loadbalancer.server.port=80
    environment:
    - DEBUG=false

    - DB_ADAPTER=postgresql
    - DB_HOST=postgresql
    - DB_PORT=5432
    - DB_USER=gitlab
    - DB_PASS=xxx
    - DB_NAME=gitlabhq_production

    - REDIS_HOST=redis
    - REDIS_PORT=6379

    - TZ=Europe/Prague
    - GITLAB_TIMEZONE=Europe/Prague

    - GITLAB_HTTPS=false
    - SSL_SELF_SIGNED=false

    - GITLAB_HOST=gitlab.zzz.com
    - GITLAB_PORT=80
    - GITLAB_SSH_PORT=22
    - GITLAB_RELATIVE_URL_ROOT=
    - GITLAB_SECRETS_DB_KEY_BASE=ccc
    - GITLAB_SECRETS_SECRET_KEY_BASE=ccc
    - GITLAB_SECRETS_OTP_KEY_BASE=ccc

    - GITLAB_ROOT_PASSWORD=xxx
    - GITLAB_ROOT_EMAIL=gitlab@zzz.com

    - GITLAB_NOTIFY_ON_BROKEN_BUILDS=true
    - GITLAB_NOTIFY_PUSHER=false

    - GITLAB_EMAIL=gitlab@zzz.com
    - GITLAB_EMAIL_REPLY_TO=gitlab.noreply@zzz.com
    - GITLAB_INCOMING_EMAIL_ADDRESS=gitlab.reply@zzz.com

    - GITLAB_BACKUP_SCHEDULE=daily
    - GITLAB_BACKUP_TIME=01:00

    - SMTP_ENABLED=true
    - SMTP_DOMAIN=www.zzz.com
    - SMTP_HOST=mail.zzz.com
    - SMTP_PORT=587
    - SMTP_USER=gitlab@zzz.com
    - SMTP_PASS=xxx
    - SMTP_STARTTLS=true
    - SMTP_AUTHENTICATION=login

    - IMAP_ENABLED=true
    - IMAP_HOST=mail.zzz.com
    - IMAP_PORT=993
    - IMAP_USER=gitlab@zzz.com
    - IMAP_PASS=xxx
    - IMAP_SSL=true
    - IMAP_STARTTLS=false

    - OAUTH_ENABLED=false
    - OAUTH_AUTO_SIGN_IN_WITH_PROVIDER=
    - OAUTH_ALLOW_SSO=
    - OAUTH_BLOCK_AUTO_CREATED_USERS=true
    - OAUTH_AUTO_LINK_LDAP_USER=false
    - OAUTH_AUTO_LINK_SAML_USER=false
    - OAUTH_EXTERNAL_PROVIDERS=

    - OAUTH_CAS3_LABEL=cas3
    - OAUTH_CAS3_SERVER=
    - OAUTH_CAS3_DISABLE_SSL_VERIFICATION=false
    - OAUTH_CAS3_LOGIN_URL=/cas/login
    - OAUTH_CAS3_VALIDATE_URL=/cas/p3/serviceValidate
    - OAUTH_CAS3_LOGOUT_URL=/cas/logout

    - OAUTH_GOOGLE_API_KEY=
    - OAUTH_GOOGLE_APP_SECRET=
    - OAUTH_GOOGLE_RESTRICT_DOMAIN=

    - OAUTH_FACEBOOK_API_KEY=
    - OAUTH_FACEBOOK_APP_SECRET=

    - OAUTH_TWITTER_API_KEY=
    - OAUTH_TWITTER_APP_SECRET=

    - OAUTH_GITHUB_API_KEY=
    - OAUTH_GITHUB_APP_SECRET=
    - OAUTH_GITHUB_URL=
    - OAUTH_GITHUB_VERIFY_SSL=

    - OAUTH_GITLAB_API_KEY=
    - OAUTH_GITLAB_APP_SECRET=

    - OAUTH_BITBUCKET_API_KEY=
    - OAUTH_BITBUCKET_APP_SECRET=
    - OAUTH_BITBUCKET_URL=

    - OAUTH_SAML_ASSERTION_CONSUMER_SERVICE_URL=
    - OAUTH_SAML_IDP_CERT_FINGERPRINT=
    - OAUTH_SAML_IDP_SSO_TARGET_URL=
    - OAUTH_SAML_ISSUER=
    - OAUTH_SAML_LABEL="Our SAML Provider"
    - OAUTH_SAML_NAME_IDENTIFIER_FORMAT=urn:oasis:names:tc:SAML:2.0:nameid-format:transient
    - OAUTH_SAML_GROUPS_ATTRIBUTE=
    - OAUTH_SAML_EXTERNAL_GROUPS=
    - OAUTH_SAML_ATTRIBUTE_STATEMENTS_EMAIL=
    - OAUTH_SAML_ATTRIBUTE_STATEMENTS_NAME=
    - OAUTH_SAML_ATTRIBUTE_STATEMENTS_USERNAME=
    - OAUTH_SAML_ATTRIBUTE_STATEMENTS_FIRST_NAME=
    - OAUTH_SAML_ATTRIBUTE_STATEMENTS_LAST_NAME=

    - OAUTH_CROWD_SERVER_URL=
    - OAUTH_CROWD_APP_NAME=
    - OAUTH_CROWD_APP_PASSWORD=

    - OAUTH_AUTH0_CLIENT_ID=
    - OAUTH_AUTH0_CLIENT_SECRET=
    - OAUTH_AUTH0_DOMAIN=
    - OAUTH_AUTH0_SCOPE=

    - OAUTH_AZURE_API_KEY=
    - OAUTH_AZURE_API_SECRET=
    - OAUTH_AZURE_TENANT_ID=

networks:
  default:
    name: gitlab

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

Start with compose.yml and reproduce the PostgreSQL errors while upgrading to GitLab 19.2.0 and the listed PostgreSQL image. Trace which startup or migration entry point issues SELECT pg_get_serial_sequence for table_without_models, then verify that the error no longer appears and document the compatible configuration or required fix.

Written by the indexing model from the issue text.

Assessment

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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.