ClickHouse / ClickHouse/ClickHouse

ClickHouse reports NO_ELEMENTS_IN_CONFIG error

Open
#44,475 4 comments 0 reactions 0 assignees View on GitHub
comp-disk-abstractions external minor usability
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.