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
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
|
# frozen_string_literal: true
module Gitlab
module Database
module Partitioning
class SlidingListStrategy
attr_reader :model, :partitioning_key, :next_partition_if, :detach_partition_if
delegate :table_name, to: :model
def initialize(model, partitioning_key, next_partition_if:, detach_partition_if:)
@model = model
@partitioning_key = partitioning_key
@next_partition_if = next_partition_if
@detach_partition_if = detach_partition_if
ensure_partitioning_column_ignored_or_readonly!
end
def current_partitions
Gitlab::Database::PostgresPartition.for_parent_table(table_name).map do |partition|
SingleNumericListPartition.from_sql(table_name, partition.name, partition.condition)
end.sort
end
def missing_partitions
if no_partitions_exist?
[initial_partition]
elsif next_partition_if.call(active_partition)
[next_partition]
else
[]
end
end
def initial_partition
SingleNumericListPartition.new(table_name, 1)
end
def next_partition
SingleNumericListPartition.new(table_name, active_partition.value + 1)
end
def extra_partitions
possibly_extra = current_partitions[0...-1] # Never consider the most recent partition
extra = possibly_extra.take_while { |p| detach_partition_if.call(p) }
default_value = current_default_value
if extra.any? { |p| p.value == default_value }
Gitlab::AppLogger.error(
message: "Inconsistent partition detected: partition with value #{current_default_value} should " \
"not be deleted because it's used as the default value.",
partition_number: current_default_value,
table_name: model.table_name
)
extra = extra.reject { |p| p.value == default_value }
end
extra
end
def after_adding_partitions
active_value = active_partition.value
model.connection.change_column_default(model.table_name, partitioning_key, active_value)
end
def active_partition
# The current partitions list is sorted, so the last partition has the highest value
# This is the only partition that receives inserts.
current_partitions.last
end
def no_partitions_exist?
current_partitions.empty?
end
def validate_and_fix
return if no_partitions_exist?
old_default_value = current_default_value
expected_default_value = active_partition.value
if old_default_value != expected_default_value
with_lock_retries do
model.connection.execute("LOCK TABLE #{model.table_name} IN ACCESS EXCLUSIVE MODE")
old_default_value = current_default_value
expected_default_value = active_partition.value
if old_default_value == expected_default_value
Gitlab::AppLogger.warn(
message: "Table partitions or partition key default value have been changed by another process",
table_name: table_name,
default_value: expected_default_value
)
raise ActiveRecord::Rollback
end
model.connection.change_column_default(model.table_name, partitioning_key, expected_default_value)
Gitlab::AppLogger.warn(
message: "Fixed default value of sliding_list_strategy partitioning_key",
column: partitioning_key,
table_name: table_name,
connection_name: model.connection.pool.db_config.name,
old_value: old_default_value,
new_value: expected_default_value
)
end
end
end
private
def current_default_value
column_name = model.connection.quote(partitioning_key)
table_name = model.connection.quote(model.table_name)
value = model.connection.select_value <<~SQL
SELECT columns.column_default AS default_value
FROM information_schema.columns columns
WHERE columns.column_name = #{column_name} AND columns.table_name = #{table_name}
SQL
raise "No default value found for the #{partitioning_key} column within #{model.name}" if value.nil?
Integer(value)
end
def ensure_partitioning_column_ignored_or_readonly!
unless key_ignored_or_readonly?
raise "Add #{partitioning_key} to #{model.name}.ignored_columns or " \
"mark it as readonly to use it with SlidingListStrategy"
end
end
def key_ignored_or_readonly?
model.ignored_columns.include?(partitioning_key.to_s) || model.readonly_attribute?(partitioning_key.to_s)
end
def with_lock_retries(&block)
Gitlab::Database::WithLockRetries.new(
klass: self.class,
logger: Gitlab::AppLogger,
connection: model.connection
).run(&block)
end
end
end
end
end
|