Docs feedback: gitlab:background_migrations:finalize[BackfillMergeRequestDiffsProjectId

document suggests that below command. could be used to complete the jobs stuck in finalizing stage but this command really does not do anything.

sudo -u git -H bundle exec rake "gitlab:background_migrations:finalize[BackfillMergeRequestDiffsProjectId,'merge_request_diffs','id',[]]" --trace RAILS_ENV=production

I have an ongoing issue where some of the background migration jobs are stuck in finalizing stage (version 16.7.7) and now I am unable to upgrade as some of the rows in table merge_request_diffs. are NULL (which has NOT_NULL constraint) on it.

Any suggestion on how to complete these stuck jobs?

This issue was automatically tagged with the label grouppipeline execution by TanukiStan, a machine learning classification model, with a probability of 0.9.

If this label is incorrect, please tag this issue with the correct group label as well as automation:ml wrong to help TanukiStan learn from its mistakes.

If you are unsure about the correct group, please do not leave the issue without a group label. Please refer to GitLab's shared responsibility functionality guidelines for more information on how to triage this kind of issues.

Authors who do not have permission to update labels can use the @gitlab-bot label ~"group::<correct group name>" command, or leave the issue to be triaged by group leaders initially assigned by TanukiStan.

This message was generated automatically. You're welcome to improve it.

added automation:ml grouppipeline execution labels

added devopsverify sectionci labels

Hey @arunmodgil, thank you for creating this issue!

To get the right eyes on your issue more quickly, we encourage you to follow the issue triage best practices.

PLEASE NOTE: You will need to use the @gitlab-bot label command to apply labels to this issue.

To set expectations, GitLab product managers or team members can't make any promise if they will proceed with this. However, we believe everyone can contribute, and welcome you to work on this proposed change, feature or bug fix. There is a bias for action, so you don't need to wait. Try and spin up that merge request yourself.

If you need help doing so, we're always open to mentor you to drive this change.

This message was generated automatically. You're welcome to improve it.

added automation:self-triage-encouraged label

mentioned in issue gitlab-org/quality/triage-reports#17274 (closed)

added Category:Continuous Integration label

changed milestone to %Backlog

added documentation label

added groupdatabase label and removed grouppipeline execution label

added Category:Database label

removed Category:Continuous Integration label

perhaps groupdatabase

fyi @rogerwoo @alexives

Adding to @gitlab-org/database-team/triage

mentioned in issue gitlab-org/quality/triage-reports#17350 (closed)

mentioned in issue gitlab-org/database-team/team-tasks#431 (closed)

mentioned in issue gitlab-org/quality/triage-reports#17448 (closed)

@arunmodgil - The command you have produced is slightly different than the expected format for job_arguments (empty array). This doc has the correct format and the below script should finalize the expected batched migration.

sudo gitlab-rake gitlab:background_migrations:finalize[BackfillMergeRequestDiffsProjectId, merge_request_diffs, id, '[]']

mentioned in issue gitlab-org/database-team/team-tasks#433 (closed)

mentioned in issue gitlab-org/quality/triage-reports#17616 (closed)

mentioned in issue gitlab-org/database-team/team-tasks#434 (closed)

mentioned in issue gitlab-org/quality/triage-reports#17718 (closed)

mentioned in issue gitlab-org/database-team/team-tasks#435 (closed)

Thanks @praba.m7n The command that worked for me is

sudo -u git -H bundle exec rake gitlab:background_migrations:finalize[BackfillMergeRequestDiffsProjectId,merge_request_diffs,id,'[]'] RAILS_ENV=production

Below command threw me an error

sudo gitlab-rake gitlab:background_migrations:finalize[BackfillMergeRequestDiffsProjectId, merge_request_diffs, id, '[]']

closed

added typemaintenance label

added groupdatabase frameworks label and removed groupdatabase [DEPRECATED] label