2026.10.27 16:55:20.599244 [ 8 ] {} <Information> Application: Will watch for the process with pid 10
2026.10.27 16:55:20.599585 [ 10 ] {} <Information> Application: Forked a child process to watch
2026.10.27 16:55:20.600095 [ 10 ] {} <Information> SentryWriter: Sending crash reports is disabled
2026.10.27 16:55:20.600283 [ 10 ] {} <Trace> Pipe: Pipe capacity is 1.00 MiB
2026.10.27 16:55:20.710791 [ 10 ] {} <Information> Application: Starting ClickHouse 23.8.16.43.altinitystable (revision: 54477, git hash: 94a4590da68abf5a5bc6f5c1b00f903b74178e31, build id: 2E450542EEC04447D36FB91C31F4C26A2CF31486), PID 10
2026.10.27 16:55:20.710929 [ 10 ] {} <Information> Application: starting up
2026.10.27 16:55:20.710952 [ 10 ] {} <Information> Application: OS name: Linux, version: 5.15.0-130-generic, architecture: x86_64
2026.10.27 16:55:20.714600 [ 10 ] {} <Information> Application: Available RAM: 30.59 GiB; physical cores: 16; logical cores: 16.
2026.10.27 16:55:20.715577 [ 10 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/thermal
2026.10.27 16:55:20.715596 [ 10 ] {} <Trace> AsynchronousMetrics: Scanning /sys/block
2026.10.27 16:55:20.715688 [ 10 ] {} <Trace> AsynchronousMetrics: Scanning /sys/devices/system/edac
2026.10.27 16:55:20.715706 [ 10 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/hwmon
2026.10.27 16:55:20.854386 [ 10 ] {} <Information> Application: Integrity check of the executable successfully passed (checksum: 74332C2DF520168716821F59DE27F5C4)
2026.10.27 16:55:20.854450 [ 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.27 16:55:20.856157 [ 10 ] {} <Debug> Application: rlimit on number of file descriptors is 1048576
2026.10.27 16:55:20.856173 [ 10 ] {} <Debug> Application: rlimit on number of threads is 18446744073709551615
2026.10.27 16:55:20.856180 [ 10 ] {} <Debug> Application: Initializing DateLUT.
2026.10.27 16:55:20.856185 [ 10 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'.
2026.10.27 16:55:20.856219 [ 10 ] {} <Debug> Context: Setting up /var/lib/clickhouse/tmp/ to store temporary data in it
2026.10.27 16:55:20.856855 [ 10 ] {} <Debug> Application: Configuration parameter 'interserver_http_host' doesn't exist or exists and empty. Will use 'github-hetzner-runner-40521195197-122265957546' as replica host.
2026.10.27 16:55:20.856873 [ 10 ] {} <Debug> Application: Initializing interserver credentials.
2026.10.27 16:55:20.856935 [ 10 ] {} <Trace> NamedCollectionsUtils: Loaded 0 collections from config
2026.10.27 16:55:20.857010 [ 10 ] {} <Trace> NamedCollectionsUtils: Loaded 0 collections from SQL
2026.10.27 16:55:20.857223 [ 10 ] {} <Debug> ConfigReloader: Loading config '/config/config.xml'
2026.10.27 16:55:20.860334 [ 10 ] {} <Debug> ConfigReloader: Loaded config '/config/config.xml', performing update on configuration
2026.10.27 16:55:20.862355 [ 10 ] {} <Information> Application: Setting max_server_memory_usage was set to 27.54 GiB (30.59 GiB available * 0.90 max_server_memory_usage_to_ram_ratio)
2026.10.27 16:55:20.862364 [ 10 ] {} <Information> Application: Setting merges_mutations_memory_usage_soft_limit was set to 15.30 GiB (30.59 GiB available * 0.50 merges_mutations_memory_usage_to_ram_ratio)
2026.10.27 16:55:20.862369 [ 10 ] {} <Information> Application: Merges and mutations memory limit is set to 15.30 GiB
2026.10.27 16:55:20.862661 [ 10 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads
2026.10.27 16:55:20.864480 [ 10 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 128 threads
2026.10.27 16:55:20.881528 [ 10 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads
2026.10.27 16:55:20.883428 [ 10 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads
2026.10.27 16:55:20.885682 [ 10 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again.
2026.10.27 16:55:20.885722 [ 10 ] {} <Debug> ConfigReloader: Loaded config '/config/config.xml', performed update on configuration
2026.10.27 16:55:20.896139 [ 10 ] {} <Information> Application: Listening for replica communication (interserver): http://[::1]:9009
2026.10.27 16:55:20.898597 [ 10 ] {} <Information> Application: Listening for replica communication (interserver): http://127.0.0.1:9009
2026.10.27 16:55:20.913682 [ 10 ] {} <Debug> ConfigReloader: Loading config '/config/users.xml'
2026.10.27 16:55:20.914814 [ 10 ] {} <Debug> ConfigReloader: Loaded config '/config/users.xml', performing update on configuration
2026.10.27 16:55:20.915988 [ 10 ] {} <Debug> ConfigReloader: Loaded config '/config/users.xml', performed update on configuration
2026.10.27 16:55:20.916177 [ 10 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: /config/users.xml
2026.10.27 16:55:20.916434 [ 10 ] {} <Warning> Access(local_directory): File /var/lib/clickhouse/access/users.list doesn't exist
2026.10.27 16:55:20.916479 [ 10 ] {} <Warning> Access(local_directory): Recovering lists in directory /var/lib/clickhouse/access/
2026.10.27 16:55:20.916944 [ 10 ] {} <Debug> Access(user directories): Added local_directory access storage 'local_directory', path: /var/lib/clickhouse/access/
2026.10.27 16:55:20.918580 [ 10 ] {} <Information> Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32, scheduling_policy=round_robin
2026.10.27 16:55:20.919424 [ 10 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8
2026.10.27 16:55:20.920319 [ 10 ] {} <Information> Context: Initialized background executor for fetches with num_threads=8, num_tasks=8
2026.10.27 16:55:20.921081 [ 10 ] {} <Information> Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8
2026.10.27 16:55:20.923035 [ 10 ] {} <Information> DNSCacheUpdater: Update period 15 seconds
2026.10.27 16:55:20.923080 [ 10 ] {} <Information> Application: Loading metadata from /var/lib/clickhouse/
2026.10.27 16:55:20.923426 [ 26 ] {} <Debug> DNSResolver: Updating DNS cache
2026.10.27 16:55:20.929094 [ 26 ] {} <Debug> DNSResolver: Updated DNS cache
2026.10.27 16:55:20.933092 [ 10 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total.
2026.10.27 16:55:20.933128 [ 10 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.0001804 sec
2026.10.27 16:55:20.933144 [ 10 ] {} <Trace> ReferentialDeps: No tables
2026.10.27 16:55:20.933158 [ 10 ] {} <Trace> LoadingDeps: No tables
2026.10.27 16:55:20.933214 [ 10 ] {} <Information> DatabaseAtomic (system): Starting up tables.
2026.10.27 16:55:20.933255 [ 10 ] {} <Debug> SystemLog: Creating system.query_log from query_log
2026.10.27 16:55:20.934632 [ 10 ] {} <Debug> SystemLog: Creating system.query_thread_log from query_thread_log
2026.10.27 16:55:20.935055 [ 10 ] {} <Debug> SystemLog: Creating system.part_log from part_log
2026.10.27 16:55:20.935511 [ 10 ] {} <Debug> SystemLog: Creating system.trace_log from trace_log
2026.10.27 16:55:20.935858 [ 10 ] {} <Debug> SystemLog: Creating system.crash_log from crash_log
2026.10.27 16:55:20.936035 [ 10 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config
2026.10.27 16:55:20.936053 [ 10 ] {} <Debug> SystemLog: Creating system.metric_log from metric_log
2026.10.27 16:55:20.939522 [ 10 ] {} <Debug> SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config
2026.10.27 16:55:20.939579 [ 10 ] {} <Debug> SystemLog: Not creating system.filesystem_read_prefetches_log since corresponding section 'filesystem_read_prefetches_log' is missing from config
2026.10.27 16:55:20.939614 [ 10 ] {} <Debug> SystemLog: Creating system.asynchronous_metric_log from asynchronous_metric_log
2026.10.27 16:55:20.939929 [ 10 ] {} <Debug> SystemLog: Creating system.opentelemetry_span_log from opentelemetry_span_log
2026.10.27 16:55:20.940296 [ 10 ] {} <Debug> SystemLog: Creating system.query_views_log from query_views_log
2026.10.27 16:55:20.940706 [ 10 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config
2026.10.27 16:55:20.940734 [ 10 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config
2026.10.27 16:55:20.940751 [ 10 ] {} <Debug> SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config
2026.10.27 16:55:20.940768 [ 10 ] {} <Debug> SystemLog: Creating system.processors_profile_log from processors_profile_log
2026.10.27 16:55:20.941000 [ 10 ] {} <Debug> SystemLog: Creating system.asynchronous_insert_log from asynchronous_insert_log
2026.10.27 16:55:20.966685 [ 10 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal.
2026.10.27 16:55:20.969289 [ 10 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total.
2026.10.27 16:55:20.969309 [ 10 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 7.094e-05 sec
2026.10.27 16:55:20.969320 [ 10 ] {} <Trace> ReferentialDeps: No tables
2026.10.27 16:55:20.969328 [ 10 ] {} <Trace> LoadingDeps: No tables
2026.10.27 16:55:20.969349 [ 10 ] {} <Information> DatabaseAtomic (default): Starting up tables.
2026.10.27 16:55:20.969559 [ 10 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/lib/clickhouse/user_defined/
2026.10.27 16:55:20.969612 [ 10 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded
2026.10.27 16:55:20.969622 [ 10 ] {} <Debug> Application: Loaded metadata.
2026.10.27 16:55:20.969674 [ 10 ] {} <Trace> Pipe: Pipe capacity is 1.00 MiB
2026.10.27 16:55:20.969839 [ 10 ] {} <Information> Application: Tasks stats provider: procfs
2026.10.27 16:55:20.969852 [ 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.27 16:55:20.970499 [ 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.43.altinitystable (altinity build))
2026.10.27 16:55:20.970649 [ 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.43.altinitystable (altinity build))
2026.10.27 16:55:20.970661 [ 10 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair.
2026.10.27 16:55:21.014014 [ 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.43.altinitystable (altinity build))
2026.10.27 16:55:21.014084 [ 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.43.altinitystable (altinity build))
2026.10.27 16:55:21.014089 [ 10 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair.
2026.10.27 16:55:21.068689 [ 10 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again.
2026.10.27 16:55:21.069380 [ 10 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 40.27 MiB, peak 40.27 MiB, free memory in arenas 48.26 MiB, will set to 446.04 MiB (RSS), difference: 405.77 MiB
2026.10.27 16:55:21.069963 [ 10 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 1.281e-05 sec.
2026.10.27 16:55:21.071092 [ 10 ] {} <Information> Application: Listening for http://[::1]:8123
2026.10.27 16:55:21.071146 [ 10 ] {} <Information> Application: Listening for native protocol (tcp): [::1]:9000
2026.10.27 16:55:21.071194 [ 10 ] {} <Information> Application: Listening for MySQL compatibility protocol: [::1]:9004
2026.10.27 16:55:21.071236 [ 10 ] {} <Information> Application: Listening for PostgreSQL compatibility protocol: [::1]:9005
2026.10.27 16:55:21.071279 [ 10 ] {} <Information> Application: Listening for http://127.0.0.1:8123
2026.10.27 16:55:21.071356 [ 10 ] {} <Information> Application: Listening for native protocol (tcp): 127.0.0.1:9000
2026.10.27 16:55:21.071399 [ 10 ] {} <Information> Application: Listening for MySQL compatibility protocol: 127.0.0.1:9004
2026.10.27 16:55:21.071442 [ 10 ] {} <Information> Application: Listening for PostgreSQL compatibility protocol: 127.0.0.1:9005
2026.10.27 16:55:21.071446 [ 10 ] {} <Information> Application: Ready for connections.
2026.10.27 16:55:22.000542 [ 269 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 446.05 MiB, peak 446.05 MiB, free memory in arenas 48.29 MiB, will set to 448.54 MiB (RSS), difference: 2.48 MiB
2026.10.27 16:55:25.583147 [ 12 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:54678
2026.10.27 16:55:25.583403 [ 12 ] {} <Debug> TCPHandler: Connected ClickHouse client version 23.8.0, revision: 54465, user: default.
2026.10.27 16:55:25.583459 [ 12 ] {} <Debug> TCP-Session: 1f1c17bb-2252-491a-b9e2-22bbac3d5d5d Authenticating user 'default' from [::1]:54678
2026.10.27 16:55:25.583481 [ 12 ] {} <Debug> TCP-Session: 1f1c17bb-2252-491a-b9e2-22bbac3d5d5d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
2026.10.27 16:55:25.583493 [ 12 ] {} <Debug> TCP-Session: 1f1c17bb-2252-491a-b9e2-22bbac3d5d5d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
2026.10.27 16:55:25.583623 [ 12 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false
2026.10.27 16:55:25.583654 [ 12 ] {} <Trace> ContextAccess (default): List of all grants: GRANT SHOW, SELECT, INSERT, ALTER, CREATE, DROP, UNDROP TABLE, TRUNCATE, OPTIMIZE, BACKUP, KILL QUERY, KILL TRANSACTION, MOVE PARTITION BETWEEN SHARDS, SYSTEM, dictGet, displaySecretsInShowAndSelect, INTROSPECTION, SOURCES, CLUSTER ON *.*
2026.10.27 16:55:25.583685 [ 12 ] {} <Trace> ContextAccess (default): List of all grants including implicit: GRANT SHOW, SELECT, INSERT, ALTER, CREATE, DROP, UNDROP TABLE, TRUNCATE, OPTIMIZE, BACKUP, KILL QUERY, KILL TRANSACTION, MOVE PARTITION BETWEEN SHARDS, SYSTEM, dictGet, displaySecretsInShowAndSelect, INTROSPECTION, SOURCES, CLUSTER ON *.*
2026.10.27 16:55:25.602527 [ 12 ] {} <Trace> TCP-Session: 1f1c17bb-2252-491a-b9e2-22bbac3d5d5d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
2026.10.27 16:55:25.602905 [ 12 ] {b5697f72-0d04-4279-bca1-209891407b0a} <Debug> executeQuery: (from [::1]:54678) select 'OK' (stage: Complete)
2026.10.27 16:55:25.603180 [ 12 ] {b5697f72-0d04-4279-bca1-209891407b0a} <Trace> ContextAccess (default): Access granted: SELECT(dummy) ON system.one
2026.10.27 16:55:25.603231 [ 12 ] {b5697f72-0d04-4279-bca1-209891407b0a} <Trace> InterpreterSelectQuery: FetchColumns -> Complete
2026.10.27 16:55:25.604547 [ 12 ] {b5697f72-0d04-4279-bca1-209891407b0a} <Debug> executeQuery: Read 1 rows, 1.00 B in 0.001655 sec., 604.2296072507553 rows/sec., 604.23 B/sec.
2026.10.27 16:55:25.604596 [ 12 ] {b5697f72-0d04-4279-bca1-209891407b0a} <Debug> TCPHandler: Processed in 0.002220851 sec.
2026.10.27 16:55:25.606666 [ 12 ] {} <Debug> TCPHandler: Done processing connection.
2026.10.27 16:55:25.606723 [ 12 ] {} <Debug> TCP-Session: 1f1c17bb-2252-491a-b9e2-22bbac3d5d5d Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
2026.10.27 16:55:25.998724 [ 7 ] {} <Information> Application: Will watch for the process with pid 9
2026.10.27 16:55:25.999050 [ 9 ] {} <Information> Application: Forked a child process to watch
2026.10.27 16:55:25.999608 [ 9 ] {} <Information> SentryWriter: Sending crash reports is disabled
2026.10.27 16:55:25.999830 [ 9 ] {} <Trace> Pipe: Pipe capacity is 1.00 MiB
2026.10.27 16:55:26.110388 [ 9 ] {} <Information> Application: Starting ClickHouse 23.8.16.43.altinitystable (revision: 54477, git hash: 94a4590da68abf5a5bc6f5c1b00f903b74178e31, build id: 2E450542EEC04447D36FB91C31F4C26A2CF31486), PID 9
2026.10.27 16:55:26.110525 [ 9 ] {} <Information> Application: starting up
2026.10.27 16:55:26.110550 [ 9 ] {} <Information> Application: OS name: Linux, version: 5.15.0-130-generic, architecture: x86_64
2026.10.27 16:55:26.114311 [ 9 ] {} <Information> Application: Available RAM: 30.59 GiB; physical cores: 16; logical cores: 16.
2026.10.27 16:55:26.115547 [ 9 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/thermal
2026.10.27 16:55:26.115565 [ 9 ] {} <Trace> AsynchronousMetrics: Scanning /sys/block
2026.10.27 16:55:26.115649 [ 9 ] {} <Trace> AsynchronousMetrics: Scanning /sys/devices/system/edac
2026.10.27 16:55:26.115666 [ 9 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/hwmon
2026.10.27 16:55:26.253350 [ 9 ] {} <Information> Application: Integrity check of the executable successfully passed (checksum: 74332C2DF520168716821F59DE27F5C4)
2026.10.27 16:55:26.253408 [ 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.27 16:55:26.255733 [ 9 ] {} <Debug> Application: rlimit on number of file descriptors is 1048576
2026.10.27 16:55:26.255753 [ 9 ] {} <Debug> Application: rlimit on number of threads is 18446744073709551615
2026.10.27 16:55:26.255761 [ 9 ] {} <Debug> Application: Initializing DateLUT.
2026.10.27 16:55:26.255766 [ 9 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'.
2026.10.27 16:55:26.255803 [ 9 ] {} <Debug> Context: Setting up /var/lib/clickhouse/tmp/ to store temporary data in it
2026.10.27 16:55:26.256432 [ 9 ] {} <Debug> Application: Configuration parameter 'interserver_http_host' doesn't exist or exists and empty. Will use 'github-hetzner-runner-40521195197-122265957546' as replica host.
2026.10.27 16:55:26.256448 [ 9 ] {} <Debug> Application: Initializing interserver credentials.
2026.10.27 16:55:26.256508 [ 9 ] {} <Trace> NamedCollectionsUtils: Loaded 0 collections from config
2026.10.27 16:55:26.256583 [ 9 ] {} <Trace> NamedCollectionsUtils: Loaded 0 collections from SQL
2026.10.27 16:55:26.256811 [ 9 ] {} <Debug> ConfigReloader: Loading config '/config/config.xml'
2026.10.27 16:55:26.259664 [ 9 ] {} <Debug> ConfigReloader: Loaded config '/config/config.xml', performing update on configuration
2026.10.27 16:55:26.261661 [ 9 ] {} <Information> Application: Setting max_server_memory_usage was set to 27.54 GiB (30.59 GiB available * 0.90 max_server_memory_usage_to_ram_ratio)
2026.10.27 16:55:26.261670 [ 9 ] {} <Information> Application: Setting merges_mutations_memory_usage_soft_limit was set to 15.30 GiB (30.59 GiB available * 0.50 merges_mutations_memory_usage_to_ram_ratio)
2026.10.27 16:55:26.261675 [ 9 ] {} <Information> Application: Merges and mutations memory limit is set to 15.30 GiB
2026.10.27 16:55:26.261924 [ 9 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads
2026.10.27 16:55:26.262972 [ 9 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 128 threads
2026.10.27 16:55:26.279667 [ 9 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads
2026.10.27 16:55:26.281373 [ 9 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads
2026.10.27 16:55:26.283251 [ 9 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again.
2026.10.27 16:55:26.283281 [ 9 ] {} <Debug> ConfigReloader: Loaded config '/config/config.xml', performed update on configuration
2026.10.27 16:55:26.291234 [ 9 ] {} <Information> Application: Listening for replica communication (interserver): http://[::1]:9009
2026.10.27 16:55:26.302914 [ 9 ] {} <Information> Application: Listening for replica communication (interserver): http://127.0.0.1:9009
2026.10.27 16:55:26.309422 [ 9 ] {} <Debug> ConfigReloader: Loading config '/config/users.xml'
2026.10.27 16:55:26.309854 [ 9 ] {} <Debug> ConfigReloader: Loaded config '/config/users.xml', performing update on configuration
2026.10.27 16:55:26.310381 [ 9 ] {} <Debug> ConfigReloader: Loaded config '/config/users.xml', performed update on configuration
2026.10.27 16:55:26.310519 [ 9 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: /config/users.xml
2026.10.27 16:55:26.310650 [ 9 ] {} <Warning> Access(local_directory): File /var/lib/clickhouse/access/users.list doesn't exist
2026.10.27 16:55:26.310677 [ 9 ] {} <Warning> Access(local_directory): Recovering lists in directory /var/lib/clickhouse/access/
2026.10.27 16:55:26.310893 [ 9 ] {} <Debug> Access(user directories): Added local_directory access storage 'local_directory', path: /var/lib/clickhouse/access/
2026.10.27 16:55:26.312679 [ 9 ] {} <Information> Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32, scheduling_policy=round_robin
2026.10.27 16:55:26.314153 [ 9 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8
2026.10.27 16:55:26.314508 [ 9 ] {} <Information> Context: Initialized background executor for fetches with num_threads=8, num_tasks=8
2026.10.27 16:55:26.314967 [ 9 ] {} <Information> Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8
2026.10.27 16:55:26.320931 [ 9 ] {} <Information> DNSCacheUpdater: Update period 15 seconds
2026.10.27 16:55:26.320973 [ 9 ] {} <Information> Application: Loading metadata from /var/lib/clickhouse/
2026.10.27 16:55:26.321038 [ 31 ] {} <Debug> DNSResolver: Updating DNS cache
2026.10.27 16:55:26.321550 [ 31 ] {} <Debug> DNSResolver: Updated DNS cache
2026.10.27 16:55:26.327840 [ 9 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total.
2026.10.27 16:55:26.327868 [ 9 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.00018199 sec
2026.10.27 16:55:26.327882 [ 9 ] {} <Trace> ReferentialDeps: No tables
2026.10.27 16:55:26.327894 [ 9 ] {} <Trace> LoadingDeps: No tables
2026.10.27 16:55:26.327942 [ 9 ] {} <Information> DatabaseAtomic (system): Starting up tables.
2026.10.27 16:55:26.327980 [ 9 ] {} <Debug> SystemLog: Creating system.query_log from query_log
2026.10.27 16:55:26.329280 [ 9 ] {} <Debug> SystemLog: Creating system.query_thread_log from query_thread_log
2026.10.27 16:55:26.329688 [ 9 ] {} <Debug> SystemLog: Creating system.part_log from part_log
2026.10.27 16:55:26.330154 [ 9 ] {} <Debug> SystemLog: Creating system.trace_log from trace_log
2026.10.27 16:55:26.330423 [ 9 ] {} <Debug> SystemLog: Creating system.crash_log from crash_log
2026.10.27 16:55:26.330585 [ 9 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config
2026.10.27 16:55:26.330605 [ 9 ] {} <Debug> SystemLog: Creating system.metric_log from metric_log
2026.10.27 16:55:26.333889 [ 9 ] {} <Debug> SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config
2026.10.27 16:55:26.333939 [ 9 ] {} <Debug> SystemLog: Not creating system.filesystem_read_prefetches_log since corresponding section 'filesystem_read_prefetches_log' is missing from config
2026.10.27 16:55:26.333962 [ 9 ] {} <Debug> SystemLog: Creating system.asynchronous_metric_log from asynchronous_metric_log
2026.10.27 16:55:26.334231 [ 9 ] {} <Debug> SystemLog: Creating system.opentelemetry_span_log from opentelemetry_span_log
2026.10.27 16:55:26.334558 [ 9 ] {} <Debug> SystemLog: Creating system.query_views_log from query_views_log
2026.10.27 16:55:26.334932 [ 9 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config
2026.10.27 16:55:26.334959 [ 9 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config
2026.10.27 16:55:26.334978 [ 9 ] {} <Debug> SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config
2026.10.27 16:55:26.334998 [ 9 ] {} <Debug> SystemLog: Creating system.processors_profile_log from processors_profile_log
2026.10.27 16:55:26.335226 [ 9 ] {} <Debug> SystemLog: Creating system.asynchronous_insert_log from asynchronous_insert_log
2026.10.27 16:55:26.357933 [ 9 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal.
2026.10.27 16:55:26.360472 [ 9 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total.
2026.10.27 16:55:26.360493 [ 9 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 7.151e-05 sec
2026.10.27 16:55:26.360503 [ 9 ] {} <Trace> ReferentialDeps: No tables
2026.10.27 16:55:26.360512 [ 9 ] {} <Trace> LoadingDeps: No tables
2026.10.27 16:55:26.360532 [ 9 ] {} <Information> DatabaseAtomic (default): Starting up tables.
2026.10.27 16:55:26.360742 [ 9 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/lib/clickhouse/user_defined/
2026.10.27 16:55:26.360798 [ 9 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded
2026.10.27 16:55:26.360807 [ 9 ] {} <Debug> Application: Loaded metadata.
2026.10.27 16:55:26.360848 [ 9 ] {} <Trace> Pipe: Pipe capacity is 1.00 MiB
2026.10.27 16:55:26.360979 [ 9 ] {} <Information> Application: Tasks stats provider: procfs
2026.10.27 16:55:26.360990 [ 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.27 16:55:26.361648 [ 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.43.altinitystable (altinity build))
2026.10.27 16:55:26.361788 [ 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.43.altinitystable (altinity build))
2026.10.27 16:55:26.361797 [ 9 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair.
2026.10.27 16:55:26.431650 [ 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.43.altinitystable (altinity build))
2026.10.27 16:55:26.431722 [ 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.43.altinitystable (altinity build))
2026.10.27 16:55:26.431737 [ 9 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair.
2026.10.27 16:55:26.503028 [ 9 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again.
2026.10.27 16:55:26.503702 [ 9 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 40.27 MiB, peak 40.27 MiB, free memory in arenas 46.36 MiB, will set to 445.19 MiB (RSS), difference: 404.92 MiB
2026.10.27 16:55:26.504622 [ 9 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 1.074e-05 sec.
2026.10.27 16:55:26.505568 [ 9 ] {} <Information> Application: Listening for http://[::1]:8123
2026.10.27 16:55:26.505615 [ 9 ] {} <Information> Application: Listening for native protocol (tcp): [::1]:9000
2026.10.27 16:55:26.505654 [ 9 ] {} <Information> Application: Listening for MySQL compatibility protocol: [::1]:9004
2026.10.27 16:55:26.505707 [ 9 ] {} <Information> Application: Listening for PostgreSQL compatibility protocol: [::1]:9005
2026.10.27 16:55:26.505750 [ 9 ] {} <Information> Application: Listening for http://127.0.0.1:8123
2026.10.27 16:55:26.505788 [ 9 ] {} <Information> Application: Listening for native protocol (tcp): 127.0.0.1:9000
2026.10.27 16:55:26.505828 [ 9 ] {} <Information> Application: Listening for MySQL compatibility protocol: 127.0.0.1:9004
2026.10.27 16:55:26.505865 [ 9 ] {} <Information> Application: Listening for PostgreSQL compatibility protocol: 127.0.0.1:9005
2026.10.27 16:55:26.505870 [ 9 ] {} <Information> Application: Ready for connections.
2026.10.27 16:55:27.000677 [ 266 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 445.21 MiB, peak 445.21 MiB, free memory in arenas 46.40 MiB, will set to 447.77 MiB (RSS), difference: 2.57 MiB
2026.10.27 16:55:30.972390 [ 11 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: 127.0.0.1:53830
2026.10.27 16:55:30.972512 [ 11 ] {} <Debug> TCPHandler: Connected ClickHouse client version 23.8.0, revision: 54465, user: default.
2026.10.27 16:55:30.972539 [ 11 ] {} <Debug> TCP-Session: bc899cff-4620-43d5-8885-bc07c67c9ce5 Authenticating user 'default' from 127.0.0.1:53830
2026.10.27 16:55:30.972555 [ 11 ] {} <Debug> TCP-Session: bc899cff-4620-43d5-8885-bc07c67c9ce5 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
2026.10.27 16:55:30.972561 [ 11 ] {} <Debug> TCP-Session: bc899cff-4620-43d5-8885-bc07c67c9ce5 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
2026.10.27 16:55:30.972639 [ 11 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false
2026.10.27 16:55:30.972657 [ 11 ] {} <Trace> ContextAccess (default): List of all grants: GRANT SHOW, SELECT, INSERT, ALTER, CREATE, DROP, UNDROP TABLE, TRUNCATE, OPTIMIZE, BACKUP, KILL QUERY, KILL TRANSACTION, MOVE PARTITION BETWEEN SHARDS, SYSTEM, dictGet, displaySecretsInShowAndSelect, INTROSPECTION, SOURCES, CLUSTER ON *.*
2026.10.27 16:55:30.972665 [ 11 ] {} <Trace> ContextAccess (default): List of all grants including implicit: GRANT SHOW, SELECT, INSERT, ALTER, CREATE, DROP, UNDROP TABLE, TRUNCATE, OPTIMIZE, BACKUP, KILL QUERY, KILL TRANSACTION, MOVE PARTITION BETWEEN SHARDS, SYSTEM, dictGet, displaySecretsInShowAndSelect, INTROSPECTION, SOURCES, CLUSTER ON *.*
2026.10.27 16:55:30.991189 [ 11 ] {} <Trace> TCP-Session: bc899cff-4620-43d5-8885-bc07c67c9ce5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
2026.10.27 16:55:30.991388 [ 11 ] {719d9915-83a7-4069-9181-7296937ab87e} <Debug> executeQuery: (from 127.0.0.1:53830) select 'OK' (stage: Complete)
2026.10.27 16:55:30.991551 [ 11 ] {719d9915-83a7-4069-9181-7296937ab87e} <Trace> ContextAccess (default): Access granted: SELECT(dummy) ON system.one
2026.10.27 16:55:30.991582 [ 11 ] {719d9915-83a7-4069-9181-7296937ab87e} <Trace> InterpreterSelectQuery: FetchColumns -> Complete
2026.10.27 16:55:30.992392 [ 11 ] {719d9915-83a7-4069-9181-7296937ab87e} <Debug> executeQuery: Read 1 rows, 1.00 B in 0.001012 sec., 988.1422924901185 rows/sec., 988.14 B/sec.
2026.10.27 16:55:30.992422 [ 11 ] {719d9915-83a7-4069-9181-7296937ab87e} <Debug> TCPHandler: Processed in 0.001312331 sec.
2026.10.27 16:55:30.994597 [ 11 ] {} <Debug> TCPHandler: Done processing connection.
2026.10.27 16:55:30.994614 [ 11 ] {} <Debug> TCP-Session: bc899cff-4620-43d5-8885-bc07c67c9ce5 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db