Coverage Report

Created: 2026-03-13 19:42

next uncovered line (L), next uncovered region (R), next uncovered branch (B)
be/src/exec/spill/spill_stream_manager.cpp
Line
Count
Source
1
// Licensed to the Apache Software Foundation (ASF) under one
2
// or more contributor license agreements.  See the NOTICE file
3
// distributed with this work for additional information
4
// regarding copyright ownership.  The ASF licenses this file
5
// to you under the Apache License, Version 2.0 (the
6
// "License"); you may not use this file except in compliance
7
// with the License.  You may obtain a copy of the License at
8
//
9
//   http://www.apache.org/licenses/LICENSE-2.0
10
//
11
// Unless required by applicable law or agreed to in writing,
12
// software distributed under the License is distributed on an
13
// "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
14
// KIND, either express or implied.  See the License for the
15
// specific language governing permissions and limitations
16
// under the License.
17
18
#include "exec/spill/spill_stream_manager.h"
19
20
#include <fmt/format.h>
21
#include <glog/logging.h>
22
23
#include <algorithm>
24
#include <filesystem>
25
#include <memory>
26
#include <numeric>
27
#include <random>
28
#include <string>
29
30
#include "common/logging.h"
31
#include "common/metrics/doris_metrics.h"
32
#include "exec/spill/spill_stream.h"
33
#include "io/fs/file_system.h"
34
#include "io/fs/local_file_system.h"
35
#include "runtime/runtime_profile.h"
36
#include "runtime/runtime_state.h"
37
#include "storage/olap_define.h"
38
#include "util/parse_util.h"
39
#include "util/pretty_printer.h"
40
#include "util/time.h"
41
#include "util/uid_util.h"
42
43
namespace doris {
44
#include "common/compile_check_begin.h"
45
46
57
SpillStreamManager::~SpillStreamManager() {
47
57
    DorisMetrics::instance()->metric_registry()->deregister_entity(_entity);
48
57
}
49
SpillStreamManager::SpillStreamManager(
50
        std::unordered_map<std::string, std::unique_ptr<SpillDataDir>>&& spill_store_map)
51
68
        : _spill_store_map(std::move(spill_store_map)), _stop_background_threads_latch(1) {}
52
53
68
Status SpillStreamManager::init() {
54
68
    LOG(INFO) << "init spill stream manager";
55
68
    RETURN_IF_ERROR(_init_spill_store_map());
56
57
68
    for (const auto& [path, store] : _spill_store_map) {
58
68
        auto gc_dir_root_dir = store->get_spill_data_gc_path();
59
68
        bool exists = true;
60
68
        RETURN_IF_ERROR(io::global_local_filesystem()->exists(gc_dir_root_dir, &exists));
61
68
        if (!exists) {
62
12
            RETURN_IF_ERROR(io::global_local_filesystem()->create_directory(gc_dir_root_dir));
63
12
        }
64
65
68
        auto spill_dir = store->get_spill_data_path();
66
68
        RETURN_IF_ERROR(io::global_local_filesystem()->exists(spill_dir, &exists));
67
68
        if (!exists) {
68
12
            RETURN_IF_ERROR(io::global_local_filesystem()->create_directory(spill_dir));
69
56
        } else {
70
56
            auto suffix = ToStringFromUnixMillis(UnixMillis());
71
56
            auto gc_dir = store->get_spill_data_gc_path(suffix);
72
56
            if (std::filesystem::exists(gc_dir)) {
73
0
                LOG(WARNING) << "gc dir already exists: " << gc_dir;
74
0
            }
75
56
            (void)io::global_local_filesystem()->rename(spill_dir, gc_dir);
76
56
            RETURN_IF_ERROR(io::global_local_filesystem()->create_directory(spill_dir));
77
56
        }
78
68
    }
79
80
68
    RETURN_IF_ERROR(Thread::create(
81
68
            "Spill", "spill_gc_thread", [this]() { this->_spill_gc_thread_callback(); },
82
68
            &_spill_gc_thread));
83
68
    LOG(INFO) << "spill gc thread started";
84
85
68
    _init_metrics();
86
87
68
    return Status::OK();
88
68
}
89
90
68
void SpillStreamManager::_init_metrics() {
91
68
    _entity = DorisMetrics::instance()->metric_registry()->register_entity("spill",
92
68
                                                                           {{"name", "spill"}});
93
94
68
    _spill_write_bytes_metric = std::make_unique<doris::MetricPrototype>(
95
68
            doris::MetricType::COUNTER, doris::MetricUnit::BYTES, "spill_write_bytes");
96
68
    _spill_write_bytes_counter = (IntAtomicCounter*)(_entity->register_metric<IntAtomicCounter>(
97
68
            _spill_write_bytes_metric.get()));
98
99
68
    _spill_read_bytes_metric = std::make_unique<doris::MetricPrototype>(
100
68
            doris::MetricType::COUNTER, doris::MetricUnit::BYTES, "spill_read_bytes");
101
68
    _spill_read_bytes_counter = (IntAtomicCounter*)(_entity->register_metric<IntAtomicCounter>(
102
68
            _spill_read_bytes_metric.get()));
103
68
}
104
105
// clean up stale spilled files
106
68
void SpillStreamManager::_spill_gc_thread_callback() {
107
8.28k
    while (!_stop_background_threads_latch.wait_for(
108
8.28k
            std::chrono::milliseconds(config::spill_gc_interval_ms))) {
109
8.21k
        gc(config::spill_gc_work_time_ms);
110
8.22k
        for (auto& [path, dir] : _spill_store_map) {
111
8.22k
            static_cast<void>(dir->update_capacity());
112
8.22k
        }
113
8.21k
    }
114
68
}
115
116
68
Status SpillStreamManager::_init_spill_store_map() {
117
68
    for (const auto& store : _spill_store_map) {
118
68
        RETURN_IF_ERROR(store.second->init());
119
68
    }
120
121
68
    return Status::OK();
122
68
}
123
124
std::vector<SpillDataDir*> SpillStreamManager::_get_stores_for_spill(
125
230
        TStorageMedium::type storage_medium) {
126
230
    std::vector<std::pair<SpillDataDir*, double>> stores_with_usage;
127
230
    for (auto& [_, store] : _spill_store_map) {
128
230
        if (store->storage_medium() == storage_medium && !store->reach_capacity_limit(0)) {
129
115
            stores_with_usage.emplace_back(store.get(), store->_get_disk_usage(0));
130
115
        }
131
230
    }
132
230
    if (stores_with_usage.empty()) {
133
115
        return {};
134
115
    }
135
136
115
    std::sort(stores_with_usage.begin(), stores_with_usage.end(),
137
115
              [](auto&& a, auto&& b) { return a.second < b.second; });
138
139
115
    std::vector<SpillDataDir*> stores;
140
115
    for (const auto& [store, _] : stores_with_usage) {
141
115
        stores.emplace_back(store);
142
115
    }
143
115
    return stores;
144
230
}
145
146
Status SpillStreamManager::register_spill_stream(RuntimeState* state, SpillStreamSPtr& spill_stream,
147
                                                 const std::string& query_id,
148
                                                 const std::string& operator_name, int32_t node_id,
149
                                                 int32_t batch_rows, size_t batch_bytes,
150
115
                                                 RuntimeProfile* operator_profile) {
151
115
    auto data_dirs = _get_stores_for_spill(TStorageMedium::type::SSD);
152
115
    if (data_dirs.empty()) {
153
115
        data_dirs = _get_stores_for_spill(TStorageMedium::type::HDD);
154
115
    }
155
115
    if (data_dirs.empty()) {
156
0
        return Status::Error<ErrorCode::NO_AVAILABLE_ROOT_PATH>(
157
0
                "no available disk can be used for spill.");
158
0
    }
159
160
115
    uint64_t id = id_++;
161
115
    std::string spill_dir;
162
115
    SpillDataDir* data_dir = nullptr;
163
115
    for (auto& dir : data_dirs) {
164
115
        std::string spill_root_dir = dir->get_spill_data_path();
165
        // storage_root/spill/query_id/partitioned_hash_join-node_id-task_id-stream_id
166
115
        spill_dir = fmt::format("{}/{}/{}-{}-{}-{}", spill_root_dir, query_id, operator_name,
167
115
                                node_id, state->task_id(), id);
168
115
        auto st = io::global_local_filesystem()->create_directory(spill_dir);
169
115
        if (!st.ok()) {
170
0
            std::cerr << "create spill dir failed: " << st.to_string();
171
0
            continue;
172
0
        }
173
115
        data_dir = dir;
174
115
        break;
175
115
    }
176
115
    if (!data_dir) {
177
0
        return Status::Error<ErrorCode::CE_CMD_PARAMS_ERROR>(
178
0
                "there is no available disk that can be used to spill.");
179
0
    }
180
115
    spill_stream = std::make_shared<SpillStream>(state, id, data_dir, spill_dir, batch_rows,
181
115
                                                 batch_bytes, operator_profile);
182
115
    RETURN_IF_ERROR(spill_stream->prepare());
183
115
    return Status::OK();
184
115
}
185
186
37
void SpillStreamManager::delete_spill_stream(SpillStreamSPtr stream) {
187
37
    stream->gc();
188
37
}
189
190
8.26k
void SpillStreamManager::gc(int32_t max_work_time_ms) {
191
8.26k
    bool exists = true;
192
8.26k
    bool has_work = false;
193
8.26k
    int64_t max_work_time_ns = max_work_time_ms * 1000L * 1000L;
194
8.26k
    MonotonicStopWatch watch;
195
8.26k
    watch.start();
196
8.26k
    Defer defer {[&]() {
197
8.21k
        if (has_work) {
198
4
            std::string msg(
199
4
                    fmt::format("spill gc time: {}",
200
4
                                PrettyPrinter::print(watch.elapsed_time(), TUnit::TIME_NS)));
201
4
            msg += ", spill storage:\n";
202
4
            for (const auto& [path, store_dir] : _spill_store_map) {
203
4
                msg += "    " + store_dir->debug_string();
204
4
                msg += "\n";
205
4
            }
206
4
            LOG(INFO) << msg;
207
4
        }
208
8.21k
    }};
209
8.26k
    for (const auto& [path, store_dir] : _spill_store_map) {
210
8.22k
        std::string gc_root_dir = store_dir->get_spill_data_gc_path();
211
212
8.22k
        std::error_code ec;
213
8.22k
        exists = std::filesystem::exists(gc_root_dir, ec);
214
8.22k
        if (ec || !exists) {
215
8.14k
            continue;
216
8.14k
        }
217
        // dirs of queries
218
83
        std::vector<io::FileInfo> dirs;
219
83
        auto st = io::global_local_filesystem()->list(gc_root_dir, false, &dirs, &exists);
220
83
        if (!st.ok()) {
221
0
            continue;
222
0
        }
223
224
131
        for (const auto& dir : dirs) {
225
131
            has_work = true;
226
131
            if (dir.is_file) {
227
0
                continue;
228
0
            }
229
131
            std::string abs_dir = fmt::format("{}/{}", gc_root_dir, dir.file_name);
230
            // operator spill sub dirs of a query
231
131
            std::vector<io::FileInfo> files;
232
131
            st = io::global_local_filesystem()->list(abs_dir, false, &files, &exists);
233
131
            if (!st.ok()) {
234
0
                continue;
235
0
            }
236
131
            if (files.empty()) {
237
81
                static_cast<void>(io::global_local_filesystem()->delete_directory(abs_dir));
238
81
                continue;
239
81
            }
240
241
130
            for (const auto& file : files) {
242
130
                auto abs_file_path = fmt::format("{}/{}", abs_dir, file.file_name);
243
130
                if (file.is_file) {
244
0
                    static_cast<void>(io::global_local_filesystem()->delete_file(abs_file_path));
245
130
                } else {
246
130
                    static_cast<void>(
247
130
                            io::global_local_filesystem()->delete_directory(abs_file_path));
248
130
                }
249
130
                if (watch.elapsed_time() > max_work_time_ns) {
250
0
                    break;
251
0
                }
252
130
            }
253
50
        }
254
83
    }
255
8.26k
}
256
257
DEFINE_GAUGE_METRIC_PROTOTYPE_2ARG(spill_disk_capacity, MetricUnit::BYTES);
258
DEFINE_GAUGE_METRIC_PROTOTYPE_2ARG(spill_disk_limit, MetricUnit::BYTES);
259
DEFINE_GAUGE_METRIC_PROTOTYPE_2ARG(spill_disk_avail_capacity, MetricUnit::BYTES);
260
DEFINE_GAUGE_METRIC_PROTOTYPE_2ARG(spill_disk_data_size, MetricUnit::BYTES);
261
DEFINE_GAUGE_METRIC_PROTOTYPE_2ARG(spill_disk_has_spill_data, MetricUnit::BYTES);
262
DEFINE_GAUGE_METRIC_PROTOTYPE_2ARG(spill_disk_has_spill_gc_data, MetricUnit::BYTES);
263
264
SpillDataDir::SpillDataDir(std::string path, int64_t capacity_bytes,
265
                           TStorageMedium::type storage_medium)
266
68
        : _path(std::move(path)),
267
68
          _disk_capacity_bytes(capacity_bytes),
268
68
          _storage_medium(storage_medium) {
269
68
    spill_data_dir_metric_entity = DorisMetrics::instance()->metric_registry()->register_entity(
270
68
            std::string("spill_data_dir.") + _path, {{"path", _path + "/" + SPILL_DIR_PREFIX}});
271
68
    INT_GAUGE_METRIC_REGISTER(spill_data_dir_metric_entity, spill_disk_capacity);
272
68
    INT_GAUGE_METRIC_REGISTER(spill_data_dir_metric_entity, spill_disk_limit);
273
68
    INT_GAUGE_METRIC_REGISTER(spill_data_dir_metric_entity, spill_disk_avail_capacity);
274
68
    INT_GAUGE_METRIC_REGISTER(spill_data_dir_metric_entity, spill_disk_data_size);
275
68
    INT_GAUGE_METRIC_REGISTER(spill_data_dir_metric_entity, spill_disk_has_spill_data);
276
68
    INT_GAUGE_METRIC_REGISTER(spill_data_dir_metric_entity, spill_disk_has_spill_gc_data);
277
68
}
278
279
154
bool is_directory_empty(const std::filesystem::path& dir) {
280
154
    try {
281
154
        return std::filesystem::is_directory(dir) &&
282
154
               std::filesystem::directory_iterator(dir) ==
283
130
                       std::filesystem::end(std::filesystem::directory_iterator {});
284
        // this method is not thread safe, the file referenced by directory_iterator
285
        // maybe moved to spill_gc dir during this function call, so need to catch expection
286
154
    } catch (const std::filesystem::filesystem_error&) {
287
0
        return true;
288
0
    }
289
154
}
290
291
68
Status SpillDataDir::init() {
292
68
    bool exists = false;
293
68
    RETURN_IF_ERROR(io::global_local_filesystem()->exists(_path, &exists));
294
68
    if (!exists) {
295
0
        RETURN_NOT_OK_STATUS_WITH_WARN(Status::IOError("opendir failed, path={}", _path),
296
0
                                       "check file exist failed");
297
0
    }
298
68
    RETURN_IF_ERROR(update_capacity());
299
68
    LOG(INFO) << fmt::format(
300
68
            "spill storage path: {}, capacity: {}, limit: {}, available: "
301
68
            "{}",
302
68
            _path, PrettyPrinter::print_bytes(_disk_capacity_bytes),
303
68
            PrettyPrinter::print_bytes(_spill_data_limit_bytes),
304
68
            PrettyPrinter::print_bytes(_available_bytes));
305
68
    return Status::OK();
306
68
}
307
308
260
std::string SpillDataDir::get_spill_data_path(const std::string& query_id) const {
309
260
    auto dir = fmt::format("{}/{}", _path, SPILL_DIR_PREFIX);
310
260
    if (!query_id.empty()) {
311
0
        dir = fmt::format("{}/{}", dir, query_id);
312
0
    }
313
260
    return dir;
314
260
}
315
316
8.52k
std::string SpillDataDir::get_spill_data_gc_path(const std::string& sub_dir_name) const {
317
8.52k
    auto dir = fmt::format("{}/{}", _path, SPILL_GC_DIR_PREFIX);
318
8.52k
    if (!sub_dir_name.empty()) {
319
171
        dir = fmt::format("{}/{}", dir, sub_dir_name);
320
171
    }
321
8.52k
    return dir;
322
8.52k
}
323
324
8.29k
Status SpillDataDir::update_capacity() {
325
8.29k
    std::lock_guard<std::mutex> l(_mutex);
326
8.29k
    RETURN_IF_ERROR(io::global_local_filesystem()->get_space_info(_path, &_disk_capacity_bytes,
327
8.29k
                                                                  &_available_bytes));
328
118
    spill_disk_capacity->set_value(_disk_capacity_bytes);
329
118
    spill_disk_avail_capacity->set_value(_available_bytes);
330
118
    auto disk_use_max_bytes =
331
118
            (int64_t)(_disk_capacity_bytes * config::storage_flood_stage_usage_percent / 100);
332
118
    bool is_percent = true;
333
118
    _spill_data_limit_bytes = ParseUtil::parse_mem_spec(config::spill_storage_limit, -1,
334
118
                                                        _disk_capacity_bytes, &is_percent);
335
118
    if (_spill_data_limit_bytes <= 0) {
336
0
        spill_disk_limit->set_value(_spill_data_limit_bytes);
337
0
        auto err_msg = fmt::format("Failed to parse spill storage limit from '{}'",
338
0
                                   config::spill_storage_limit);
339
0
        LOG(WARNING) << err_msg;
340
0
        return Status::InvalidArgument(err_msg);
341
0
    }
342
118
    if (is_percent) {
343
77
        _spill_data_limit_bytes = (int64_t)(_spill_data_limit_bytes *
344
77
                                            config::storage_flood_stage_usage_percent / 100);
345
77
    }
346
118
    if (_spill_data_limit_bytes > disk_use_max_bytes) {
347
0
        _spill_data_limit_bytes = disk_use_max_bytes;
348
0
    }
349
118
    spill_disk_limit->set_value(_spill_data_limit_bytes);
350
351
118
    std::string spill_root_dir = get_spill_data_path();
352
118
    std::string spill_gc_root_dir = get_spill_data_gc_path();
353
118
    spill_disk_has_spill_data->set_value(is_directory_empty(spill_root_dir) ? 0 : 1);
354
118
    spill_disk_has_spill_gc_data->set_value(is_directory_empty(spill_gc_root_dir) ? 0 : 1);
355
356
118
    return Status::OK();
357
118
}
358
359
263
bool SpillDataDir::_reach_disk_capacity_limit(int64_t incoming_data_size) {
360
263
    double used_pct = _get_disk_usage(incoming_data_size);
361
263
    int64_t left_bytes = _available_bytes - incoming_data_size;
362
263
    if (used_pct >= config::storage_flood_stage_usage_percent / 100.0 &&
363
263
        left_bytes <= config::storage_flood_stage_left_capacity_bytes) {
364
0
        LOG(WARNING) << "reach capacity limit. used pct: " << used_pct
365
0
                     << ", left bytes: " << left_bytes << ", path: " << _path;
366
0
        return true;
367
0
    }
368
263
    return false;
369
263
}
370
263
bool SpillDataDir::reach_capacity_limit(int64_t incoming_data_size) {
371
263
    std::lock_guard<std::mutex> l(_mutex);
372
263
    if (_reach_disk_capacity_limit(incoming_data_size)) {
373
0
        return true;
374
0
    }
375
263
    if (_spill_data_bytes + incoming_data_size > _spill_data_limit_bytes) {
376
0
        LOG_EVERY_T(WARNING, 1) << fmt::format(
377
0
                "spill data reach limit, path: {}, capacity: {}, limit: {}, used: {}, available: "
378
0
                "{}, "
379
0
                "incoming "
380
0
                "bytes: {}",
381
0
                _path, PrettyPrinter::print_bytes(_disk_capacity_bytes),
382
0
                PrettyPrinter::print_bytes(_spill_data_limit_bytes),
383
0
                PrettyPrinter::print_bytes(_spill_data_bytes),
384
0
                PrettyPrinter::print_bytes(_available_bytes),
385
0
                PrettyPrinter::print_bytes(incoming_data_size));
386
0
        return true;
387
0
    }
388
263
    return false;
389
263
}
390
4
std::string SpillDataDir::debug_string() {
391
4
    return fmt::format(
392
4
            "path: {}, capacity: {}, limit: {}, used: {}, available: "
393
4
            "{}",
394
4
            _path, PrettyPrinter::print_bytes(_disk_capacity_bytes),
395
4
            PrettyPrinter::print_bytes(_spill_data_limit_bytes),
396
4
            PrettyPrinter::print_bytes(_spill_data_bytes),
397
4
            PrettyPrinter::print_bytes(_available_bytes));
398
4
}
399
} // namespace doris