2026.10.28 14:06:35.190048 [ 8 ] {} <Information> Application: Will watch for the process with pid 10
2026.10.28 14:06:35.190260 [ 10 ] {} <Information> Application: Forked a child process to watch
2026.10.28 14:06:35.190764 [ 10 ] {} <Information> SentryWriter: Sending crash reports is disabled
2026.10.28 14:06:35.190950 [ 10 ] {} <Trace> Pipe: Pipe capacity is 1.00 MiB
2026.10.28 14:06:35.302013 [ 10 ] {} <Information> Application: Starting ClickHouse 23.8.16.43.altinitystable (revision: 54477, git hash: a26de2e0e62c813df59bc08c1069dd5620e7c685, build id: D8039DA4E3474D50BED371A3CAA0576DB0826CBD), PID 10
2026.10.28 14:06:35.302148 [ 10 ] {} <Information> Application: starting up
2026.10.28 14:06:35.302166 [ 10 ] {} <Information> Application: OS name: Linux, version: 5.15.0-130-generic, architecture: x86_64
2026.10.28 14:06:35.305753 [ 10 ] {} <Information> Application: Available RAM: 30.59 GiB; physical cores: 16; logical cores: 16.
2026.10.28 14:06:35.306693 [ 10 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/thermal
2026.10.28 14:06:35.306710 [ 10 ] {} <Trace> AsynchronousMetrics: Scanning /sys/block
2026.10.28 14:06:35.306800 [ 10 ] {} <Trace> AsynchronousMetrics: Scanning /sys/devices/system/edac
2026.10.28 14:06:35.306817 [ 10 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/hwmon
2026.10.28 14:06:35.443581 [ 10 ] {} <Information> Application: Integrity check of the executable successfully passed (checksum: D2DEB088DC059EC9E51331ADEC269EE0)
2026.10.28 14:06:35.443665 [ 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 14:06:35.445744 [ 10 ] {} <Debug> Application: rlimit on number of file descriptors is 1048576
2026.10.28 14:06:35.445755 [ 10 ] {} <Debug> Application: rlimit on number of threads is 18446744073709551615
2026.10.28 14:06:35.445762 [ 10 ] {} <Debug> Application: Initializing DateLUT.
2026.10.28 14:06:35.445767 [ 10 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'.
2026.10.28 14:06:35.445789 [ 10 ] {} <Debug> Context: Setting up /var/lib/clickhouse/tmp/ to store temporary data in it
2026.10.28 14:06:35.446489 [ 10 ] {} <Debug> Application: Configuration parameter 'interserver_http_host' doesn't exist or exists and empty. Will use 'github-hetzner-runner-40687803414-122854835796' as replica host.
2026.10.28 14:06:35.446501 [ 10 ] {} <Debug> Application: Initializing interserver credentials.
2026.10.28 14:06:35.446559 [ 10 ] {} <Trace> NamedCollectionsUtils: Loaded 0 collections from config
2026.10.28 14:06:35.446664 [ 10 ] {} <Trace> NamedCollectionsUtils: Loaded 0 collections from SQL
2026.10.28 14:06:35.446881 [ 10 ] {} <Debug> ConfigReloader: Loading config '/config/config.xml'
2026.10.28 14:06:35.449748 [ 10 ] {} <Debug> ConfigReloader: Loaded config '/config/config.xml', performing update on configuration
2026.10.28 14:06:35.451741 [ 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 14:06:35.451749 [ 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 14:06:35.451753 [ 10 ] {} <Information> Application: Merges and mutations memory limit is set to 15.30 GiB
2026.10.28 14:06:35.452042 [ 10 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads
2026.10.28 14:06:35.454795 [ 10 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 128 threads
2026.10.28 14:06:35.469679 [ 10 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads
2026.10.28 14:06:35.490719 [ 10 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads
2026.10.28 14:06:35.493031 [ 10 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again.
2026.10.28 14:06:35.493076 [ 10 ] {} <Debug> ConfigReloader: Loaded config '/config/config.xml', performed update on configuration
2026.10.28 14:06:35.497322 [ 10 ] {} <Information> Application: Listening for replica communication (interserver): http://[::1]:9009
2026.10.28 14:06:35.497693 [ 10 ] {} <Information> Application: Listening for replica communication (interserver): http://127.0.0.1:9009
2026.10.28 14:06:35.503103 [ 10 ] {} <Debug> ConfigReloader: Loading config '/config/users.xml'
2026.10.28 14:06:35.504511 [ 10 ] {} <Debug> ConfigReloader: Loaded config '/config/users.xml', performing update on configuration
2026.10.28 14:06:35.505894 [ 10 ] {} <Debug> ConfigReloader: Loaded config '/config/users.xml', performed update on configuration
2026.10.28 14:06:35.506105 [ 10 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: /config/users.xml
2026.10.28 14:06:35.506369 [ 10 ] {} <Warning> Access(local_directory): File /var/lib/clickhouse/access/users.list doesn't exist
2026.10.28 14:06:35.506418 [ 10 ] {} <Warning> Access(local_directory): Recovering lists in directory /var/lib/clickhouse/access/
2026.10.28 14:06:35.506839 [ 10 ] {} <Debug> Access(user directories): Added local_directory access storage 'local_directory', path: /var/lib/clickhouse/access/
2026.10.28 14:06:35.508648 [ 10 ] {} <Information> Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32, scheduling_policy=round_robin
2026.10.28 14:06:35.509545 [ 10 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8
2026.10.28 14:06:35.510347 [ 10 ] {} <Information> Context: Initialized background executor for fetches with num_threads=8, num_tasks=8
2026.10.28 14:06:35.511501 [ 10 ] {} <Information> Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8
2026.10.28 14:06:35.513382 [ 10 ] {} <Information> DNSCacheUpdater: Update period 15 seconds
2026.10.28 14:06:35.513430 [ 10 ] {} <Information> Application: Loading metadata from /var/lib/clickhouse/
2026.10.28 14:06:35.513532 [ 45 ] {} <Debug> DNSResolver: Updating DNS cache
2026.10.28 14:06:35.517857 [ 45 ] {} <Debug> DNSResolver: Updated DNS cache
2026.10.28 14:06:35.520804 [ 10 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total.
2026.10.28 14:06:35.520829 [ 10 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.00026661 sec
2026.10.28 14:06:35.520842 [ 10 ] {} <Trace> ReferentialDeps: No tables
2026.10.28 14:06:35.520853 [ 10 ] {} <Trace> LoadingDeps: No tables
2026.10.28 14:06:35.520896 [ 10 ] {} <Information> DatabaseAtomic (system): Starting up tables.
2026.10.28 14:06:35.520933 [ 10 ] {} <Debug> SystemLog: Creating system.query_log from query_log
2026.10.28 14:06:35.522249 [ 10 ] {} <Debug> SystemLog: Creating system.query_thread_log from query_thread_log
2026.10.28 14:06:35.522678 [ 10 ] {} <Debug> SystemLog: Creating system.part_log from part_log
2026.10.28 14:06:35.523034 [ 10 ] {} <Debug> SystemLog: Creating system.trace_log from trace_log
2026.10.28 14:06:35.523256 [ 10 ] {} <Debug> SystemLog: Creating system.crash_log from crash_log
2026.10.28 14:06:35.523415 [ 10 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config
2026.10.28 14:06:35.523433 [ 10 ] {} <Debug> SystemLog: Creating system.metric_log from metric_log
2026.10.28 14:06:35.526601 [ 10 ] {} <Debug> SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config
2026.10.28 14:06:35.526648 [ 10 ] {} <Debug> SystemLog: Not creating system.filesystem_read_prefetches_log since corresponding section 'filesystem_read_prefetches_log' is missing from config
2026.10.28 14:06:35.526681 [ 10 ] {} <Debug> SystemLog: Creating system.asynchronous_metric_log from asynchronous_metric_log
2026.10.28 14:06:35.526951 [ 10 ] {} <Debug> SystemLog: Creating system.opentelemetry_span_log from opentelemetry_span_log
2026.10.28 14:06:35.527246 [ 10 ] {} <Debug> SystemLog: Creating system.query_views_log from query_views_log
2026.10.28 14:06:35.527552 [ 10 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config
2026.10.28 14:06:35.527572 [ 10 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config
2026.10.28 14:06:35.527589 [ 10 ] {} <Debug> SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config
2026.10.28 14:06:35.527606 [ 10 ] {} <Debug> SystemLog: Creating system.processors_profile_log from processors_profile_log
2026.10.28 14:06:35.527889 [ 10 ] {} <Debug> SystemLog: Creating system.asynchronous_insert_log from asynchronous_insert_log
2026.10.28 14:06:35.551451 [ 10 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal.
2026.10.28 14:06:35.554983 [ 10 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total.
2026.10.28 14:06:35.555005 [ 10 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 8.171e-05 sec
2026.10.28 14:06:35.555017 [ 10 ] {} <Trace> ReferentialDeps: No tables
2026.10.28 14:06:35.555027 [ 10 ] {} <Trace> LoadingDeps: No tables
2026.10.28 14:06:35.555051 [ 10 ] {} <Information> DatabaseAtomic (default): Starting up tables.
2026.10.28 14:06:35.555290 [ 10 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/lib/clickhouse/user_defined/
2026.10.28 14:06:35.555354 [ 10 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded
2026.10.28 14:06:35.555363 [ 10 ] {} <Debug> Application: Loaded metadata.
2026.10.28 14:06:35.555412 [ 10 ] {} <Trace> Pipe: Pipe capacity is 1.00 MiB
2026.10.28 14:06:35.555575 [ 10 ] {} <Information> Application: Tasks stats provider: procfs
2026.10.28 14:06:35.555587 [ 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 14:06:35.556410 [ 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 14:06:35.556580 [ 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 14:06:35.556590 [ 10 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair.
2026.10.28 14:06:35.619102 [ 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 14:06:35.619168 [ 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 14:06:35.619172 [ 10 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair.
2026.10.28 14:06:35.652009 [ 10 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again.
2026.10.28 14:06:35.652647 [ 10 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 40.25 MiB, peak 40.25 MiB, free memory in arenas 46.73 MiB, will set to 445.96 MiB (RSS), difference: 405.72 MiB
2026.10.28 14:06:35.653187 [ 10 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 1.065e-05 sec.
2026.10.28 14:06:35.654092 [ 10 ] {} <Information> Application: Listening for http://[::1]:8123
2026.10.28 14:06:35.654139 [ 10 ] {} <Information> Application: Listening for native protocol (tcp): [::1]:9000
2026.10.28 14:06:35.654182 [ 10 ] {} <Information> Application: Listening for MySQL compatibility protocol: [::1]:9004
2026.10.28 14:06:35.654234 [ 10 ] {} <Information> Application: Listening for PostgreSQL compatibility protocol: [::1]:9005
2026.10.28 14:06:35.654282 [ 10 ] {} <Information> Application: Listening for http://127.0.0.1:8123
2026.10.28 14:06:35.654327 [ 10 ] {} <Information> Application: Listening for native protocol (tcp): 127.0.0.1:9000
2026.10.28 14:06:35.654370 [ 10 ] {} <Information> Application: Listening for MySQL compatibility protocol: 127.0.0.1:9004
2026.10.28 14:06:35.654411 [ 10 ] {} <Information> Application: Listening for PostgreSQL compatibility protocol: 127.0.0.1:9005
2026.10.28 14:06:35.654415 [ 10 ] {} <Information> Application: Ready for connections.
2026.10.28 14:06:36.000705 [ 267 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 445.98 MiB, peak 445.98 MiB, free memory in arenas 46.77 MiB, will set to 448.88 MiB (RSS), difference: 2.89 MiB
2026.10.28 14:06:40.171645 [ 12 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:35246
2026.10.28 14:06:40.171965 [ 12 ] {} <Debug> TCPHandler: Connected ClickHouse client version 23.8.0, revision: 54465, user: default.
2026.10.28 14:06:40.172019 [ 12 ] {} <Debug> TCP-Session: e32a4f83-8c02-4fa4-84c4-db20a97193f6 Authenticating user 'default' from [::1]:35246
2026.10.28 14:06:40.172041 [ 12 ] {} <Debug> TCP-Session: e32a4f83-8c02-4fa4-84c4-db20a97193f6 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
2026.10.28 14:06:40.172053 [ 12 ] {} <Debug> TCP-Session: e32a4f83-8c02-4fa4-84c4-db20a97193f6 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
2026.10.28 14:06:40.172177 [ 12 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false
2026.10.28 14:06:40.172207 [ 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 14:06:40.172221 [ 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 14:06:40.193200 [ 12 ] {} <Trace> TCP-Session: e32a4f83-8c02-4fa4-84c4-db20a97193f6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
2026.10.28 14:06:40.193593 [ 12 ] {ff473d7d-1224-4a74-8859-d5ec6142b97f} <Debug> executeQuery: (from [::1]:35246) select 'OK' (stage: Complete)
2026.10.28 14:06:40.193876 [ 12 ] {ff473d7d-1224-4a74-8859-d5ec6142b97f} <Trace> ContextAccess (default): Access granted: SELECT(dummy) ON system.one
2026.10.28 14:06:40.193928 [ 12 ] {ff473d7d-1224-4a74-8859-d5ec6142b97f} <Trace> InterpreterSelectQuery: FetchColumns -> Complete
2026.10.28 14:06:40.195119 [ 12 ] {ff473d7d-1224-4a74-8859-d5ec6142b97f} <Debug> executeQuery: Read 1 rows, 1.00 B in 0.001557 sec., 642.2607578676943 rows/sec., 642.26 B/sec.
2026.10.28 14:06:40.195159 [ 12 ] {ff473d7d-1224-4a74-8859-d5ec6142b97f} <Debug> TCPHandler: Processed in 0.002163953 sec.
2026.10.28 14:06:40.197055 [ 12 ] {} <Debug> TCPHandler: Done processing connection.
2026.10.28 14:06:40.197087 [ 12 ] {} <Debug> TCP-Session: e32a4f83-8c02-4fa4-84c4-db20a97193f6 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
2026.10.28 14:06:40.617601 [ 7 ] {} <Information> Application: Will watch for the process with pid 9
2026.10.28 14:06:40.617940 [ 9 ] {} <Information> Application: Forked a child process to watch
2026.10.28 14:06:40.618681 [ 9 ] {} <Information> SentryWriter: Sending crash reports is disabled
2026.10.28 14:06:40.618880 [ 9 ] {} <Trace> Pipe: Pipe capacity is 1.00 MiB
2026.10.28 14:06:40.729492 [ 9 ] {} <Information> Application: Starting ClickHouse 23.8.16.43.altinitystable (revision: 54477, git hash: a26de2e0e62c813df59bc08c1069dd5620e7c685, build id: D8039DA4E3474D50BED371A3CAA0576DB0826CBD), PID 9
2026.10.28 14:06:40.729622 [ 9 ] {} <Information> Application: starting up
2026.10.28 14:06:40.729641 [ 9 ] {} <Information> Application: OS name: Linux, version: 5.15.0-130-generic, architecture: x86_64
2026.10.28 14:06:40.733340 [ 9 ] {} <Information> Application: Available RAM: 30.59 GiB; physical cores: 16; logical cores: 16.
2026.10.28 14:06:40.734498 [ 9 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/thermal
2026.10.28 14:06:40.734514 [ 9 ] {} <Trace> AsynchronousMetrics: Scanning /sys/block
2026.10.28 14:06:40.734598 [ 9 ] {} <Trace> AsynchronousMetrics: Scanning /sys/devices/system/edac
2026.10.28 14:06:40.734615 [ 9 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/hwmon
2026.10.28 14:06:40.874703 [ 9 ] {} <Information> Application: Integrity check of the executable successfully passed (checksum: D2DEB088DC059EC9E51331ADEC269EE0)
2026.10.28 14:06:40.874765 [ 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 14:06:40.876793 [ 9 ] {} <Debug> Application: rlimit on number of file descriptors is 1048576
2026.10.28 14:06:40.876807 [ 9 ] {} <Debug> Application: rlimit on number of threads is 18446744073709551615
2026.10.28 14:06:40.876815 [ 9 ] {} <Debug> Application: Initializing DateLUT.
2026.10.28 14:06:40.876820 [ 9 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'.
2026.10.28 14:06:40.876844 [ 9 ] {} <Debug> Context: Setting up /var/lib/clickhouse/tmp/ to store temporary data in it
2026.10.28 14:06:40.877472 [ 9 ] {} <Debug> Application: Configuration parameter 'interserver_http_host' doesn't exist or exists and empty. Will use 'github-hetzner-runner-40687803414-122854835796' as replica host.
2026.10.28 14:06:40.877485 [ 9 ] {} <Debug> Application: Initializing interserver credentials.
2026.10.28 14:06:40.877546 [ 9 ] {} <Trace> NamedCollectionsUtils: Loaded 0 collections from config
2026.10.28 14:06:40.877617 [ 9 ] {} <Trace> NamedCollectionsUtils: Loaded 0 collections from SQL
2026.10.28 14:06:40.877854 [ 9 ] {} <Debug> ConfigReloader: Loading config '/config/config.xml'
2026.10.28 14:06:40.880728 [ 9 ] {} <Debug> ConfigReloader: Loaded config '/config/config.xml', performing update on configuration
2026.10.28 14:06:40.882726 [ 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 14:06:40.882735 [ 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 14:06:40.882740 [ 9 ] {} <Information> Application: Merges and mutations memory limit is set to 15.30 GiB
2026.10.28 14:06:40.882953 [ 9 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads
2026.10.28 14:06:40.884069 [ 9 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 128 threads
2026.10.28 14:06:40.904824 [ 9 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads
2026.10.28 14:06:40.906492 [ 9 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads
2026.10.28 14:06:40.908321 [ 9 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again.
2026.10.28 14:06:40.908360 [ 9 ] {} <Debug> ConfigReloader: Loaded config '/config/config.xml', performed update on configuration
2026.10.28 14:06:40.922819 [ 9 ] {} <Information> Application: Listening for replica communication (interserver): http://[::1]:9009
2026.10.28 14:06:40.926342 [ 9 ] {} <Information> Application: Listening for replica communication (interserver): http://127.0.0.1:9009
2026.10.28 14:06:40.928384 [ 9 ] {} <Debug> ConfigReloader: Loading config '/config/users.xml'
2026.10.28 14:06:40.928792 [ 9 ] {} <Debug> ConfigReloader: Loaded config '/config/users.xml', performing update on configuration
2026.10.28 14:06:40.929267 [ 9 ] {} <Debug> ConfigReloader: Loaded config '/config/users.xml', performed update on configuration
2026.10.28 14:06:40.929388 [ 9 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: /config/users.xml
2026.10.28 14:06:40.929513 [ 9 ] {} <Warning> Access(local_directory): File /var/lib/clickhouse/access/users.list doesn't exist
2026.10.28 14:06:40.929533 [ 9 ] {} <Warning> Access(local_directory): Recovering lists in directory /var/lib/clickhouse/access/
2026.10.28 14:06:40.929724 [ 9 ] {} <Debug> Access(user directories): Added local_directory access storage 'local_directory', path: /var/lib/clickhouse/access/
2026.10.28 14:06:40.930464 [ 9 ] {} <Information> Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32, scheduling_policy=round_robin
2026.10.28 14:06:40.933400 [ 9 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8
2026.10.28 14:06:40.934392 [ 9 ] {} <Information> Context: Initialized background executor for fetches with num_threads=8, num_tasks=8
2026.10.28 14:06:40.934759 [ 9 ] {} <Information> Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8
2026.10.28 14:06:40.935587 [ 9 ] {} <Information> DNSCacheUpdater: Update period 15 seconds
2026.10.28 14:06:40.935603 [ 9 ] {} <Information> Application: Loading metadata from /var/lib/clickhouse/
2026.10.28 14:06:40.936154 [ 56 ] {} <Debug> DNSResolver: Updating DNS cache
2026.10.28 14:06:40.939980 [ 56 ] {} <Debug> DNSResolver: Updated DNS cache
2026.10.28 14:06:40.944046 [ 9 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total.
2026.10.28 14:06:40.944074 [ 9 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.000229711 sec
2026.10.28 14:06:40.944088 [ 9 ] {} <Trace> ReferentialDeps: No tables
2026.10.28 14:06:40.944101 [ 9 ] {} <Trace> LoadingDeps: No tables
2026.10.28 14:06:40.944148 [ 9 ] {} <Information> DatabaseAtomic (system): Starting up tables.
2026.10.28 14:06:40.944188 [ 9 ] {} <Debug> SystemLog: Creating system.query_log from query_log
2026.10.28 14:06:40.945573 [ 9 ] {} <Debug> SystemLog: Creating system.query_thread_log from query_thread_log
2026.10.28 14:06:40.946009 [ 9 ] {} <Debug> SystemLog: Creating system.part_log from part_log
2026.10.28 14:06:40.946408 [ 9 ] {} <Debug> SystemLog: Creating system.trace_log from trace_log
2026.10.28 14:06:40.946634 [ 9 ] {} <Debug> SystemLog: Creating system.crash_log from crash_log
2026.10.28 14:06:40.946814 [ 9 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config
2026.10.28 14:06:40.946834 [ 9 ] {} <Debug> SystemLog: Creating system.metric_log from metric_log
2026.10.28 14:06:40.950337 [ 9 ] {} <Debug> SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config
2026.10.28 14:06:40.950390 [ 9 ] {} <Debug> SystemLog: Not creating system.filesystem_read_prefetches_log since corresponding section 'filesystem_read_prefetches_log' is missing from config
2026.10.28 14:06:40.950414 [ 9 ] {} <Debug> SystemLog: Creating system.asynchronous_metric_log from asynchronous_metric_log
2026.10.28 14:06:40.950706 [ 9 ] {} <Debug> SystemLog: Creating system.opentelemetry_span_log from opentelemetry_span_log
2026.10.28 14:06:40.951063 [ 9 ] {} <Debug> SystemLog: Creating system.query_views_log from query_views_log
2026.10.28 14:06:40.951424 [ 9 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config
2026.10.28 14:06:40.951448 [ 9 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config
2026.10.28 14:06:40.951467 [ 9 ] {} <Debug> SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config
2026.10.28 14:06:40.951486 [ 9 ] {} <Debug> SystemLog: Creating system.processors_profile_log from processors_profile_log
2026.10.28 14:06:40.951730 [ 9 ] {} <Debug> SystemLog: Creating system.asynchronous_insert_log from asynchronous_insert_log
2026.10.28 14:06:40.976081 [ 9 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal.
2026.10.28 14:06:40.978817 [ 9 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total.
2026.10.28 14:06:40.978842 [ 9 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 9.897e-05 sec
2026.10.28 14:06:40.978855 [ 9 ] {} <Trace> ReferentialDeps: No tables
2026.10.28 14:06:40.978867 [ 9 ] {} <Trace> LoadingDeps: No tables
2026.10.28 14:06:40.978894 [ 9 ] {} <Information> DatabaseAtomic (default): Starting up tables.
2026.10.28 14:06:40.979132 [ 9 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/lib/clickhouse/user_defined/
2026.10.28 14:06:40.979199 [ 9 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded
2026.10.28 14:06:40.979210 [ 9 ] {} <Debug> Application: Loaded metadata.
2026.10.28 14:06:40.979260 [ 9 ] {} <Trace> Pipe: Pipe capacity is 1.00 MiB
2026.10.28 14:06:40.979411 [ 9 ] {} <Information> Application: Tasks stats provider: procfs
2026.10.28 14:06:40.979424 [ 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 14:06:40.980219 [ 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 14:06:40.980377 [ 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 14:06:40.980389 [ 9 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair.
2026.10.28 14:06:41.098791 [ 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 14:06:41.098861 [ 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 14:06:41.098881 [ 9 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair.
2026.10.28 14:06:41.141401 [ 9 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again.
2026.10.28 14:06:41.142115 [ 9 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 40.25 MiB, peak 40.25 MiB, free memory in arenas 46.85 MiB, will set to 445.81 MiB (RSS), difference: 405.56 MiB
2026.10.28 14:06:41.143173 [ 9 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 1.223e-05 sec.
2026.10.28 14:06:41.144125 [ 9 ] {} <Information> Application: Listening for http://[::1]:8123
2026.10.28 14:06:41.144182 [ 9 ] {} <Information> Application: Listening for native protocol (tcp): [::1]:9000
2026.10.28 14:06:41.144224 [ 9 ] {} <Information> Application: Listening for MySQL compatibility protocol: [::1]:9004
2026.10.28 14:06:41.144266 [ 9 ] {} <Information> Application: Listening for PostgreSQL compatibility protocol: [::1]:9005
2026.10.28 14:06:41.144307 [ 9 ] {} <Information> Application: Listening for http://127.0.0.1:8123
2026.10.28 14:06:41.144350 [ 9 ] {} <Information> Application: Listening for native protocol (tcp): 127.0.0.1:9000
2026.10.28 14:06:41.144389 [ 9 ] {} <Information> Application: Listening for MySQL compatibility protocol: 127.0.0.1:9004
2026.10.28 14:06:41.144430 [ 9 ] {} <Information> Application: Listening for PostgreSQL compatibility protocol: 127.0.0.1:9005
2026.10.28 14:06:41.144435 [ 9 ] {} <Information> Application: Ready for connections.
2026.10.28 14:06:42.000731 [ 267 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 445.83 MiB, peak 445.83 MiB, free memory in arenas 46.78 MiB, will set to 448.16 MiB (RSS), difference: 2.33 MiB
2026.10.28 14:06:45.599451 [ 11 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: 127.0.0.1:59710
2026.10.28 14:06:45.599716 [ 11 ] {} <Debug> TCPHandler: Connected ClickHouse client version 23.8.0, revision: 54465, user: default.
2026.10.28 14:06:45.599777 [ 11 ] {} <Debug> TCP-Session: e166ce28-c848-4c6c-8ea9-fbdab448f0f3 Authenticating user 'default' from 127.0.0.1:59710
2026.10.28 14:06:45.599808 [ 11 ] {} <Debug> TCP-Session: e166ce28-c848-4c6c-8ea9-fbdab448f0f3 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
2026.10.28 14:06:45.599827 [ 11 ] {} <Debug> TCP-Session: e166ce28-c848-4c6c-8ea9-fbdab448f0f3 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
2026.10.28 14:06:45.600048 [ 11 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false
2026.10.28 14:06:45.600102 [ 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 14:06:45.600126 [ 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 14:06:45.618584 [ 11 ] {} <Trace> TCP-Session: e166ce28-c848-4c6c-8ea9-fbdab448f0f3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
2026.10.28 14:06:45.619002 [ 11 ] {3c2f2d81-2c2f-4112-a860-abbf3a74f792} <Debug> executeQuery: (from 127.0.0.1:59710) select 'OK' (stage: Complete)
2026.10.28 14:06:45.619231 [ 11 ] {3c2f2d81-2c2f-4112-a860-abbf3a74f792} <Trace> ContextAccess (default): Access granted: SELECT(dummy) ON system.one
2026.10.28 14:06:45.619279 [ 11 ] {3c2f2d81-2c2f-4112-a860-abbf3a74f792} <Trace> InterpreterSelectQuery: FetchColumns -> Complete
2026.10.28 14:06:45.620646 [ 11 ] {3c2f2d81-2c2f-4112-a860-abbf3a74f792} <Debug> executeQuery: Read 1 rows, 1.00 B in 0.001669 sec., 599.1611743559017 rows/sec., 599.16 B/sec.
2026.10.28 14:06:45.620750 [ 11 ] {3c2f2d81-2c2f-4112-a860-abbf3a74f792} <Debug> TCPHandler: Processed in 0.002376383 sec.
2026.10.28 14:06:45.622589 [ 11 ] {} <Debug> TCPHandler: Done processing connection.
2026.10.28 14:06:45.622620 [ 11 ] {} <Debug> TCP-Session: e166ce28-c848-4c6c-8ea9-fbdab448f0f3 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db