Add sharding key to slack_integrations_scopes
What does this MR do and why?
Adding sharding key to:
- slack_integrations_scopes
- slack_api_scopes
Adding to both tables at the same time as the code
that sets the sharding key for slack_api_scopes
is closely linked to slack_integrations_scopes.
We are doing some migration work in regular migrations for the slack_api_scopes table, but this should be fine (and required) because in .com and any self-hosted instance, this table will contain a maximum of 3 records. Using a regular migration because the new version of the code could in theory already try to insert a record with the same name in a different organization
Query plans
Only 3 records exist in slack_api_scopes
https://console.postgres.ai/gitlab/gitlab-production-main/sessions/46306/commands/141374
Find by organization and name
https://console.postgres.ai/gitlab/gitlab-production-main/sessions/46306/commands/141373
SELECT * FROM "slack_api_scopes" WHERE "organization_id" = 1 AND "name" IN ('commands')Migration output
UP
main: == [advisory_lock_connection] object_id: 131060, pg_backend_pid: 71608
main: == 20251201213020 AddShardingKeyToSlackIntegrationsScopes: migrating ==========
main: -- add_column(:slack_integrations_scopes, :project_id, :bigint)
main: -> 0.0310s
main: -- add_column(:slack_integrations_scopes, :group_id, :bigint)
main: -> 0.0016s
main: -- add_column(:slack_integrations_scopes, :organization_id, :bigint)
main: -> 0.0012s
main: == 20251201213020 AddShardingKeyToSlackIntegrationsScopes: migrated (0.0568s) =
main: == [advisory_lock_connection] object_id: 131060, pg_backend_pid: 71608
ci: == [advisory_lock_connection] object_id: 131060, pg_backend_pid: 71609
ci: == 20251201213020 AddShardingKeyToSlackIntegrationsScopes: migrating ==========
ci: -- add_column(:slack_integrations_scopes, :project_id, :bigint)
ci: -> 0.0019s
ci: -- add_column(:slack_integrations_scopes, :group_id, :bigint)
ci: -> 0.0011s
ci: -- add_column(:slack_integrations_scopes, :organization_id, :bigint)
ci: -> 0.0010s
ci: == 20251201213020 AddShardingKeyToSlackIntegrationsScopes: migrated (0.0116s) =
ci: == [advisory_lock_connection] object_id: 131060, pg_backend_pid: 71609
main: == [advisory_lock_connection] object_id: 131060, pg_backend_pid: 71611
main: == 20251202185247 AddOrganizationIdToSlackApiScopes: migrating ================
main: -- add_column(:slack_api_scopes, :organization_id, :bigint, {:null=>false, :default=>1})
main: -> 0.0039s
main: == 20251202185247 AddOrganizationIdToSlackApiScopes: migrated (0.0314s) =======
main: == [advisory_lock_connection] object_id: 131060, pg_backend_pid: 71611
ci: == [advisory_lock_connection] object_id: 131060, pg_backend_pid: 71612
ci: == 20251202185247 AddOrganizationIdToSlackApiScopes: migrating ================
ci: -- add_column(:slack_api_scopes, :organization_id, :bigint, {:null=>false, :default=>1})
ci: -> 0.0072s
ci: == 20251202185247 AddOrganizationIdToSlackApiScopes: migrated (0.0275s) =======
ci: == [advisory_lock_connection] object_id: 131060, pg_backend_pid: 71612
main: == [advisory_lock_connection] object_id: 131060, pg_backend_pid: 71614
main: == 20251201215436 AddIndexesToSlackIntegrationsScopesShardingKey: migrating ===
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- view_exists?(:postgres_partitions)
main: -> 0.0010s
main: -- index_exists?(:slack_integrations_scopes, :project_id, {:if_not_exists=>true, :name=>"index_slack_integrations_scopes_on_project_id", :algorithm=>:concurrently})
main: -> 0.0050s
main: -- execute("SET statement_timeout TO 0")
main: -> 0.0004s
main: -- add_index(:slack_integrations_scopes, :project_id, {:if_not_exists=>true, :name=>"index_slack_integrations_scopes_on_project_id", :algorithm=>:concurrently})
main: -> 0.0059s
main: -- execute("RESET statement_timeout")
main: -> 0.0004s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- view_exists?(:postgres_partitions)
main: -> 0.0005s
main: -- index_exists?(:slack_integrations_scopes, :group_id, {:if_not_exists=>true, :name=>"index_slack_integrations_scopes_on_group_id", :algorithm=>:concurrently})
main: -> 0.0018s
main: -- add_index(:slack_integrations_scopes, :group_id, {:if_not_exists=>true, :name=>"index_slack_integrations_scopes_on_group_id", :algorithm=>:concurrently})
main: -> 0.0031s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- view_exists?(:postgres_partitions)
main: -> 0.0005s
main: -- index_exists?(:slack_integrations_scopes, :organization_id, {:if_not_exists=>true, :name=>"index_slack_integrations_scopes_on_organization_id", :algorithm=>:concurrently})
main: -> 0.0015s
main: -- add_index(:slack_integrations_scopes, :organization_id, {:if_not_exists=>true, :name=>"index_slack_integrations_scopes_on_organization_id", :algorithm=>:concurrently})
main: -> 0.0015s
main: == 20251201215436 AddIndexesToSlackIntegrationsScopesShardingKey: migrated (0.0839s)
main: == [advisory_lock_connection] object_id: 131060, pg_backend_pid: 71614
ci: == [advisory_lock_connection] object_id: 131060, pg_backend_pid: 71615
ci: == 20251201215436 AddIndexesToSlackIntegrationsScopesShardingKey: migrating ===
ci: -- transaction_open?(nil)
ci: -> 0.0000s
ci: -- view_exists?(:postgres_partitions)
ci: -> 0.0006s
ci: -- index_exists?(:slack_integrations_scopes, :project_id, {:if_not_exists=>true, :name=>"index_slack_integrations_scopes_on_project_id", :algorithm=>:concurrently})
ci: -> 0.0072s
ci: -- execute("SET statement_timeout TO 0")
ci: -> 0.0006s
ci: -- add_index(:slack_integrations_scopes, :project_id, {:if_not_exists=>true, :name=>"index_slack_integrations_scopes_on_project_id", :algorithm=>:concurrently})
ci: -> 0.0050s
ci: -- execute("RESET statement_timeout")
ci: -> 0.0004s
ci: -- transaction_open?(nil)
ci: -> 0.0000s
ci: -- view_exists?(:postgres_partitions)
ci: -> 0.0005s
ci: -- index_exists?(:slack_integrations_scopes, :group_id, {:if_not_exists=>true, :name=>"index_slack_integrations_scopes_on_group_id", :algorithm=>:concurrently})
ci: -> 0.0022s
ci: -- add_index(:slack_integrations_scopes, :group_id, {:if_not_exists=>true, :name=>"index_slack_integrations_scopes_on_group_id", :algorithm=>:concurrently})
ci: -> 0.0029s
ci: -- transaction_open?(nil)
ci: -> 0.0000s
ci: -- view_exists?(:postgres_partitions)
ci: -> 0.0004s
ci: -- index_exists?(:slack_integrations_scopes, :organization_id, {:if_not_exists=>true, :name=>"index_slack_integrations_scopes_on_organization_id", :algorithm=>:concurrently})
ci: -> 0.0018s
ci: -- add_index(:slack_integrations_scopes, :organization_id, {:if_not_exists=>true, :name=>"index_slack_integrations_scopes_on_organization_id", :algorithm=>:concurrently})
ci: -> 0.0017s
ci: == 20251201215436 AddIndexesToSlackIntegrationsScopesShardingKey: migrated (0.0873s)
main: == [advisory_lock_connection] object_id: 131060, pg_backend_pid: 73707
main: == 20251201215440 AddForeignKeysToSlackIntegrationScopesShardingKey: migrating
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- execute("ALTER TABLE slack_integrations_scopes ADD CONSTRAINT fk_b7bd6dc444 FOREIGN KEY (project_id) REFERENCES projects (id) ON DELETE CASCADE NOT VALID;")
main: -> 0.0029s
main: -- execute("SET statement_timeout TO 0")
main: -> 0.0004s
main: -- execute("ALTER TABLE slack_integrations_scopes VALIDATE CONSTRAINT fk_b7bd6dc444;")
main: -> 0.0127s
main: -- execute("RESET statement_timeout")
main: -> 0.0006s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- execute("ALTER TABLE slack_integrations_scopes ADD CONSTRAINT fk_b2353bd86b FOREIGN KEY (group_id) REFERENCES namespaces (id) ON DELETE CASCADE NOT VALID;")
main: -> 0.0015s
main: -- execute("ALTER TABLE slack_integrations_scopes VALIDATE CONSTRAINT fk_b2353bd86b;")
main: -> 0.0066s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- execute("ALTER TABLE slack_integrations_scopes ADD CONSTRAINT fk_67e0ce7a40 FOREIGN KEY (organization_id) REFERENCES organizations (id) ON DELETE CASCADE NOT VALID;")
main: -> 0.0009s
main: -- execute("ALTER TABLE slack_integrations_scopes VALIDATE CONSTRAINT fk_67e0ce7a40;")
main: -> 0.0018s
main: == 20251201215440 AddForeignKeysToSlackIntegrationScopesShardingKey: migrated (0.1297s)
main: == [advisory_lock_connection] object_id: 131060, pg_backend_pid: 73707
ci: == [advisory_lock_connection] object_id: 131060, pg_backend_pid: 73708
ci: == 20251201215440 AddForeignKeysToSlackIntegrationScopesShardingKey: migrating
ci: -- transaction_open?(nil)
ci: -> 0.0000s
ci: -- transaction_open?(nil)
ci: -> 0.0000s
ci: -- execute("ALTER TABLE slack_integrations_scopes ADD CONSTRAINT fk_b7bd6dc444 FOREIGN KEY (project_id) REFERENCES projects (id) ON DELETE CASCADE NOT VALID;")
ci: -> 0.0026s
ci: -- execute("SET statement_timeout TO 0")
ci: -> 0.0003s
ci: -- execute("ALTER TABLE slack_integrations_scopes VALIDATE CONSTRAINT fk_b7bd6dc444;")
ci: -> 0.0208s
ci: -- execute("RESET statement_timeout")
ci: -> 0.0005s
ci: -- transaction_open?(nil)
ci: -> 0.0000s
ci: -- transaction_open?(nil)
ci: -> 0.0000s
ci: -- execute("ALTER TABLE slack_integrations_scopes ADD CONSTRAINT fk_b2353bd86b FOREIGN KEY (group_id) REFERENCES namespaces (id) ON DELETE CASCADE NOT VALID;")
ci: -> 0.0015s
ci: -- execute("ALTER TABLE slack_integrations_scopes VALIDATE CONSTRAINT fk_b2353bd86b;")
ci: -> 0.0063s
ci: -- transaction_open?(nil)
ci: -> 0.0000s
ci: -- transaction_open?(nil)
ci: -> 0.0000s
ci: -- execute("ALTER TABLE slack_integrations_scopes ADD CONSTRAINT fk_67e0ce7a40 FOREIGN KEY (organization_id) REFERENCES organizations (id) ON DELETE CASCADE NOT VALID;")
ci: -> 0.0011s
ci: -- execute("ALTER TABLE slack_integrations_scopes VALIDATE CONSTRAINT fk_67e0ce7a40;")
ci: -> 0.0015s
ci: == 20251201215440 AddForeignKeysToSlackIntegrationScopesShardingKey: migrated (0.0962s)
ci: == [advisory_lock_connection] object_id: 131060, pg_backend_pid: 73708
ci: == [advisory_lock_connection] object_id: 131060, pg_backend_pid: 71615
main: == [advisory_lock_connection] object_id: 131060, pg_backend_pid: 71619
main: == 20251202185810 AddSlackApiScopesOrganizationIdIndex: migrating =============
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- view_exists?(:postgres_partitions)
main: -> 0.0008s
main: -- index_exists?(:slack_api_scopes, :organization_id, {:if_not_exists=>true, :name=>"index_slack_api_scopes_on_organization_id", :algorithm=>:concurrently})
main: -> 0.0042s
main: -- execute("SET statement_timeout TO 0")
main: -> 0.0004s
main: -- add_index(:slack_api_scopes, :organization_id, {:if_not_exists=>true, :name=>"index_slack_api_scopes_on_organization_id", :algorithm=>:concurrently})
main: -> 0.0050s
main: -- execute("RESET statement_timeout")
main: -> 0.0004s
main: == 20251202185810 AddSlackApiScopesOrganizationIdIndex: migrated (0.0394s) ====
main: == [advisory_lock_connection] object_id: 131060, pg_backend_pid: 71619
ci: == [advisory_lock_connection] object_id: 131060, pg_backend_pid: 71620
ci: == 20251202185810 AddSlackApiScopesOrganizationIdIndex: migrating =============
ci: -- transaction_open?(nil)
ci: -> 0.0000s
ci: -- view_exists?(:postgres_partitions)
ci: -> 0.0006s
ci: -- index_exists?(:slack_api_scopes, :organization_id, {:if_not_exists=>true, :name=>"index_slack_api_scopes_on_organization_id", :algorithm=>:concurrently})
ci: -> 0.0052s
ci: -- execute("SET statement_timeout TO 0")
ci: -> 0.0004s
ci: -- add_index(:slack_api_scopes, :organization_id, {:if_not_exists=>true, :name=>"index_slack_api_scopes_on_organization_id", :algorithm=>:concurrently})
ci: -> 0.0037s
ci: -- execute("RESET statement_timeout")
ci: -> 0.0029s
ci: == 20251202185810 AddSlackApiScopesOrganizationIdIndex: migrated (0.0504s) ====
ci: == [advisory_lock_connection] object_id: 131060, pg_backend_pid: 71620
main: == [advisory_lock_connection] object_id: 131060, pg_backend_pid: 71622
main: == 20251202185819 AddSlackApiScopesOrganizationIdForeignKey: migrating ========
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- execute("ALTER TABLE slack_api_scopes ADD CONSTRAINT fk_eee7de10f6 FOREIGN KEY (organization_id) REFERENCES organizations (id) ON DELETE CASCADE NOT VALID;")
main: -> 0.0034s
main: -- execute("SET statement_timeout TO 0")
main: -> 0.0031s
main: -- execute("ALTER TABLE slack_api_scopes VALIDATE CONSTRAINT fk_eee7de10f6;")
main: -> 0.0052s
main: -- execute("RESET statement_timeout")
main: -> 0.0005s
main: == 20251202185819 AddSlackApiScopesOrganizationIdForeignKey: migrated (0.0642s)
main: == [advisory_lock_connection] object_id: 131060, pg_backend_pid: 71622
ci: == [advisory_lock_connection] object_id: 131060, pg_backend_pid: 71623
ci: == 20251202185819 AddSlackApiScopesOrganizationIdForeignKey: migrating ========
ci: -- transaction_open?(nil)
ci: -> 0.0000s
ci: -- transaction_open?(nil)
ci: -> 0.0000s
ci: -- execute("ALTER TABLE slack_api_scopes ADD CONSTRAINT fk_eee7de10f6 FOREIGN KEY (organization_id) REFERENCES organizations (id) ON DELETE CASCADE NOT VALID;")
ci: -> 0.0041s
ci: -- execute("SET statement_timeout TO 0")
ci: -> 0.0004s
ci: -- execute("ALTER TABLE slack_api_scopes VALIDATE CONSTRAINT fk_eee7de10f6;")
ci: -> 0.0052s
ci: -- execute("RESET statement_timeout")
ci: -> 0.0004s
ci: == 20251202185819 AddSlackApiScopesOrganizationIdForeignKey: migrated (0.0620s)
ci: == [advisory_lock_connection] object_id: 131060, pg_backend_pid: 71623
main: == [advisory_lock_connection] object_id: 131060, pg_backend_pid: 71625
main: == 20251202190736 RemoveDefaultFromSlackApiScopesOrganizationId: migrating ====
main: -- change_column_default(:slack_api_scopes, :organization_id, {:from=>1, :to=>nil})
main: -> 0.0043s
main: == 20251202190736 RemoveDefaultFromSlackApiScopesOrganizationId: migrated (0.0128s)
main: == [advisory_lock_connection] object_id: 131060, pg_backend_pid: 71625
ci: == [advisory_lock_connection] object_id: 131060, pg_backend_pid: 71626
ci: == 20251202190736 RemoveDefaultFromSlackApiScopesOrganizationId: migrating ====
ci: -- change_column_default(:slack_api_scopes, :organization_id, {:from=>1, :to=>nil})
ci: -> 0.0048s
ci: == 20251202190736 RemoveDefaultFromSlackApiScopesOrganizationId: migrated (0.0135s)
ci: == [advisory_lock_connection] object_id: 131060, pg_backend_pid: 71626DOWN
main: == [advisory_lock_connection] object_id: 130580, pg_backend_pid: 70591
main: == 20251202190736 RemoveDefaultFromSlackApiScopesOrganizationId: reverting ====
main: -- change_column_default(:slack_api_scopes, :organization_id, {:from=>nil, :to=>1})
main: -> 0.0408s
main: == 20251202190736 RemoveDefaultFromSlackApiScopesOrganizationId: reverted (0.0710s)
main: == 20251202185819 AddSlackApiScopesOrganizationIdForeignKey: reverting ========
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- remove_foreign_key(:slack_api_scopes, {:column=>:organization_id})
main: -> 0.0028s
main: == 20251202185819 AddSlackApiScopesOrganizationIdForeignKey: reverted (0.0495s)
main: == 20251202185810 AddSlackApiScopesOrganizationIdIndex: reverting =============
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- view_exists?(:postgres_partitions)
main: -> 0.0003s
main: -- index_exists?(:slack_api_scopes, :organization_id, {:if_exists=>true, :name=>"index_slack_api_scopes_on_organization_id", :algorithm=>:concurrently})
main: -> 0.0019s
main: -- execute("SET statement_timeout TO 0")
main: -> 0.0003s
main: -- remove_index(:slack_api_scopes, {:if_exists=>true, :name=>"index_slack_api_scopes_on_organization_id", :algorithm=>:concurrently, :column=>:organization_id})
main: -> 0.0049s
main: -- execute("RESET statement_timeout")
main: -> 0.0003s
main: == 20251202185810 AddSlackApiScopesOrganizationIdIndex: reverted (0.0253s) ====
main: == [advisory_lock_connection] object_id: 130580, pg_backend_pid: 74349
main: == 20251201215440 AddForeignKeysToSlackIntegrationScopesShardingKey: reverting
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- remove_foreign_key(:slack_integrations_scopes, {:column=>:project_id})
main: -> 0.0027s
main: -- remove_foreign_key(:slack_integrations_scopes, {:column=>:group_id})
main: -> 0.0025s
main: -- remove_foreign_key(:slack_integrations_scopes, {:column=>:organization_id})
main: -> 0.0021s
main: == 20251201215440 AddForeignKeysToSlackIntegrationScopesShardingKey: reverted (0.0943s)
main: == [advisory_lock_connection] object_id: 130580, pg_backend_pid: 74349
main: == 20251201215436 AddIndexesToSlackIntegrationsScopesShardingKey: reverting ===
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- view_exists?(:postgres_partitions)
main: -> 0.0003s
main: -- index_exists?(:slack_integrations_scopes, :project_id, {:if_exists=>true, :name=>"index_slack_integrations_scopes_on_project_id", :algorithm=>:concurrently})
main: -> 0.0022s
main: -- remove_index(:slack_integrations_scopes, {:if_exists=>true, :name=>"index_slack_integrations_scopes_on_project_id", :algorithm=>:concurrently, :column=>:project_id})
main: -> 0.0051s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- view_exists?(:postgres_partitions)
main: -> 0.0003s
main: -- index_exists?(:slack_integrations_scopes, :group_id, {:if_exists=>true, :name=>"index_slack_integrations_scopes_on_group_id", :algorithm=>:concurrently})
main: -> 0.0014s
main: -- remove_index(:slack_integrations_scopes, {:if_exists=>true, :name=>"index_slack_integrations_scopes_on_group_id", :algorithm=>:concurrently, :column=>:group_id})
main: -> 0.0047s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- view_exists?(:postgres_partitions)
main: -> 0.0003s
main: -- index_exists?(:slack_integrations_scopes, :organization_id, {:if_exists=>true, :name=>"index_slack_integrations_scopes_on_organization_id", :algorithm=>:concurrently})
main: -> 0.0014s
main: -- remove_index(:slack_integrations_scopes, {:if_exists=>true, :name=>"index_slack_integrations_scopes_on_organization_id", :algorithm=>:concurrently, :column=>:organization_id})
main: -> 0.0039s
main: == 20251201215436 AddIndexesToSlackIntegrationsScopesShardingKey: reverted (0.0409s)
main: == [advisory_lock_connection] object_id: 130580, pg_backend_pid: 70591
ci: == [advisory_lock_connection] object_id: 130580, pg_backend_pid: 70614
ci: == 20251202190736 RemoveDefaultFromSlackApiScopesOrganizationId: reverting ====
ci: -- change_column_default(:slack_api_scopes, :organization_id, {:from=>nil, :to=>1})
ci: -> 0.0053s
ci: == 20251202190736 RemoveDefaultFromSlackApiScopesOrganizationId: reverted (0.0227s)
ci: == 20251202185819 AddSlackApiScopesOrganizationIdForeignKey: reverting ========
ci: -- transaction_open?(nil)
ci: -> 0.0000s
ci: -- remove_foreign_key(:slack_api_scopes, {:column=>:organization_id})
ci: -> 0.0031s
ci: == 20251202185819 AddSlackApiScopesOrganizationIdForeignKey: reverted (0.0377s)
ci: == 20251202185810 AddSlackApiScopesOrganizationIdIndex: reverting =============
ci: -- transaction_open?(nil)
ci: -> 0.0000s
ci: -- view_exists?(:postgres_partitions)
ci: -> 0.0007s
ci: -- index_exists?(:slack_api_scopes, :organization_id, {:if_exists=>true, :name=>"index_slack_api_scopes_on_organization_id", :algorithm=>:concurrently})
ci: -> 0.0019s
ci: -- execute("SET statement_timeout TO 0")
ci: -> 0.0003s
ci: -- remove_index(:slack_api_scopes, {:if_exists=>true, :name=>"index_slack_api_scopes_on_organization_id", :algorithm=>:concurrently, :column=>:organization_id})
ci: -> 0.0053s
ci: -- execute("RESET statement_timeout")
ci: -> 0.0003s
ci: == 20251202185810 AddSlackApiScopesOrganizationIdIndex: reverted (0.0244s) ====
ci: == [advisory_lock_connection] object_id: 130580, pg_backend_pid: 74371
ci: == 20251201215440 AddForeignKeysToSlackIntegrationScopesShardingKey: reverting
ci: -- transaction_open?(nil)
ci: -> 0.0000s
ci: -- remove_foreign_key(:slack_integrations_scopes, {:column=>:project_id})
ci: -> 0.0076s
ci: -- remove_foreign_key(:slack_integrations_scopes, {:column=>:group_id})
ci: -> 0.0051s
ci: -- remove_foreign_key(:slack_integrations_scopes, {:column=>:organization_id})
ci: -> 0.0038s
ci: == 20251201215440 AddForeignKeysToSlackIntegrationScopesShardingKey: reverted (0.0660s)
ci: == [advisory_lock_connection] object_id: 130580, pg_backend_pid: 74371
ci: == 20251201215436 AddIndexesToSlackIntegrationsScopesShardingKey: reverting ===
ci: -- transaction_open?(nil)
ci: -> 0.0000s
ci: -- view_exists?(:postgres_partitions)
ci: -> 0.0005s
ci: -- index_exists?(:slack_integrations_scopes, :project_id, {:if_exists=>true, :name=>"index_slack_integrations_scopes_on_project_id", :algorithm=>:concurrently})
ci: -> 0.0024s
ci: -- remove_index(:slack_integrations_scopes, {:if_exists=>true, :name=>"index_slack_integrations_scopes_on_project_id", :algorithm=>:concurrently, :column=>:project_id})
ci: -> 0.0050s
ci: -- transaction_open?(nil)
ci: -> 0.0000s
ci: -- view_exists?(:postgres_partitions)
ci: -> 0.0003s
ci: -- index_exists?(:slack_integrations_scopes, :group_id, {:if_exists=>true, :name=>"index_slack_integrations_scopes_on_group_id", :algorithm=>:concurrently})
ci: -> 0.0017s
ci: -- remove_index(:slack_integrations_scopes, {:if_exists=>true, :name=>"index_slack_integrations_scopes_on_group_id", :algorithm=>:concurrently, :column=>:group_id})
ci: -> 0.0111s
ci: -- transaction_open?(nil)
ci: -> 0.0000s
ci: -- view_exists?(:postgres_partitions)
ci: -> 0.0003s
ci: -- index_exists?(:slack_integrations_scopes, :organization_id, {:if_exists=>true, :name=>"index_slack_integrations_scopes_on_organization_id", :algorithm=>:concurrently})
ci: -> 0.0015s
ci: -- remove_index(:slack_integrations_scopes, {:if_exists=>true, :name=>"index_slack_integrations_scopes_on_organization_id", :algorithm=>:concurrently, :column=>:organization_id})
ci: -> 0.0042s
ci: == 20251201215436 AddIndexesToSlackIntegrationsScopesShardingKey: reverted (0.0535s)
ci: == [advisory_lock_connection] object_id: 130580, pg_backend_pid: 70614
main: == [advisory_lock_connection] object_id: 130580, pg_backend_pid: 70948
main: == 20251202185247 AddOrganizationIdToSlackApiScopes: reverting ================
main: -- remove_column(:slack_api_scopes, :organization_id, :bigint, {:null=>false, :default=>1})
main: -> 0.0384s
main: == 20251202185247 AddOrganizationIdToSlackApiScopes: reverted (0.0732s) =======
main: == [advisory_lock_connection] object_id: 130580, pg_backend_pid: 70948
ci: == [advisory_lock_connection] object_id: 130580, pg_backend_pid: 70973
ci: == 20251202185247 AddOrganizationIdToSlackApiScopes: reverting ================
ci: -- remove_column(:slack_api_scopes, :organization_id, :bigint, {:null=>false, :default=>1})
ci: -> 0.0021s
ci: == 20251202185247 AddOrganizationIdToSlackApiScopes: reverted (0.0114s) =======
ci: == [advisory_lock_connection] object_id: 130580, pg_backend_pid: 70973
main: == [advisory_lock_connection] object_id: 130580, pg_backend_pid: 71223
main: == 20251201213020 AddShardingKeyToSlackIntegrationsScopes: reverting ==========
main: -- remove_column(:slack_integrations_scopes, :organization_id, :bigint)
main: -> 0.0379s
main: -- remove_column(:slack_integrations_scopes, :group_id, :bigint)
main: -> 0.0023s
main: -- remove_column(:slack_integrations_scopes, :project_id, :bigint)
main: -> 0.0017s
main: == 20251201213020 AddShardingKeyToSlackIntegrationsScopes: reverted (0.0766s) =
main: == [advisory_lock_connection] object_id: 130580, pg_backend_pid: 71223
ci: == [advisory_lock_connection] object_id: 130580, pg_backend_pid: 71244
ci: == 20251201213020 AddShardingKeyToSlackIntegrationsScopes: reverting ==========
ci: -- remove_column(:slack_integrations_scopes, :organization_id, :bigint)
ci: -> 0.0029s
ci: -- remove_column(:slack_integrations_scopes, :group_id, :bigint)
ci: -> 0.0038s
ci: -- remove_column(:slack_integrations_scopes, :project_id, :bigint)
ci: -> 0.0016s
ci: == 20251201213020 AddShardingKeyToSlackIntegrationsScopes: reverted (0.0250s) =
ci: == [advisory_lock_connection] object_id: 130580, pg_backend_pid: 71244Edited by Mario Celi