Skip to content

Cleanup Debian incoming files daily

Mathieu Parent requested to merge sathieu/gitlab:debian_cleanup_dangling into master

What does this MR do and why?

Fixes #367538 (closed).

Migrations

main: == 20230329194244 AddIndexPackagesDebianFileMetadataWhenUnknown: migrating ====
main: -- transaction_open?()
main:    -> 0.0000s
main: -- view_exists?(:postgres_partitions)
main:    -> 0.1038s
main: -- index_exists?(:packages_debian_file_metadata, [:updated_at, :package_file_id], {:where=>"file_type = 1", :name=>"i_pkgs_deb_file_meta_on_updated_at_package_file_id_when_unknown", :algorithm=>:concurrently})
main:    -> 0.0037s
main: -- execute("SET statement_timeout TO 0")
main:    -> 0.0013s
main: -- add_index(:packages_debian_file_metadata, [:updated_at, :package_file_id], {:where=>"file_type = 1", :name=>"i_pkgs_deb_file_meta_on_updated_at_package_file_id_when_unknown", :algorithm=>:concurrently})
main:    -> 0.0105s
main: -- execute("RESET statement_timeout")
main:    -> 0.0008s
main: == 20230329194244 AddIndexPackagesDebianFileMetadataWhenUnknown: migrated (0.1550s) 

Below is outdated migration from older version of this MR.

main: == 20221230062827 CreateIndicesForCleanupDebianPackageFiles: migrating ========
main: -- transaction_open?()
main:    -> 0.0000s
main: -- view_exists?(:postgres_partitions)
main:    -> 0.0569s
main: -- index_exists?(:packages_package_files, [:package_id, :updated_at, :id], {:where=>"status != 1", :name=>"idx_packages_package_files_on_package_id_and_updated_at", :algorithm=>:concurrently})
main:    -> 0.0146s
main: -- execute("SET statement_timeout TO 0")
main:    -> 0.0010s
main: -- add_index(:packages_package_files, [:package_id, :updated_at, :id], {:where=>"status != 1", :name=>"idx_packages_package_files_on_package_id_and_updated_at", :algorithm=>:concurrently})
main:    -> 0.0036s
main: -- execute("RESET statement_timeout")
main:    -> 0.0014s
main: -- transaction_open?()
main:    -> 0.0000s
main: -- view_exists?(:postgres_partitions)
main:    -> 0.0016s
main: -- index_exists?(:packages_packages, :id, {:where=>"package_type = 9 AND version IS NULL AND name = 'incoming'", :name=>"idx_packages_packages_on_incoming_debian", :algorithm=>:concurrently})
main:    -> 0.0267s
main: -- add_index(:packages_packages, :id, {:where=>"package_type = 9 AND version IS NULL AND name = 'incoming'", :name=>"idx_packages_packages_on_incoming_debian", :algorithm=>:concurrently})
main:    -> 0.0041s
main: == 20221230062827 CreateIndicesForCleanupDebianPackageFiles: migrated (0.1564s)

main: == 20221230062827 CreateIndicesForCleanupDebianPackageFiles: reverting ========
main: -- transaction_open?()
main:    -> 0.0000s
main: -- view_exists?(:postgres_partitions)
main:    -> 0.0506s
main: -- indexes(:packages_package_files)
main:    -> 0.0223s
main: -- execute("SET statement_timeout TO 0")
main:    -> 0.0017s
main: -- remove_index(:packages_package_files, {:algorithm=>:concurrently, :name=>"idx_packages_package_files_on_package_id_and_updated_at"})
main:    -> 0.0043s
main: -- execute("RESET statement_timeout")
main:    -> 0.0018s
main: -- transaction_open?()
main:    -> 0.0000s
main: -- view_exists?(:postgres_partitions)
main:    -> 0.0024s
main: -- indexes(:packages_packages)
main:    -> 0.0247s
main: -- remove_index(:packages_packages, {:algorithm=>:concurrently, :name=>"idx_packages_packages_on_incoming_debian"})
main:    -> 0.0028s
main: == 20221230062827 CreateIndicesForCleanupDebianPackageFiles: reverted (0.1575s) 
Edited by Mathieu Parent

Merge request reports