Project

General

Profile

Actions

Bug #29543

closed

AddDockerTagJoinTable and AddDockerMetaTagJoinTable migrations take too long

Added by Ian Ballou about 4 years ago. Updated almost 4 years ago.

Status:
Rejected
Priority:
Normal
Assignee:
-
Category:
-
Target version:
Difficulty:
Triaged:
Yes
Fixed in Releases:
Found in Releases:

Description

For environments with a large number of repos, this migration takes a long time even if there aren't any docker tags. I believe it's due to the block that runs through each repo and updates its tags/meta_tags. We could probably query instead for the repositories that have tags and update those.

Reference: https://github.com/Katello/katello/blob/master/db/migrate/20190730183518_add_docker_tag_join_table.rb#L9

Actions #1

Updated by Ian Ballou about 4 years ago

After a test with ~8.5k repos, the migration was significantly faster when only migrating Repository.docker_type

Actions #2

Updated by Jonathon Turel almost 4 years ago

  • Status changed from New to Rejected
  • Target version set to Katello Recycle Bin
  • Triaged changed from No to Yes
Actions

Also available in: Atom PDF