ClickHouse / ClickHouse/ClickHouse
ClickHouse backup disk quota exceeded cause clickhouse can not start
- Dominant language
- C++
- Stars
- 49.9k
- Forks
- 9k
- Avg merge
- 21h 32m
- Merged PRs (30d)
- 515
Description
### clickhouse version
```shell
23.4.2.11
```
### clickhouse backup configuration
```xml
local
/clickhouse/backup/
backups
/clickhouse/backup/
```
### error log
```log
2023.06.19 15:01:44.423144 [ 41 ] {} BaseDaemon: (version 23.4.2.11 (official build), build id: CB00FF1352DDBA096F95C86E890588C10074E9A1) (from thread 333) Terminate called for uncaught exception:
2023.06.19 15:01:44.423319 [ 41 ] {} BaseDaemon: Code: 75. DB::ErrnoException: Cannot write to file /clickhouse/backup/clickhouse_access_check_191a3389-2fc8-46d6-98bb-49918d26d102, errno: 122, strerror: Disk quota exceeded. (CANNOT_WRITE_TO_FILE_DESCRIPTOR), Stack trace (when copying this message, always include the lines below):
0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0xe3bb175 in /usr/bin/clickhouse
1. ? @ 0xe3bbeb3 in /usr/bin/clickhouse
2. DB::throwFromErrnoWithPath(String const&, String const&, int, int) @ 0xe3bc1f1 in /usr/bin/clickhouse
3. DB::WriteBufferFromFileDescriptor::nextImpl() @ 0xe426a48 in /usr/bin/clickhouse
4. DB::WriteBufferFromFile::finalizeImpl() @ 0xe4d91e1 in /usr/bin/clickhouse
5. ? @ 0x8b5f6c8 in /usr/bin/clickhouse
6. DB::WriteBufferFromFile::~WriteBufferFromFile() @ 0xe4d9179 in /usr/bin/clickhouse
7. DB::IDisk::checkAccessImpl(String const&) @ 0x12eb7ec3 in /usr/bin/clickhouse
8. DB::DiskLocal::checkAccessImpl(String const&) @ 0x12ec675a in /usr/bin/clickhouse
9. DB::IDisk::checkAccess() @ 0x12eb7cdf in /usr/bin/clickhouse
10. DB::IDisk::startup(std::shared_ptr, bool) @ 0x12eb784f in /usr/bin/clickhouse
11. ? @ 0x12eca743 in /usr/bin/clickhouse
12. DB::DiskFactory::create(String const&, Poco::Util::AbstractConfiguration const&, String const&, std::shared_ptr, std::map, std::less, std::allocator>>> const&) const @ 0x12ebb1a2 in /usr/bin/clickhouse
13. DB::DiskSelector::initialize(Poco::Util::AbstractConfiguration const&, String const&, std::shared_ptr) @ 0x130bddad in /usr/bin/clickhouse
14. DB::Context::getDiskSelector(std::lock_guard&) const @ 0x13089556 in /usr/bin/clickhouse
15. DB::Context::getStoragePolicySelector(std::lock_guard&) const @ 0x1305e0b3 in /usr/bin/clickhouse
16. DB::Context::getStoragePolicy(String const&) const @ 0x13089c40 in /usr/bin/clickhouse
17. DB::MergeTreeData::getStoragePolicy() const @ 0x148006e4 in /usr/bin/clickhouse
18. DB::MergeTreeData::initializeDirectoriesAndFormatVersion(String const&, bool, String const&, bool) @ 0x147fb1a6 in /usr/bin/clickhouse
19. DB::StorageMergeTree::StorageMergeTree(DB::StorageID const&, String const&, DB::StorageInMemoryMetadata const&, bool, std::shared_ptr, String const&, DB::MergeTreeData::MergingParams const&, std::unique_ptr>, bool) @ 0x14b4a699 in /usr/bin/clickhouse
20. ? @ 0x14b46f88 in /usr/bin/clickhouse
21. DB::StorageFactory::get(DB::ASTCreateQuery const&, String const&, std::shared_ptr, std::shared_ptr, DB::ColumnsDescription const&, DB::ConstraintsDescription const&, bool) const @ 0x14294dbb in /usr/bin/clickhouse
22. DB::createTableFromAST(DB::ASTCreateQuery, String const&, String const&, std::shared_ptr, bool) @ 0x12e3c83c in /usr/bin/clickhouse
23. DB::DatabaseOrdinary::loadTableFromMetadata(std::shared_ptr, String const&, DB::QualifiedTableName const&, std::shared_ptr const&, DB::LoadingStrictnessLevel) @ 0x12e5bc37 in /usr/bin/clickhouse
24. ? @ 0x12eb033f in /usr/bin/clickhouse
25. ThreadPoolImpl>::worker(std::__list_iterator, void*>) @ 0xe490475 in /usr/bin/clickhouse
26. void std::__function::__policy_invoker::__call_impl::ThreadFromGlobalPoolImpl>::scheduleImpl(std::function, long, std::optional, bool)::'lambda0'()>(void&&)::'lambda'(), void ()>>(std::__function::__policy_storage const*) @ 0xe492cb5 in /usr/bin/clickhouse
27. ThreadPoolImpl::worker(std::__list_iterator) @ 0xe48c2a1 in /usr/bin/clickhouse
28. ? @ 0xe491b21 in /usr/bin/clickhouse
29. ? @ 0x7f68c920bb43 in ?
30. clone @ 0x7f68c929cbb4 in ?
```
### how can I solve this problem, I expect disks not to affect each other
Contributor guide
Assessment
This issue has not been assessed yet.