Skip to content

Use with_lock_retries helper to remove code hotspot tables

This issue is to verify whether the newly introduced migration helper method implemented in !22479 (merged) is able to remove tables from the production database.

Plan

(copied from !22479 (comment 273121446))

Create an MR with the following migrations

  • Removing FK on projects from analytics_repository_files table.
  • Removing FK on projects from analytics_repository_file_edits table.
  • Removing FK on projects from analytics_repository_file_commits table.
  • Removing FK on analytics_repository_files from analytics_repository_file_edits table.
  • Removing FK on analytics_repository_files from analytics_repository_file_commits table.
  • Dropping analytics_repository_files, analytics_repository_file_commits and analytics_repository_file_edits tables.

Additional tasks

  • Coordinate with delivery group for getting access to the log/migrations.log file.
  • Create a revert MR so we can undo things in case the retry mechanism fails.

Related issue: #196733 (closed)