-
Notifications
You must be signed in to change notification settings - Fork 387
/
list_verify_segments.go
221 lines (189 loc) · 5.87 KB
/
list_verify_segments.go
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
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
// Copyright (C) 2022 Storj Labs, Inc.
// See LICENSE for copying information.
package metabase
import (
"context"
"time"
"storj.io/common/storj"
"storj.io/common/uuid"
"storj.io/private/dbutil/pgutil"
"storj.io/private/tagsql"
)
// ListVerifyLimit is the maximum number of items the client can request for listing.
const ListVerifyLimit = intLimitRange(100000)
// ListVerifySegments contains arguments necessary for listing stream segments.
type ListVerifySegments struct {
CursorStreamID uuid.UUID
CursorPosition SegmentPosition
StreamIDs []uuid.UUID
Limit int
AsOfSystemTime time.Time
AsOfSystemInterval time.Duration
}
// ListVerifySegmentsResult is the result of ListVerifySegments.
type ListVerifySegmentsResult struct {
Segments []VerifySegment
}
// VerifySegment result of listing segments for verifying remote segments.
type VerifySegment struct {
StreamID uuid.UUID
Position SegmentPosition
CreatedAt time.Time
RepairedAt *time.Time
RootPieceID storj.PieceID
Redundancy storj.RedundancyScheme
AliasPieces AliasPieces
}
func (opts *ListVerifySegments) getQueryAndParameters(asof string) (string, []interface{}) {
if len(opts.StreamIDs) == 0 {
return `
SELECT
stream_id, position,
created_at, repaired_at,
root_piece_id, redundancy,
remote_alias_pieces
FROM segments
` + asof + `
WHERE
(stream_id, position) > ($1, $2) AND
inline_data IS NULL AND
remote_alias_pieces IS NOT NULL
ORDER BY stream_id ASC, position ASC
LIMIT $3
`, []interface{}{
opts.CursorStreamID,
opts.CursorPosition,
opts.Limit,
}
}
return `
SELECT
segments.stream_id, segments.position,
segments.created_at, segments.repaired_at,
segments.root_piece_id, segments.redundancy,
segments.remote_alias_pieces
FROM segments
` + asof + `
WHERE
stream_id = ANY($1) AND
(segments.stream_id, segments.position) > ($2, $3) AND
segments.inline_data IS NULL AND
segments.remote_alias_pieces IS NOT NULL
ORDER BY segments.stream_id ASC, segments.position ASC
LIMIT $4
`, []interface{}{
pgutil.UUIDArray(opts.StreamIDs),
opts.CursorStreamID,
opts.CursorPosition,
opts.Limit,
}
}
// ListVerifySegments lists specified stream segments.
func (db *DB) ListVerifySegments(ctx context.Context, opts ListVerifySegments) (result ListVerifySegmentsResult, err error) {
defer mon.Task()(&ctx)(&err)
if opts.Limit <= 0 {
return ListVerifySegmentsResult{}, ErrInvalidRequest.New("invalid limit: %d", opts.Limit)
}
ListVerifyLimit.Ensure(&opts.Limit)
result.Segments = make([]VerifySegment, 0, opts.Limit)
asOfString := db.asOfTime(opts.AsOfSystemTime, opts.AsOfSystemInterval)
query, parameters := opts.getQueryAndParameters(asOfString)
err = withRows(db.db.QueryContext(ctx, query, parameters...))(func(rows tagsql.Rows) error {
for rows.Next() {
var seg VerifySegment
err := rows.Scan(
&seg.StreamID,
&seg.Position,
&seg.CreatedAt,
&seg.RepairedAt,
&seg.RootPieceID,
redundancyScheme{&seg.Redundancy},
&seg.AliasPieces,
)
if err != nil {
return Error.Wrap(err)
}
result.Segments = append(result.Segments, seg)
}
return nil
})
return result, Error.Wrap(err)
}
// ListVerifyBucketList represents a list of buckets.
type ListVerifyBucketList struct {
Buckets []BucketLocation
}
// Add adds a (projectID, bucketName) to the list of buckets to be checked.
func (list *ListVerifyBucketList) Add(projectID uuid.UUID, bucketName string) {
list.Buckets = append(list.Buckets, BucketLocation{
ProjectID: projectID,
BucketName: bucketName,
})
}
// ListBucketsStreamIDsResult is the result of listing segments of a list of buckets.
type ListBucketsStreamIDsResult struct {
StreamIDs []uuid.UUID
Counts []int
LastBucket BucketLocation
}
func (list *ListBucketsStreamIDsResult) addStreamID(streamID uuid.UUID, count int) {
list.StreamIDs = append(list.StreamIDs, streamID)
list.Counts = append(list.Counts, count)
}
// ListBucketsStreamIDs contains arguments necessary for listing stream segments from buckets.
type ListBucketsStreamIDs struct {
BucketList ListVerifyBucketList
CursorBucket BucketLocation
CursorStreamID uuid.UUID
Limit int
AsOfSystemTime time.Time
AsOfSystemInterval time.Duration
}
// ListBucketsStreamIDs lists the streamIDs of a list of buckets.
func (db *DB) ListBucketsStreamIDs(ctx context.Context, opts ListBucketsStreamIDs) (ListBucketsStreamIDsResult, error) {
if opts.Limit <= 0 {
return ListBucketsStreamIDsResult{}, ErrInvalidRequest.New("invalid limit: %d", opts.Limit)
}
ListVerifyLimit.Ensure(&opts.Limit)
result := ListBucketsStreamIDsResult{}
bucketNamesBytes := [][]byte{}
projectIDs := []uuid.UUID{}
for _, bucket := range opts.BucketList.Buckets {
bucketNamesBytes = append(bucketNamesBytes, []byte(bucket.BucketName))
projectIDs = append(projectIDs, bucket.ProjectID)
}
// get the list of stream_ids and segment counts from the objects table
err := withRows(db.db.QueryContext(ctx, `
SELECT DISTINCT project_id, bucket_name, stream_id, segment_count
FROM objects
`+db.asOfTime(opts.AsOfSystemTime, opts.AsOfSystemInterval)+`
WHERE
(project_id, bucket_name, stream_id) > ($4::BYTEA, $5::BYTEA, $6::BYTEA) AND
(project_id, bucket_name) IN (SELECT UNNEST($1::BYTEA[]),UNNEST($2::BYTEA[]))
ORDER BY project_id, bucket_name, stream_id ASC
LIMIT $3
`, pgutil.UUIDArray(projectIDs), pgutil.ByteaArray(bucketNamesBytes),
opts.Limit,
opts.CursorBucket.ProjectID, opts.CursorBucket.BucketName, opts.CursorStreamID,
))(func(rows tagsql.Rows) error {
for rows.Next() {
var streamID uuid.UUID
var count int
err := rows.Scan(
&result.LastBucket.ProjectID,
&result.LastBucket.BucketName,
&streamID,
&count,
)
if err != nil {
return Error.Wrap(err)
}
result.addStreamID(streamID, count)
}
return nil
})
if err != nil {
return ListBucketsStreamIDsResult{}, err
}
return result, nil
}