Cleanup Debian incoming files daily
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