2026.10.30 23:05:36.574570 [ 8 ] {} <Information> Application: Will watch for the process with pid 10
2026.10.30 23:05:36.574575 [ 10 ] {} <Information> Application: Forked a child process to watch
2026.10.30 23:05:36.574839 [ 10 ] {} <Information> SentryWriter: Sending crash reports is disabled
2026.10.30 23:05:36.574920 [ 10 ] {} <Trace> Pipe: Pipe capacity is 1.00 MiB
2026.10.30 23:05:36.687940 [ 10 ] {} <Information> Application: Starting ClickHouse 23.8.16.10044.altinitystable (revision: 54477, git hash: 0354a0be7b917ec9e67e860be45ef4cb00850a4f, build id: 4AE05CDC20D37A7D25B052D4FD188233CE55064A), PID 10
2026.10.30 23:05:36.688131 [ 10 ] {} <Information> Application: starting up
2026.10.30 23:05:36.688154 [ 10 ] {} <Information> Application: OS name: Linux, version: 5.15.0-202-generic, architecture: x86_64
2026.10.30 23:05:36.691513 [ 10 ] {} <Information> Application: Available RAM: 31.34 GiB; physical cores: 12; logical cores: 12.
2026.10.30 23:05:36.692456 [ 10 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/thermal
2026.10.30 23:05:36.692480 [ 10 ] {} <Trace> AsynchronousMetrics: Scanning /sys/block
2026.10.30 23:05:36.692573 [ 10 ] {} <Trace> AsynchronousMetrics: Scanning /sys/devices/system/edac
2026.10.30 23:05:36.692596 [ 10 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/hwmon
2026.10.30 23:05:36.825478 [ 10 ] {} <Information> Application: Integrity check of the executable successfully passed (checksum: E53E66F661B7D46009140694D94A1A1B)
2026.10.30 23:05:36.825563 [ 10 ] {} <Information> Application: It looks like the process has no CAP_IPC_LOCK capability, binary mlock will be disabled. It could happen due to incorrect ClickHouse package installation. You could resolve the problem manually with 'sudo setcap cap_ipc_lock=+ep /clickhouse'. Note that it will not work on 'nosuid' mounted filesystems.
2026.10.30 23:05:36.827400 [ 10 ] {} <Debug> Application: Set max number of file descriptors to 524288 (was 1024).
2026.10.30 23:05:36.827414 [ 10 ] {} <Debug> Application: rlimit on number of threads is 18446744073709551615
2026.10.30 23:05:36.827421 [ 10 ] {} <Debug> Application: Initializing DateLUT.
2026.10.30 23:05:36.827425 [ 10 ] {} <Trace> Application: Initialized DateLUT with time zone 'Etc/UTC'.
2026.10.30 23:05:36.827450 [ 10 ] {} <Debug> Context: Setting up /var/lib/clickhouse/tmp/ to store temporary data in it
2026.10.30 23:05:36.827983 [ 10 ] {} <Debug> Application: Configuration parameter 'interserver_http_host' doesn't exist or exists and empty. Will use 'v2202606370085471938.bestsrv.de' as replica host.
2026.10.30 23:05:36.828011 [ 10 ] {} <Debug> Application: Initializing interserver credentials.
2026.10.30 23:05:36.828073 [ 10 ] {} <Trace> NamedCollectionsUtils: Loaded 0 collections from config
2026.10.30 23:05:36.828150 [ 10 ] {} <Trace> NamedCollectionsUtils: Loaded 0 collections from SQL
2026.10.30 23:05:36.828365 [ 10 ] {} <Debug> ConfigReloader: Loading config '/config/config.xml'
2026.10.30 23:05:36.830811 [ 10 ] {} <Debug> ConfigReloader: Loaded config '/config/config.xml', performing update on configuration
2026.10.30 23:05:36.832706 [ 10 ] {} <Information> Application: Setting max_server_memory_usage was set to 28.20 GiB (31.34 GiB available * 0.90 max_server_memory_usage_to_ram_ratio)
2026.10.30 23:05:36.832711 [ 10 ] {} <Information> Application: Setting merges_mutations_memory_usage_soft_limit was set to 15.67 GiB (31.34 GiB available * 0.50 merges_mutations_memory_usage_to_ram_ratio)
2026.10.30 23:05:36.832713 [ 10 ] {} <Information> Application: Merges and mutations memory limit is set to 15.67 GiB
2026.10.30 23:05:36.833212 [ 10 ] {} <Warning> DNSResolver: Cannot resolve host (localhost), error 0: Host not found.
2026.10.30 23:05:36.833521 [ 10 ] {} <Error> Cluster: Code: 198. DB::Exception: Not found address of host: localhost. (DNS_ERROR), Stack trace (when copying this message, always include the lines below):

0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000c5d79d7 in /clickhouse
1. DB::Exception::Exception<String const&>(int, FormatStringHelperImpl<std::type_identity<String const&>::type>, String const&) @ 0x0000000007460b0d in /clickhouse
2. DB::(anonymous namespace)::hostByName(String const&) @ 0x000000000c5ac56d in /clickhouse
3. DB::(anonymous namespace)::resolveIPAddressImpl(String const&) (.llvm.5016407592880486221) @ 0x000000000c5aaa3c in /clickhouse
4. DB::(anonymous namespace)::resolveIPAddressWithCache(DB::CacheBase<String, std::vector<Poco::Net::IPAddress, std::allocator<Poco::Net::IPAddress>>, std::hash<String>, DB::EqualWeightFunction<std::vector<Poco::Net::IPAddress, std::allocator<Poco::Net::IPAddress>>>>&, String const&) (.llvm.5016407592880486221) @ 0x000000000c5ab87a in /clickhouse
5. DB::DNSResolver::resolveAddress(String const&, unsigned short) @ 0x000000000c5abc46 in /clickhouse
6. DB::Cluster::Address::getResolvedAddress() const @ 0x00000000115cbd2d in /clickhouse
7. DB::Cluster::Address::Address(Poco::Util::AbstractConfiguration const&, String const&, String const&, String const&, unsigned int, unsigned int) @ 0x00000000115ccaca in /clickhouse
8. DB::Cluster::Cluster(Poco::Util::AbstractConfiguration const&, DB::Settings const&, String const&, String const&) @ 0x00000000115d407b in /clickhouse
9. DB::Clusters::updateClusters(Poco::Util::AbstractConfiguration const&, DB::Settings const&, String const&, Poco::Util::AbstractConfiguration*) @ 0x00000000115d18fb in /clickhouse
10. DB::Clusters::Clusters(Poco::Util::AbstractConfiguration const&, DB::Settings const&, std::shared_ptr<DB::Macros const>, String const&) @ 0x00000000115d0b7a in /clickhouse
11. DB::Context::setClustersConfig(Poco::AutoPtr<Poco::Util::AbstractConfiguration> const&, bool, String const&) @ 0x0000000011607506 in /clickhouse
12. DB::Server::main(std::vector<String, std::allocator<String>> const&)::$_4::operator()(Poco::AutoPtr<Poco::Util::AbstractConfiguration>, bool) const @ 0x000000000c68e292 in /clickhouse
13. void std::__function::__policy_invoker<void (Poco::AutoPtr<Poco::Util::AbstractConfiguration>, bool)>::__call_impl<std::__function::__default_alloc_func<DB::Server::main(std::vector<String, std::allocator<String>> const&)::$_4, void (Poco::AutoPtr<Poco::Util::AbstractConfiguration>, bool)>>(std::__function::__policy_storage const*, Poco::AutoPtr<Poco::Util::AbstractConfiguration>&&, bool) @ 0x000000000c68ca46 in /clickhouse
14. DB::ConfigReloader::reloadIfNewer(bool, bool, bool, bool) @ 0x000000001377104c in /clickhouse
15. DB::ConfigReloader::ConfigReloader(std::basic_string_view<char, std::char_traits<char>>, std::vector<String, std::allocator<String>> const&, String const&, zkutil::ZooKeeperNodeCache&&, std::shared_ptr<Poco::Event> const&, std::function<void (Poco::AutoPtr<Poco::Util::AbstractConfiguration>, bool)>&&, bool) @ 0x000000001376f8b2 in /clickhouse
16. DB::Server::main(std::vector<String, std::allocator<String>> const&) @ 0x000000000c66dc74 in /clickhouse
17. Poco::Util::Application::run() @ 0x0000000015b12146 in /clickhouse
18. DB::Server::run() @ 0x000000000c65e8be in /clickhouse
19. Poco::Util::ServerApplication::run(int, char**) @ 0x0000000015b21259 in /clickhouse
20. mainEntryClickHouseServer(int, char**) @ 0x000000000c65b68a in /clickhouse
21. main @ 0x00000000070e336f in /clickhouse
22. ? @ 0x00000000000217ed in /lib/x86_64-linux-gnu/libc-2.15.so
23. _start @ 0x000000000634bc2e in /clickhouse
 (version 23.8.16.10044.altinitystable (altinity build))
2026.10.30 23:05:36.833593 [ 10 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads
2026.10.30 23:05:36.834179 [ 10 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 128 threads
2026.10.30 23:05:36.846149 [ 10 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads
2026.10.30 23:05:36.848006 [ 10 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads
2026.10.30 23:05:36.848641 [ 10 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again.
2026.10.30 23:05:36.848667 [ 10 ] {} <Debug> ConfigReloader: Loaded config '/config/config.xml', performed update on configuration
2026.10.30 23:05:36.849306 [ 10 ] {} <Information> Application: Listening for replica communication (interserver): http://[::1]:9009
2026.10.30 23:05:36.849332 [ 10 ] {} <Information> Application: Listening for replica communication (interserver): http://127.0.0.1:9009
2026.10.30 23:05:36.851524 [ 10 ] {} <Debug> ConfigReloader: Loading config '/config/users.xml'
2026.10.30 23:05:36.851937 [ 10 ] {} <Debug> ConfigReloader: Loaded config '/config/users.xml', performing update on configuration
2026.10.30 23:05:36.852503 [ 10 ] {} <Debug> ConfigReloader: Loaded config '/config/users.xml', performed update on configuration
2026.10.30 23:05:36.852612 [ 10 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: /config/users.xml
2026.10.30 23:05:36.852723 [ 10 ] {} <Warning> Access(local_directory): File /var/lib/clickhouse/access/users.list doesn't exist
2026.10.30 23:05:36.852731 [ 10 ] {} <Warning> Access(local_directory): Recovering lists in directory /var/lib/clickhouse/access/
2026.10.30 23:05:36.853056 [ 10 ] {} <Debug> Access(user directories): Added local_directory access storage 'local_directory', path: /var/lib/clickhouse/access/
2026.10.30 23:05:36.853937 [ 10 ] {} <Information> Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32, scheduling_policy=round_robin
2026.10.30 23:05:36.854382 [ 10 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8
2026.10.30 23:05:36.854838 [ 10 ] {} <Information> Context: Initialized background executor for fetches with num_threads=8, num_tasks=8
2026.10.30 23:05:36.855252 [ 10 ] {} <Information> Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8
2026.10.30 23:05:36.856190 [ 10 ] {} <Information> DNSCacheUpdater: Update period 15 seconds
2026.10.30 23:05:36.856203 [ 10 ] {} <Information> Application: Loading metadata from /var/lib/clickhouse/
2026.10.30 23:05:36.856584 [ 32 ] {} <Debug> DNSResolver: Updating DNS cache
2026.10.30 23:05:36.859340 [ 32 ] {} <Warning> DNSResolver: Cannot resolve host (localhost), error 0: Host not found.
2026.10.30 23:05:36.859411 [ 32 ] {} <Information> DNSResolver: Cached hosts not found: localhost
2026.10.30 23:05:36.859414 [ 32 ] {} <Debug> DNSResolver: Updated DNS cache
2026.10.30 23:05:36.861228 [ 10 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total.
2026.10.30 23:05:36.861239 [ 10 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 8.3374e-05 sec
2026.10.30 23:05:36.861244 [ 10 ] {} <Trace> ReferentialDeps: No tables
2026.10.30 23:05:36.861247 [ 10 ] {} <Trace> LoadingDeps: No tables
2026.10.30 23:05:36.861286 [ 10 ] {} <Information> DatabaseAtomic (system): Starting up tables.
2026.10.30 23:05:36.861299 [ 10 ] {} <Debug> SystemLog: Creating system.query_log from query_log
2026.10.30 23:05:36.866904 [ 10 ] {} <Debug> SystemLog: Creating system.query_thread_log from query_thread_log
2026.10.30 23:05:36.867147 [ 10 ] {} <Debug> SystemLog: Creating system.part_log from part_log
2026.10.30 23:05:36.867304 [ 10 ] {} <Debug> SystemLog: Creating system.trace_log from trace_log
2026.10.30 23:05:36.867396 [ 10 ] {} <Debug> SystemLog: Creating system.crash_log from crash_log
2026.10.30 23:05:36.867461 [ 10 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config
2026.10.30 23:05:36.867466 [ 10 ] {} <Debug> SystemLog: Creating system.metric_log from metric_log
2026.10.30 23:05:36.869416 [ 10 ] {} <Debug> SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config
2026.10.30 23:05:36.869428 [ 10 ] {} <Debug> SystemLog: Not creating system.filesystem_read_prefetches_log since corresponding section 'filesystem_read_prefetches_log' is missing from config
2026.10.30 23:05:36.869443 [ 10 ] {} <Debug> SystemLog: Creating system.asynchronous_metric_log from asynchronous_metric_log
2026.10.30 23:05:36.869547 [ 10 ] {} <Debug> SystemLog: Creating system.opentelemetry_span_log from opentelemetry_span_log
2026.10.30 23:05:36.869672 [ 10 ] {} <Debug> SystemLog: Creating system.query_views_log from query_views_log
2026.10.30 23:05:36.869795 [ 10 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config
2026.10.30 23:05:36.869801 [ 10 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config
2026.10.30 23:05:36.869807 [ 10 ] {} <Debug> SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config
2026.10.30 23:05:36.869812 [ 10 ] {} <Debug> SystemLog: Creating system.processors_profile_log from processors_profile_log
2026.10.30 23:05:36.869897 [ 10 ] {} <Debug> SystemLog: Creating system.asynchronous_insert_log from asynchronous_insert_log
2026.10.30 23:05:36.880839 [ 10 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal.
2026.10.30 23:05:36.883045 [ 10 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total.
2026.10.30 23:05:36.883061 [ 10 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 5.6215e-05 sec
2026.10.30 23:05:36.883065 [ 10 ] {} <Trace> ReferentialDeps: No tables
2026.10.30 23:05:36.883068 [ 10 ] {} <Trace> LoadingDeps: No tables
2026.10.30 23:05:36.883091 [ 10 ] {} <Information> DatabaseAtomic (default): Starting up tables.
2026.10.30 23:05:36.883611 [ 10 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/lib/clickhouse/user_defined/
2026.10.30 23:05:36.883631 [ 10 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded
2026.10.30 23:05:36.883633 [ 10 ] {} <Debug> Application: Loaded metadata.
2026.10.30 23:05:36.883662 [ 10 ] {} <Trace> Pipe: Pipe capacity is 1.00 MiB
2026.10.30 23:05:36.883787 [ 10 ] {} <Information> Application: Tasks stats provider: procfs
2026.10.30 23:05:36.883791 [ 10 ] {} <Information> Application: It looks like the process has no CAP_SYS_NICE capability, the setting 'os_thread_priority' will have no effect. It could happen due to incorrect ClickHouse package installation. You could resolve the problem manually with 'sudo setcap cap_sys_nice=+ep /clickhouse'. Note that it will not work on 'nosuid' mounted filesystems.
2026.10.30 23:05:36.884168 [ 10 ] {} <Trace> MySQLHandlerFactory: Failed to create SSL context. SSL will be disabled. Error: Poco::Exception. Code: 1000, e.code() = 0, SSL Exception: Configuration error: no certificate file has been specified (version 23.8.16.10044.altinitystable (altinity build))
2026.10.30 23:05:36.884253 [ 10 ] {} <Trace> MySQLHandlerFactory: Failed to read RSA key pair from server certificate. Error: Code: 139. DB::Exception: Certificate file is not set. (NO_ELEMENTS_IN_CONFIG) (version 23.8.16.10044.altinitystable (altinity build))
2026.10.30 23:05:36.884256 [ 10 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair.
2026.10.30 23:05:36.959851 [ 10 ] {} <Trace> MySQLHandlerFactory: Failed to create SSL context. SSL will be disabled. Error: Poco::Exception. Code: 1000, e.code() = 0, SSL Exception: Configuration error: no certificate file has been specified (version 23.8.16.10044.altinitystable (altinity build))
2026.10.30 23:05:36.959925 [ 10 ] {} <Trace> MySQLHandlerFactory: Failed to read RSA key pair from server certificate. Error: Code: 139. DB::Exception: Certificate file is not set. (NO_ELEMENTS_IN_CONFIG) (version 23.8.16.10044.altinitystable (altinity build))
2026.10.30 23:05:36.959928 [ 10 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair.
2026.10.30 23:05:37.014324 [ 10 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again.
2026.10.30 23:05:37.015403 [ 10 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 45.24 MiB, peak 45.24 MiB, free memory in arenas 3.34 MiB, will set to 412.11 MiB (RSS), difference: 366.87 MiB
2026.10.30 23:05:37.015954 [ 10 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 1.0917e-05 sec.
2026.10.30 23:05:37.016859 [ 10 ] {} <Information> Application: Listening for http://[::1]:8123
2026.10.30 23:05:37.016924 [ 10 ] {} <Information> Application: Listening for native protocol (tcp): [::1]:9000
2026.10.30 23:05:37.016971 [ 10 ] {} <Information> Application: Listening for MySQL compatibility protocol: [::1]:9004
2026.10.30 23:05:37.017084 [ 10 ] {} <Information> Application: Listening for PostgreSQL compatibility protocol: [::1]:9005
2026.10.30 23:05:37.017170 [ 10 ] {} <Information> Application: Listening for http://127.0.0.1:8123
2026.10.30 23:05:37.017229 [ 10 ] {} <Information> Application: Listening for native protocol (tcp): 127.0.0.1:9000
2026.10.30 23:05:37.017286 [ 10 ] {} <Information> Application: Listening for MySQL compatibility protocol: 127.0.0.1:9004
2026.10.30 23:05:37.017346 [ 10 ] {} <Information> Application: Listening for PostgreSQL compatibility protocol: 127.0.0.1:9005
2026.10.30 23:05:37.017349 [ 10 ] {} <Information> Application: Ready for connections.
2026.10.30 23:05:38.000643 [ 267 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 412.12 MiB, peak 412.12 MiB, free memory in arenas 3.41 MiB, will set to 413.30 MiB (RSS), difference: 1.18 MiB
2026.10.30 23:05:41.777231 [ 7 ] {} <Information> Application: Will watch for the process with pid 9
2026.10.30 23:05:41.777278 [ 9 ] {} <Information> Application: Forked a child process to watch
2026.10.30 23:05:41.777431 [ 9 ] {} <Information> SentryWriter: Sending crash reports is disabled
2026.10.30 23:05:41.777498 [ 9 ] {} <Trace> Pipe: Pipe capacity is 1.00 MiB
2026.10.30 23:05:41.863766 [ 9 ] {} <Information> Application: Starting ClickHouse 23.8.16.10044.altinitystable (revision: 54477, git hash: 0354a0be7b917ec9e67e860be45ef4cb00850a4f, build id: 4AE05CDC20D37A7D25B052D4FD188233CE55064A), PID 9
2026.10.30 23:05:41.863979 [ 9 ] {} <Information> Application: starting up
2026.10.30 23:05:41.864002 [ 9 ] {} <Information> Application: OS name: Linux, version: 5.15.0-202-generic, architecture: x86_64
2026.10.30 23:05:41.868111 [ 9 ] {} <Information> Application: Available RAM: 31.34 GiB; physical cores: 12; logical cores: 12.
2026.10.30 23:05:41.870516 [ 9 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/thermal
2026.10.30 23:05:41.870549 [ 9 ] {} <Trace> AsynchronousMetrics: Scanning /sys/block
2026.10.30 23:05:41.870618 [ 9 ] {} <Trace> AsynchronousMetrics: Scanning /sys/devices/system/edac
2026.10.30 23:05:41.870631 [ 9 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/hwmon
2026.10.30 23:05:42.003478 [ 9 ] {} <Information> Application: Integrity check of the executable successfully passed (checksum: E53E66F661B7D46009140694D94A1A1B)
2026.10.30 23:05:42.003564 [ 9 ] {} <Information> Application: It looks like the process has no CAP_IPC_LOCK capability, binary mlock will be disabled. It could happen due to incorrect ClickHouse package installation. You could resolve the problem manually with 'sudo setcap cap_ipc_lock=+ep /clickhouse'. Note that it will not work on 'nosuid' mounted filesystems.
2026.10.30 23:05:42.006533 [ 9 ] {} <Debug> Application: Set max number of file descriptors to 524288 (was 1024).
2026.10.30 23:05:42.006554 [ 9 ] {} <Debug> Application: rlimit on number of threads is 18446744073709551615
2026.10.30 23:05:42.006563 [ 9 ] {} <Debug> Application: Initializing DateLUT.
2026.10.30 23:05:42.006567 [ 9 ] {} <Trace> Application: Initialized DateLUT with time zone 'Etc/UTC'.
2026.10.30 23:05:42.006596 [ 9 ] {} <Debug> Context: Setting up /var/lib/clickhouse/tmp/ to store temporary data in it
2026.10.30 23:05:42.007195 [ 9 ] {} <Debug> Application: Configuration parameter 'interserver_http_host' doesn't exist or exists and empty. Will use 'v2202606370085471938.bestsrv.de' as replica host.
2026.10.30 23:05:42.007215 [ 9 ] {} <Debug> Application: Initializing interserver credentials.
2026.10.30 23:05:42.007285 [ 9 ] {} <Trace> NamedCollectionsUtils: Loaded 0 collections from config
2026.10.30 23:05:42.007339 [ 9 ] {} <Trace> NamedCollectionsUtils: Loaded 0 collections from SQL
2026.10.30 23:05:42.007561 [ 9 ] {} <Debug> ConfigReloader: Loading config '/config/config.xml'
2026.10.30 23:05:42.010081 [ 9 ] {} <Debug> ConfigReloader: Loaded config '/config/config.xml', performing update on configuration
2026.10.30 23:05:42.011985 [ 9 ] {} <Information> Application: Setting max_server_memory_usage was set to 28.20 GiB (31.34 GiB available * 0.90 max_server_memory_usage_to_ram_ratio)
2026.10.30 23:05:42.011993 [ 9 ] {} <Information> Application: Setting merges_mutations_memory_usage_soft_limit was set to 15.67 GiB (31.34 GiB available * 0.50 merges_mutations_memory_usage_to_ram_ratio)
2026.10.30 23:05:42.011996 [ 9 ] {} <Information> Application: Merges and mutations memory limit is set to 15.67 GiB
2026.10.30 23:05:42.012471 [ 9 ] {} <Warning> DNSResolver: Cannot resolve host (localhost), error 0: Host not found.
2026.10.30 23:05:42.012802 [ 9 ] {} <Error> Cluster: Code: 198. DB::Exception: Not found address of host: localhost. (DNS_ERROR), Stack trace (when copying this message, always include the lines below):

0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000c5d79d7 in /clickhouse
1. DB::Exception::Exception<String const&>(int, FormatStringHelperImpl<std::type_identity<String const&>::type>, String const&) @ 0x0000000007460b0d in /clickhouse
2. DB::(anonymous namespace)::hostByName(String const&) @ 0x000000000c5ac56d in /clickhouse
3. DB::(anonymous namespace)::resolveIPAddressImpl(String const&) (.llvm.5016407592880486221) @ 0x000000000c5aaa3c in /clickhouse
4. DB::(anonymous namespace)::resolveIPAddressWithCache(DB::CacheBase<String, std::vector<Poco::Net::IPAddress, std::allocator<Poco::Net::IPAddress>>, std::hash<String>, DB::EqualWeightFunction<std::vector<Poco::Net::IPAddress, std::allocator<Poco::Net::IPAddress>>>>&, String const&) (.llvm.5016407592880486221) @ 0x000000000c5ab87a in /clickhouse
5. DB::DNSResolver::resolveAddress(String const&, unsigned short) @ 0x000000000c5abc46 in /clickhouse
6. DB::Cluster::Address::getResolvedAddress() const @ 0x00000000115cbd2d in /clickhouse
7. DB::Cluster::Address::Address(Poco::Util::AbstractConfiguration const&, String const&, String const&, String const&, unsigned int, unsigned int) @ 0x00000000115ccaca in /clickhouse
8. DB::Cluster::Cluster(Poco::Util::AbstractConfiguration const&, DB::Settings const&, String const&, String const&) @ 0x00000000115d407b in /clickhouse
9. DB::Clusters::updateClusters(Poco::Util::AbstractConfiguration const&, DB::Settings const&, String const&, Poco::Util::AbstractConfiguration*) @ 0x00000000115d18fb in /clickhouse
10. DB::Clusters::Clusters(Poco::Util::AbstractConfiguration const&, DB::Settings const&, std::shared_ptr<DB::Macros const>, String const&) @ 0x00000000115d0b7a in /clickhouse
11. DB::Context::setClustersConfig(Poco::AutoPtr<Poco::Util::AbstractConfiguration> const&, bool, String const&) @ 0x0000000011607506 in /clickhouse
12. DB::Server::main(std::vector<String, std::allocator<String>> const&)::$_4::operator()(Poco::AutoPtr<Poco::Util::AbstractConfiguration>, bool) const @ 0x000000000c68e292 in /clickhouse
13. void std::__function::__policy_invoker<void (Poco::AutoPtr<Poco::Util::AbstractConfiguration>, bool)>::__call_impl<std::__function::__default_alloc_func<DB::Server::main(std::vector<String, std::allocator<String>> const&)::$_4, void (Poco::AutoPtr<Poco::Util::AbstractConfiguration>, bool)>>(std::__function::__policy_storage const*, Poco::AutoPtr<Poco::Util::AbstractConfiguration>&&, bool) @ 0x000000000c68ca46 in /clickhouse
14. DB::ConfigReloader::reloadIfNewer(bool, bool, bool, bool) @ 0x000000001377104c in /clickhouse
15. DB::ConfigReloader::ConfigReloader(std::basic_string_view<char, std::char_traits<char>>, std::vector<String, std::allocator<String>> const&, String const&, zkutil::ZooKeeperNodeCache&&, std::shared_ptr<Poco::Event> const&, std::function<void (Poco::AutoPtr<Poco::Util::AbstractConfiguration>, bool)>&&, bool) @ 0x000000001376f8b2 in /clickhouse
16. DB::Server::main(std::vector<String, std::allocator<String>> const&) @ 0x000000000c66dc74 in /clickhouse
17. Poco::Util::Application::run() @ 0x0000000015b12146 in /clickhouse
18. DB::Server::run() @ 0x000000000c65e8be in /clickhouse
19. Poco::Util::ServerApplication::run(int, char**) @ 0x0000000015b21259 in /clickhouse
20. mainEntryClickHouseServer(int, char**) @ 0x000000000c65b68a in /clickhouse
21. main @ 0x00000000070e336f in /clickhouse
22. __libc_start_main @ 0x000000000001d9f4 in /lib64/libc-2.5.so
23. _start @ 0x000000000634bc2e in /clickhouse
 (version 23.8.16.10044.altinitystable (altinity build))
2026.10.30 23:05:42.012880 [ 9 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads
2026.10.30 23:05:42.013803 [ 9 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 128 threads
2026.10.30 23:05:42.022654 [ 9 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads
2026.10.30 23:05:42.023606 [ 9 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads
2026.10.30 23:05:42.024592 [ 9 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again.
2026.10.30 23:05:42.024624 [ 9 ] {} <Debug> ConfigReloader: Loaded config '/config/config.xml', performed update on configuration
2026.10.30 23:05:42.027938 [ 9 ] {} <Information> Application: Listening for replica communication (interserver): http://[::1]:9009
2026.10.30 23:05:42.030142 [ 9 ] {} <Information> Application: Listening for replica communication (interserver): http://127.0.0.1:9009
2026.10.30 23:05:42.035124 [ 9 ] {} <Debug> ConfigReloader: Loading config '/config/users.xml'
2026.10.30 23:05:42.035576 [ 9 ] {} <Debug> ConfigReloader: Loaded config '/config/users.xml', performing update on configuration
2026.10.30 23:05:42.036151 [ 9 ] {} <Debug> ConfigReloader: Loaded config '/config/users.xml', performed update on configuration
2026.10.30 23:05:42.036303 [ 9 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: /config/users.xml
2026.10.30 23:05:42.036436 [ 9 ] {} <Warning> Access(local_directory): File /var/lib/clickhouse/access/users.list doesn't exist
2026.10.30 23:05:42.036459 [ 9 ] {} <Warning> Access(local_directory): Recovering lists in directory /var/lib/clickhouse/access/
2026.10.30 23:05:42.036727 [ 9 ] {} <Debug> Access(user directories): Added local_directory access storage 'local_directory', path: /var/lib/clickhouse/access/
2026.10.30 23:05:42.037556 [ 9 ] {} <Information> Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32, scheduling_policy=round_robin
2026.10.30 23:05:42.037944 [ 9 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8
2026.10.30 23:05:42.039155 [ 9 ] {} <Information> Context: Initialized background executor for fetches with num_threads=8, num_tasks=8
2026.10.30 23:05:42.039843 [ 9 ] {} <Information> Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8
2026.10.30 23:05:42.040867 [ 9 ] {} <Information> DNSCacheUpdater: Update period 15 seconds
2026.10.30 23:05:42.040885 [ 9 ] {} <Information> Application: Loading metadata from /var/lib/clickhouse/
2026.10.30 23:05:42.041072 [ 28 ] {} <Debug> DNSResolver: Updating DNS cache
2026.10.30 23:05:42.041907 [ 28 ] {} <Warning> DNSResolver: Cannot resolve host (localhost), error 0: Host not found.
2026.10.30 23:05:42.041973 [ 28 ] {} <Information> DNSResolver: Cached hosts not found: localhost
2026.10.30 23:05:42.041982 [ 28 ] {} <Debug> DNSResolver: Updated DNS cache
2026.10.30 23:05:42.047759 [ 9 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total.
2026.10.30 23:05:42.047772 [ 9 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 8.8833e-05 sec
2026.10.30 23:05:42.047777 [ 9 ] {} <Trace> ReferentialDeps: No tables
2026.10.30 23:05:42.047780 [ 9 ] {} <Trace> LoadingDeps: No tables
2026.10.30 23:05:42.047813 [ 9 ] {} <Information> DatabaseAtomic (system): Starting up tables.
2026.10.30 23:05:42.047828 [ 9 ] {} <Debug> SystemLog: Creating system.query_log from query_log
2026.10.30 23:05:42.053419 [ 9 ] {} <Debug> SystemLog: Creating system.query_thread_log from query_thread_log
2026.10.30 23:05:42.053636 [ 9 ] {} <Debug> SystemLog: Creating system.part_log from part_log
2026.10.30 23:05:42.053815 [ 9 ] {} <Debug> SystemLog: Creating system.trace_log from trace_log
2026.10.30 23:05:42.053909 [ 9 ] {} <Debug> SystemLog: Creating system.crash_log from crash_log
2026.10.30 23:05:42.053973 [ 9 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config
2026.10.30 23:05:42.053979 [ 9 ] {} <Debug> SystemLog: Creating system.metric_log from metric_log
2026.10.30 23:05:42.056133 [ 9 ] {} <Debug> SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config
2026.10.30 23:05:42.056153 [ 9 ] {} <Debug> SystemLog: Not creating system.filesystem_read_prefetches_log since corresponding section 'filesystem_read_prefetches_log' is missing from config
2026.10.30 23:05:42.056162 [ 9 ] {} <Debug> SystemLog: Creating system.asynchronous_metric_log from asynchronous_metric_log
2026.10.30 23:05:42.056294 [ 9 ] {} <Debug> SystemLog: Creating system.opentelemetry_span_log from opentelemetry_span_log
2026.10.30 23:05:42.056421 [ 9 ] {} <Debug> SystemLog: Creating system.query_views_log from query_views_log
2026.10.30 23:05:42.056563 [ 9 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config
2026.10.30 23:05:42.056571 [ 9 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config
2026.10.30 23:05:42.056577 [ 9 ] {} <Debug> SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config
2026.10.30 23:05:42.056583 [ 9 ] {} <Debug> SystemLog: Creating system.processors_profile_log from processors_profile_log
2026.10.30 23:05:42.056681 [ 9 ] {} <Debug> SystemLog: Creating system.asynchronous_insert_log from asynchronous_insert_log
2026.10.30 23:05:42.068992 [ 9 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal.
2026.10.30 23:05:42.071537 [ 9 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total.
2026.10.30 23:05:42.071552 [ 9 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 5.6634e-05 sec
2026.10.30 23:05:42.071557 [ 9 ] {} <Trace> ReferentialDeps: No tables
2026.10.30 23:05:42.071561 [ 9 ] {} <Trace> LoadingDeps: No tables
2026.10.30 23:05:42.071584 [ 9 ] {} <Information> DatabaseAtomic (default): Starting up tables.
2026.10.30 23:05:42.071723 [ 9 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/lib/clickhouse/user_defined/
2026.10.30 23:05:42.071741 [ 9 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded
2026.10.30 23:05:42.071744 [ 9 ] {} <Debug> Application: Loaded metadata.
2026.10.30 23:05:42.071768 [ 9 ] {} <Trace> Pipe: Pipe capacity is 1.00 MiB
2026.10.30 23:05:42.071892 [ 9 ] {} <Information> Application: Tasks stats provider: procfs
2026.10.30 23:05:42.071896 [ 9 ] {} <Information> Application: It looks like the process has no CAP_SYS_NICE capability, the setting 'os_thread_priority' will have no effect. It could happen due to incorrect ClickHouse package installation. You could resolve the problem manually with 'sudo setcap cap_sys_nice=+ep /clickhouse'. Note that it will not work on 'nosuid' mounted filesystems.
2026.10.30 23:05:42.072189 [ 9 ] {} <Trace> MySQLHandlerFactory: Failed to create SSL context. SSL will be disabled. Error: Poco::Exception. Code: 1000, e.code() = 0, SSL Exception: Configuration error: no certificate file has been specified (version 23.8.16.10044.altinitystable (altinity build))
2026.10.30 23:05:42.072243 [ 9 ] {} <Trace> MySQLHandlerFactory: Failed to read RSA key pair from server certificate. Error: Code: 139. DB::Exception: Certificate file is not set. (NO_ELEMENTS_IN_CONFIG) (version 23.8.16.10044.altinitystable (altinity build))
2026.10.30 23:05:42.072246 [ 9 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair.
2026.10.30 23:05:42.143564 [ 9 ] {} <Trace> MySQLHandlerFactory: Failed to create SSL context. SSL will be disabled. Error: Poco::Exception. Code: 1000, e.code() = 0, SSL Exception: Configuration error: no certificate file has been specified (version 23.8.16.10044.altinitystable (altinity build))
2026.10.30 23:05:42.143662 [ 9 ] {} <Trace> MySQLHandlerFactory: Failed to read RSA key pair from server certificate. Error: Code: 139. DB::Exception: Certificate file is not set. (NO_ELEMENTS_IN_CONFIG) (version 23.8.16.10044.altinitystable (altinity build))
2026.10.30 23:05:42.143672 [ 9 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair.
2026.10.30 23:05:42.225795 [ 9 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again.
2026.10.30 23:05:42.227066 [ 9 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 45.25 MiB, peak 45.25 MiB, free memory in arenas 41.41 MiB, will set to 449.64 MiB (RSS), difference: 404.39 MiB
2026.10.30 23:05:42.227908 [ 9 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 1.0095e-05 sec.
2026.10.30 23:05:42.228638 [ 9 ] {} <Information> Application: Listening for http://[::1]:8123
2026.10.30 23:05:42.228700 [ 9 ] {} <Information> Application: Listening for native protocol (tcp): [::1]:9000
2026.10.30 23:05:42.228744 [ 9 ] {} <Information> Application: Listening for MySQL compatibility protocol: [::1]:9004
2026.10.30 23:05:42.228790 [ 9 ] {} <Information> Application: Listening for PostgreSQL compatibility protocol: [::1]:9005
2026.10.30 23:05:42.228838 [ 9 ] {} <Information> Application: Listening for http://127.0.0.1:8123
2026.10.30 23:05:42.228886 [ 9 ] {} <Information> Application: Listening for native protocol (tcp): 127.0.0.1:9000
2026.10.30 23:05:42.229000 [ 9 ] {} <Information> Application: Listening for MySQL compatibility protocol: 127.0.0.1:9004
2026.10.30 23:05:42.229049 [ 9 ] {} <Information> Application: Listening for PostgreSQL compatibility protocol: 127.0.0.1:9005
2026.10.30 23:05:42.229053 [ 9 ] {} <Information> Application: Ready for connections.
2026.10.30 23:05:43.000755 [ 266 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 449.65 MiB, peak 449.65 MiB, free memory in arenas 41.47 MiB, will set to 450.71 MiB (RSS), difference: 1.05 MiB