Skip to content

Background migrations still running for over 24 hours

We successfully upgraded to 18.4.1-ce.0.el8. We have 3 background migrations that still show active.

 id  |            job_class_name             |    table_name    | column_name | job_arguments
-----+---------------------------------------+------------------+-------------+---------------
 326 | SetProjectVulnerabilityCount          | project_settings | project_id  | []
 614 | ResetAutoDuoCodeReviewFalseValues     | project_settings | project_id  | []
 628 | ResetDuoRemoteFlowsEnabledFalseValues | project_settings | project_id  | []
(3 rows)

All three show the same result

SELECT
  started_at,
  finished_at,
  finished_at - started_at AS duration,
  min_value,
  max_value,
  batch_size,
  sub_batch_size
FROM batched_background_migration_jobs
WHERE batched_background_migration_id = 326
ORDER BY id DESC
LIMIT 10;

started_at | finished_at | duration | min_value | max_value | batch_size | sub_batch_size
------------+-------------+----------+-----------+-----------+------------+----------------
(0 rows)
Edited by Max Orefice