Docker image CE 10.8.4 (2268d0cf) to gitlab-ee=11.0.1-ee.0 upgrade fail
Summary
Just pull gitlab-ee=11.0.1-ee.0 over 10.8.4 and upgrade crash at migrations .
Steps to reproduce
Pull new image (lastes) over 10.8.4
git_1 |
git_1 | bash[migrate gitlab-rails database] (gitlab::database_migrations line 49) had an error: Mixlib::ShellOut::ShellCommandFailed: Expected process to exit with [0], but received '1'
git_1 | ---- Begin output of "bash" "/tmp/chef-script20180627-43-kqqliz" ----
git_1 | STDOUT: rake aborted!
git_1 | StandardError: An error has occurred, this and all later migrations canceled:
git_1 |
git_1 | PG::DuplicateColumn: ERROR: column "issues_template" of relation "projects" already exists
git_1 | : ALTER TABLE "projects" ADD "issues_template" text
git_1 | /opt/gitlab/embedded/service/gitlab-rails/config/initializers/postgresql_limit_fix.rb:6:in `add_column'
git_1 | /opt/gitlab/embedded/service/gitlab-rails/ee/db/migrate/20150929160851_add_issues_template_to_project.rb:3:in `change'
git_1 | /opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/db.rake:50:in `block (3 levels) in <top (required)>'
git_1 | /opt/gitlab/embedded/bin/bundle:23:in `load'
git_1 | /opt/gitlab/embedded/bin/bundle:23:in `<main>'
git_1 |
git_1 | Caused by:
git_1 | ActiveRecord::StatementInvalid: PG::DuplicateColumn: ERROR: column "issues_template" of relation "projects" already exists
git_1 | : ALTER TABLE "projects" ADD "issues_template" text
git_1 | /opt/gitlab/embedded/service/gitlab-rails/config/initializers/postgresql_limit_fix.rb:6:in `add_column'
git_1 | /opt/gitlab/embedded/service/gitlab-rails/ee/db/migrate/20150929160851_add_issues_template_to_project.rb:3:in `change'
git_1 | /opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/db.rake:50:in `block (3 levels) in <top (required)>'
git_1 | /opt/gitlab/embedded/bin/bundle:23:in `load'
git_1 | /opt/gitlab/embedded/bin/bundle:23:in `<main>'
git_1 |
git_1 | Caused by:
git_1 | PG::DuplicateColumn: ERROR: column "issues_template" of relation "projects" already exists
git_1 | /opt/gitlab/embedded/service/gitlab-rails/config/initializers/postgresql_limit_fix.rb:6:in `add_column'
git_1 | /opt/gitlab/embedded/service/gitlab-rails/ee/db/migrate/20150929160851_add_issues_template_to_project.rb:3:in `change'
git_1 | /opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/db.rake:50:in `block (3 levels) in <top (required)>'
git_1 | /opt/gitlab/embedded/bin/bundle:23:in `load'
git_1 | /opt/gitlab/embedded/bin/bundle:23:in `<main>'
git_1 | Tasks: TOP => db:migrate
git_1 | (See full trace by running task with --trace)
git_1 | == 20140319135450 InitEESchema: migrating =====================================
git_1 | -- add_column(:namespaces, :ldap_cn, :string, {:null=>true})
git_1 | -> 0.0032s
git_1 | -- add_column(:namespaces, :ldap_access, :integer, {:null=>true})
git_1 | -> 0.0004s
git_1 | -- create_table(:git_hooks)
git_1 | -> 0.0215s
git_1 | == 20140319135450 InitEESchema: migrated (0.0252s) ============================
git_1 |
git_1 | == 20140414093351 CreateAppearances: migrating ================================
git_1 | -- table_exists?(:appearances)
git_1 | -> 0.0011s
git_1 | == 20140414093351 CreateAppearances: migrated (0.0011s) =======================
git_1 |
git_1 | == 20140508105809 AddMrTemplateToProject: migrating ===========================
git_1 | -- add_column(:projects, :merge_requests_template, :text)
git_1 | -> 0.0019s
git_1 | == 20140508105809 AddMrTemplateToProject: migrated (0.0019s) ==================
git_1 |
git_1 | == 20140513095908 AddUsernamePasswordApiVersionToServices: migrating ==========
git_1 | -- add_column(:services, :username, :string)
git_1 | -> 0.0014s
git_1 | -- add_column(:services, :password, :string)
git_1 | -> 0.0006s
git_1 | -- add_column(:services, :api_version, :string)
git_1 | -> 0.0008s
git_1 | == 20140513095908 AddUsernamePasswordApiVersionToServices: migrated (0.0028s) =
git_1 |
git_1 | == 20140811083829 AddUnsubscribedAtFieldToUsers: migrating ====================
git_1 | -- add_column(:users, :admin_email_unsubscribed_at, :datetime)
git_1 | -> 0.0012s
git_1 | == 20140811083829 AddUnsubscribedAtFieldToUsers: migrated (0.0012s) ===========
git_1 |
git_1 | == 20140811155127 AddJiraIssueTransitionIdToServices: migrating ===============
git_1 | -- add_column(:services, :jira_issue_transition_id, :string, {:default=>"2"})
git_1 | -> 0.0230s
git_1 | == 20140811155127 AddJiraIssueTransitionIdToServices: migrated (0.0296s) ======
git_1 |
git_1 | == 20140813090117 AddLdapGroupsTable: migrating ===============================
git_1 | -- create_table(:ldap_groups)
git_1 | -> 0.0080s
git_1 | == 20140813090117 AddLdapGroupsTable: migrated (0.0081s) ======================
git_1 |
git_1 | == 20140813133925 RenameLdapGroupToLdapGroupLink: migrating ===================
git_1 | -- rename_table(:ldap_groups, :ldap_group_links)
git_1 | -> 0.0153s
git_1 | -- execute("INSERT INTO ldap_group_links ( group_access, cn, group_id, created_at, updated_at )\n SELECT ldap_access, ldap_cn, id, DATE('2018-06-27 15:58:12'), DATE('2018-06-27 15:58:12') FROM namespaces\n WHERE ldap_cn IS NOT NULL;")
git_1 | -> 0.0016s
git_1 | == 20140813133925 RenameLdapGroupToLdapGroupLink: migrated (0.0171s) ==========
git_1 |
git_1 | == 20140907223153 RemoveColumnsForServices: migrating =========================
git_1 | -- remove_column(:services, :username, :string)
git_1 | -> 0.0012s
git_1 | -- remove_column(:services, :password, :string)
git_1 | -> 0.0004s
git_1 | -- remove_column(:services, :jira_issue_transition_id, :string)
git_1 | -> 0.0008s
git_1 | -- remove_column(:services, :api_version, :string)
git_1 | -> 0.0004s
git_1 | == 20140907223153 RemoveColumnsForServices: migrated (0.0028s) ================
git_1 |
git_1 | == 20141010132608 AddProviderToLdapGroupLinks: migrating ======================
git_1 | -- add_column(:ldap_group_links, :provider, :string)
git_1 | -> 0.0005s
git_1 | == 20141010132608 AddProviderToLdapGroupLinks: migrated (0.0005s) =============
git_1 |
git_1 | == 20141027173526 AddAuthorEmailRegexToGitHook: migrating =====================
git_1 | -- add_column(:git_hooks, :author_email_regex, :string)
git_1 | -> 0.0006s
git_1 | == 20141027173526 AddAuthorEmailRegexToGitHook: migrated (0.0007s) ============
git_1 |
git_1 | == 20141030133853 AddMemberCheckToGitHooks: migrating =========================
git_1 | -- add_column(:git_hooks, :member_check, :boolean, {:default=>false, :null=>false})
git_1 | -> 0.0090s
git_1 | == 20141030133853 AddMemberCheckToGitHooks: migrated (0.0091s) ================
git_1 |
git_1 | == 20141103160516 AddFileNameRegexToGitHooks: migrating =======================
git_1 | -- add_column(:git_hooks, :file_name_regex, :string)
git_1 | -> 0.0006s
git_1 | == 20141103160516 AddFileNameRegexToGitHooks: migrated (0.0006s) ==============
git_1 |
git_1 | == 20141212124604 AddGroupMembershipLock: migrating ===========================
git_1 | -- add_column(:namespaces, :membership_lock, :boolean, {:default=>false})
git_1 | -> 0.0379s
git_1 | == 20141212124604 AddGroupMembershipLock: migrated (0.0380s) ==================
git_1 |
git_1 | == 20141213212220 AddHeaderLogosToAppearances: migrating ======================
git_1 | -- add_column(:appearances, :dark_logo, :string)
git_1 | -> 0.0015s
git_1 | -- add_column(:appearances, :light_logo, :string)
git_1 | -> 0.0005s
git_1 | == 20141213212220 AddHeaderLogosToAppearances: migrated (0.0021s) =============
git_1 |
git_1 | == 20141230100055 RemoveOldFieldsFromNamespace: migrating =====================
git_1 | -- remove_column(:namespaces, :ldap_cn)
git_1 | -> 0.0006s
git_1 | -- remove_column(:namespaces, :ldap_access)
git_1 | -> 0.0004s
git_1 | == 20141230100055 RemoveOldFieldsFromNamespace: migrated (0.0011s) ============
git_1 |
git_1 | == 20150125163158 AddRebaseSettingToProjects: migrating =======================
git_1 | -- add_column(:projects, :merge_requests_rebase_default, :boolean, {:default=>true})
git_1 | -> 0.0533s
git_1 | == 20150125163158 AddRebaseSettingToProjects: migrated (0.0534s) ==============
git_1 |
git_1 | == 20150225214822 HelpTextToApplicationSettings: migrating ====================
git_1 | -- add_column(:application_settings, :help_text, :text)
git_1 | -> 0.0015s
git_1 | == 20150225214822 HelpTextToApplicationSettings: migrated (0.0016s) ===========
git_1 |
git_1 | == 20150312000132 AddGroupIdToWebHooks: migrating =============================
git_1 | -- add_column(:web_hooks, :group_id, :integer, {:after=>:project_id})
git_1 | -> 0.0013s
git_1 | == 20150312000132 AddGroupIdToWebHooks: migrated (0.0014s) ====================
git_1 |
git_1 | == 20150324223425 AddIsSampleToGitHooks: migrating ============================
git_1 | -- add_column(:git_hooks, :is_sample, :boolean, {:default=>false})
git_1 | -> 0.0114s
git_1 | == 20150324223425 AddIsSampleToGitHooks: migrated (0.0115s) ===================
git_1 |
git_1 | == 20150501095306 CreateLicenses: migrating ===================================
git_1 | -- create_table(:licenses)
git_1 | -> 0.0061s
git_1 | == 20150501095306 CreateLicenses: migrated (0.0062s) ==========================
git_1 |
git_1 | == 20150507194350 CreateHistoricalData: migrating =============================
git_1 | -- create_table(:historical_data)
git_1 | -> 0.0038s
git_1 | == 20150507194350 CreateHistoricalData: migrated (0.0038s) ====================
git_1 |
git_1 | == 20150605131047 AddMaxFileSizeToGitHooks: migrating =========================
git_1 | -- add_column(:git_hooks, :max_file_size, :integer, {:default=>0})
git_1 | -> 0.0069s
git_1 | == 20150605131047 AddMaxFileSizeToGitHooks: migrated (0.0070s) ================
git_1 |
git_1 | == 20150609113337 CreateApproves: migrating ===================================
git_1 | -- create_table(:approvals)
git_1 | -> 0.0045s
git_1 | == 20150609113337 CreateApproves: migrated (0.0046s) ==========================
git_1 |
git_1 | == 20150609125332 AddProjectMergeApproves: migrating ==========================
git_1 | -- add_column(:projects, :approvals_before_merge, :integer, {:null=>false, :default=>0})
git_1 | -> 0.0596s
git_1 | == 20150609125332 AddProjectMergeApproves: migrated (0.0597s) =================
git_1 |
git_1 | == 20150707222220 AddApproversTable: migrating ================================
git_1 | -- create_table(:approvers)
git_1 | -> 0.0215s
git_1 | == 20150707222220 AddApproversTable: migrated (0.0216s) =======================
git_1 |
git_1 | == 20150709134649 AddResetApproversToProject: migrating =======================
git_1 | -- add_column(:projects, :reset_approvers_on_push, :boolean, {:default=>true})
git_1 | -> 0.0470s
git_1 | == 20150709134649 AddResetApproversToProject: migrated (0.0471s) ==============
git_1 |
git_1 | == 20150717155058 RenameResetApprovers: migrating =============================
git_1 | -- rename_column(:projects, :reset_approvers_on_push, :reset_approvals_on_push)
git_1 | -> 0.0177s
git_1 | == 20150717155058 RenameResetApprovers: migrated (0.0179s) ====================
git_1 |
git_1 | == 20150731200022 RemoveInvalidApprovers: migrating ===========================
git_1 | -- execute("DELETE FROM approvers WHERE user_id = 0")
git_1 | -> 0.0007s
git_1 | == 20150731200022 RemoveInvalidApprovers: migrated (0.0007s) ==================
git_1 |
git_1 | == 20150827144737 MigrateRebaseFeature: migrating =============================
git_1 | -- execute("UPDATE projects SET merge_requests_ff_only_enabled = TRUE WHERE merge_requests_rebase_enabled IS TRUE")
git_1 | -> 0.0032s
git_1 | -- remove_column(:projects, :merge_requests_rebase_default)
git_1 | -> 0.0007s
git_1 | == 20150827144737 MigrateRebaseFeature: migrated (0.0040s) ====================
git_1 |
git_1 | == 20150929160851 AddIssuesTemplateToProject: migrating =======================
git_1 | -- add_column(:projects, :issues_template, :text)
git_1 | STDERR:
git_1 | ---- End output of "bash" "/tmp/chef-script20180627-43-kqqliz" ----
git_1 | Ran "bash" "/tmp/chef-script20180627-43-kqqliz" returned 1
git_1 |
Edited by 🤖 GitLab Bot 🤖