Skip to content

All CI offline migrations

Kamil Trzcińśki requested to merge all-ci-offline-migrations into master

What does this MR do?

This MR merges all CI migrations to aid merge and makes sure that they are reversible:

This is also a follow up after: https://gitlab.com/gitlab-com/infrastructure/issues/1267

Forward migration from 8.17.2

== 20170211073944 DisableInvalidServiceTemplates: migrating ===================
== 20170211073944 DisableInvalidServiceTemplates: migrated (0.0157s) ==========

== 20170214084746 AddDefaultArtifactsExpirationToApplicationSettings: migrating 
-- add_column(:application_settings, :default_artifacts_expire_in, :string, {:null=>false, :default=>"0"})
   -> 0.0715s
== 20170214084746 AddDefaultArtifactsExpirationToApplicationSettings: migrated (0.0717s) 

== 20170214111112 DeleteDeprecatedGitlabCiService: migrating ==================
-- execute("SET statement_timeout TO 0")
   -> 0.0008s
-- execute("DELETE FROM services WHERE type = 'GitlabCiService';")
   -> 0.0028s
== 20170214111112 DeleteDeprecatedGitlabCiService: migrated (0.0038s) =========

== 20170215200045 RemoveThemeIdFromUsers: migrating ===========================
-- remove_column(:users, :theme_id, :integer)
   -> 0.0014s
== 20170215200045 RemoveThemeIdFromUsers: migrated (0.0015s) ==================

== 20170216135621 AddIndexForLatestSuccessfulPipeline: migrating ==============
-- transaction_open?()
   -> 0.0000s
-- execute("SET statement_timeout TO 0")
   -> 0.0011s
-- add_index(:ci_commits, [:gl_project_id, :ref, :status], {:algorithm=>:concurrently})
   -> 0.0503s
== 20170216135621 AddIndexForLatestSuccessfulPipeline: migrated (0.0517s) =====

== 20170216141440 DropIndexForBuildsProjectStatus: migrating ==================
-- remove_index(:ci_commits, {:column=>[:gl_project_id, :status]})
   -> 0.0027s
== 20170216141440 DropIndexForBuildsProjectStatus: migrated (0.0028s) =========

== 20170217132157 RenameMergeWhenBuildSucceeds: migrating =====================
-- rename_column(:merge_requests, :merge_when_build_succeeds, :merge_when_pipeline_succeeds)
   -> 0.0183s
== 20170217132157 RenameMergeWhenBuildSucceeds: migrated (0.0184s) ============

== 20170217151947 RenameOnlyAllowMergeIfBuildSucceeds: migrating ==============
-- rename_column(:projects, :only_allow_merge_if_build_succeeds, :only_allow_merge_if_pipeline_succeeds)
   -> 0.0264s
== 20170217151947 RenameOnlyAllowMergeIfBuildSucceeds: migrated (0.0266s) =====

== 20170217151948 AddOwnerIdToTriggers: migrating =============================
-- add_column(:ci_triggers, :owner_id, :integer)
   -> 0.0084s
== 20170217151948 AddOwnerIdToTriggers: migrated (0.0085s) ====================

== 20170217151949 AddDescriptionToTriggers: migrating =========================
-- add_column(:ci_triggers, :description, :string)
   -> 0.0029s
== 20170217151949 AddDescriptionToTriggers: migrated (0.0029s) ================

== 20170222143317 DropCiProjects: migrating ===================================
-- drop_table(:ci_projects)
   -> 0.0024s
== 20170222143317 DropCiProjects: migrated (0.0025s) ==========================

== 20170222143500 RemoveOldProjectIdColumns: migrating ========================
-- index_exists?(:ci_builds, :project_id)
   -> 0.0098s
-- remove_index(:ci_builds, :project_id)
   -> 0.0147s
-- remove_column(:ci_builds, :project_id)
   -> 0.0176s
-- remove_column(:ci_commits, :project_id)
   -> 0.0131s
-- remove_column(:ci_runner_projects, :project_id)
   -> 0.0131s
-- remove_column(:ci_triggers, :project_id)
   -> 0.0126s
-- remove_column(:ci_variables, :project_id)
   -> 0.0151s
== 20170222143500 RemoveOldProjectIdColumns: migrated (0.0967s) ===============

== 20170222143603 RenameGlProjectIdToProjectId: migrating =====================
-- rename_column(:ci_builds, :gl_project_id, :project_id)
   -> 0.0526s
-- rename_column(:ci_commits, :gl_project_id, :project_id)
   -> 0.0284s
-- rename_column(:ci_runner_projects, :gl_project_id, :project_id)
   -> 0.0059s
-- rename_column(:ci_triggers, :gl_project_id, :project_id)
   -> 0.0085s
-- rename_column(:ci_variables, :gl_project_id, :project_id)
   -> 0.0062s
== 20170222143603 RenameGlProjectIdToProjectId: migrated (0.1021s) ============

== 20170301195939 RenameCiCommitsToCiPipelines: migrating =====================
-- rename_table("ci_commits", "ci_pipelines")
   -> 0.0174s
== 20170301195939 RenameCiCommitsToCiPipelines: migrated (0.0175s) ============

== 20170301205639 RemoveUnusedCiTablesAndColumns: migrating ===================
-- drop_table("ci_application_settings")
   -> 0.0014s
-- drop_table("ci_events")
   -> 0.0015s
-- drop_table("ci_jobs")
   -> 0.0017s
-- drop_table("ci_sessions")
   -> 0.0021s
-- drop_table("ci_taggings")
   -> 0.0068s
-- drop_table("ci_tags")
   -> 0.0034s
-- remove_column(:ci_pipelines, :push_data, :text)
   -> 0.0015s
-- remove_column(:ci_builds, :job_id, :integer)
   -> 0.0010s
-- remove_column(:ci_builds, :deploy, :boolean)
   -> 0.0008s
== 20170301205639 RemoveUnusedCiTablesAndColumns: migrated (0.0207s) ==========

== 20170305203726 AddOwnerIdForeignKey: migrating =============================
-- transaction_open?()
   -> 0.0001s
-- execute("SET statement_timeout TO 0")
   -> 0.0013s
-- execute("ALTER TABLE ci_triggers\nADD CONSTRAINT fk_e8e10d1964\nFOREIGN KEY (owner_id)\nREFERENCES users (id)\nON DELETE cascade NOT VALID;\n")
   -> 0.0234s
-- execute("ALTER TABLE ci_triggers VALIDATE CONSTRAINT fk_e8e10d1964;")
   -> 0.0192s
== 20170305203726 AddOwnerIdForeignKey: migrated (0.0447s) ====================

Rollback migration to 8.17.2

== 20170305203726 AddOwnerIdForeignKey: reverting =============================
== 20170305203726 AddOwnerIdForeignKey: reverted (0.0000s) ====================

== 20170301205639 RemoveUnusedCiTablesAndColumns: reverting ===================
-- add_column(:ci_builds, :deploy, :boolean)
   -> 0.0034s
-- add_column(:ci_builds, :job_id, :integer)
   -> 0.0046s
-- add_column(:ci_pipelines, :push_data, :text)
   -> 0.0045s
-- create_table("ci_tags", {:force=>:cascade})
   -> 0.0710s
-- create_table("ci_taggings", {:force=>:cascade})
   -> 0.0660s
-- add_index("ci_taggings", ["taggable_id", "taggable_type", "context"])
   -> 0.0288s
-- create_table("ci_sessions", {:force=>:cascade})
   -> 0.0622s
-- create_table("ci_jobs", {:force=>:cascade})
   -> 0.0543s
-- create_table("ci_events", {:force=>:cascade})
   -> 0.0563s
-- create_table("ci_application_settings", {:force=>:cascade})
   -> 0.0300s
== 20170301205639 RemoveUnusedCiTablesAndColumns: reverted (0.3824s) ==========

== 20170301195939 RenameCiCommitsToCiPipelines: reverting =====================
-- rename_table("ci_pipelines", "ci_commits")
   -> 0.0134s
== 20170301195939 RenameCiCommitsToCiPipelines: reverted (0.0256s) ============

== 20170222143603 RenameGlProjectIdToProjectId: reverting =====================
-- rename_column(:ci_variables, :project_id, :gl_project_id)
   -> 0.0035s
-- rename_column(:ci_triggers, :project_id, :gl_project_id)
   -> 0.0029s
-- rename_column(:ci_runner_projects, :project_id, :gl_project_id)
   -> 0.0033s
-- rename_column(:ci_commits, :project_id, :gl_project_id)
   -> 0.0060s
-- rename_column(:ci_builds, :project_id, :gl_project_id)
   -> 0.0081s
== 20170222143603 RenameGlProjectIdToProjectId: reverted (0.0247s) ============

== 20170222143500 RemoveOldProjectIdColumns: reverting ========================
-- add_column(:ci_builds, :project_id, :integer)
   -> 0.0217s
-- add_column(:ci_commits, :project_id, :integer)
   -> 0.0142s
-- add_column(:ci_runner_projects, :project_id, :integer)
   -> 0.0197s
-- add_column(:ci_triggers, :project_id, :integer)
   -> 0.0170s
-- add_column(:ci_variables, :project_id, :integer)
   -> 0.0130s
-- transaction_open?()
   -> 0.0001s
-- execute("SET statement_timeout TO 0")
   -> 0.0037s
-- add_index(:ci_builds, :project_id, {:algorithm=>:concurrently})
   -> 0.0562s
== 20170222143500 RemoveOldProjectIdColumns: reverted (0.1474s) ===============

== 20170222143317 DropCiProjects: reverting ===================================
-- create_table("ci_projects", {:force=>:cascade})
   -> 0.0639s
== 20170222143317 DropCiProjects: reverted (0.0641s) ==========================

== 20170217151949 AddDescriptionToTriggers: reverting =========================
-- remove_column(:ci_triggers, :description, :string)
   -> 0.0008s
== 20170217151949 AddDescriptionToTriggers: reverted (0.0009s) ================

== 20170217151948 AddOwnerIdToTriggers: reverting =============================
-- remove_column(:ci_triggers, :owner_id, :integer)
   -> 0.0009s
== 20170217151948 AddOwnerIdToTriggers: reverted (0.0009s) ====================

== 20170217151947 RenameOnlyAllowMergeIfBuildSucceeds: reverting ==============
-- rename_column(:projects, :only_allow_merge_if_pipeline_succeeds, :only_allow_merge_if_build_succeeds)
   -> 0.0110s
== 20170217151947 RenameOnlyAllowMergeIfBuildSucceeds: reverted (0.0112s) =====

== 20170217132157 RenameMergeWhenBuildSucceeds: reverting =====================
-- rename_column(:merge_requests, :merge_when_pipeline_succeeds, :merge_when_build_succeeds)
   -> 0.0088s
== 20170217132157 RenameMergeWhenBuildSucceeds: reverted (0.0090s) ============

== 20170216141440 DropIndexForBuildsProjectStatus: reverting ==================
-- add_index(:ci_commits, [:gl_project_id, :status], {})
   -> 0.0375s
== 20170216141440 DropIndexForBuildsProjectStatus: reverted (0.0376s) =========

== 20170216135621 AddIndexForLatestSuccessfulPipeline: reverting ==============
-- remove_index(:ci_commits, [:gl_project_id, :ref, :status])
   -> 0.0159s
== 20170216135621 AddIndexForLatestSuccessfulPipeline: reverted (0.0159s) =====

== 20170215200045 RemoveThemeIdFromUsers: reverting ===========================
-- add_column(:users, :theme_id, :integer)
   -> 0.0014s
== 20170215200045 RemoveThemeIdFromUsers: reverted (0.0016s) ==================

== 20170214111112 DeleteDeprecatedGitlabCiService: reverting ==================
== 20170214111112 DeleteDeprecatedGitlabCiService: reverted (0.0000s) =========

== 20170214084746 AddDefaultArtifactsExpirationToApplicationSettings: reverting 
-- remove_column(:application_settings, :default_artifacts_expire_in, :string, {:null=>false, :default=>"0"})
   -> 0.0029s
== 20170214084746 AddDefaultArtifactsExpirationToApplicationSettings: reverted (0.0030s) 

== 20170211073944 DisableInvalidServiceTemplates: reverting ===================
== 20170211073944 DisableInvalidServiceTemplates: reverted (0.0000s) ==========

cc @godfat @stanhu @yorickpeterse

Merge request reports