All CI offline migrations
What does this MR do?
This MR merges all CI migrations to aid merge and makes sure that they are reversible:
- https://gitlab.com/gitlab-org/gitlab-ce/merge_requests/9639
- https://gitlab.com/gitlab-org/gitlab-ce/merge_requests/9638
- https://gitlab.com/gitlab-org/gitlab-ce/merge_requests/9378
- https://gitlab.com/gitlab-org/gitlab-ce/merge_requests/8196
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) ==========