Drop tables related to elastic stack integration stack applications
What does this MR do and why?
Drops tables mentioned in #360196 (closed)
Drops foreign keys for those tables
Removes occurrences in ymls for files removed related to Elastic Stack
Migrations
UP
main: == 20220706065245 RemoveForeignKeyInClustersApplicationsElasticStacks: migrating
main: -- transaction_open?()
main: -> 0.0000s
main: -- foreign_keys(:clusters_applications_elastic_stacks)
main: -> 0.0055s
main: -- remove_foreign_key(:clusters_applications_elastic_stacks, {:column=>:cluster_id})
main: -> 0.0064s
main: == 20220706065245 RemoveForeignKeyInClustersApplicationsElasticStacks: migrated (0.0249s)
main: == 20220706065611 RemoveForeignKeyInClustersIntegrationElasticstack: migrating
main: -- transaction_open?()
main: -> 0.0000s
main: -- foreign_keys(:clusters_integration_elasticstack)
main: -> 0.0035s
main: -- remove_foreign_key(:clusters_integration_elasticstack, {:column=>:cluster_id})
main: -> 0.0048s
main: == 20220706065611 RemoveForeignKeyInClustersIntegrationElasticstack: migrated (0.0123s)
main: == 20220706070804 DropClustersApplicationsElasticStacksTable: migrating =======
main: -- drop_table(:clusters_applications_elastic_stacks)
main: -> 0.0035s
main: == 20220706070804 DropClustersApplicationsElasticStacksTable: migrated (0.0036s)
main: == 20220706071304 DropClustersIntegrationElasticstackTable: migrating =========
main: -- transaction_open?()
main: -> 0.0000s
main: -- indexes(:clusters_integration_elasticstack)
main: -> 0.0051s
main: -- execute("SET statement_timeout TO 0")
main: -> 0.0007s
main: -- remove_index(:clusters_integration_elasticstack, {:algorithm=>:concurrently, :name=>"index_clusters_integration_elasticstack_enabled"})
main: -> 0.0024s
main: -- execute("RESET statement_timeout")
main: -> 0.0008s
main: -- drop_table(:clusters_integration_elasticstack)
main: -> 0.0029s
main: == 20220706071304 DropClustersIntegrationElasticstackTable: migrated (0.0231s)
DOWN
main: == 20220706071304 DropClustersIntegrationElasticstackTable: reverting =========
main: -- create_table(:clusters_integration_elasticstack, {:id=>false})
main: -- quote_column_name(:chart_version)
main: -> 0.0000s
main: -> 0.0304s
main: -- transaction_open?()
main: -> 0.0000s
main: -- index_exists?(:clusters_integration_elasticstack, [:enabled, :created_at, :cluster_id], {:name=>"index_clusters_integration_elasticstack_enabled", :algorithm=>:concurrently})
main: -> 0.0095s
main: -- execute("SET statement_timeout TO 0")
main: -> 0.0005s
main: -- add_index(:clusters_integration_elasticstack, [:enabled, :created_at, :cluster_id], {:name=>"index_clusters_integration_elasticstack_enabled", :algorithm=>:concurrently})
main: -> 0.0027s
main: -- execute("RESET statement_timeout")
main: -> 0.0005s
main: == 20220706071304 DropClustersIntegrationElasticstackTable: reverted (0.0557s)
main: == 20220706070804 DropClustersApplicationsElasticStacksTable: reverting =======
main: -- create_table(:clusters_applications_elastic_stacks, {})
main: -> 0.0192s
main: == 20220706070804 DropClustersApplicationsElasticStacksTable: reverted (0.0207s)
main: == 20220706065611 RemoveForeignKeyInClustersIntegrationElasticstack: reverting
main: -- transaction_open?()
main: -> 0.0000s
main: -- foreign_keys(:clusters_integration_elasticstack)
main: -> 0.0156s
main: -- transaction_open?()
main: -> 0.0000s
main: -- execute("ALTER TABLE clusters_integration_elasticstack\nADD CONSTRAINT fk_rails_cc5ba8f658\nFOREIGN KEY (cluster_id)\nREFERENCES clusters (id)\nON DELETE CASCADE\nNOT VALID;\n")
main: -> 0.0076s
main: -- execute("SET statement_timeout TO 0")
main: -> 0.0008s
main: -- execute("ALTER TABLE clusters_integration_elasticstack VALIDATE CONSTRAINT fk_rails_cc5ba8f658;")
main: -> 0.0064s
main: -- execute("RESET statement_timeout")
main: -> 0.0007s
main: == 20220706065611 RemoveForeignKeyInClustersIntegrationElasticstack: reverted (0.0480s)
main: == 20220706065245 RemoveForeignKeyInClustersApplicationsElasticStacks: reverting
main: -- transaction_open?()
main: -> 0.0000s
main: -- foreign_keys(:clusters_applications_elastic_stacks)
main: -> 0.0078s
main: -- transaction_open?()
main: -> 0.0000s
main: -- execute("ALTER TABLE clusters_applications_elastic_stacks\nADD CONSTRAINT fk_rails_026f219f46\nFOREIGN KEY (cluster_id)\nREFERENCES clusters (id)\nON DELETE CASCADE\nNOT VALID;\n")
main: -> 0.0031s
main: -- execute("SET statement_timeout TO 0")
main: -> 0.0008s
main: -- execute("ALTER TABLE clusters_applications_elastic_stacks VALIDATE CONSTRAINT fk_rails_026f219f46;")
main: -> 0.0030s
main: -- execute("RESET statement_timeout")
main: -> 0.0007s
main: == 20220706065245 RemoveForeignKeyInClustersApplicationsElasticStacks: reverted (0.0310s)
How to set up and validate locally
Numbered steps to set up and validate the change are strongly suggested.
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.
Related to #360196 (closed)
Edited by Mayra Cabrera