gitlabhq_production=# select * from batched_background_migrations;
id | created_at | updated_at | min_value | max_value | batch_size | sub_batch_size | interval | status | job_class_name | batch_class_name | table_name | column_name | job_arguments
| total_tuple_count | pause_ms
----±------------------------------±------------------------------±----------±----------±-----------±---------------±---------±-------±--------------------------------------±---------------------------±--------------------------------±------------±--------------------------------------------------------
---------------------------±------------------±---------
1 | 2021-07-05 12:26:16.396198+00 | 2021-07-05 12:26:16.396198+00 | 1 | 1 | 15000 | 100 | 120 | 3 | CopyColumnUsingBackgroundMigrationJob | PrimaryKeyBatchingStrategy | ci_build_trace_sections | build_id | [[“build_id”], [“build_id_convert_to_bigint”]]
| | 100
2 | 2021-07-05 12:26:16.662849+00 | 2021-07-05 12:26:16.668397+00 | 1 | 130 | 15000 | 100 | 120 | 1 | CopyColumnUsingBackgroundMigrationJob | PrimaryKeyBatchingStrategy | ci_builds_metadata | id | [[“build_id”], [“build_id_convert_to_bigint”]]
| 84 | 100
3 | 2021-07-05 12:26:16.680868+00 | 2021-07-05 12:26:16.686324+00 | 1 | 2820 | 20000 | 500 | 120 | 1 | CopyColumnUsingBackgroundMigrationJob | PrimaryKeyBatchingStrategy | events | id | [[“id”], [“id_convert_to_bigint”]]
| 2762 | 100
4 | 2021-07-05 12:26:16.691681+00 | 2021-07-05 12:26:16.696718+00 | 1 | 2820 | 20000 | 2500 | 120 | 1 | CopyColumnUsingBackgroundMigrationJob | PrimaryKeyBatchingStrategy | push_event_payloads | event_id | [[“event_id”], [“event_id_convert_to_bigint”]]
| 1257 | 100
5 | 2021-07-05 12:26:16.704958+00 | 2021-07-05 12:26:16.704958+00 | 1 | 1 | 20000 | 2000 | 120 | 3 | CopyColumnUsingBackgroundMigrationJob | PrimaryKeyBatchingStrategy | ci_job_artifacts | id | [[“id”, “job_id”], [“id_convert_to_bigint”, “job_id_conv
ert_to_bigint”]] | | 100
6 | 2021-07-05 12:26:16.715022+00 | 2021-07-05 12:26:16.715022+00 | 1 | 1 | 20000 | 100 | 120 | 3 | CopyColumnUsingBackgroundMigrationJob | PrimaryKeyBatchingStrategy | ci_sources_pipelines | id | [[“source_job_id”], [“source_job_id_convert_to_bigint”]]
| | 100
7 | 2021-07-05 12:26:16.725961+00 | 2021-07-05 12:26:16.725961+00 | 1 | 1 | 20000 | 1000 | 120 | 3 | CopyColumnUsingBackgroundMigrationJob | PrimaryKeyBatchingStrategy | ci_build_needs | id | [[“build_id”], [“build_id_convert_to_bigint”]]
| | 100
8 | 2021-07-05 12:26:16.746143+00 | 2021-07-05 12:26:16.751726+00 | 1 | 249 | 20000 | 250 | 120 | 1 | CopyColumnUsingBackgroundMigrationJob | PrimaryKeyBatchingStrategy | ci_builds | id | [[“id”, “stage_id”], [“id_convert_to_bigint”, “stage_id_
convert_to_bigint”]] | 216 | 100
9 | 2021-07-05 12:26:16.759154+00 | 2021-07-05 12:26:16.759154+00 | 1 | 1 | 20000 | 5000 | 120 | 3 | CopyColumnUsingBackgroundMigrationJob | PrimaryKeyBatchingStrategy | ci_builds_runner_session | id | [[“build_id”], [“build_id_convert_to_bigint”]]
| | 100
10 | 2021-07-05 12:26:16.770675+00 | 2021-07-05 12:26:16.770675+00 | 1 | 1 | 20000 | 1000 | 120 | 3 | CopyColumnUsingBackgroundMigrationJob | PrimaryKeyBatchingStrategy | ci_build_trace_chunks | id | [[“build_id”], [“build_id_convert_to_bigint”]]
| | 100
11 | 2021-07-05 12:26:16.804698+00 | 2021-07-05 12:26:16.804698+00 | 1 | 1 | 15000 | 100 | 120 | 3 | CopyColumnUsingBackgroundMigrationJob | PrimaryKeyBatchingStrategy | taggings | id | [[“id”, “taggable_id”], [“id_convert_to_bigint”, “taggab
le_id_convert_to_bigint”]] | | 100
12 | 2021-07-05 12:26:16.845565+00 | 2021-07-05 12:26:16.845565+00 | 1 | 1 | 20000 | 1000 | 120 | 3 | CopyColumnUsingBackgroundMigrationJob | PrimaryKeyBatchingStrategy | deployments | id | [[“deployable_id”], [“deployable_id_convert_to_bigint”]]
| | 100
13 | 2021-07-05 12:26:16.868583+00 | 2021-07-05 12:26:16.868583+00 | 1 | 1 | 20000 | 1000 | 120 | 3 | CopyColumnUsingBackgroundMigrationJob | PrimaryKeyBatchingStrategy | geo_job_artifact_deleted_events | id | [[“job_artifact_id”], [“job_artifact_id_convert_to_bigin
t”]] | | 100
14 | 2021-07-05 12:26:17.731005+00 | 2021-07-05 12:26:17.737291+00 | 1 | 124 | 20000 | 1000 | 120 | 1 | CopyColumnUsingBackgroundMigrationJob | PrimaryKeyBatchingStrategy | ci_stages | id | [[“id”], [“id_convert_to_bigint”]]
| 109 | 100
(14 rows)
It is unlikely that the problem in my actions was updated six months ago from off source. I have attached the solution above. But I don’t understand how to implement the current version inside.