1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
|
# frozen_string_literal: true
class BackfillPkConversionForSelfManaged < ActiveRecord::Migration[6.0]
include Gitlab::Database::MigrationHelpers
disable_ddl_transaction!
CONVERSIONS = [
{ table: :events, columns: %i(id), sub_batch_size: 500 },
{ table: :push_event_payloads, columns: %i(event_id), sub_batch_size: 2500, primary_key: :event_id },
{ table: :ci_job_artifacts, columns: %i(id job_id), sub_batch_size: 2000 },
{ table: :ci_sources_pipelines, columns: %i(source_job_id), sub_batch_size: 100 },
{ table: :ci_build_needs, columns: %i(build_id), sub_batch_size: 1000 },
{ table: :ci_builds, columns: %i(id stage_id), sub_batch_size: 250 },
{ table: :ci_builds_runner_session, columns: %i(build_id), sub_batch_size: 5000 },
{ table: :ci_build_trace_chunks, columns: %i(build_id), sub_batch_size: 1000 }
]
def up
return unless should_run?
CONVERSIONS.each do |conversion|
backfill_conversion_of_integer_to_bigint(
conversion[:table], conversion[:columns],
sub_batch_size: conversion[:sub_batch_size], primary_key: conversion.fetch(:primary_key, :id)
)
end
end
def down
return unless should_run?
CONVERSIONS.each do |conversion|
revert_backfill_conversion_of_integer_to_bigint(
conversion[:table], conversion[:columns],
primary_key: conversion.fetch(:primary_key, :id)
)
end
end
private
def should_run?
!Gitlab.com?
end
end
|
