ClickHouse / ClickHouse/ClickHouse
ClickHouse reports NO_ELEMENTS_IN_CONFIG error
- Dominant language
- C++
- Stars
- 49.9k
- Forks
- 9k
- Avg merge
- 21h 32m
- Merged PRs (30d)
- 515
Description
I use 22.4 and 22.11 two versions. They all report NO_ELEMENTS_IN_CONFIG error.
```
WITH arrayMap(x -> demangle(addressToSymbol(x)), last_error_trace) AS `all`
SELECT
name,
last_error_message,
arrayStringConcat(`all`, '\n') AS res
FROM system.errors
WHERE name = 'NO_ELEMENTS_IN_CONFIG'
SETTINGS allow_introspection_functions = 1
Query id: d927c51c-a94b-4393-a41b-f0b0d41641fe
Row 1:
──────
name: NO_ELEMENTS_IN_CONFIG
last_error_message: Volume must contain at least one disk
res: DB::Exception::Exception(std::__1::basic_string, std::__1::allocator> const&, int, bool)
DB::IVolume::IVolume(std::__1::basic_string, std::__1::allocator>, Poco::Util::AbstractConfiguration const&, std::__1::basic_string, std::__1::allocator> const&, std::__1::shared_ptr)
DB::VolumeJBOD::VolumeJBOD(std::__1::basic_string, std::__1::allocator>, Poco::Util::AbstractConfiguration const&, std::__1::basic_string, std::__1::allocator> const&, std::__1::shared_ptr)
DB::VolumeJBOD::VolumeJBOD(DB::VolumeJBOD const&, Poco::Util::AbstractConfiguration const&, std::__1::basic_string, std::__1::allocator> const&, std::__1::shared_ptr)
DB::updateVolumeFromConfig(std::__1::shared_ptr, Poco::Util::AbstractConfiguration const&, std::__1::basic_string, std::__1::allocator> const&, std::__1::shared_ptr&)
DB::StoragePolicy::StoragePolicy(std::__1::shared_ptr, Poco::Util::AbstractConfiguration const&, std::__1::basic_string, std::__1::allocator> const&, std::__1::shared_ptr)
DB::StoragePolicySelector::updateFromConfig(Poco::Util::AbstractConfiguration const&, std::__1::basic_string, std::__1::allocator> const&, std::__1::shared_ptr) const
DB::Context::updateStorageConfiguration(Poco::Util::AbstractConfiguration const&)
DB::ConfigReloader::reloadIfNewer(bool, bool, bool, bool)
DB::ConfigReloader::run()
void std::__1::__function::__policy_invoker::__call_impl::ThreadFromGlobalPoolImpl(void (DB::ConfigReloader::*&&)(), DB::ConfigReloader*&&)::'lambda'(), void ()>>(std::__1::__function::__policy_storage const*)
ThreadPoolImpl::worker(std::__1::__list_iterator)
__clone
1 row in set. Elapsed: 0.002 sec.
```
My storage_configuration is:
```
104857600
s3
http://xxx/data/
xxx
xxx
false
false
120000
120000
10
4
1048576
/var/lib/clickhouse/disks/s3/
true
/var/lib/clickhouse/disks/s3/cache/
true
default
s3
true
0.05
```
The content of storage_policies table is:
```
SELECT *
FROM system.storage_policies
Query id: 99538796-f83e-42bb-9996-e56cbcea1337
Row 1:
──────
policy_name: default
volume_name: default
volume_priority: 1
disks: ['default']
volume_type: JBOD
max_data_part_size: 0
move_factor: 0
prefer_not_to_merge: 0
Row 2:
──────
policy_name: ssd_s3
volume_name: ssd
volume_priority: 1
disks: ['default']
volume_type: JBOD
max_data_part_size: 0
move_factor: 0.05
prefer_not_to_merge: 0
Row 3:
──────
policy_name: ssd_s3
volume_name: s3
volume_priority: 2
disks: ['s3']
volume_type: JBOD
max_data_part_size: 0
move_factor: 0.05
prefer_not_to_merge: 1
3 rows in set. Elapsed: 0.002 sec.
```
What is wrong?
The version is `22.4.4.7` and `22.11.2.30 `.
Thanks!
Contributor guide
Assessment
This issue has not been assessed yet.