review-qa-smoke failing to create a merge request due to data migration state

Description

review-qa-smoke fails with Create Create a new merge request creates a basic merge request

QA::Page::Validatable::PageValidationError:
       discussion_filter_dropdown did not appear on QA::Page::MergeRequest::Show as expected
     # ./qa/page/validatable.rb:15:in `block in validate_elements_present!'
     # ./qa/page/validatable.rb:13:in `each'
     # ./qa/page/validatable.rb:13:in `validate_elements_present!'
     # ./qa/page/base.rb:207:in `click_element'
     # ./qa/support/page/logging.rb:80:in `click_element'
     # ./qa/page/merge_request/new.rb:31:in `create_merge_request'
     # ./qa/resource/merge_request.rb:88:in `block in fabricate!'
     # ./qa/scenario/actable.rb:16:in `perform

GCP logs indicate that there's a migration error ERROR: column "author_name" of relation "merge_request_diff_commits" does not exist at character 225 and shuts down

Events

More context here

1. 2021-10-25 11:25 UTC - !72219 (merged) merged
2. A number of review apps were deployed with the migration
3. 2021-10-26 01:48 UTC - !73035 (merged) reverted the migration
4. 2021-10-27 17:07 UTC - !73068 (merged) restored the migration

Solution

Review apps that were first deployed between 2021-10-25 11:25 UTC and 2021-10-26 01:48 UTC will have this error.

This may be fixed by running review-stop and re-running a new pipeline.