GitLab 9.0 to 9.2 is incompatible with PostgreSQL 9.1
We have several migrations that use the DROP INDEX CONCURRENTLY
syntax explicitly. This causes them to fail when run against postgresql 9.1
We should use CONCURRENTLY
conditionally in existing code, and drop support for postgresql 9.1 in GitLab 9.3
Summary
Application shows error 500 page after upgrading from 9.1 to 9.2
Steps to reproduce
Upgrade from 9.1 to 9.2 using incremental upgrade documentation here:
https://gitlab.com/gitlab-org/gitlab-ce/blob/master/doc/update/9.1-to-9.2.md
What is the current bug behavior?
The application shows error page 500 and errors ont production.log:
Relevant logs and/or screenshots
Started GET "/" for 192.168.1.116 at 2017-05-24 10:49:11 +0200
Processing by RootController#index as HTML
Completed 500 Internal Server Error in 192ms (ActiveRecord: 2.9ms)
NoMethodError (undefined method `clientside_sentry_enabled' for #<ApplicationSetting:0x007f9ab45f8b00>):
lib/gitlab/gon_helper.rb:13:in `add_gon_variables'
lib/gitlab/middleware/multipart.rb:93:in `call'
lib/gitlab/request_profiler/middleware.rb:14:in `call'
lib/gitlab/middleware/go.rb:16:in `call'
lib/gitlab/etag_caching/middleware.rb:10:in `call'
lib/gitlab/request_context.rb:18:in `call'
Results of GitLab environment info
Expand for output related to GitLab environment info
System information System: Debian 7.11 Current User: git Using RVM: no Ruby Version: 2.3.1p112 Gem Version: 2.5.1 Bundler Version:1.14.6 Rake Version: 10.5.0 Redis Version: 3.2.4 Git Version: 2.7.3 Sidekiq Version:5.0.0GitLab information Version: 9.2.1 Revision: f50598f Directory: /home/git/gitlab DB Adapter: postgresql URL: http://192.168.1.120 HTTP Clone URL: http://192.168.1.120/some-group/some-project.git SSH Clone URL: git@192.168.1.120:some-group/some-project.git Using LDAP: no Using Omniauth: no
GitLab Shell Version: 5.0.4 Repository storage paths:
- default: /home/git/repositories Hooks: /home/git/gitlab-shell/hooks Git: /usr/bin/git
Results of GitLab application Check
Expand for output related to the GitLab application check
Checking GitLab Shell ...GitLab Shell version >= 5.0.4 ? ... OK (5.0.4) Repo base directory exists? default... yes Repo storage directories are symlinks? default... no Repo paths owned by git:root, or git:git? default... yes Repo paths access is drwxrws---? default... yes hooks directories in repos are links: ... 3/1 ... ok 3/2 ... ok 3/3 ... ok 3/4 ... ok 13/5 ... ok 18/6 ... ok 13/7 ... ok 3/8 ... ok 3/9 ... ok 2/11 ... ok 3/12 ... ok 13/13 ... ok 3/14 ... ok 3/15 ... ok 3/16 ... ok 3/17 ... ok 3/18 ... ok 13/19 ... ok 3/20 ... ok 18/21 ... ok 3/22 ... ok 18/23 ... ok 18/24 ... ok 18/25 ... ok 3/26 ... ok 18/27 ... ok 3/28 ... ok 3/29 ... ok 18/30 ... ok 18/31 ... ok 18/32 ... ok 3/33 ... ok 2/34 ... ok 3/35 ... ok 18/36 ... ok 2/37 ... ok 3/38 ... ok 3/39 ... ok 18/40 ... ok 13/41 ... ok 18/42 ... ok 3/43 ... ok 3/44 ... ok 3/45 ... ok 3/46 ... ok 18/47 ... ok 3/48 ... ok 3/49 ... ok Running /home/git/gitlab-shell/bin/check Check GitLab API access: OK Access to /home/git/.ssh/authorized_keys: OK Send ping to redis server: OK gitlab-shell self-check successful
Checking GitLab Shell ... Finished
Checking Sidekiq ...
Running? ... yes Number of Sidekiq processes ... 1
Checking Sidekiq ... Finished
Checking Reply by email ...
Reply by email is disabled in config/gitlab.yml
Checking Reply by email ... Finished
Checking LDAP ...
LDAP is disabled in config/gitlab.yml
Checking LDAP ... Finished
Checking GitLab ...
Git configured with autocrlf=input? ... yes Database config exists? ... yes All migrations up? ... yes Database contains orphaned GroupMembers? ... no GitLab config exists? ... yes GitLab config outdated? ... no Log directory writable? ... yes Tmp directory writable? ... yes Uploads directory setup correctly? ... yes Init script exists? ... yes Init script up-to-date? ... yes projects have namespace: ... 3/1 ... yes 3/2 ... yes 3/3 ... yes 3/4 ... yes 13/5 ... yes 18/6 ... yes 13/7 ... yes 3/8 ... yes 3/9 ... yes 2/11 ... yes 3/12 ... yes 13/13 ... yes 3/14 ... yes 3/15 ... yes 3/16 ... yes 3/17 ... yes 3/18 ... yes 13/19 ... yes 3/20 ... yes 18/21 ... yes 3/22 ... yes 18/23 ... yes 18/24 ... yes 18/25 ... yes 3/26 ... yes 18/27 ... yes 3/28 ... yes 3/29 ... yes 18/30 ... yes 18/31 ... yes 18/32 ... yes 3/33 ... yes 2/34 ... yes 3/35 ... yes 18/36 ... yes 2/37 ... yes 3/38 ... yes 3/39 ... yes 18/40 ... yes 13/41 ... yes 18/42 ... yes 3/43 ... yes 3/44 ... yes 3/45 ... yes 3/46 ... yes 18/47 ... yes 3/48 ... yes 3/49 ... yes Redis version >= 2.8.0? ... yes Ruby version >= 2.1.0 ? ... yes (2.3.1) Your git bin path is "/usr/bin/git" Git version >= 2.7.3 ? ... yes (2.7.3) Active users: 12
Checking GitLab ... Finished