2026.10.28 06:51:51.093354 [ 8 ] {} <Information> Application: Will watch for the process with pid 10
2026.10.28 06:51:51.093585 [ 10 ] {} <Information> Application: Forked a child process to watch
2026.10.28 06:51:51.094021 [ 10 ] {} <Information> SentryWriter: Sending crash reports is disabled
2026.10.28 06:51:51.094203 [ 10 ] {} <Trace> Pipe: Pipe capacity is 1.00 MiB
2026.10.28 06:51:51.207329 [ 10 ] {} <Information> Application: Starting ClickHouse 23.8.16.43.altinitystable (revision: 54477, git hash: d59f55c483d377f17a87ec7c465a08c887e053f9, build id: 112C8E72C3AB75BD1CACC2B94EB43D90D46CE1DC), PID 10
2026.10.28 06:51:51.207469 [ 10 ] {} <Information> Application: starting up
2026.10.28 06:51:51.207488 [ 10 ] {} <Information> Application: OS name: Linux, version: 5.15.0-130-generic, architecture: x86_64
2026.10.28 06:51:51.211412 [ 10 ] {} <Information> Application: Available RAM: 30.59 GiB; physical cores: 16; logical cores: 16.
2026.10.28 06:51:51.212545 [ 10 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/thermal
2026.10.28 06:51:51.212567 [ 10 ] {} <Trace> AsynchronousMetrics: Scanning /sys/block
2026.10.28 06:51:51.212665 [ 10 ] {} <Trace> AsynchronousMetrics: Scanning /sys/devices/system/edac
2026.10.28 06:51:51.212684 [ 10 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/hwmon
2026.10.28 06:51:51.350887 [ 10 ] {} <Information> Application: Integrity check of the executable successfully passed (checksum: 7C79D7D28408289E441A33BE4FBA054E)
2026.10.28 06:51:51.350952 [ 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.28 06:51:51.353090 [ 10 ] {} <Debug> Application: rlimit on number of file descriptors is 1048576
2026.10.28 06:51:51.353110 [ 10 ] {} <Debug> Application: rlimit on number of threads is 18446744073709551615
2026.10.28 06:51:51.353120 [ 10 ] {} <Debug> Application: Initializing DateLUT.
2026.10.28 06:51:51.353126 [ 10 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'.
2026.10.28 06:51:51.353170 [ 10 ] {} <Debug> Context: Setting up /var/lib/clickhouse/tmp/ to store temporary data in it
2026.10.28 06:51:51.354000 [ 10 ] {} <Debug> Application: Configuration parameter 'interserver_http_host' doesn't exist or exists and empty. Will use 'github-hetzner-runner-40639463102-122669575661' as replica host.
2026.10.28 06:51:51.354021 [ 10 ] {} <Debug> Application: Initializing interserver credentials.
2026.10.28 06:51:51.354101 [ 10 ] {} <Trace> NamedCollectionsUtils: Loaded 0 collections from config
2026.10.28 06:51:51.354200 [ 10 ] {} <Trace> NamedCollectionsUtils: Loaded 0 collections from SQL
2026.10.28 06:51:51.354533 [ 10 ] {} <Debug> ConfigReloader: Loading config '/config/config.xml'
2026.10.28 06:51:51.358837 [ 10 ] {} <Debug> ConfigReloader: Loaded config '/config/config.xml', performing update on configuration
2026.10.28 06:51:51.360956 [ 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.28 06:51:51.360968 [ 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.28 06:51:51.360972 [ 10 ] {} <Information> Application: Merges and mutations memory limit is set to 15.30 GiB
2026.10.28 06:51:51.361249 [ 10 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads
2026.10.28 06:51:51.363414 [ 10 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 128 threads
2026.10.28 06:51:51.378943 [ 10 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads
2026.10.28 06:51:51.380762 [ 10 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads
2026.10.28 06:51:51.383039 [ 10 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again.
2026.10.28 06:51:51.383078 [ 10 ] {} <Debug> ConfigReloader: Loaded config '/config/config.xml', performed update on configuration
2026.10.28 06:51:51.396288 [ 10 ] {} <Information> Application: Listening for replica communication (interserver): http://[::1]:9009
2026.10.28 06:51:51.402399 [ 10 ] {} <Information> Application: Listening for replica communication (interserver): http://127.0.0.1:9009
2026.10.28 06:51:51.413081 [ 10 ] {} <Debug> ConfigReloader: Loading config '/config/users.xml'
2026.10.28 06:51:51.413953 [ 10 ] {} <Debug> ConfigReloader: Loaded config '/config/users.xml', performing update on configuration
2026.10.28 06:51:51.415036 [ 10 ] {} <Debug> ConfigReloader: Loaded config '/config/users.xml', performed update on configuration
2026.10.28 06:51:51.415269 [ 10 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: /config/users.xml
2026.10.28 06:51:51.415521 [ 10 ] {} <Warning> Access(local_directory): File /var/lib/clickhouse/access/users.list doesn't exist
2026.10.28 06:51:51.415569 [ 10 ] {} <Warning> Access(local_directory): Recovering lists in directory /var/lib/clickhouse/access/
2026.10.28 06:51:51.415997 [ 10 ] {} <Debug> Access(user directories): Added local_directory access storage 'local_directory', path: /var/lib/clickhouse/access/
2026.10.28 06:51:51.417622 [ 10 ] {} <Information> Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32, scheduling_policy=round_robin
2026.10.28 06:51:51.418709 [ 10 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8
2026.10.28 06:51:51.419540 [ 10 ] {} <Information> Context: Initialized background executor for fetches with num_threads=8, num_tasks=8
2026.10.28 06:51:51.420376 [ 10 ] {} <Information> Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8
2026.10.28 06:51:51.422155 [ 10 ] {} <Information> DNSCacheUpdater: Update period 15 seconds
2026.10.28 06:51:51.422194 [ 10 ] {} <Information> Application: Loading metadata from /var/lib/clickhouse/
2026.10.28 06:51:51.422441 [ 32 ] {} <Debug> DNSResolver: Updating DNS cache
2026.10.28 06:51:51.427419 [ 32 ] {} <Debug> DNSResolver: Updated DNS cache
2026.10.28 06:51:51.431483 [ 10 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total.
2026.10.28 06:51:51.431506 [ 10 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.000122324 sec
2026.10.28 06:51:51.431518 [ 10 ] {} <Trace> ReferentialDeps: No tables
2026.10.28 06:51:51.431528 [ 10 ] {} <Trace> LoadingDeps: No tables
2026.10.28 06:51:51.431571 [ 10 ] {} <Information> DatabaseAtomic (system): Starting up tables.
2026.10.28 06:51:51.431607 [ 10 ] {} <Debug> SystemLog: Creating system.query_log from query_log
2026.10.28 06:51:51.432960 [ 10 ] {} <Debug> SystemLog: Creating system.query_thread_log from query_thread_log
2026.10.28 06:51:51.433424 [ 10 ] {} <Debug> SystemLog: Creating system.part_log from part_log
2026.10.28 06:51:51.433795 [ 10 ] {} <Debug> SystemLog: Creating system.trace_log from trace_log
2026.10.28 06:51:51.434043 [ 10 ] {} <Debug> SystemLog: Creating system.crash_log from crash_log
2026.10.28 06:51:51.434243 [ 10 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config
2026.10.28 06:51:51.434263 [ 10 ] {} <Debug> SystemLog: Creating system.metric_log from metric_log
2026.10.28 06:51:51.437583 [ 10 ] {} <Debug> SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config
2026.10.28 06:51:51.437622 [ 10 ] {} <Debug> SystemLog: Not creating system.filesystem_read_prefetches_log since corresponding section 'filesystem_read_prefetches_log' is missing from config
2026.10.28 06:51:51.437657 [ 10 ] {} <Debug> SystemLog: Creating system.asynchronous_metric_log from asynchronous_metric_log
2026.10.28 06:51:51.437960 [ 10 ] {} <Debug> SystemLog: Creating system.opentelemetry_span_log from opentelemetry_span_log
2026.10.28 06:51:51.438258 [ 10 ] {} <Debug> SystemLog: Creating system.query_views_log from query_views_log
2026.10.28 06:51:51.438572 [ 10 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config
2026.10.28 06:51:51.438593 [ 10 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config
2026.10.28 06:51:51.438610 [ 10 ] {} <Debug> SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config
2026.10.28 06:51:51.438627 [ 10 ] {} <Debug> SystemLog: Creating system.processors_profile_log from processors_profile_log
2026.10.28 06:51:51.438870 [ 10 ] {} <Debug> SystemLog: Creating system.asynchronous_insert_log from asynchronous_insert_log
2026.10.28 06:51:51.461903 [ 10 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal.
2026.10.28 06:51:51.464163 [ 10 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total.
2026.10.28 06:51:51.464173 [ 10 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 3.317e-05 sec
2026.10.28 06:51:51.464178 [ 10 ] {} <Trace> ReferentialDeps: No tables
2026.10.28 06:51:51.464182 [ 10 ] {} <Trace> LoadingDeps: No tables
2026.10.28 06:51:51.464192 [ 10 ] {} <Information> DatabaseAtomic (default): Starting up tables.
2026.10.28 06:51:51.464289 [ 10 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/lib/clickhouse/user_defined/
2026.10.28 06:51:51.464315 [ 10 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded
2026.10.28 06:51:51.464319 [ 10 ] {} <Debug> Application: Loaded metadata.
2026.10.28 06:51:51.464343 [ 10 ] {} <Trace> Pipe: Pipe capacity is 1.00 MiB
2026.10.28 06:51:51.464414 [ 10 ] {} <Information> Application: Tasks stats provider: procfs
2026.10.28 06:51:51.464419 [ 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.28 06:51:51.464730 [ 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.28 06:51:51.464860 [ 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.28 06:51:51.464865 [ 10 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair.
2026.10.28 06:51:51.488834 [ 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.28 06:51:51.488889 [ 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.28 06:51:51.488894 [ 10 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair.
2026.10.28 06:51:51.539271 [ 10 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again.
2026.10.28 06:51:51.539915 [ 10 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 40.27 MiB, peak 40.27 MiB, free memory in arenas 45.04 MiB, will set to 445.80 MiB (RSS), difference: 405.53 MiB
2026.10.28 06:51:51.540437 [ 10 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 1.0766e-05 sec.
2026.10.28 06:51:51.541504 [ 10 ] {} <Information> Application: Listening for http://[::1]:8123
2026.10.28 06:51:51.541560 [ 10 ] {} <Information> Application: Listening for native protocol (tcp): [::1]:9000
2026.10.28 06:51:51.541599 [ 10 ] {} <Information> Application: Listening for MySQL compatibility protocol: [::1]:9004
2026.10.28 06:51:51.541650 [ 10 ] {} <Information> Application: Listening for PostgreSQL compatibility protocol: [::1]:9005
2026.10.28 06:51:51.541689 [ 10 ] {} <Information> Application: Listening for http://127.0.0.1:8123
2026.10.28 06:51:51.541724 [ 10 ] {} <Information> Application: Listening for native protocol (tcp): 127.0.0.1:9000
2026.10.28 06:51:51.541776 [ 10 ] {} <Information> Application: Listening for MySQL compatibility protocol: 127.0.0.1:9004
2026.10.28 06:51:51.541827 [ 10 ] {} <Information> Application: Listening for PostgreSQL compatibility protocol: 127.0.0.1:9005
2026.10.28 06:51:51.541832 [ 10 ] {} <Information> Application: Ready for connections.
2026.10.28 06:51:52.000861 [ 267 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 445.81 MiB, peak 445.81 MiB, free memory in arenas 45.08 MiB, will set to 448.38 MiB (RSS), difference: 2.57 MiB
2026.10.28 06:51:56.065690 [ 12 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:60286
2026.10.28 06:51:56.065809 [ 12 ] {} <Debug> TCPHandler: Connected ClickHouse client version 23.8.0, revision: 54465, user: default.
2026.10.28 06:51:56.065833 [ 12 ] {} <Debug> TCP-Session: c66fd787-c137-4094-8921-3361914dcae5 Authenticating user 'default' from [::1]:60286
2026.10.28 06:51:56.065845 [ 12 ] {} <Debug> TCP-Session: c66fd787-c137-4094-8921-3361914dcae5 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
2026.10.28 06:51:56.065850 [ 12 ] {} <Debug> TCP-Session: c66fd787-c137-4094-8921-3361914dcae5 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
2026.10.28 06:51:56.065927 [ 12 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false
2026.10.28 06:51:56.065944 [ 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.28 06:51:56.065950 [ 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.28 06:51:56.073754 [ 12 ] {} <Trace> TCP-Session: c66fd787-c137-4094-8921-3361914dcae5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
2026.10.28 06:51:56.073939 [ 12 ] {34ac8f07-882b-453d-a4ae-688398d91447} <Debug> executeQuery: (from [::1]:60286) select 'OK' (stage: Complete)
2026.10.28 06:51:56.074092 [ 12 ] {34ac8f07-882b-453d-a4ae-688398d91447} <Trace> ContextAccess (default): Access granted: SELECT(dummy) ON system.one
2026.10.28 06:51:56.074124 [ 12 ] {34ac8f07-882b-453d-a4ae-688398d91447} <Trace> InterpreterSelectQuery: FetchColumns -> Complete
2026.10.28 06:51:56.075239 [ 12 ] {34ac8f07-882b-453d-a4ae-688398d91447} <Debug> executeQuery: Read 1 rows, 1.00 B in 0.001307 sec., 765.1109410864575 rows/sec., 765.11 B/sec.
2026.10.28 06:51:56.075266 [ 12 ] {34ac8f07-882b-453d-a4ae-688398d91447} <Debug> TCPHandler: Processed in 0.001578359 sec.
2026.10.28 06:51:56.076252 [ 12 ] {} <Debug> TCPHandler: Done processing connection.
2026.10.28 06:51:56.076269 [ 12 ] {} <Debug> TCP-Session: c66fd787-c137-4094-8921-3361914dcae5 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
2026.10.28 06:51:56.485336 [ 7 ] {} <Information> Application: Will watch for the process with pid 9
2026.10.28 06:51:56.485662 [ 9 ] {} <Information> Application: Forked a child process to watch
2026.10.28 06:51:56.486222 [ 9 ] {} <Information> SentryWriter: Sending crash reports is disabled
2026.10.28 06:51:56.486422 [ 9 ] {} <Trace> Pipe: Pipe capacity is 1.00 MiB
2026.10.28 06:51:56.596923 [ 9 ] {} <Information> Application: Starting ClickHouse 23.8.16.43.altinitystable (revision: 54477, git hash: d59f55c483d377f17a87ec7c465a08c887e053f9, build id: 112C8E72C3AB75BD1CACC2B94EB43D90D46CE1DC), PID 9
2026.10.28 06:51:56.597061 [ 9 ] {} <Information> Application: starting up
2026.10.28 06:51:56.597080 [ 9 ] {} <Information> Application: OS name: Linux, version: 5.15.0-130-generic, architecture: x86_64
2026.10.28 06:51:56.600989 [ 9 ] {} <Information> Application: Available RAM: 30.59 GiB; physical cores: 16; logical cores: 16.
2026.10.28 06:51:56.602175 [ 9 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/thermal
2026.10.28 06:51:56.602196 [ 9 ] {} <Trace> AsynchronousMetrics: Scanning /sys/block
2026.10.28 06:51:56.602283 [ 9 ] {} <Trace> AsynchronousMetrics: Scanning /sys/devices/system/edac
2026.10.28 06:51:56.602300 [ 9 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/hwmon
2026.10.28 06:51:56.741163 [ 9 ] {} <Information> Application: Integrity check of the executable successfully passed (checksum: 7C79D7D28408289E441A33BE4FBA054E)
2026.10.28 06:51:56.741225 [ 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.28 06:51:56.743464 [ 9 ] {} <Debug> Application: rlimit on number of file descriptors is 1048576
2026.10.28 06:51:56.743482 [ 9 ] {} <Debug> Application: rlimit on number of threads is 18446744073709551615
2026.10.28 06:51:56.743491 [ 9 ] {} <Debug> Application: Initializing DateLUT.
2026.10.28 06:51:56.743496 [ 9 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'.
2026.10.28 06:51:56.743529 [ 9 ] {} <Debug> Context: Setting up /var/lib/clickhouse/tmp/ to store temporary data in it
2026.10.28 06:51:56.744161 [ 9 ] {} <Debug> Application: Configuration parameter 'interserver_http_host' doesn't exist or exists and empty. Will use 'github-hetzner-runner-40639463102-122669575661' as replica host.
2026.10.28 06:51:56.744176 [ 9 ] {} <Debug> Application: Initializing interserver credentials.
2026.10.28 06:51:56.744238 [ 9 ] {} <Trace> NamedCollectionsUtils: Loaded 0 collections from config
2026.10.28 06:51:56.744313 [ 9 ] {} <Trace> NamedCollectionsUtils: Loaded 0 collections from SQL
2026.10.28 06:51:56.744561 [ 9 ] {} <Debug> ConfigReloader: Loading config '/config/config.xml'
2026.10.28 06:51:56.747395 [ 9 ] {} <Debug> ConfigReloader: Loaded config '/config/config.xml', performing update on configuration
2026.10.28 06:51:56.749429 [ 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.28 06:51:56.749438 [ 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.28 06:51:56.749443 [ 9 ] {} <Information> Application: Merges and mutations memory limit is set to 15.30 GiB
2026.10.28 06:51:56.749671 [ 9 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads
2026.10.28 06:51:56.750795 [ 9 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 128 threads
2026.10.28 06:51:56.770109 [ 9 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads
2026.10.28 06:51:56.772374 [ 9 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads
2026.10.28 06:51:56.793321 [ 9 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again.
2026.10.28 06:51:56.793344 [ 9 ] {} <Debug> ConfigReloader: Loaded config '/config/config.xml', performed update on configuration
2026.10.28 06:51:56.794906 [ 9 ] {} <Information> Application: Listening for replica communication (interserver): http://[::1]:9009
2026.10.28 06:51:56.794957 [ 9 ] {} <Information> Application: Listening for replica communication (interserver): http://127.0.0.1:9009
2026.10.28 06:51:56.796935 [ 9 ] {} <Debug> ConfigReloader: Loading config '/config/users.xml'
2026.10.28 06:51:56.797325 [ 9 ] {} <Debug> ConfigReloader: Loaded config '/config/users.xml', performing update on configuration
2026.10.28 06:51:56.797838 [ 9 ] {} <Debug> ConfigReloader: Loaded config '/config/users.xml', performed update on configuration
2026.10.28 06:51:56.797987 [ 9 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: /config/users.xml
2026.10.28 06:51:56.798107 [ 9 ] {} <Warning> Access(local_directory): File /var/lib/clickhouse/access/users.list doesn't exist
2026.10.28 06:51:56.798128 [ 9 ] {} <Warning> Access(local_directory): Recovering lists in directory /var/lib/clickhouse/access/
2026.10.28 06:51:56.798306 [ 9 ] {} <Debug> Access(user directories): Added local_directory access storage 'local_directory', path: /var/lib/clickhouse/access/
2026.10.28 06:51:56.799498 [ 9 ] {} <Information> Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32, scheduling_policy=round_robin
2026.10.28 06:51:56.799997 [ 9 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8
2026.10.28 06:51:56.800443 [ 9 ] {} <Information> Context: Initialized background executor for fetches with num_threads=8, num_tasks=8
2026.10.28 06:51:56.801019 [ 9 ] {} <Information> Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8
2026.10.28 06:51:56.807714 [ 9 ] {} <Information> DNSCacheUpdater: Update period 15 seconds
2026.10.28 06:51:56.807924 [ 9 ] {} <Information> Application: Loading metadata from /var/lib/clickhouse/
2026.10.28 06:51:56.808022 [ 31 ] {} <Debug> DNSResolver: Updating DNS cache
2026.10.28 06:51:56.808972 [ 31 ] {} <Debug> DNSResolver: Updated DNS cache
2026.10.28 06:51:56.815358 [ 9 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total.
2026.10.28 06:51:56.815387 [ 9 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.000151096 sec
2026.10.28 06:51:56.815402 [ 9 ] {} <Trace> ReferentialDeps: No tables
2026.10.28 06:51:56.815414 [ 9 ] {} <Trace> LoadingDeps: No tables
2026.10.28 06:51:56.815463 [ 9 ] {} <Information> DatabaseAtomic (system): Starting up tables.
2026.10.28 06:51:56.815502 [ 9 ] {} <Debug> SystemLog: Creating system.query_log from query_log
2026.10.28 06:51:56.816848 [ 9 ] {} <Debug> SystemLog: Creating system.query_thread_log from query_thread_log
2026.10.28 06:51:56.817308 [ 9 ] {} <Debug> SystemLog: Creating system.part_log from part_log
2026.10.28 06:51:56.817679 [ 9 ] {} <Debug> SystemLog: Creating system.trace_log from trace_log
2026.10.28 06:51:56.817929 [ 9 ] {} <Debug> SystemLog: Creating system.crash_log from crash_log
2026.10.28 06:51:56.818091 [ 9 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config
2026.10.28 06:51:56.818111 [ 9 ] {} <Debug> SystemLog: Creating system.metric_log from metric_log
2026.10.28 06:51:56.821395 [ 9 ] {} <Debug> SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config
2026.10.28 06:51:56.821442 [ 9 ] {} <Debug> SystemLog: Not creating system.filesystem_read_prefetches_log since corresponding section 'filesystem_read_prefetches_log' is missing from config
2026.10.28 06:51:56.821466 [ 9 ] {} <Debug> SystemLog: Creating system.asynchronous_metric_log from asynchronous_metric_log
2026.10.28 06:51:56.821730 [ 9 ] {} <Debug> SystemLog: Creating system.opentelemetry_span_log from opentelemetry_span_log
2026.10.28 06:51:56.822057 [ 9 ] {} <Debug> SystemLog: Creating system.query_views_log from query_views_log
2026.10.28 06:51:56.822365 [ 9 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config
2026.10.28 06:51:56.822387 [ 9 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config
2026.10.28 06:51:56.822406 [ 9 ] {} <Debug> SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config
2026.10.28 06:51:56.822425 [ 9 ] {} <Debug> SystemLog: Creating system.processors_profile_log from processors_profile_log
2026.10.28 06:51:56.822646 [ 9 ] {} <Debug> SystemLog: Creating system.asynchronous_insert_log from asynchronous_insert_log
2026.10.28 06:51:56.846111 [ 9 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal.
2026.10.28 06:51:56.848633 [ 9 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total.
2026.10.28 06:51:56.848654 [ 9 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 7.2409e-05 sec
2026.10.28 06:51:56.848665 [ 9 ] {} <Trace> ReferentialDeps: No tables
2026.10.28 06:51:56.848674 [ 9 ] {} <Trace> LoadingDeps: No tables
2026.10.28 06:51:56.848696 [ 9 ] {} <Information> DatabaseAtomic (default): Starting up tables.
2026.10.28 06:51:56.848906 [ 9 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/lib/clickhouse/user_defined/
2026.10.28 06:51:56.848959 [ 9 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded
2026.10.28 06:51:56.848968 [ 9 ] {} <Debug> Application: Loaded metadata.
2026.10.28 06:51:56.849009 [ 9 ] {} <Trace> Pipe: Pipe capacity is 1.00 MiB
2026.10.28 06:51:56.849141 [ 9 ] {} <Information> Application: Tasks stats provider: procfs
2026.10.28 06:51:56.849152 [ 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.28 06:51:56.849838 [ 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.28 06:51:56.849966 [ 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.28 06:51:56.849975 [ 9 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair.
2026.10.28 06:51:56.906193 [ 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.28 06:51:56.906254 [ 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.28 06:51:56.906267 [ 9 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair.
2026.10.28 06:51:56.939817 [ 9 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again.
2026.10.28 06:51:56.940482 [ 9 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 40.25 MiB, peak 40.25 MiB, free memory in arenas 46.79 MiB, will set to 445.30 MiB (RSS), difference: 405.05 MiB
2026.10.28 06:51:56.941412 [ 9 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 1.0936e-05 sec.
2026.10.28 06:51:56.942316 [ 9 ] {} <Information> Application: Listening for http://[::1]:8123
2026.10.28 06:51:56.942368 [ 9 ] {} <Information> Application: Listening for native protocol (tcp): [::1]:9000
2026.10.28 06:51:56.942409 [ 9 ] {} <Information> Application: Listening for MySQL compatibility protocol: [::1]:9004
2026.10.28 06:51:56.942448 [ 9 ] {} <Information> Application: Listening for PostgreSQL compatibility protocol: [::1]:9005
2026.10.28 06:51:56.942486 [ 9 ] {} <Information> Application: Listening for http://127.0.0.1:8123
2026.10.28 06:51:56.942528 [ 9 ] {} <Information> Application: Listening for native protocol (tcp): 127.0.0.1:9000
2026.10.28 06:51:56.942568 [ 9 ] {} <Information> Application: Listening for MySQL compatibility protocol: 127.0.0.1:9004
2026.10.28 06:51:56.942606 [ 9 ] {} <Information> Application: Listening for PostgreSQL compatibility protocol: 127.0.0.1:9005
2026.10.28 06:51:56.942611 [ 9 ] {} <Information> Application: Ready for connections.
2026.10.28 06:51:57.000679 [ 266 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 445.31 MiB, peak 445.31 MiB, free memory in arenas 46.71 MiB, will set to 447.75 MiB (RSS), difference: 2.44 MiB
2026.10.28 06:52:01.474637 [ 11 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: 127.0.0.1:35150
2026.10.28 06:52:01.474857 [ 11 ] {} <Debug> TCPHandler: Connected ClickHouse client version 23.8.0, revision: 54465, user: default.
2026.10.28 06:52:01.474898 [ 11 ] {} <Debug> TCP-Session: 44d152c3-ffca-44df-b084-3cd5f1173c34 Authenticating user 'default' from 127.0.0.1:35150
2026.10.28 06:52:01.474922 [ 11 ] {} <Debug> TCP-Session: 44d152c3-ffca-44df-b084-3cd5f1173c34 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
2026.10.28 06:52:01.474935 [ 11 ] {} <Debug> TCP-Session: 44d152c3-ffca-44df-b084-3cd5f1173c34 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
2026.10.28 06:52:01.475059 [ 11 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false
2026.10.28 06:52:01.475093 [ 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.28 06:52:01.475109 [ 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.28 06:52:01.493829 [ 11 ] {} <Trace> TCP-Session: 44d152c3-ffca-44df-b084-3cd5f1173c34 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
2026.10.28 06:52:01.494225 [ 11 ] {5305510b-1f60-41ae-a057-5d9226af636f} <Debug> executeQuery: (from 127.0.0.1:35150) select 'OK' (stage: Complete)
2026.10.28 06:52:01.494495 [ 11 ] {5305510b-1f60-41ae-a057-5d9226af636f} <Trace> ContextAccess (default): Access granted: SELECT(dummy) ON system.one
2026.10.28 06:52:01.494552 [ 11 ] {5305510b-1f60-41ae-a057-5d9226af636f} <Trace> InterpreterSelectQuery: FetchColumns -> Complete
2026.10.28 06:52:01.495860 [ 11 ] {5305510b-1f60-41ae-a057-5d9226af636f} <Debug> executeQuery: Read 1 rows, 1.00 B in 0.001651 sec., 605.6935190793458 rows/sec., 605.69 B/sec.
2026.10.28 06:52:01.495943 [ 11 ] {5305510b-1f60-41ae-a057-5d9226af636f} <Debug> TCPHandler: Processed in 0.002303167 sec.
2026.10.28 06:52:01.498071 [ 11 ] {} <Debug> TCPHandler: Done processing connection.
2026.10.28 06:52:01.498096 [ 11 ] {} <Debug> TCP-Session: 44d152c3-ffca-44df-b084-3cd5f1173c34 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db