Removing the ignored column project_pages_metadata.artifacts_archive_id
What does this MR do and why?
This is step 2 / 3 of removing the column: project_pages_metadata.artifacts_archive_id
Issue: #353365 (closed)
Database
Up
== 20220324110247 UntrackDeletionsOnCiJobArtifacts: migrating =================
-- execute("DROP TRIGGER IF EXISTS ci_job_artifacts_loose_fk_trigger ON ci_job_artifacts")
-> 0.0009s
== 20220324110247 UntrackDeletionsOnCiJobArtifacts: migrated (0.0009s) ========
== 20220324180717 RemoveProjectPagesMetadataArtifactsArchiveIdColumn: migrating
-- remove_column(:project_pages_metadata, :artifacts_archive_id)
-> 0.0029s
== 20220324180717 RemoveProjectPagesMetadataArtifactsArchiveIdColumn: migrated (0.0030s)
== 20220329175119 RemoveLeftoverCiJobArtifactDeletions: migrating =============
-- execute("DELETE FROM \"loose_foreign_keys_deleted_records\"\nWHERE\n(\"loose_foreign_keys_deleted_records\".\"partition\", \"loose_foreign_keys_deleted_records\".\"id\") IN (\n SELECT \"loose_foreign_keys_deleted_records\".\"partition\", \"loose_foreign_keys_deleted_records\".\"id\"\n FROM \"loose_foreign_keys_deleted_records\"\n WHERE\n \"loose_foreign_keys_deleted_records\".\"fully_qualified_table_name\" = 'public.ci_job_artifacts' AND\n \"loose_foreign_keys_deleted_records\".\"status\" = 1\n LIMIT 100\n)\n")
-> 0.0013s
== 20220329175119 RemoveLeftoverCiJobArtifactDeletions: migrated (0.0013s) ====
Down
bin/rails db:migrate:down VERSION=20220329175119
== 20220329175119 RemoveLeftoverCiJobArtifactDeletions: reverting =============
== 20220329175119 RemoveLeftoverCiJobArtifactDeletions: reverted (0.0000s) ====
bin/rails db:migrate:down VERSION=20220324180717
== 20220324180717 RemoveProjectPagesMetadataArtifactsArchiveIdColumn: reverting
-- column_exists?(:project_pages_metadata, :artifacts_archive_id)
-> 0.0005s
-- add_column(:project_pages_metadata, :artifacts_archive_id, :bigint)
-> 0.0009s
-- transaction_open?()
-> 0.0000s
-- index_exists?(:project_pages_metadata, :artifacts_archive_id, {:name=>"index_project_pages_metadata_on_artifacts_archive_id", :algorithm=>:concurrently})
-> 0.0011s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- add_index(:project_pages_metadata, :artifacts_archive_id, {:name=>"index_project_pages_metadata_on_artifacts_archive_id", :algorithm=>:concurrently})
-> 0.0013s
-- execute("RESET statement_timeout")
-> 0.0002s
== 20220324180717 RemoveProjectPagesMetadataArtifactsArchiveIdColumn: reverted (0.0080s)
bin/rails db:migrate:down VERSION=20220324110247
== 20220324110247 UntrackDeletionsOnCiJobArtifacts: reverting =================
-- execute("CREATE TRIGGER ci_job_artifacts_loose_fk_trigger\nAFTER DELETE ON ci_job_artifacts REFERENCING OLD TABLE AS old_table\nFOR EACH STATEMENT\nEXECUTE FUNCTION insert_into_loose_foreign_keys_deleted_records();\n")
-> 0.0007s
== 20220324110247 UntrackDeletionsOnCiJobArtifacts: reverted (0.0007s) ========
MR acceptance checklist
This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.
-
I have evaluated the MR acceptance checklist for this MR.
Edited by Omar Qunsul