sameersbn / sameersbn/docker-gitlab
ERROR: relation "table_without_models" does not exist
Open
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
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- 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