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