Drop the virtual_registries_packages_maven_cache_local_entries table

David Fernandezrequested to merge
583722-drop-old-table into master

🗡️ Context

In the maven virtual registry, we do have a cache system.

While working on the local upstreams support, we created a new table in the cache tables for local cache entries.

That table followed the same structure of its "sibling" table, the remote cache entries:

  • it is a partitioned table.
  • it has a composite primary key.

For coherence between the two tables, we followed the same partition scheme: hash partitioning on relative_path.

On remote cache entries, we opened a discussion in #582681 about modifying the partition configuration to better handle the challenges there. We came to the conclusion that:

  • the partition key needs to be moved from relative_path to group_id.

Again, for coherence between the two tables, the local cache entries table should follow the same partitioning.

Changing the partitioning on an existing table is not really doable so we're going to leverage the fact that the local upstream support is still a work in progress feature which means that the local cache entries table is not used (yet). We have some code that could read the records from the parent object but since there is not code that actually create that parent object = the table is empty and there are no queries that run on it.

Thus, our re partitioning task can be split in two steps:

  1. drop the table along with the model class. This is to make sure that no code will access the table.
  2. recreate the table (same name, different partition). Re-introduce the model class.

This MR is step (1.). We followed the instructions of https://docs.gitlab.com/development/migration_style_guide/#dropping-a-database-table, case Table has foreign keys.

The entire Maven virtual registry is behind a beta feature flag that is enabled by default (eg. beta open to everyone). However, as stated above, the local cache entry table is not in use.

🤔 What does this MR do and why?

  • Drop the virtual_registries_packages_maven_cache_local_entries table
  • Removed the related model class, specs and factories.

This is part of #583722 where we're going to redo the partitioning of that table.

📚 References

🦄 Screenshots or screen recordings

No UI changes

⚙️ How to set up and validate locally

I'm not sure that there is a way to "test" a table drop MR but here some rails console commands:

top_level_group = Group.top_level.sample
upstream = ::VirtualRegistries::Packages::Maven::Upstream.create!(group: top_level_group, url: "https://gitlab.com/maven1", name: "testing local cache entries")

upstream.cache_local_entries
# => [] this is a fixed empty array

🏎️ MR acceptance checklist

Evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.

✅

💽 Database review

⬆️ Migrations up

20251211090520 
$ rails db:migrate:up:main VERSION=20251211090520 && rails db:migrate:up:ci VERSION=20251211090520
DEPRECATION WARNING: `config.active_record.warn_on_records_fetched_greater_than` is deprecated and will be removed in Rails 8.0. Please subscribe to `sql.active_record` notifications and access the row count field to detect large result set sizes. (called from <main> at /Users/david/projects/gitlab-development-kit/gitlab/config/environment.rb:7)
main: == [advisory_lock_connection] object_id: 131080, pg_backend_pid: 36811
main: == 20251211090520 DropPackageFileForeignKeyFromVirtualRegistriesPkgsMvnCacheLocalEntries: migrating 
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- remove_foreign_key(:virtual_registries_packages_maven_cache_local_entries, {:column=>:package_file_id})
main:    -> 0.0676s
main: == 20251211090520 DropPackageFileForeignKeyFromVirtualRegistriesPkgsMvnCacheLocalEntries: migrated (0.2206s) 

main: == [advisory_lock_connection] object_id: 131080, pg_backend_pid: 36811
DEPRECATION WARNING: `config.active_record.warn_on_records_fetched_greater_than` is deprecated and will be removed in Rails 8.0. Please subscribe to `sql.active_record` notifications and access the row count field to detect large result set sizes. (called from <main> at /Users/david/projects/gitlab-development-kit/gitlab/config/environment.rb:7)
ci: == [advisory_lock_connection] object_id: 131080, pg_backend_pid: 36973
ci: == 20251211090520 DropPackageFileForeignKeyFromVirtualRegistriesPkgsMvnCacheLocalEntries: migrating 
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- remove_foreign_key(:virtual_registries_packages_maven_cache_local_entries, {:column=>:package_file_id})
ci:    -> 0.0418s
ci: == 20251211090520 DropPackageFileForeignKeyFromVirtualRegistriesPkgsMvnCacheLocalEntries: migrated (0.0822s) 

ci: == [advisory_lock_connection] object_id: 131080, pg_backend_pid: 36973
20251211091519 
$ rails db:migrate:up:main VERSION=20251211091519 && rails db:migrate:up:ci VERSION=20251211091519
DEPRECATION WARNING: `config.active_record.warn_on_records_fetched_greater_than` is deprecated and will be removed in Rails 8.0. Please subscribe to `sql.active_record` notifications and access the row count field to detect large result set sizes. (called from <main> at /Users/david/projects/gitlab-development-kit/gitlab/config/environment.rb:7)
main: == [advisory_lock_connection] object_id: 131080, pg_backend_pid: 37113
main: == 20251211091519 DropUpstreamForeignKeyFromVirtualRegistriesPkgMvnCacheLocalEntries: migrating 
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- remove_foreign_key(:virtual_registries_packages_maven_cache_local_entries, {:column=>:upstream_id})
main:    -> 0.0816s
main: == 20251211091519 DropUpstreamForeignKeyFromVirtualRegistriesPkgMvnCacheLocalEntries: migrated (0.2410s) 

main: == [advisory_lock_connection] object_id: 131080, pg_backend_pid: 37113
DEPRECATION WARNING: `config.active_record.warn_on_records_fetched_greater_than` is deprecated and will be removed in Rails 8.0. Please subscribe to `sql.active_record` notifications and access the row count field to detect large result set sizes. (called from <main> at /Users/david/projects/gitlab-development-kit/gitlab/config/environment.rb:7)
ci: == [advisory_lock_connection] object_id: 131080, pg_backend_pid: 37253
ci: == 20251211091519 DropUpstreamForeignKeyFromVirtualRegistriesPkgMvnCacheLocalEntries: migrating 
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- remove_foreign_key(:virtual_registries_packages_maven_cache_local_entries, {:column=>:upstream_id})
ci:    -> 0.0375s
ci: == 20251211091519 DropUpstreamForeignKeyFromVirtualRegistriesPkgMvnCacheLocalEntries: migrated (0.0729s) 

ci: == [advisory_lock_connection] object_id: 131080, pg_backend_pid: 37253
20251211092343 
$ rails db:migrate:up:main VERSION=20251211092343 && rails db:migrate:up:ci VERSION=20251211092343
DEPRECATION WARNING: `config.active_record.warn_on_records_fetched_greater_than` is deprecated and will be removed in Rails 8.0. Please subscribe to `sql.active_record` notifications and access the row count field to detect large result set sizes. (called from <main> at /Users/david/projects/gitlab-development-kit/gitlab/config/environment.rb:7)
main: == [advisory_lock_connection] object_id: 131080, pg_backend_pid: 37400
main: == 20251211092343 DropGroupForeignKeyFromVirtualRegistriesPkgMvnCacheLocalEntries: migrating 
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- remove_foreign_key(:virtual_registries_packages_maven_cache_local_entries, {:column=>:group_id})
main:    -> 0.0877s
main: == 20251211092343 DropGroupForeignKeyFromVirtualRegistriesPkgMvnCacheLocalEntries: migrated (0.2913s) 

main: == [advisory_lock_connection] object_id: 131080, pg_backend_pid: 37400
DEPRECATION WARNING: `config.active_record.warn_on_records_fetched_greater_than` is deprecated and will be removed in Rails 8.0. Please subscribe to `sql.active_record` notifications and access the row count field to detect large result set sizes. (called from <main> at /Users/david/projects/gitlab-development-kit/gitlab/config/environment.rb:7)
ci: == [advisory_lock_connection] object_id: 131080, pg_backend_pid: 37545
ci: == 20251211092343 DropGroupForeignKeyFromVirtualRegistriesPkgMvnCacheLocalEntries: migrating 
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- remove_foreign_key(:virtual_registries_packages_maven_cache_local_entries, {:column=>:group_id})
ci:    -> 0.0393s
ci: == 20251211092343 DropGroupForeignKeyFromVirtualRegistriesPkgMvnCacheLocalEntries: migrated (0.0797s) 

ci: == [advisory_lock_connection] object_id: 131080, pg_backend_pid: 37545
20251211092720 
$ rails db:migrate:up:main VERSION=20251211092720 && rails db:migrate:up:ci VERSION=20251211092720
DEPRECATION WARNING: `config.active_record.warn_on_records_fetched_greater_than` is deprecated and will be removed in Rails 8.0. Please subscribe to `sql.active_record` notifications and access the row count field to detect large result set sizes. (called from <main> at /Users/david/projects/gitlab-development-kit/gitlab/config/environment.rb:7)
main: == [advisory_lock_connection] object_id: 131080, pg_backend_pid: 37695
main: == 20251211092720 DropVirtualRegistriesPackagesMavenCacheLocalEntries: migrating 
main: -- drop_table(:virtual_registries_packages_maven_cache_local_entries)
main:    -> 0.0321s
main: == 20251211092720 DropVirtualRegistriesPackagesMavenCacheLocalEntries: migrated (0.0551s) 

main: == [advisory_lock_connection] object_id: 131080, pg_backend_pid: 37695
DEPRECATION WARNING: `config.active_record.warn_on_records_fetched_greater_than` is deprecated and will be removed in Rails 8.0. Please subscribe to `sql.active_record` notifications and access the row count field to detect large result set sizes. (called from <main> at /Users/david/projects/gitlab-development-kit/gitlab/config/environment.rb:7)
ci: == [advisory_lock_connection] object_id: 131060, pg_backend_pid: 37819
ci: == 20251211092720 DropVirtualRegistriesPackagesMavenCacheLocalEntries: migrating 
ci: -- drop_table(:virtual_registries_packages_maven_cache_local_entries)
ci:    -> 0.0276s
ci: == 20251211092720 DropVirtualRegistriesPackagesMavenCacheLocalEntries: migrated (0.0531s) 

ci: == [advisory_lock_connection] object_id: 131060, pg_backend_pid: 37819

⬇️ Migrations down

20251211092720 
$ rails db:migrate:down:main VERSION=20251211092720 && rails db:migrate:down:ci VERSION=20251211092720
DEPRECATION WARNING: `config.active_record.warn_on_records_fetched_greater_than` is deprecated and will be removed in Rails 8.0. Please subscribe to `sql.active_record` notifications and access the row count field to detect large result set sizes. (called from <main> at /Users/david/projects/gitlab-development-kit/gitlab/config/environment.rb:7)
main: == [advisory_lock_connection] object_id: 131080, pg_backend_pid: 42454
main: == 20251211092720 DropVirtualRegistriesPackagesMavenCacheLocalEntries: reverting 
main: -- create_table(:virtual_registries_packages_maven_cache_local_entries, {:if_not_exists=>true, :options=>"PARTITION BY HASH (relative_path)", :primary_key=>[:upstream_id, :relative_path]})
main: -- quote_column_name(:relative_path)
main:    -> 0.0000s
main:    -> 0.0129s
main: -- transaction(nil)
main: -- execute("CREATE TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_00\nPARTITION OF virtual_registries_packages_maven_cache_local_entries\nFOR VALUES WITH (MODULUS 16, REMAINDER 0);\n")
main:    -> 0.0068s
main: -- execute("CREATE TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_01\nPARTITION OF virtual_registries_packages_maven_cache_local_entries\nFOR VALUES WITH (MODULUS 16, REMAINDER 1);\n")
main:    -> 0.0036s
main: -- execute("CREATE TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_02\nPARTITION OF virtual_registries_packages_maven_cache_local_entries\nFOR VALUES WITH (MODULUS 16, REMAINDER 2);\n")
main:    -> 0.0417s
main: -- execute("CREATE TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_03\nPARTITION OF virtual_registries_packages_maven_cache_local_entries\nFOR VALUES WITH (MODULUS 16, REMAINDER 3);\n")
main:    -> 0.0055s
main: -- execute("CREATE TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_04\nPARTITION OF virtual_registries_packages_maven_cache_local_entries\nFOR VALUES WITH (MODULUS 16, REMAINDER 4);\n")
main:    -> 0.0028s
main: -- execute("CREATE TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_05\nPARTITION OF virtual_registries_packages_maven_cache_local_entries\nFOR VALUES WITH (MODULUS 16, REMAINDER 5);\n")
main:    -> 0.0027s
main: -- execute("CREATE TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_06\nPARTITION OF virtual_registries_packages_maven_cache_local_entries\nFOR VALUES WITH (MODULUS 16, REMAINDER 6);\n")
main:    -> 0.0035s
main: -- execute("CREATE TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_07\nPARTITION OF virtual_registries_packages_maven_cache_local_entries\nFOR VALUES WITH (MODULUS 16, REMAINDER 7);\n")
main:    -> 0.0031s
main: -- execute("CREATE TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_08\nPARTITION OF virtual_registries_packages_maven_cache_local_entries\nFOR VALUES WITH (MODULUS 16, REMAINDER 8);\n")
main:    -> 0.0025s
main: -- execute("CREATE TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_09\nPARTITION OF virtual_registries_packages_maven_cache_local_entries\nFOR VALUES WITH (MODULUS 16, REMAINDER 9);\n")
main:    -> 0.0033s
main: -- execute("CREATE TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_10\nPARTITION OF virtual_registries_packages_maven_cache_local_entries\nFOR VALUES WITH (MODULUS 16, REMAINDER 10);\n")
main:    -> 0.0025s
main: -- execute("CREATE TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_11\nPARTITION OF virtual_registries_packages_maven_cache_local_entries\nFOR VALUES WITH (MODULUS 16, REMAINDER 11);\n")
main:    -> 0.0024s
main: -- execute("CREATE TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_12\nPARTITION OF virtual_registries_packages_maven_cache_local_entries\nFOR VALUES WITH (MODULUS 16, REMAINDER 12);\n")
main:    -> 0.0028s
main: -- execute("CREATE TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_13\nPARTITION OF virtual_registries_packages_maven_cache_local_entries\nFOR VALUES WITH (MODULUS 16, REMAINDER 13);\n")
main:    -> 0.0037s
main: -- execute("CREATE TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_14\nPARTITION OF virtual_registries_packages_maven_cache_local_entries\nFOR VALUES WITH (MODULUS 16, REMAINDER 14);\n")
main:    -> 0.0034s
main: -- execute("CREATE TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_15\nPARTITION OF virtual_registries_packages_maven_cache_local_entries\nFOR VALUES WITH (MODULUS 16, REMAINDER 15);\n")
main:    -> 0.0030s
main:    -> 0.0963s
main: == 20251211092720 DropVirtualRegistriesPackagesMavenCacheLocalEntries: reverted (0.2634s) 

main: == [advisory_lock_connection] object_id: 131080, pg_backend_pid: 42454
DEPRECATION WARNING: `config.active_record.warn_on_records_fetched_greater_than` is deprecated and will be removed in Rails 8.0. Please subscribe to `sql.active_record` notifications and access the row count field to detect large result set sizes. (called from <main> at /Users/david/projects/gitlab-development-kit/gitlab/config/environment.rb:7)
ci: == [advisory_lock_connection] object_id: 131080, pg_backend_pid: 42611
ci: == 20251211092720 DropVirtualRegistriesPackagesMavenCacheLocalEntries: reverting 
ci: -- create_table(:virtual_registries_packages_maven_cache_local_entries, {:if_not_exists=>true, :options=>"PARTITION BY HASH (relative_path)", :primary_key=>[:upstream_id, :relative_path]})
ci: -- quote_column_name(:relative_path)
ci:    -> 0.0000s
ci:    -> 0.0068s
ci: -- transaction(nil)
ci: -- execute("CREATE TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_00\nPARTITION OF virtual_registries_packages_maven_cache_local_entries\nFOR VALUES WITH (MODULUS 16, REMAINDER 0);\n")
ci:    -> 0.0045s
ci: -- execute("CREATE TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_01\nPARTITION OF virtual_registries_packages_maven_cache_local_entries\nFOR VALUES WITH (MODULUS 16, REMAINDER 1);\n")
ci:    -> 0.0027s
ci: -- execute("CREATE TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_02\nPARTITION OF virtual_registries_packages_maven_cache_local_entries\nFOR VALUES WITH (MODULUS 16, REMAINDER 2);\n")
ci:    -> 0.0029s
ci: -- execute("CREATE TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_03\nPARTITION OF virtual_registries_packages_maven_cache_local_entries\nFOR VALUES WITH (MODULUS 16, REMAINDER 3);\n")
ci:    -> 0.0025s
ci: -- execute("CREATE TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_04\nPARTITION OF virtual_registries_packages_maven_cache_local_entries\nFOR VALUES WITH (MODULUS 16, REMAINDER 4);\n")
ci:    -> 0.0028s
ci: -- execute("CREATE TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_05\nPARTITION OF virtual_registries_packages_maven_cache_local_entries\nFOR VALUES WITH (MODULUS 16, REMAINDER 5);\n")
ci:    -> 0.0023s
ci: -- execute("CREATE TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_06\nPARTITION OF virtual_registries_packages_maven_cache_local_entries\nFOR VALUES WITH (MODULUS 16, REMAINDER 6);\n")
ci:    -> 0.0026s
ci: -- execute("CREATE TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_07\nPARTITION OF virtual_registries_packages_maven_cache_local_entries\nFOR VALUES WITH (MODULUS 16, REMAINDER 7);\n")
ci:    -> 0.0023s
ci: -- execute("CREATE TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_08\nPARTITION OF virtual_registries_packages_maven_cache_local_entries\nFOR VALUES WITH (MODULUS 16, REMAINDER 8);\n")
ci:    -> 0.0025s
ci: -- execute("CREATE TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_09\nPARTITION OF virtual_registries_packages_maven_cache_local_entries\nFOR VALUES WITH (MODULUS 16, REMAINDER 9);\n")
ci:    -> 0.0025s
ci: -- execute("CREATE TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_10\nPARTITION OF virtual_registries_packages_maven_cache_local_entries\nFOR VALUES WITH (MODULUS 16, REMAINDER 10);\n")
ci:    -> 0.0024s
ci: -- execute("CREATE TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_11\nPARTITION OF virtual_registries_packages_maven_cache_local_entries\nFOR VALUES WITH (MODULUS 16, REMAINDER 11);\n")
ci:    -> 0.0022s
ci: -- execute("CREATE TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_12\nPARTITION OF virtual_registries_packages_maven_cache_local_entries\nFOR VALUES WITH (MODULUS 16, REMAINDER 12);\n")
ci:    -> 0.0026s
ci: -- execute("CREATE TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_13\nPARTITION OF virtual_registries_packages_maven_cache_local_entries\nFOR VALUES WITH (MODULUS 16, REMAINDER 13);\n")
ci:    -> 0.0037s
ci: -- execute("CREATE TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_14\nPARTITION OF virtual_registries_packages_maven_cache_local_entries\nFOR VALUES WITH (MODULUS 16, REMAINDER 14);\n")
ci:    -> 0.0029s
ci: -- execute("CREATE TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_15\nPARTITION OF virtual_registries_packages_maven_cache_local_entries\nFOR VALUES WITH (MODULUS 16, REMAINDER 15);\n")
ci:    -> 0.0023s
ci:    -> 0.0459s
ci: == 20251211092720 DropVirtualRegistriesPackagesMavenCacheLocalEntries: reverted (0.1002s) 

ci: == [advisory_lock_connection] object_id: 131080, pg_backend_pid: 42611
20251211092343 
$ rails db:migrate:down:main VERSION=20251211092343 && rails db:migrate:down:ci VERSION=20251211092343
DEPRECATION WARNING: `config.active_record.warn_on_records_fetched_greater_than` is deprecated and will be removed in Rails 8.0. Please subscribe to `sql.active_record` notifications and access the row count field to detect large result set sizes. (called from <main> at /Users/david/projects/gitlab-development-kit/gitlab/config/environment.rb:7)
main: == [advisory_lock_connection] object_id: 131080, pg_backend_pid: 35826
main: == 20251211092343 DropGroupForeignKeyFromVirtualRegistriesPkgMvnCacheLocalEntries: reverting 
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_00 ADD CONSTRAINT fk_rails_1f4887d93d FOREIGN KEY (group_id) REFERENCES namespaces (id) ON DELETE CASCADE NOT VALID;")
main:    -> 0.0025s
main: -- execute("SET statement_timeout TO 0")
main:    -> 0.0003s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_00 VALIDATE CONSTRAINT fk_rails_1f4887d93d;")
main:    -> 0.0054s
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 gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_01 ADD CONSTRAINT fk_rails_1f4887d93d FOREIGN KEY (group_id) REFERENCES namespaces (id) ON DELETE CASCADE NOT VALID;")
main:    -> 0.0008s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_01 VALIDATE CONSTRAINT fk_rails_1f4887d93d;")
main:    -> 0.0012s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_02 ADD CONSTRAINT fk_rails_1f4887d93d FOREIGN KEY (group_id) REFERENCES namespaces (id) ON DELETE CASCADE NOT VALID;")
main:    -> 0.0008s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_02 VALIDATE CONSTRAINT fk_rails_1f4887d93d;")
main:    -> 0.0012s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_03 ADD CONSTRAINT fk_rails_1f4887d93d FOREIGN KEY (group_id) REFERENCES namespaces (id) ON DELETE CASCADE NOT VALID;")
main:    -> 0.0009s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_03 VALIDATE CONSTRAINT fk_rails_1f4887d93d;")
main:    -> 0.0010s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_04 ADD CONSTRAINT fk_rails_1f4887d93d FOREIGN KEY (group_id) REFERENCES namespaces (id) ON DELETE CASCADE NOT VALID;")
main:    -> 0.0009s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_04 VALIDATE CONSTRAINT fk_rails_1f4887d93d;")
main:    -> 0.0011s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_05 ADD CONSTRAINT fk_rails_1f4887d93d FOREIGN KEY (group_id) REFERENCES namespaces (id) ON DELETE CASCADE NOT VALID;")
main:    -> 0.0010s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_05 VALIDATE CONSTRAINT fk_rails_1f4887d93d;")
main:    -> 0.0011s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_06 ADD CONSTRAINT fk_rails_1f4887d93d FOREIGN KEY (group_id) REFERENCES namespaces (id) ON DELETE CASCADE NOT VALID;")
main:    -> 0.0007s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_06 VALIDATE CONSTRAINT fk_rails_1f4887d93d;")
main:    -> 0.0016s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_07 ADD CONSTRAINT fk_rails_1f4887d93d FOREIGN KEY (group_id) REFERENCES namespaces (id) ON DELETE CASCADE NOT VALID;")
main:    -> 0.0008s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_07 VALIDATE CONSTRAINT fk_rails_1f4887d93d;")
main:    -> 0.0014s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_08 ADD CONSTRAINT fk_rails_1f4887d93d FOREIGN KEY (group_id) REFERENCES namespaces (id) ON DELETE CASCADE NOT VALID;")
main:    -> 0.0008s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_08 VALIDATE CONSTRAINT fk_rails_1f4887d93d;")
main:    -> 0.0011s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_09 ADD CONSTRAINT fk_rails_1f4887d93d FOREIGN KEY (group_id) REFERENCES namespaces (id) ON DELETE CASCADE NOT VALID;")
main:    -> 0.0008s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_09 VALIDATE CONSTRAINT fk_rails_1f4887d93d;")
main:    -> 0.0012s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_10 ADD CONSTRAINT fk_rails_1f4887d93d FOREIGN KEY (group_id) REFERENCES namespaces (id) ON DELETE CASCADE NOT VALID;")
main:    -> 0.0007s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_10 VALIDATE CONSTRAINT fk_rails_1f4887d93d;")
main:    -> 0.0013s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_11 ADD CONSTRAINT fk_rails_1f4887d93d FOREIGN KEY (group_id) REFERENCES namespaces (id) ON DELETE CASCADE NOT VALID;")
main:    -> 0.0009s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_11 VALIDATE CONSTRAINT fk_rails_1f4887d93d;")
main:    -> 0.0014s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_12 ADD CONSTRAINT fk_rails_1f4887d93d FOREIGN KEY (group_id) REFERENCES namespaces (id) ON DELETE CASCADE NOT VALID;")
main:    -> 0.0008s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_12 VALIDATE CONSTRAINT fk_rails_1f4887d93d;")
main:    -> 0.0009s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_13 ADD CONSTRAINT fk_rails_1f4887d93d FOREIGN KEY (group_id) REFERENCES namespaces (id) ON DELETE CASCADE NOT VALID;")
main:    -> 0.0007s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_13 VALIDATE CONSTRAINT fk_rails_1f4887d93d;")
main:    -> 0.0011s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_14 ADD CONSTRAINT fk_rails_1f4887d93d FOREIGN KEY (group_id) REFERENCES namespaces (id) ON DELETE CASCADE NOT VALID;")
main:    -> 0.0012s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_14 VALIDATE CONSTRAINT fk_rails_1f4887d93d;")
main:    -> 0.0015s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_15 ADD CONSTRAINT fk_rails_1f4887d93d FOREIGN KEY (group_id) REFERENCES namespaces (id) ON DELETE CASCADE NOT VALID;")
main:    -> 0.0008s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_15 VALIDATE CONSTRAINT fk_rails_1f4887d93d;")
main:    -> 0.0011s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- execute("ALTER TABLE virtual_registries_packages_maven_cache_local_entries ADD CONSTRAINT fk_rails_1f4887d93d FOREIGN KEY (group_id) REFERENCES namespaces (id) ON DELETE CASCADE ;")
main:    -> 0.0049s
main: -- execute("ALTER TABLE virtual_registries_packages_maven_cache_local_entries VALIDATE CONSTRAINT fk_rails_1f4887d93d;")
main:    -> 0.0007s
main: == 20251211092343 DropGroupForeignKeyFromVirtualRegistriesPkgMvnCacheLocalEntries: reverted (0.5162s) 

main: == [advisory_lock_connection] object_id: 131080, pg_backend_pid: 35826
DEPRECATION WARNING: `config.active_record.warn_on_records_fetched_greater_than` is deprecated and will be removed in Rails 8.0. Please subscribe to `sql.active_record` notifications and access the row count field to detect large result set sizes. (called from <main> at /Users/david/projects/gitlab-development-kit/gitlab/config/environment.rb:7)
ci: == [advisory_lock_connection] object_id: 131080, pg_backend_pid: 35976
ci: == 20251211092343 DropGroupForeignKeyFromVirtualRegistriesPkgMvnCacheLocalEntries: reverting 
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_00 ADD CONSTRAINT fk_rails_1f4887d93d FOREIGN KEY (group_id) REFERENCES namespaces (id) ON DELETE CASCADE NOT VALID;")
ci:    -> 0.0021s
ci: -- execute("SET statement_timeout TO 0")
ci:    -> 0.0003s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_00 VALIDATE CONSTRAINT fk_rails_1f4887d93d;")
ci:    -> 0.0058s
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 gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_01 ADD CONSTRAINT fk_rails_1f4887d93d FOREIGN KEY (group_id) REFERENCES namespaces (id) ON DELETE CASCADE NOT VALID;")
ci:    -> 0.0009s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_01 VALIDATE CONSTRAINT fk_rails_1f4887d93d;")
ci:    -> 0.0014s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_02 ADD CONSTRAINT fk_rails_1f4887d93d FOREIGN KEY (group_id) REFERENCES namespaces (id) ON DELETE CASCADE NOT VALID;")
ci:    -> 0.0008s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_02 VALIDATE CONSTRAINT fk_rails_1f4887d93d;")
ci:    -> 0.0012s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_03 ADD CONSTRAINT fk_rails_1f4887d93d FOREIGN KEY (group_id) REFERENCES namespaces (id) ON DELETE CASCADE NOT VALID;")
ci:    -> 0.0321s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_03 VALIDATE CONSTRAINT fk_rails_1f4887d93d;")
ci:    -> 0.0014s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_04 ADD CONSTRAINT fk_rails_1f4887d93d FOREIGN KEY (group_id) REFERENCES namespaces (id) ON DELETE CASCADE NOT VALID;")
ci:    -> 0.0008s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_04 VALIDATE CONSTRAINT fk_rails_1f4887d93d;")
ci:    -> 0.0012s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_05 ADD CONSTRAINT fk_rails_1f4887d93d FOREIGN KEY (group_id) REFERENCES namespaces (id) ON DELETE CASCADE NOT VALID;")
ci:    -> 0.0010s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_05 VALIDATE CONSTRAINT fk_rails_1f4887d93d;")
ci:    -> 0.0010s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_06 ADD CONSTRAINT fk_rails_1f4887d93d FOREIGN KEY (group_id) REFERENCES namespaces (id) ON DELETE CASCADE NOT VALID;")
ci:    -> 0.0009s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_06 VALIDATE CONSTRAINT fk_rails_1f4887d93d;")
ci:    -> 0.0017s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_07 ADD CONSTRAINT fk_rails_1f4887d93d FOREIGN KEY (group_id) REFERENCES namespaces (id) ON DELETE CASCADE NOT VALID;")
ci:    -> 0.0073s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_07 VALIDATE CONSTRAINT fk_rails_1f4887d93d;")
ci:    -> 0.0014s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_08 ADD CONSTRAINT fk_rails_1f4887d93d FOREIGN KEY (group_id) REFERENCES namespaces (id) ON DELETE CASCADE NOT VALID;")
ci:    -> 0.0008s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_08 VALIDATE CONSTRAINT fk_rails_1f4887d93d;")
ci:    -> 0.0012s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_09 ADD CONSTRAINT fk_rails_1f4887d93d FOREIGN KEY (group_id) REFERENCES namespaces (id) ON DELETE CASCADE NOT VALID;")
ci:    -> 0.0009s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_09 VALIDATE CONSTRAINT fk_rails_1f4887d93d;")
ci:    -> 0.0013s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_10 ADD CONSTRAINT fk_rails_1f4887d93d FOREIGN KEY (group_id) REFERENCES namespaces (id) ON DELETE CASCADE NOT VALID;")
ci:    -> 0.0014s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_10 VALIDATE CONSTRAINT fk_rails_1f4887d93d;")
ci:    -> 0.0016s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_11 ADD CONSTRAINT fk_rails_1f4887d93d FOREIGN KEY (group_id) REFERENCES namespaces (id) ON DELETE CASCADE NOT VALID;")
ci:    -> 0.0011s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_11 VALIDATE CONSTRAINT fk_rails_1f4887d93d;")
ci:    -> 0.0011s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_12 ADD CONSTRAINT fk_rails_1f4887d93d FOREIGN KEY (group_id) REFERENCES namespaces (id) ON DELETE CASCADE NOT VALID;")
ci:    -> 0.0007s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_12 VALIDATE CONSTRAINT fk_rails_1f4887d93d;")
ci:    -> 0.0013s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_13 ADD CONSTRAINT fk_rails_1f4887d93d FOREIGN KEY (group_id) REFERENCES namespaces (id) ON DELETE CASCADE NOT VALID;")
ci:    -> 0.0009s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_13 VALIDATE CONSTRAINT fk_rails_1f4887d93d;")
ci:    -> 0.0012s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_14 ADD CONSTRAINT fk_rails_1f4887d93d FOREIGN KEY (group_id) REFERENCES namespaces (id) ON DELETE CASCADE NOT VALID;")
ci:    -> 0.0009s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_14 VALIDATE CONSTRAINT fk_rails_1f4887d93d;")
ci:    -> 0.0012s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_15 ADD CONSTRAINT fk_rails_1f4887d93d FOREIGN KEY (group_id) REFERENCES namespaces (id) ON DELETE CASCADE NOT VALID;")
ci:    -> 0.0008s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_15 VALIDATE CONSTRAINT fk_rails_1f4887d93d;")
ci:    -> 0.0011s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- execute("ALTER TABLE virtual_registries_packages_maven_cache_local_entries ADD CONSTRAINT fk_rails_1f4887d93d FOREIGN KEY (group_id) REFERENCES namespaces (id) ON DELETE CASCADE ;")
ci:    -> 0.0047s
ci: -- execute("ALTER TABLE virtual_registries_packages_maven_cache_local_entries VALIDATE CONSTRAINT fk_rails_1f4887d93d;")
ci:    -> 0.0003s
ci: == 20251211092343 DropGroupForeignKeyFromVirtualRegistriesPkgMvnCacheLocalEntries: reverted (0.3769s) 

ci: == [advisory_lock_connection] object_id: 131080, pg_backend_pid: 35976
20251211091519 
$ rails db:migrate:down:main VERSION=20251211091519 && rails db:migrate:down:ci VERSION=20251211091519
DEPRECATION WARNING: `config.active_record.warn_on_records_fetched_greater_than` is deprecated and will be removed in Rails 8.0. Please subscribe to `sql.active_record` notifications and access the row count field to detect large result set sizes. (called from <main> at /Users/david/projects/gitlab-development-kit/gitlab/config/environment.rb:7)
main: == [advisory_lock_connection] object_id: 131080, pg_backend_pid: 36149
main: == 20251211091519 DropUpstreamForeignKeyFromVirtualRegistriesPkgMvnCacheLocalEntries: reverting 
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_00 ADD CONSTRAINT fk_rails_c6f6218d37 FOREIGN KEY (upstream_id) REFERENCES virtual_registries_packages_maven_upstreams (id) ON DELETE CASCADE NOT VALID;")
main:    -> 0.0019s
main: -- execute("SET statement_timeout TO 0")
main:    -> 0.0003s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_00 VALIDATE CONSTRAINT fk_rails_c6f6218d37;")
main:    -> 0.0030s
main: -- execute("RESET statement_timeout")
main:    -> 0.0003s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_01 ADD CONSTRAINT fk_rails_c6f6218d37 FOREIGN KEY (upstream_id) REFERENCES virtual_registries_packages_maven_upstreams (id) ON DELETE CASCADE NOT VALID;")
main:    -> 0.0005s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_01 VALIDATE CONSTRAINT fk_rails_c6f6218d37;")
main:    -> 0.0007s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_02 ADD CONSTRAINT fk_rails_c6f6218d37 FOREIGN KEY (upstream_id) REFERENCES virtual_registries_packages_maven_upstreams (id) ON DELETE CASCADE NOT VALID;")
main:    -> 0.0006s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_02 VALIDATE CONSTRAINT fk_rails_c6f6218d37;")
main:    -> 0.0009s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_03 ADD CONSTRAINT fk_rails_c6f6218d37 FOREIGN KEY (upstream_id) REFERENCES virtual_registries_packages_maven_upstreams (id) ON DELETE CASCADE NOT VALID;")
main:    -> 0.0005s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_03 VALIDATE CONSTRAINT fk_rails_c6f6218d37;")
main:    -> 0.0013s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_04 ADD CONSTRAINT fk_rails_c6f6218d37 FOREIGN KEY (upstream_id) REFERENCES virtual_registries_packages_maven_upstreams (id) ON DELETE CASCADE NOT VALID;")
main:    -> 0.0005s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_04 VALIDATE CONSTRAINT fk_rails_c6f6218d37;")
main:    -> 0.0008s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_05 ADD CONSTRAINT fk_rails_c6f6218d37 FOREIGN KEY (upstream_id) REFERENCES virtual_registries_packages_maven_upstreams (id) ON DELETE CASCADE NOT VALID;")
main:    -> 0.0005s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_05 VALIDATE CONSTRAINT fk_rails_c6f6218d37;")
main:    -> 0.0009s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_06 ADD CONSTRAINT fk_rails_c6f6218d37 FOREIGN KEY (upstream_id) REFERENCES virtual_registries_packages_maven_upstreams (id) ON DELETE CASCADE NOT VALID;")
main:    -> 0.0005s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_06 VALIDATE CONSTRAINT fk_rails_c6f6218d37;")
main:    -> 0.0006s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_07 ADD CONSTRAINT fk_rails_c6f6218d37 FOREIGN KEY (upstream_id) REFERENCES virtual_registries_packages_maven_upstreams (id) ON DELETE CASCADE NOT VALID;")
main:    -> 0.0005s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_07 VALIDATE CONSTRAINT fk_rails_c6f6218d37;")
main:    -> 0.0010s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_08 ADD CONSTRAINT fk_rails_c6f6218d37 FOREIGN KEY (upstream_id) REFERENCES virtual_registries_packages_maven_upstreams (id) ON DELETE CASCADE NOT VALID;")
main:    -> 0.0005s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_08 VALIDATE CONSTRAINT fk_rails_c6f6218d37;")
main:    -> 0.0007s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_09 ADD CONSTRAINT fk_rails_c6f6218d37 FOREIGN KEY (upstream_id) REFERENCES virtual_registries_packages_maven_upstreams (id) ON DELETE CASCADE NOT VALID;")
main:    -> 0.0007s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_09 VALIDATE CONSTRAINT fk_rails_c6f6218d37;")
main:    -> 0.0025s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_10 ADD CONSTRAINT fk_rails_c6f6218d37 FOREIGN KEY (upstream_id) REFERENCES virtual_registries_packages_maven_upstreams (id) ON DELETE CASCADE NOT VALID;")
main:    -> 0.0164s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_10 VALIDATE CONSTRAINT fk_rails_c6f6218d37;")
main:    -> 0.0010s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_11 ADD CONSTRAINT fk_rails_c6f6218d37 FOREIGN KEY (upstream_id) REFERENCES virtual_registries_packages_maven_upstreams (id) ON DELETE CASCADE NOT VALID;")
main:    -> 0.0006s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_11 VALIDATE CONSTRAINT fk_rails_c6f6218d37;")
main:    -> 0.0008s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_12 ADD CONSTRAINT fk_rails_c6f6218d37 FOREIGN KEY (upstream_id) REFERENCES virtual_registries_packages_maven_upstreams (id) ON DELETE CASCADE NOT VALID;")
main:    -> 0.0010s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_12 VALIDATE CONSTRAINT fk_rails_c6f6218d37;")
main:    -> 0.0008s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_13 ADD CONSTRAINT fk_rails_c6f6218d37 FOREIGN KEY (upstream_id) REFERENCES virtual_registries_packages_maven_upstreams (id) ON DELETE CASCADE NOT VALID;")
main:    -> 0.0006s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_13 VALIDATE CONSTRAINT fk_rails_c6f6218d37;")
main:    -> 0.0009s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_14 ADD CONSTRAINT fk_rails_c6f6218d37 FOREIGN KEY (upstream_id) REFERENCES virtual_registries_packages_maven_upstreams (id) ON DELETE CASCADE NOT VALID;")
main:    -> 0.0007s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_14 VALIDATE CONSTRAINT fk_rails_c6f6218d37;")
main:    -> 0.0009s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_15 ADD CONSTRAINT fk_rails_c6f6218d37 FOREIGN KEY (upstream_id) REFERENCES virtual_registries_packages_maven_upstreams (id) ON DELETE CASCADE NOT VALID;")
main:    -> 0.0007s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_15 VALIDATE CONSTRAINT fk_rails_c6f6218d37;")
main:    -> 0.0009s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- execute("ALTER TABLE virtual_registries_packages_maven_cache_local_entries ADD CONSTRAINT fk_rails_c6f6218d37 FOREIGN KEY (upstream_id) REFERENCES virtual_registries_packages_maven_upstreams (id) ON DELETE CASCADE ;")
main:    -> 0.0025s
main: -- execute("ALTER TABLE virtual_registries_packages_maven_cache_local_entries VALIDATE CONSTRAINT fk_rails_c6f6218d37;")
main:    -> 0.0003s
main: == 20251211091519 DropUpstreamForeignKeyFromVirtualRegistriesPkgMvnCacheLocalEntries: reverted (0.3286s) 

main: == [advisory_lock_connection] object_id: 131080, pg_backend_pid: 36149
DEPRECATION WARNING: `config.active_record.warn_on_records_fetched_greater_than` is deprecated and will be removed in Rails 8.0. Please subscribe to `sql.active_record` notifications and access the row count field to detect large result set sizes. (called from <main> at /Users/david/projects/gitlab-development-kit/gitlab/config/environment.rb:7)
ci: == [advisory_lock_connection] object_id: 131080, pg_backend_pid: 36307
ci: == 20251211091519 DropUpstreamForeignKeyFromVirtualRegistriesPkgMvnCacheLocalEntries: reverting 
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_00 ADD CONSTRAINT fk_rails_c6f6218d37 FOREIGN KEY (upstream_id) REFERENCES virtual_registries_packages_maven_upstreams (id) ON DELETE CASCADE NOT VALID;")
ci:    -> 0.0020s
ci: -- execute("SET statement_timeout TO 0")
ci:    -> 0.0003s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_00 VALIDATE CONSTRAINT fk_rails_c6f6218d37;")
ci:    -> 0.0034s
ci: -- execute("RESET statement_timeout")
ci:    -> 0.0003s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_01 ADD CONSTRAINT fk_rails_c6f6218d37 FOREIGN KEY (upstream_id) REFERENCES virtual_registries_packages_maven_upstreams (id) ON DELETE CASCADE NOT VALID;")
ci:    -> 0.0007s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_01 VALIDATE CONSTRAINT fk_rails_c6f6218d37;")
ci:    -> 0.0010s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_02 ADD CONSTRAINT fk_rails_c6f6218d37 FOREIGN KEY (upstream_id) REFERENCES virtual_registries_packages_maven_upstreams (id) ON DELETE CASCADE NOT VALID;")
ci:    -> 0.0006s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_02 VALIDATE CONSTRAINT fk_rails_c6f6218d37;")
ci:    -> 0.0007s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_03 ADD CONSTRAINT fk_rails_c6f6218d37 FOREIGN KEY (upstream_id) REFERENCES virtual_registries_packages_maven_upstreams (id) ON DELETE CASCADE NOT VALID;")
ci:    -> 0.0005s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_03 VALIDATE CONSTRAINT fk_rails_c6f6218d37;")
ci:    -> 0.0010s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_04 ADD CONSTRAINT fk_rails_c6f6218d37 FOREIGN KEY (upstream_id) REFERENCES virtual_registries_packages_maven_upstreams (id) ON DELETE CASCADE NOT VALID;")
ci:    -> 0.0007s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_04 VALIDATE CONSTRAINT fk_rails_c6f6218d37;")
ci:    -> 0.0008s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_05 ADD CONSTRAINT fk_rails_c6f6218d37 FOREIGN KEY (upstream_id) REFERENCES virtual_registries_packages_maven_upstreams (id) ON DELETE CASCADE NOT VALID;")
ci:    -> 0.0006s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_05 VALIDATE CONSTRAINT fk_rails_c6f6218d37;")
ci:    -> 0.0008s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_06 ADD CONSTRAINT fk_rails_c6f6218d37 FOREIGN KEY (upstream_id) REFERENCES virtual_registries_packages_maven_upstreams (id) ON DELETE CASCADE NOT VALID;")
ci:    -> 0.0006s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_06 VALIDATE CONSTRAINT fk_rails_c6f6218d37;")
ci:    -> 0.0011s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_07 ADD CONSTRAINT fk_rails_c6f6218d37 FOREIGN KEY (upstream_id) REFERENCES virtual_registries_packages_maven_upstreams (id) ON DELETE CASCADE NOT VALID;")
ci:    -> 0.0007s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_07 VALIDATE CONSTRAINT fk_rails_c6f6218d37;")
ci:    -> 0.0009s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_08 ADD CONSTRAINT fk_rails_c6f6218d37 FOREIGN KEY (upstream_id) REFERENCES virtual_registries_packages_maven_upstreams (id) ON DELETE CASCADE NOT VALID;")
ci:    -> 0.0012s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_08 VALIDATE CONSTRAINT fk_rails_c6f6218d37;")
ci:    -> 0.0007s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_09 ADD CONSTRAINT fk_rails_c6f6218d37 FOREIGN KEY (upstream_id) REFERENCES virtual_registries_packages_maven_upstreams (id) ON DELETE CASCADE NOT VALID;")
ci:    -> 0.0007s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_09 VALIDATE CONSTRAINT fk_rails_c6f6218d37;")
ci:    -> 0.0008s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_10 ADD CONSTRAINT fk_rails_c6f6218d37 FOREIGN KEY (upstream_id) REFERENCES virtual_registries_packages_maven_upstreams (id) ON DELETE CASCADE NOT VALID;")
ci:    -> 0.0006s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_10 VALIDATE CONSTRAINT fk_rails_c6f6218d37;")
ci:    -> 0.0007s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_11 ADD CONSTRAINT fk_rails_c6f6218d37 FOREIGN KEY (upstream_id) REFERENCES virtual_registries_packages_maven_upstreams (id) ON DELETE CASCADE NOT VALID;")
ci:    -> 0.0007s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_11 VALIDATE CONSTRAINT fk_rails_c6f6218d37;")
ci:    -> 0.0009s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_12 ADD CONSTRAINT fk_rails_c6f6218d37 FOREIGN KEY (upstream_id) REFERENCES virtual_registries_packages_maven_upstreams (id) ON DELETE CASCADE NOT VALID;")
ci:    -> 0.0006s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_12 VALIDATE CONSTRAINT fk_rails_c6f6218d37;")
ci:    -> 0.0007s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_13 ADD CONSTRAINT fk_rails_c6f6218d37 FOREIGN KEY (upstream_id) REFERENCES virtual_registries_packages_maven_upstreams (id) ON DELETE CASCADE NOT VALID;")
ci:    -> 0.0007s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_13 VALIDATE CONSTRAINT fk_rails_c6f6218d37;")
ci:    -> 0.0009s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_14 ADD CONSTRAINT fk_rails_c6f6218d37 FOREIGN KEY (upstream_id) REFERENCES virtual_registries_packages_maven_upstreams (id) ON DELETE CASCADE NOT VALID;")
ci:    -> 0.0007s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_14 VALIDATE CONSTRAINT fk_rails_c6f6218d37;")
ci:    -> 0.0008s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_15 ADD CONSTRAINT fk_rails_c6f6218d37 FOREIGN KEY (upstream_id) REFERENCES virtual_registries_packages_maven_upstreams (id) ON DELETE CASCADE NOT VALID;")
ci:    -> 0.0006s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_15 VALIDATE CONSTRAINT fk_rails_c6f6218d37;")
ci:    -> 0.0011s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- execute("ALTER TABLE virtual_registries_packages_maven_cache_local_entries ADD CONSTRAINT fk_rails_c6f6218d37 FOREIGN KEY (upstream_id) REFERENCES virtual_registries_packages_maven_upstreams (id) ON DELETE CASCADE ;")
ci:    -> 0.0034s
ci: -- execute("ALTER TABLE virtual_registries_packages_maven_cache_local_entries VALIDATE CONSTRAINT fk_rails_c6f6218d37;")
ci:    -> 0.0005s
ci: == 20251211091519 DropUpstreamForeignKeyFromVirtualRegistriesPkgMvnCacheLocalEntries: reverted (0.5063s) 

ci: == [advisory_lock_connection] object_id: 131080, pg_backend_pid: 36307
20251211090520 
$ rails db:migrate:down:main VERSION=20251211090520 && rails db:migrate:down:ci VERSION=20251211090520
DEPRECATION WARNING: `config.active_record.warn_on_records_fetched_greater_than` is deprecated and will be removed in Rails 8.0. Please subscribe to `sql.active_record` notifications and access the row count field to detect large result set sizes. (called from <main> at /Users/david/projects/gitlab-development-kit/gitlab/config/environment.rb:7)
main: == [advisory_lock_connection] object_id: 131080, pg_backend_pid: 36478
main: == 20251211090520 DropPackageFileForeignKeyFromVirtualRegistriesPkgsMvnCacheLocalEntries: reverting 
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_00 ADD CONSTRAINT fk_rails_0300080a73 FOREIGN KEY (package_file_id) REFERENCES packages_package_files (id) ON DELETE CASCADE NOT VALID;")
main:    -> 0.0022s
main: -- execute("SET statement_timeout TO 0")
main:    -> 0.0004s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_00 VALIDATE CONSTRAINT fk_rails_0300080a73;")
main:    -> 0.0064s
main: -- execute("RESET statement_timeout")
main:    -> 0.0005s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_01 ADD CONSTRAINT fk_rails_0300080a73 FOREIGN KEY (package_file_id) REFERENCES packages_package_files (id) ON DELETE CASCADE NOT VALID;")
main:    -> 0.0008s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_01 VALIDATE CONSTRAINT fk_rails_0300080a73;")
main:    -> 0.0010s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_02 ADD CONSTRAINT fk_rails_0300080a73 FOREIGN KEY (package_file_id) REFERENCES packages_package_files (id) ON DELETE CASCADE NOT VALID;")
main:    -> 0.0009s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_02 VALIDATE CONSTRAINT fk_rails_0300080a73;")
main:    -> 0.0011s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_03 ADD CONSTRAINT fk_rails_0300080a73 FOREIGN KEY (package_file_id) REFERENCES packages_package_files (id) ON DELETE CASCADE NOT VALID;")
main:    -> 0.0019s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_03 VALIDATE CONSTRAINT fk_rails_0300080a73;")
main:    -> 0.0013s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_04 ADD CONSTRAINT fk_rails_0300080a73 FOREIGN KEY (package_file_id) REFERENCES packages_package_files (id) ON DELETE CASCADE NOT VALID;")
main:    -> 0.0006s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_04 VALIDATE CONSTRAINT fk_rails_0300080a73;")
main:    -> 0.0008s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_05 ADD CONSTRAINT fk_rails_0300080a73 FOREIGN KEY (package_file_id) REFERENCES packages_package_files (id) ON DELETE CASCADE NOT VALID;")
main:    -> 0.0009s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_05 VALIDATE CONSTRAINT fk_rails_0300080a73;")
main:    -> 0.0017s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_06 ADD CONSTRAINT fk_rails_0300080a73 FOREIGN KEY (package_file_id) REFERENCES packages_package_files (id) ON DELETE CASCADE NOT VALID;")
main:    -> 0.0009s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_06 VALIDATE CONSTRAINT fk_rails_0300080a73;")
main:    -> 0.0011s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_07 ADD CONSTRAINT fk_rails_0300080a73 FOREIGN KEY (package_file_id) REFERENCES packages_package_files (id) ON DELETE CASCADE NOT VALID;")
main:    -> 0.0007s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_07 VALIDATE CONSTRAINT fk_rails_0300080a73;")
main:    -> 0.0011s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_08 ADD CONSTRAINT fk_rails_0300080a73 FOREIGN KEY (package_file_id) REFERENCES packages_package_files (id) ON DELETE CASCADE NOT VALID;")
main:    -> 0.0006s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_08 VALIDATE CONSTRAINT fk_rails_0300080a73;")
main:    -> 0.0011s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_09 ADD CONSTRAINT fk_rails_0300080a73 FOREIGN KEY (package_file_id) REFERENCES packages_package_files (id) ON DELETE CASCADE NOT VALID;")
main:    -> 0.0006s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_09 VALIDATE CONSTRAINT fk_rails_0300080a73;")
main:    -> 0.0010s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_10 ADD CONSTRAINT fk_rails_0300080a73 FOREIGN KEY (package_file_id) REFERENCES packages_package_files (id) ON DELETE CASCADE NOT VALID;")
main:    -> 0.0011s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_10 VALIDATE CONSTRAINT fk_rails_0300080a73;")
main:    -> 0.0011s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_11 ADD CONSTRAINT fk_rails_0300080a73 FOREIGN KEY (package_file_id) REFERENCES packages_package_files (id) ON DELETE CASCADE NOT VALID;")
main:    -> 0.0008s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_11 VALIDATE CONSTRAINT fk_rails_0300080a73;")
main:    -> 0.0009s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_12 ADD CONSTRAINT fk_rails_0300080a73 FOREIGN KEY (package_file_id) REFERENCES packages_package_files (id) ON DELETE CASCADE NOT VALID;")
main:    -> 0.0007s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_12 VALIDATE CONSTRAINT fk_rails_0300080a73;")
main:    -> 0.0010s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_13 ADD CONSTRAINT fk_rails_0300080a73 FOREIGN KEY (package_file_id) REFERENCES packages_package_files (id) ON DELETE CASCADE NOT VALID;")
main:    -> 0.0032s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_13 VALIDATE CONSTRAINT fk_rails_0300080a73;")
main:    -> 0.0009s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_14 ADD CONSTRAINT fk_rails_0300080a73 FOREIGN KEY (package_file_id) REFERENCES packages_package_files (id) ON DELETE CASCADE NOT VALID;")
main:    -> 0.0006s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_14 VALIDATE CONSTRAINT fk_rails_0300080a73;")
main:    -> 0.0010s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_15 ADD CONSTRAINT fk_rails_0300080a73 FOREIGN KEY (package_file_id) REFERENCES packages_package_files (id) ON DELETE CASCADE NOT VALID;")
main:    -> 0.0007s
main: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_15 VALIDATE CONSTRAINT fk_rails_0300080a73;")
main:    -> 0.0010s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- execute("ALTER TABLE virtual_registries_packages_maven_cache_local_entries ADD CONSTRAINT fk_rails_0300080a73 FOREIGN KEY (package_file_id) REFERENCES packages_package_files (id) ON DELETE CASCADE ;")
main:    -> 0.0028s
main: -- execute("ALTER TABLE virtual_registries_packages_maven_cache_local_entries VALIDATE CONSTRAINT fk_rails_0300080a73;")
main:    -> 0.0004s
main: == 20251211090520 DropPackageFileForeignKeyFromVirtualRegistriesPkgsMvnCacheLocalEntries: reverted (0.3836s) 

main: == [advisory_lock_connection] object_id: 131080, pg_backend_pid: 36478
DEPRECATION WARNING: `config.active_record.warn_on_records_fetched_greater_than` is deprecated and will be removed in Rails 8.0. Please subscribe to `sql.active_record` notifications and access the row count field to detect large result set sizes. (called from <main> at /Users/david/projects/gitlab-development-kit/gitlab/config/environment.rb:7)
ci: == [advisory_lock_connection] object_id: 131080, pg_backend_pid: 36627
ci: == 20251211090520 DropPackageFileForeignKeyFromVirtualRegistriesPkgsMvnCacheLocalEntries: reverting 
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_00 ADD CONSTRAINT fk_rails_0300080a73 FOREIGN KEY (package_file_id) REFERENCES packages_package_files (id) ON DELETE CASCADE NOT VALID;")
ci:    -> 0.0038s
ci: -- execute("SET statement_timeout TO 0")
ci:    -> 0.0003s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_00 VALIDATE CONSTRAINT fk_rails_0300080a73;")
ci:    -> 0.0057s
ci: -- execute("RESET statement_timeout")
ci:    -> 0.0003s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_01 ADD CONSTRAINT fk_rails_0300080a73 FOREIGN KEY (package_file_id) REFERENCES packages_package_files (id) ON DELETE CASCADE NOT VALID;")
ci:    -> 0.0007s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_01 VALIDATE CONSTRAINT fk_rails_0300080a73;")
ci:    -> 0.0010s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_02 ADD CONSTRAINT fk_rails_0300080a73 FOREIGN KEY (package_file_id) REFERENCES packages_package_files (id) ON DELETE CASCADE NOT VALID;")
ci:    -> 0.0005s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_02 VALIDATE CONSTRAINT fk_rails_0300080a73;")
ci:    -> 0.0008s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_03 ADD CONSTRAINT fk_rails_0300080a73 FOREIGN KEY (package_file_id) REFERENCES packages_package_files (id) ON DELETE CASCADE NOT VALID;")
ci:    -> 0.0015s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_03 VALIDATE CONSTRAINT fk_rails_0300080a73;")
ci:    -> 0.0010s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_04 ADD CONSTRAINT fk_rails_0300080a73 FOREIGN KEY (package_file_id) REFERENCES packages_package_files (id) ON DELETE CASCADE NOT VALID;")
ci:    -> 0.0007s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_04 VALIDATE CONSTRAINT fk_rails_0300080a73;")
ci:    -> 0.0009s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_05 ADD CONSTRAINT fk_rails_0300080a73 FOREIGN KEY (package_file_id) REFERENCES packages_package_files (id) ON DELETE CASCADE NOT VALID;")
ci:    -> 0.0038s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_05 VALIDATE CONSTRAINT fk_rails_0300080a73;")
ci:    -> 0.0010s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_06 ADD CONSTRAINT fk_rails_0300080a73 FOREIGN KEY (package_file_id) REFERENCES packages_package_files (id) ON DELETE CASCADE NOT VALID;")
ci:    -> 0.0006s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_06 VALIDATE CONSTRAINT fk_rails_0300080a73;")
ci:    -> 0.0012s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_07 ADD CONSTRAINT fk_rails_0300080a73 FOREIGN KEY (package_file_id) REFERENCES packages_package_files (id) ON DELETE CASCADE NOT VALID;")
ci:    -> 0.0006s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_07 VALIDATE CONSTRAINT fk_rails_0300080a73;")
ci:    -> 0.0011s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_08 ADD CONSTRAINT fk_rails_0300080a73 FOREIGN KEY (package_file_id) REFERENCES packages_package_files (id) ON DELETE CASCADE NOT VALID;")
ci:    -> 0.0005s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_08 VALIDATE CONSTRAINT fk_rails_0300080a73;")
ci:    -> 0.0007s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_09 ADD CONSTRAINT fk_rails_0300080a73 FOREIGN KEY (package_file_id) REFERENCES packages_package_files (id) ON DELETE CASCADE NOT VALID;")
ci:    -> 0.0005s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_09 VALIDATE CONSTRAINT fk_rails_0300080a73;")
ci:    -> 0.0007s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_10 ADD CONSTRAINT fk_rails_0300080a73 FOREIGN KEY (package_file_id) REFERENCES packages_package_files (id) ON DELETE CASCADE NOT VALID;")
ci:    -> 0.0005s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_10 VALIDATE CONSTRAINT fk_rails_0300080a73;")
ci:    -> 0.0008s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_11 ADD CONSTRAINT fk_rails_0300080a73 FOREIGN KEY (package_file_id) REFERENCES packages_package_files (id) ON DELETE CASCADE NOT VALID;")
ci:    -> 0.0006s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_11 VALIDATE CONSTRAINT fk_rails_0300080a73;")
ci:    -> 0.0010s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_12 ADD CONSTRAINT fk_rails_0300080a73 FOREIGN KEY (package_file_id) REFERENCES packages_package_files (id) ON DELETE CASCADE NOT VALID;")
ci:    -> 0.0006s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_12 VALIDATE CONSTRAINT fk_rails_0300080a73;")
ci:    -> 0.0008s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_13 ADD CONSTRAINT fk_rails_0300080a73 FOREIGN KEY (package_file_id) REFERENCES packages_package_files (id) ON DELETE CASCADE NOT VALID;")
ci:    -> 0.0005s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_13 VALIDATE CONSTRAINT fk_rails_0300080a73;")
ci:    -> 0.0007s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_14 ADD CONSTRAINT fk_rails_0300080a73 FOREIGN KEY (package_file_id) REFERENCES packages_package_files (id) ON DELETE CASCADE NOT VALID;")
ci:    -> 0.0009s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_14 VALIDATE CONSTRAINT fk_rails_0300080a73;")
ci:    -> 0.0012s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_15 ADD CONSTRAINT fk_rails_0300080a73 FOREIGN KEY (package_file_id) REFERENCES packages_package_files (id) ON DELETE CASCADE NOT VALID;")
ci:    -> 0.0006s
ci: -- execute("ALTER TABLE gitlab_partitions_static.virtual_registries_packages_maven_cache_local_entries_15 VALIDATE CONSTRAINT fk_rails_0300080a73;")
ci:    -> 0.0011s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- execute("ALTER TABLE virtual_registries_packages_maven_cache_local_entries ADD CONSTRAINT fk_rails_0300080a73 FOREIGN KEY (package_file_id) REFERENCES packages_package_files (id) ON DELETE CASCADE ;")
ci:    -> 0.0030s
ci: -- execute("ALTER TABLE virtual_registries_packages_maven_cache_local_entries VALIDATE CONSTRAINT fk_rails_0300080a73;")
ci:    -> 0.0005s
ci: == 20251211090520 DropPackageFileForeignKeyFromVirtualRegistriesPkgsMvnCacheLocalEntries: reverted (0.4999s) 

ci: == [advisory_lock_connection] object_id: 131080, pg_backend_pid: 36627
Edited by David Fernandez

Merge request reports