ERROR: relation "application_settings" does not exist at character 38

[Jenuce]

I used the latest docker-compose file.

It shows this error: postgresql_1 | 2021-01-05 12:02:36.850 UTC [243] STATEMENT: SELECT "application_settings".* FROM "application_settings" ORDER BY "application_settings"."id" DESC LIMIT $1 postgresql_1 | 2021-01-05 12:02:36.857 UTC [243] ERROR: relation "application_settings" does not exist at character 38

How to fixed it ?

[wrongwaycn]

Did you modify the setting of TZ and GITLAB_TIMEZONE in your docker-compose.yml ?

[bert2002]

Did you find a solution? Running into the same problem and did not change TZ.

[jicki]

same problem

[QuiNghia]

sam error

[phith0n]

same.

logs:

postgresql_1  | 2021-10-28 17:08:44.656 UTC [1] LOG:  database system is ready to accept connections
gitlab_1      | Configuring gitlab::database...
gitlab_1      | Configuring gitlab::redis
gitlab_1      | Configuring gitlab::secrets...
gitlab_1      | Configuring gitlab::sidekiq...
gitlab_1      | Configuring gitlab::gitaly...
gitlab_1      | Configuring gitlab::monitoring...
gitlab_1      | Configuring gitlab::gitlab-workhorse...
gitlab_1      | Configuring gitlab::puma...
gitlab_1      | Configuring gitlab::timezone...
gitlab_1      | Configuring gitlab::rack_attack...
gitlab_1      | Configuring gitlab::ci...
gitlab_1      | Configuring gitlab::artifacts...
gitlab_1      | Configuring gitlab::lfs...
gitlab_1      | Configuring gitlab::uploads...
gitlab_1      | Configuring gitlab::mattermost...
gitlab_1      | Configuring gitlab::project_features...
gitlab_1      | Configuring gitlab::oauth...
gitlab_1      | Configuring gitlab::ldap...
gitlab_1      | Configuring gitlab::cron_jobs...
gitlab_1      | Configuring gitlab::backups...
gitlab_1      | Configuring gitlab::registry...
gitlab_1      | Configuring gitlab::pages...
gitlab_1      | Configuring gitlab::sentry...
gitlab_1      | Configuring gitlab-shell...
gitlab_1      | Configuring nginx...
gitlab_1      | Configuring nginx::gitlab...
gitlab_1      | Setting up GitLab for firstrun. Please be patient, this could take a while...
gitlab_1      | /usr/lib/ruby/vendor_ruby/rubygems/defaults/operating_system.rb:10: warning: constant Gem::ConfigMap is deprecated
gitlab_1      | /usr/lib/ruby/vendor_ruby/rubygems/defaults/operating_system.rb:10: warning: constant Gem::ConfigMap is deprecated
gitlab_1      | /usr/lib/ruby/vendor_ruby/rubygems/defaults/operating_system.rb:29: warning: constant Gem::ConfigMap is deprecated
gitlab_1      | /usr/lib/ruby/vendor_ruby/rubygems/defaults/operating_system.rb:30: warning: constant Gem::ConfigMap is deprecated
gitlab_1      | 2021-10-28 22:38:47,123 CRIT Supervisor running as root (no user in config file)
gitlab_1      | 2021-10-28 22:38:47,123 INFO Included extra file "/etc/supervisor/conf.d/cron.conf" during parsing
gitlab_1      | 2021-10-28 22:38:47,123 INFO Included extra file "/etc/supervisor/conf.d/gitaly.conf" during parsing
gitlab_1      | 2021-10-28 22:38:47,123 INFO Included extra file "/etc/supervisor/conf.d/gitlab-workhorse.conf" during parsing
gitlab_1      | 2021-10-28 22:38:47,123 INFO Included extra file "/etc/supervisor/conf.d/groups.conf" during parsing
gitlab_1      | 2021-10-28 22:38:47,123 INFO Included extra file "/etc/supervisor/conf.d/mail_room.conf" during parsing
gitlab_1      | 2021-10-28 22:38:47,123 INFO Included extra file "/etc/supervisor/conf.d/nginx.conf" during parsing
gitlab_1      | 2021-10-28 22:38:47,123 INFO Included extra file "/etc/supervisor/conf.d/puma.conf" during parsing
gitlab_1      | 2021-10-28 22:38:47,123 INFO Included extra file "/etc/supervisor/conf.d/sidekiq.conf" during parsing
gitlab_1      | 2021-10-28 22:38:47,123 INFO Included extra file "/etc/supervisor/conf.d/sshd.conf" during parsing
gitlab_1      | /usr/lib/ruby/vendor_ruby/rubygems/defaults/operating_system.rb:10: warning: constant Gem::ConfigMap is deprecated
gitlab_1      | 2021-10-28 22:38:47,130 INFO RPC interface 'supervisor' initialized
gitlab_1      | /usr/lib/ruby/vendor_ruby/rubygems/defaults/operating_system.rb:10: warning: constant Gem::ConfigMap is deprecated
gitlab_1      | 2021-10-28 22:38:47,131 CRIT Server 'unix_http_server' running without any HTTP authentication checking
gitlab_1      | 2021-10-28 22:38:47,131 INFO supervisord started with pid 619
gitlab_1      | /usr/lib/ruby/vendor_ruby/rubygems/defaults/operating_system.rb:10: warning: constant Gem::ConfigMap is deprecated
gitlab_1      | /usr/lib/ruby/vendor_ruby/rubygems/defaults/operating_system.rb:10: warning: constant Gem::ConfigMap is deprecated
gitlab_1      | /usr/lib/ruby/vendor_ruby/rubygems/defaults/operating_system.rb:10: warning: constant Gem::ConfigMap is deprecated
gitlab_1      | 2021-10-28 22:38:48,133 INFO spawned: 'gitaly' with pid 633
gitlab_1      | 2021-10-28 22:38:48,134 INFO spawned: 'puma' with pid 634
gitlab_1      | 2021-10-28 22:38:48,136 INFO spawned: 'gitlab-workhorse' with pid 635
gitlab_1      | 2021-10-28 22:38:48,138 INFO spawned: 'sidekiq' with pid 636
gitlab_1      | 2021-10-28 22:38:48,140 INFO spawned: 'nginx' with pid 637
gitlab_1      | 2021-10-28 22:38:48,141 INFO spawned: 'sshd' with pid 642
gitlab_1      | 2021-10-28 22:38:48,143 INFO spawned: 'cron' with pid 643
gitlab_1      | 2021-10-28 22:38:49,144 INFO success: gitaly entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
gitlab_1      | 2021-10-28 22:38:49,144 INFO success: puma entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
gitlab_1      | 2021-10-28 22:38:49,144 INFO success: gitlab-workhorse entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
gitlab_1      | 2021-10-28 22:38:49,144 INFO success: sidekiq entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
gitlab_1      | 2021-10-28 22:38:49,144 INFO success: nginx entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
gitlab_1      | 2021-10-28 22:38:49,144 INFO success: sshd entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
gitlab_1      | 2021-10-28 22:38:49,144 INFO success: cron entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
gitlab_1      | /usr/lib/ruby/vendor_ruby/rubygems/defaults/operating_system.rb:10: warning: constant Gem::ConfigMap is deprecated
gitlab_1      | /usr/lib/ruby/vendor_ruby/rubygems/defaults/operating_system.rb:10: warning: constant Gem::ConfigMap is deprecated
gitlab_1      | /usr/lib/ruby/vendor_ruby/rubygems/defaults/operating_system.rb:10: warning: constant Gem::ConfigMap is deprecated
gitlab_1      | /usr/lib/ruby/vendor_ruby/rubygems/defaults/operating_system.rb:10: warning: constant Gem::ConfigMap is deprecated
postgresql_1  | 2021-10-28 17:09:05.895 UTC [227] ERROR:  relation "application_settings" does not exist at character 62
postgresql_1  | 2021-10-28 17:09:05.895 UTC [227] STATEMENT:  /*application:sidekiq*/ SELECT "application_settings".* FROM "application_settings" ORDER BY "application_settings"."id" DESC LIMIT $1
postgresql_1  | 2021-10-28 17:09:05.898 UTC [227] ERROR:  relation "application_settings" does not exist at character 62
postgresql_1  | 2021-10-28 17:09:05.898 UTC [227] STATEMENT:  /*application:sidekiq*/ SELECT "application_settings".* FROM "application_settings" ORDER BY "application_settings"."id" DESC LIMIT $1
gitlab_1      | 2021-10-28 22:39:06,689 INFO exited: sidekiq (exit status 1; not expected)
postgresql_1  | 2021-10-28 17:09:07.598 UTC [231] ERROR:  relation "application_settings" does not exist at character 58
postgresql_1  | 2021-10-28 17:09:07.598 UTC [231] STATEMENT:  /*application:web*/ SELECT "application_settings".* FROM "application_settings" ORDER BY "application_settings"."id" DESC LIMIT $1
postgresql_1  | 2021-10-28 17:09:07.601 UTC [231] ERROR:  relation "application_settings" does not exist at character 58
postgresql_1  | 2021-10-28 17:09:07.601 UTC [231] STATEMENT:  /*application:web*/ SELECT "application_settings".* FROM "application_settings" ORDER BY "application_settings"."id" DESC LIMIT $1
gitlab_1      | 2021-10-28 22:39:07,603 INFO spawned: 'sidekiq' with pid 754
gitlab_1      | 2021-10-28 22:39:07,643 INFO exited: puma (exit status 1; not expected)
gitlab_1      | 2021-10-28 22:39:07,650 INFO spawned: 'puma' with pid 755
gitlab_1      | 2021-10-28 22:39:08,694 INFO success: puma entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
gitlab_1      | 2021-10-28 22:39:08,695 INFO success: sidekiq entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
postgresql_1  | 2021-10-28 17:09:10.480 UTC [233] ERROR:  database "gitlabhq_production" already exists
postgresql_1  | 2021-10-28 17:09:10.480 UTC [233] STATEMENT:  /*application:web*/ CREATE DATABASE "gitlabhq_production" ENCODING = 'unicode'
gitlab_1      | Database 'gitlabhq_production' already exists
gitlab_1      | psql:/home/git/gitlab/db/structure.sql:9: NOTICE:  extension "btree_gist" already exists, skipping
gitlab_1      | psql:/home/git/gitlab/db/structure.sql:11: NOTICE:  extension "pg_trgm" already exists, skipping
cve-2021-22205_gitlab_1 exited with code 1

[soaska]

Same

[randall-coding]

Same I'm still seeing this issue.