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
fromanalytics_repository_files
table. - Removing FK on
projects
fromanalytics_repository_file_edits
table. - Removing FK on
projects
fromanalytics_repository_file_commits
table. - Removing FK on
analytics_repository_files
fromanalytics_repository_file_edits
table. - Removing FK on
analytics_repository_files
fromanalytics_repository_file_commits
table. - Dropping
analytics_repository_files
,analytics_repository_file_commits
andanalytics_repository_file_edits
tables.
Additional tasks
- Coordinate with
delivery
group for getting access to thelog/migrations.log
file. - Create a revert MR so we can undo things in case the retry mechanism fails.
Related issue: #196733 (closed)