Issue with updating Gitlab CE from 12.10.8 to 13.0.3
Summary
I am trying to update from version 12.10.8 to the latest one which is 13.0.3
Steps to reproduce
What I do is:
I run sudo apt-get install gitlab-ce
and it yields the following log:
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following packages will be upgraded:
gitlab-ce
1 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
Need to get 0 B/730 MB of archives.
After this operation, 238 MB disk space will be freed.
(Reading database ... 226617 files and directories currently installed.)
Preparing to unpack .../gitlab-ce_13.0.3-ce.0_amd64.deb ...
gitlab preinstall:
gitlab preinstall: Your version of PostgreSQL is no longer supported. Please upgrade your PostgreSQL version to 11.
gitlab preinstall: Check https://docs.gitlab.com/omnibus/settings/database.html#upgrade-packaged-postgresql-server for details.
gitlab preinstall:
gitlab preinstall: Upgrade failed. Retry the upgrade after upgrading your PostgreSQL version.
dpkg: error processing archive /var/cache/apt/archives/gitlab-ce_13.0.3-ce.0_amd64.deb (--unpack):
new gitlab-ce package pre-installation script subprocess returned error exit status 1
Errors were encountered while processing:
/var/cache/apt/archives/gitlab-ce_13.0.3-ce.0_amd64.deb
E: Sub-process /usr/bin/dpkg returned an error code (1)
What is the current bug behavior?
It's stopping the update script.
Also, I can no longer access the repo.
If I go to page: https://gitlab.mysite.com/folder/sub_folder
it does not work.
But these pages work fine: https://gitlab.mysite.com/help
or https://gitlab.mysite.com/
What is the expected correct behavior?
To upgrade to the new version successfully and for me to have access to the repo via the web.
Relevant logs
Relevant logs from sudo gitlab-ctl tail
:
==> /var/log/gitlab/nginx/gitlab_access.log <==
209.97.179.13 - - [02/Jun/2020:21:48:28 +0000] "POST /api/v4/jobs/request HTTP/1.1" 204 0 "-" "gitlab-runner 13.0.0 (13-0-stable; go1.13.8; linux/amd64)"
==> /var/log/gitlab/postgresql/current <==
2020-06-02_21:48:30.13221 ERROR: column projects.merge_requests_require_code_owner_approval does not exist at character 2604
2020-06-02_21:48:30.13227 STATEMENT: SELECT "projects"."id" AS t0_r0, "projects"."name" AS t0_r1, "projects"."path" AS t0_r2, "projects"."description" AS t0_r3, "projects"."created_at" AS t0_r4, "projects"."updated_at" AS t0_r5, "projects"."creator_id" AS t0_r6, "projects"."namespace_id" AS t0_r7, "projects"."last_activity_at" AS t0_r8, "projects"."import_url" AS t0_r9, "projects"."visibility_level" AS t0_r10, "projects"."archived" AS t0_r11, "projects"."avatar" AS t0_r12, "projects"."star_count" AS t0_r13, "projects"."import_type" AS t0_r14, "projects"."import_source" AS t0_r15, "projects"."shared_runners_enabled" AS t0_r16, "projects"."runners_token" AS t0_r17, "projects"."build_coverage_regex" AS t0_r18, "projects"."build_allow_git_fetch" AS t0_r19, "projects"."build_timeout" AS t0_r20, "projects"."pending_delete" AS t0_r21, "projects"."public_builds" AS t0_r22, "projects"."last_repository_check_failed" AS t0_r23, "projects"."last_repository_check_at" AS t0_r24, "projects"."container_registry_enabled" AS t0_r25, "projects"."only_allow_merge_if_pipeline_succeeds" AS t0_r26, "projects"."has_external_issue_tracker" AS t0_r27, "projects"."repository_storage" AS t0_r28, "projects"."request_access_enabled" AS t0_r29, "projects"."has_external_wiki" AS t0_r30, "projects"."ci_config_path" AS t0_r31, "projects"."lfs_enabled" AS t0_r32, "projects"."description_html" AS t0_r33, "projects"."only_allow_merge_if_all_discussions_are_resolved" AS t0_r34, "projects"."printing_merge_request_link_enabled" AS t0_r35, "projects"."auto_cancel_pending_pipelines" AS t0_r36, "projects"."cached_markdown_version" AS t0_r37, "projects"."delete_error" AS t0_r38, "projects"."last_repository_updated_at" AS t0_r39, "projects"."storage_version" AS t0_r40, "projects"."resolve_outdated_diff_discussions" AS t0_r41, "projects"."repository_read_only" AS t0_r42, "projects"."merge_requests_ff_only_enabled" AS t0_r43, "projects"."merge_requests_rebase_enabled" AS t0_r44, "projects"."jobs_cache_index" AS t0_r45, "projects"."pages_https_only" AS t0_r46, "projects"."remote_mirror_available_overridden" AS t0_r47, "projects"."pool_repository_id" AS t0_r48, "projects"."runners_token_encrypted" AS t0_r49, "projects"."bfg_object_map" AS t0_r50, "projects"."detected_repository_languages" AS t0_r51, "projects"."external_authorization_classification_label" AS t0_r52, "projects"."disable_overriding_approvers_per_merge_request" AS t0_r53, "projects"."external_webhook_token" AS t0_r54, "projects"."issues_template" AS t0_r55, "projects"."merge_requests_author_approval" AS t0_r56, "projects"."merge_requests_disable_committers_approval" AS t0_r57, "projects"."merge_requests_require_code_owner_approval" AS t0_r58, "projects"."merge_requests_template" AS t0_r59, "projects"."mirror_last_successful_update_at" AS t0_r60, "projects"."mirror_last_update_at" AS t0_r61, "projects"."mirror_overwrites_diverged_branches" AS t0_r62, "projects"."mirror_user_id" AS t0_r63, "projects"."only_mirror_protected_branches" AS t0_r64, "projects"."packages_enabled" AS t0_r65, "projects"."pull_mirror_available_overridden" AS t0_r66, "projects"."repository_size_limit" AS t0_r67, "projects"."require_password_to_approve" AS t0_r68, "projects"."mirror" AS t0_r69, "projects"."mirror_trigger_builds" AS t0_r70, "projects"."reset_approvals_on_push" AS t0_r71, "projects"."service_desk_enabled" AS t0_r72, "projects"."approvals_before_merge" AS t0_r73, "projects"."emails_disabled" AS t0_r74, "routes"."id" AS t1_r0, "routes"."source_id" AS t1_r1, "routes"."source_type" AS t1_r2, "routes"."path" AS t1_r3, "routes"."created_at" AS t1_r4, "routes"."updated_at" AS t1_r5, "routes"."name" AS t1_r6 FROM "projects" LEFT OUTER JOIN "routes" ON "routes"."source_id" = "projects"."id" AND "routes"."source_type" = 'Project' WHERE "routes"."path" = 'folder/sub_folder' LIMIT 1
==> /var/log/gitlab/gitlab-rails/production.log <==
Started GET "/folder/sub_folder" for 108.29.37.227 at 2020-06-02 21:48:30 +0000
ActiveRecord::StatementInvalid (PG::UndefinedColumn: ERROR: column projects.merge_requests_require_code_owner_approval does not exist
LINE 1: ..._requests_disable_committers_approval" AS t0_r57, "projects"...
^
):
app/models/concerns/routable.rb:38:in `find_by_full_path'
lib/constraints/project_url_constrainer.rb:15:in `matches?'
lib/gitlab/request_profiler/middleware.rb:17:in `call'
lib/gitlab/middleware/go.rb:20:in `call'
lib/gitlab/etag_caching/middleware.rb:13:in `call'
lib/gitlab/middleware/multipart.rb:124:in `call'
lib/gitlab/middleware/read_only/controller.rb:53:in `call'
lib/gitlab/middleware/read_only.rb:18:in `call'
lib/gitlab/middleware/same_site_cookies.rb:27:in `call'
lib/gitlab/middleware/basic_health_check.rb:25:in `call'
lib/gitlab/middleware/request_context.rb:23:in `call'
config/initializers/fix_local_cache_middleware.rb:9:in `call'
lib/gitlab/metrics/requests_rack_middleware.rb:60:in `call'
lib/gitlab/middleware/release_env.rb:12:in `call'
==> /var/log/gitlab/gitlab-rails/sidekiq_exporter.log <==
[2020-06-02T21:48:30.054+0000] 127.0.0.1 - - [02/Jun/2020:21:48:30 UTC] "GET /metrics HTTP/1.1" 200 7773 "-" "Prometheus/2.16.0"
Details of package version
dpkg-query -l "gitlab-*"
yields:
Desired=Unknown/Install/Remove/Purge/Hold
| Status=Not/Inst/Conf-files/Unpacked/halF-conf/Half-inst/trig-aWait/Trig-pend
|/ Err?=(none)/Reinst-required (Status,Err: uppercase=bad)
||/ Name Version Architecture Description
+++-=====================================================-===============================-===============================-================================================================================================================
ii gitlab-ce 12.10.8-ce.0 amd64 GitLab Community Edition (including NGINX, Postgres, Redis)
un gitlab-ci-multi-runner <none> <none> (no description available)
un gitlab-ci-multi-runner-beta <none> <none> (no description available)
un gitlab-ee <none> <none> (no description available)
ii gitlab-runner 13.0.1 amd64 GitLab Runner
un gitlab-runner-beta <none> <none> (no description available)
Environment details
- Operating System:
Ubuntu 18.04.4 LTS
- Installation Target, remove incorrect values:
- VM: Digital Ocean
- Installation Type, remove incorrect values:
- Upgrade from version
12.10.8
.
- Upgrade from version
- Is there any other software running on the machine:
influxdb
,nginx
- Is this a single or multiple node installation?: Single, I guess.
- Resources
- CPU:
4
- Memory total:
8GB
- CPU:
Configuration details
external_url 'https://gitlab.mysite.com'
unicorn['enable'] = true
web_server['external_users'] = ['www-data']
nginx['enable'] = false
nginx['redirect_http_to_https'] = true
nginx['redirect_http_to_https_port'] = 80
nginx['listen_port'] = 8080
letsencrypt['enable'] = false