Skip to content

Drop tables related to elastic stack integration stack applications

Rajendra Kadam requested to merge 360196-clean-db-cluster-apps into master

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.

Related to #360196 (closed)

Edited by Mayra Cabrera

Merge request reports