Out-of-memory running 20171121135738 CleanUpFromMergeRequestDiffsAndCommits
It appears on the deploy staging, the Linux OOM killer terminated the Rails process while it was running the migration 20171121135738 CleanUpFromMergeRequestDiffsAndCommits
. top
showed that over 3 GB RAM was being used.
It looks like the migration works in batches of 500, which may be too large if there are large diffs.
The last SQL query appeared to be:
SELECT "merge_request_diffs"."id", "merge_request_diffs"."st_commits", "merge_request_diffs"."st_diffs" FROM "merge_request_diffs" WHERE (st_commits IS NOT NULL OR st_diffs IS NOT NULL) AND ("merge_request_diffs"."id" BETWEEN 144057 AND 965665)
/cc: @smcgivern, @yorickpeterse
Edited by Stan Hu