2026.10.27 16:30:18.262486 [ 8 ] {} <Information> Application: Will watch for the process with pid 10
2026.10.27 16:30:18.262606 [ 10 ] {} <Information> Application: Forked a child process to watch
2026.10.27 16:30:18.262963 [ 10 ] {} <Information> SentryWriter: Sending crash reports is disabled
2026.10.27 16:30:18.263151 [ 10 ] {} <Trace> Pipe: Pipe capacity is 1.00 MiB
2026.10.27 16:30:18.360495 [ 10 ] {} <Information> Application: Starting ClickHouse 24.3.18.10327.altinitystable (revision: 54496, git hash: fbdb712bd3e22754fab0201c692e7b44d6dde842, build id: 19B4F33BD8BA5D6F567F171F682C9B0C615AE3A3), PID 10
2026.10.27 16:30:18.360683 [ 10 ] {} <Information> Application: starting up
2026.10.27 16:30:18.360702 [ 10 ] {} <Information> Application: OS name: Linux, version: 5.15.0-130-generic, architecture: x86_64
2026.10.27 16:30:18.366993 [ 10 ] {} <Information> Application: Available RAM: 30.59 GiB; logical cores: 16; used cores: 16.
2026.10.27 16:30:18.367046 [ 10 ] {} <Information> Application: Available CPU instruction sets: SSE, SSE2, SSE3, SSSE3, SSE41, SSE42, F16C, POPCNT, BMI1, BMI2, PCLMUL, AES, AVX, FMA, AVX2, AVX512F, AVX512DQ, AVX512IFMA, AVX512CD, AVX512BW, AVX512VL, AVX512VBMI, AVX512VBMI2, SHA, ADX, RDRAND, RDSEED, RDTSCP, CLFLUSHOPT, CLWB, XSAVE, OSXSAVE
2026.10.27 16:30:18.367307 [ 10 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/thermal
2026.10.27 16:30:18.367336 [ 10 ] {} <Trace> AsynchronousMetrics: Scanning /sys/block
2026.10.27 16:30:18.367491 [ 10 ] {} <Trace> AsynchronousMetrics: Scanning /sys/devices/system/edac
2026.10.27 16:30:18.367521 [ 10 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/hwmon
2026.10.27 16:30:18.372095 [ 10 ] {} <Warning> Context: Delay accounting is not enabled, OSIOWaitMicroseconds will not be gathered. You can enable it using `echo 1 > /proc/sys/kernel/task_delayacct` or by using sysctl.
2026.10.27 16:30:18.505662 [ 10 ] {} <Information> Application: Integrity check of the executable successfully passed (checksum: 1A7CE530C8264B0774F3DDD2784034BD)
2026.10.27 16:30:18.505751 [ 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:30:18.507240 [ 10 ] {} <Debug> Application: rlimit on number of file descriptors is 1048576
2026.10.27 16:30:18.507258 [ 10 ] {} <Debug> Application: rlimit on number of threads is 18446744073709551615
2026.10.27 16:30:18.507268 [ 10 ] {} <Debug> Application: Initializing DateLUT.
2026.10.27 16:30:18.507273 [ 10 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'.
2026.10.27 16:30:18.507315 [ 10 ] {} <Debug> Context: Setting up /var/lib/clickhouse/tmp/ to store temporary data in it
2026.10.27 16:30:18.508045 [ 10 ] {} <Debug> Application: Configuration parameter 'interserver_http_host' doesn't exist or exists and empty. Will use 'github-hetzner-runner-40535428736-122315123900' as replica host.
2026.10.27 16:30:18.508073 [ 10 ] {} <Debug> Application: Initializing interserver credentials.
2026.10.27 16:30:18.508205 [ 10 ] {} <Trace> NamedCollectionsUtils: Loaded 0 collections from config
2026.10.27 16:30:18.508308 [ 10 ] {} <Trace> NamedCollectionsUtils: Loaded 0 collections from SQL
2026.10.27 16:30:18.508437 [ 10 ] {} <Information> CgroupsMemoryUsageObserver: Will read the current memory usage from '/sys/fs/cgroup/' (cgroups version: v2), wait time is 15 sec
2026.10.27 16:30:18.508693 [ 10 ] {} <Debug> ConfigReloader: Loading config '/config/config.xml'
2026.10.27 16:30:18.508702 [ 10 ] {} <Debug> ConfigProcessor: Processing configuration file '/config/config.xml'.
2026.10.27 16:30:18.511787 [ 10 ] {} <Debug> ConfigProcessor: Saved preprocessed configuration to '/var/lib/clickhouse/preprocessed_configs/config.xml'.
2026.10.27 16:30:18.511860 [ 10 ] {} <Debug> ConfigReloader: Loaded config '/config/config.xml', performing update on configuration
2026.10.27 16:30:18.514926 [ 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:30:18.514939 [ 10 ] {} <Information> CgroupsMemoryUsageObserver: Set new limits, soft limit: 24.78 GiB, hard limit: 26.16 GiB
2026.10.27 16:30:18.514945 [ 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:30:18.514950 [ 10 ] {} <Information> Application: Merges and mutations memory limit is set to 15.30 GiB
2026.10.27 16:30:18.515331 [ 10 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads
2026.10.27 16:30:18.516159 [ 10 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 512 threads
2026.10.27 16:30:18.568970 [ 10 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads
2026.10.27 16:30:18.570179 [ 10 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads
2026.10.27 16:30:18.571330 [ 10 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again.
2026.10.27 16:30:18.571521 [ 10 ] {} <Debug> ConfigReloader: Loaded config '/config/config.xml', performed update on configuration
2026.10.27 16:30:18.575505 [ 10 ] {} <Information> Application: Listening for replica communication (interserver): http://[::1]:9009
2026.10.27 16:30:18.576639 [ 10 ] {} <Information> Application: Listening for replica communication (interserver): http://127.0.0.1:9009
2026.10.27 16:30:18.590209 [ 10 ] {} <Debug> ConfigReloader: Loading config '/config/users.xml'
2026.10.27 16:30:18.590254 [ 10 ] {} <Debug> ConfigProcessor: Processing configuration file '/config/users.xml'.
2026.10.27 16:30:18.590898 [ 10 ] {} <Debug> ConfigProcessor: Saved preprocessed configuration to '/var/lib/clickhouse/preprocessed_configs/users.xml'.
2026.10.27 16:30:18.590924 [ 10 ] {} <Debug> ConfigReloader: Loaded config '/config/users.xml', performing update on configuration
2026.10.27 16:30:18.591676 [ 10 ] {} <Debug> ConfigReloader: Loaded config '/config/users.xml', performed update on configuration
2026.10.27 16:30:18.591815 [ 10 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: /config/users.xml
2026.10.27 16:30:18.591980 [ 10 ] {} <Warning> Access(local_directory): File /var/lib/clickhouse/access/users.list doesn't exist
2026.10.27 16:30:18.591993 [ 10 ] {} <Warning> Access(local_directory): Recovering lists in directory /var/lib/clickhouse/access/
2026.10.27 16:30:18.592295 [ 10 ] {} <Debug> Access(user directories): Added local_directory access storage 'local_directory', path: /var/lib/clickhouse/access/
2026.10.27 16:30:18.592408 [ 10 ] {} <Information> CgroupsMemoryUsageObserver: Started cgroup current memory usage observer thread
2026.10.27 16:30:18.592766 [ 581 ] {} <Information> CgroupsMemoryUsageObserver: Memory amount initially available to the process is 30.59 GiB
2026.10.27 16:30:18.593296 [ 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:30:18.593934 [ 10 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8
2026.10.27 16:30:18.596442 [ 10 ] {} <Information> Context: Initialized background executor for fetches with num_threads=16, num_tasks=16
2026.10.27 16:30:18.597002 [ 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:30:18.599515 [ 10 ] {} <Information> DNSCacheUpdater: Update period 15 seconds
2026.10.27 16:30:18.599563 [ 10 ] {} <Information> Application: Loading metadata from /var/lib/clickhouse/
2026.10.27 16:30:18.599734 [ 122 ] {} <Debug> DNSResolver: Updating DNS cache
2026.10.27 16:30:18.600309 [ 122 ] {} <Debug> DNSResolver: Updated DNS cache
2026.10.27 16:30:18.602931 [ 10 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total.
2026.10.27 16:30:18.602945 [ 10 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 9.7006e-05 sec
2026.10.27 16:30:18.602951 [ 10 ] {} <Trace> ReferentialDeps: No tables
2026.10.27 16:30:18.602956 [ 10 ] {} <Trace> LoadingDeps: No tables
2026.10.27 16:30:18.603012 [ 10 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Atomic database system': BgStartup -> FgLoad
2026.10.27 16:30:18.603018 [ 10 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Ordinary database system': BgStartup -> FgLoad
2026.10.27 16:30:18.603026 [ 10 ] {} <Debug> AsyncLoader: Schedule load job 'startup Ordinary database system' into FgLoad
2026.10.27 16:30:18.603032 [ 10 ] {} <Debug> AsyncLoader: Schedule load job 'startup Atomic database system' into FgLoad
2026.10.27 16:30:18.603038 [ 10 ] {} <Debug> AsyncLoader: Change current priority: none -> 0
2026.10.27 16:30:18.603043 [ 10 ] {} <Debug> AsyncLoader: Spawn loader worker #1 in FgLoad
2026.10.27 16:30:18.603122 [ 10 ] {} <Debug> AsyncLoader: Wait load job 'startup Atomic database system' in FgLoad
2026.10.27 16:30:18.603218 [ 646 ] {} <Debug> AsyncLoader: Execute load job 'startup Ordinary database system' in FgLoad
2026.10.27 16:30:18.603289 [ 646 ] {} <Debug> AsyncLoader: Finish load job 'startup Ordinary database system' with status OK
2026.10.27 16:30:18.603297 [ 646 ] {} <Debug> AsyncLoader: Spawn loader worker #2 in FgLoad
2026.10.27 16:30:18.603390 [ 646 ] {} <Debug> AsyncLoader: Execute load job 'startup Atomic database system' in FgLoad
2026.10.27 16:30:18.603424 [ 646 ] {} <Debug> AsyncLoader: Finish load job 'startup Atomic database system' with status OK
2026.10.27 16:30:18.603433 [ 646 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2026.10.27 16:30:18.603451 [ 10 ] {} <Debug> SystemLog: Creating system.query_log from query_log
2026.10.27 16:30:18.603479 [ 647 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2026.10.27 16:30:18.603521 [ 647 ] {} <Debug> AsyncLoader: Change current priority: 0 -> none
2026.10.27 16:30:18.604418 [ 10 ] {} <Debug> SystemLog: Creating system.query_thread_log from query_thread_log
2026.10.27 16:30:18.604689 [ 10 ] {} <Debug> SystemLog: Creating system.part_log from part_log
2026.10.27 16:30:18.604898 [ 10 ] {} <Debug> SystemLog: Creating system.trace_log from trace_log
2026.10.27 16:30:18.605020 [ 10 ] {} <Debug> SystemLog: Creating system.crash_log from crash_log
2026.10.27 16:30:18.605115 [ 10 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config
2026.10.27 16:30:18.605123 [ 10 ] {} <Debug> SystemLog: Creating system.metric_log from metric_log
2026.10.27 16:30:18.609382 [ 10 ] {} <Debug> SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config
2026.10.27 16:30:18.609402 [ 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:30:18.609413 [ 10 ] {} <Debug> SystemLog: Creating system.asynchronous_metric_log from asynchronous_metric_log
2026.10.27 16:30:18.609578 [ 10 ] {} <Debug> SystemLog: Creating system.opentelemetry_span_log from opentelemetry_span_log
2026.10.27 16:30:18.609743 [ 10 ] {} <Debug> SystemLog: Creating system.query_views_log from query_views_log
2026.10.27 16:30:18.609919 [ 10 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config
2026.10.27 16:30:18.609928 [ 10 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config
2026.10.27 16:30:18.609937 [ 10 ] {} <Debug> SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config
2026.10.27 16:30:18.609956 [ 10 ] {} <Debug> SystemLog: Creating system.processors_profile_log from processors_profile_log
2026.10.27 16:30:18.610098 [ 10 ] {} <Debug> SystemLog: Creating system.asynchronous_insert_log from asynchronous_insert_log
2026.10.27 16:30:18.610271 [ 10 ] {} <Debug> SystemLog: Creating system.backup_log from backup_log
2026.10.27 16:30:18.610415 [ 10 ] {} <Debug> SystemLog: Creating system.s3queue_log from s3queue_log
2026.10.27 16:30:18.610551 [ 10 ] {} <Debug> SystemLog: Creating system.blob_storage_log from blob_storage_log
2026.10.27 16:30:18.621642 [ 10 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal.
2026.10.27 16:30:18.623055 [ 10 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total.
2026.10.27 16:30:18.623069 [ 10 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 5.0336e-05 sec
2026.10.27 16:30:18.623076 [ 10 ] {} <Trace> ReferentialDeps: No tables
2026.10.27 16:30:18.623080 [ 10 ] {} <Trace> LoadingDeps: No tables
2026.10.27 16:30:18.623130 [ 10 ] {} <Information> loadMetadata: Start synchronous loading of databases
2026.10.27 16:30:18.623135 [ 10 ] {} <Information> loadMetadata: Start synchronous startup of databases
2026.10.27 16:30:18.623141 [ 10 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Atomic database default': BgStartup -> FgLoad
2026.10.27 16:30:18.623145 [ 10 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Ordinary database default': BgStartup -> FgLoad
2026.10.27 16:30:18.623153 [ 10 ] {} <Debug> AsyncLoader: Schedule load job 'startup Ordinary database default' into FgLoad
2026.10.27 16:30:18.623157 [ 10 ] {} <Debug> AsyncLoader: Schedule load job 'startup Atomic database default' into FgLoad
2026.10.27 16:30:18.623163 [ 10 ] {} <Debug> AsyncLoader: Change current priority: none -> 0
2026.10.27 16:30:18.623167 [ 10 ] {} <Debug> AsyncLoader: Spawn loader worker #1 in FgLoad
2026.10.27 16:30:18.623261 [ 10 ] {} <Debug> AsyncLoader: Wait load job 'startup Atomic database default' in FgLoad
2026.10.27 16:30:18.623394 [ 661 ] {} <Debug> AsyncLoader: Execute load job 'startup Ordinary database default' in FgLoad
2026.10.27 16:30:18.623449 [ 661 ] {} <Debug> AsyncLoader: Finish load job 'startup Ordinary database default' with status OK
2026.10.27 16:30:18.623458 [ 661 ] {} <Debug> AsyncLoader: Spawn loader worker #2 in FgLoad
2026.10.27 16:30:18.623579 [ 661 ] {} <Debug> AsyncLoader: Execute load job 'startup Atomic database default' in FgLoad
2026.10.27 16:30:18.623592 [ 661 ] {} <Debug> AsyncLoader: Finish load job 'startup Atomic database default' with status OK
2026.10.27 16:30:18.623596 [ 661 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2026.10.27 16:30:18.623754 [ 10 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/lib/clickhouse/user_defined/
2026.10.27 16:30:18.623746 [ 662 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2026.10.27 16:30:18.623799 [ 10 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded
2026.10.27 16:30:18.623804 [ 662 ] {} <Debug> AsyncLoader: Change current priority: 0 -> none
2026.10.27 16:30:18.623805 [ 10 ] {} <Debug> Application: Loaded metadata.
2026.10.27 16:30:18.623854 [ 10 ] {} <Trace> Pipe: Pipe capacity is 1.00 MiB
2026.10.27 16:30:18.623890 [ 10 ] {} <Information> Application: Tasks stats provider: procfs
2026.10.27 16:30:18.623896 [ 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:30:18.624322 [ 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 24.3.18.10327.altinitystable (altinity build))
2026.10.27 16:30:18.624399 [ 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 24.3.18.10327.altinitystable (altinity build))
2026.10.27 16:30:18.624404 [ 10 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair.
2026.10.27 16:30:18.700030 [ 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 24.3.18.10327.altinitystable (altinity build))
2026.10.27 16:30:18.700110 [ 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 24.3.18.10327.altinitystable (altinity build))
2026.10.27 16:30:18.700115 [ 10 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair.
2026.10.27 16:30:18.765589 [ 10 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again.
2026.10.27 16:30:18.766828 [ 10 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 49.45 MiB, peak 49.45 MiB, free memory in arenas 44.00 MiB, will set to 448.14 MiB (RSS), difference: 398.69 MiB
2026.10.27 16:30:18.768910 [ 10 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 1.2389e-05 sec.
2026.10.27 16:30:18.769813 [ 10 ] {} <Information> Application: Listening for http://[::1]:8123
2026.10.27 16:30:18.769861 [ 10 ] {} <Information> Application: Listening for native protocol (tcp): [::1]:9000
2026.10.27 16:30:18.769903 [ 10 ] {} <Information> Application: Listening for MySQL compatibility protocol: [::1]:9004
2026.10.27 16:30:18.769944 [ 10 ] {} <Information> Application: Listening for PostgreSQL compatibility protocol: [::1]:9005
2026.10.27 16:30:18.770007 [ 10 ] {} <Information> Application: Listening for http://127.0.0.1:8123
2026.10.27 16:30:18.770051 [ 10 ] {} <Information> Application: Listening for native protocol (tcp): 127.0.0.1:9000
2026.10.27 16:30:18.770089 [ 10 ] {} <Information> Application: Listening for MySQL compatibility protocol: 127.0.0.1:9004
2026.10.27 16:30:18.770128 [ 10 ] {} <Information> Application: Listening for PostgreSQL compatibility protocol: 127.0.0.1:9005
2026.10.27 16:30:18.770133 [ 10 ] {} <Information> Application: Ready for connections.
2026.10.27 16:30:19.000760 [ 662 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 448.17 MiB, peak 448.17 MiB, free memory in arenas 44.06 MiB, will set to 450.71 MiB (RSS), difference: 2.54 MiB
2026.10.27 16:30:23.251038 [ 12 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:33068
2026.10.27 16:30:23.251179 [ 12 ] {} <Debug> TCPHandler: Connected ClickHouse client version 24.3.0, revision: 54467, user: default.
2026.10.27 16:30:23.251205 [ 12 ] {} <Debug> TCP-Session: 0f6c2ac4-58de-4cd9-aadb-e402ce6bcf8e Authenticating user 'default' from [::1]:33068
2026.10.27 16:30:23.251243 [ 12 ] {} <Debug> TCP-Session: 0f6c2ac4-58de-4cd9-aadb-e402ce6bcf8e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
2026.10.27 16:30:23.251249 [ 12 ] {} <Debug> TCP-Session: 0f6c2ac4-58de-4cd9-aadb-e402ce6bcf8e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
2026.10.27 16:30:23.251363 [ 12 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false
2026.10.27 16:30:23.251389 [ 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, ACCESS MANAGEMENT, SYSTEM, dictGet, displaySecretsInShowAndSelect, INTROSPECTION, SOURCES, CLUSTER ON *.* WITH GRANT OPTION, GRANT SET DEFINER ON * WITH GRANT OPTION, GRANT ALTER NAMED COLLECTION, CREATE NAMED COLLECTION, DROP NAMED COLLECTION, SHOW NAMED COLLECTIONS, NAMED COLLECTION ON * WITH GRANT OPTION
2026.10.27 16:30:23.251425 [ 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, ACCESS MANAGEMENT, SYSTEM, dictGet, displaySecretsInShowAndSelect, INTROSPECTION, SOURCES, CLUSTER ON *.* WITH GRANT OPTION, GRANT SET DEFINER ON * WITH GRANT OPTION, GRANT ALTER NAMED COLLECTION, CREATE NAMED COLLECTION, DROP NAMED COLLECTION, SHOW NAMED COLLECTIONS, NAMED COLLECTION ON * WITH GRANT OPTION
2026.10.27 16:30:23.261253 [ 12 ] {} <Trace> TCP-Session: 0f6c2ac4-58de-4cd9-aadb-e402ce6bcf8e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
2026.10.27 16:30:23.261723 [ 12 ] {768ca907-3948-4c84-8fd4-6b182af5b722} <Debug> executeQuery: (from [::1]:33068) select 'OK' (stage: Complete)
2026.10.27 16:30:23.261997 [ 12 ] {768ca907-3948-4c84-8fd4-6b182af5b722} <Trace> Planner: Query SELECT 'OK' AS `'OK'` FROM system.one AS __table1 to stage Complete
2026.10.27 16:30:23.262044 [ 12 ] {768ca907-3948-4c84-8fd4-6b182af5b722} <Trace> ContextAccess (default): Access granted: SELECT(dummy) ON system.one
2026.10.27 16:30:23.262116 [ 12 ] {768ca907-3948-4c84-8fd4-6b182af5b722} <Trace> Planner: Query SELECT 'OK' AS `'OK'` FROM system.one AS __table1 from stage FetchColumns to stage Complete
2026.10.27 16:30:23.262964 [ 12 ] {768ca907-3948-4c84-8fd4-6b182af5b722} <Debug> executeQuery: Read 1 rows, 1.00 B in 0.001295 sec., 772.2007722007722 rows/sec., 772.20 B/sec.
2026.10.27 16:30:23.263001 [ 12 ] {768ca907-3948-4c84-8fd4-6b182af5b722} <Debug> TCPHandler: Processed in 0.0020203 sec.
2026.10.27 16:30:23.264133 [ 12 ] {} <Debug> TCPHandler: Done processing connection.
2026.10.27 16:30:23.264153 [ 12 ] {} <Debug> TCP-Session: 0f6c2ac4-58de-4cd9-aadb-e402ce6bcf8e Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
2026.10.27 16:30:23.529951 [ 7 ] {} <Information> Application: Will watch for the process with pid 9
2026.10.27 16:30:23.530169 [ 9 ] {} <Information> Application: Forked a child process to watch
2026.10.27 16:30:23.530521 [ 9 ] {} <Information> SentryWriter: Sending crash reports is disabled
2026.10.27 16:30:23.530721 [ 9 ] {} <Trace> Pipe: Pipe capacity is 1.00 MiB
2026.10.27 16:30:23.632897 [ 9 ] {} <Information> Application: Starting ClickHouse 24.3.18.10327.altinitystable (revision: 54496, git hash: fbdb712bd3e22754fab0201c692e7b44d6dde842, build id: 19B4F33BD8BA5D6F567F171F682C9B0C615AE3A3), PID 9
2026.10.27 16:30:23.633133 [ 9 ] {} <Information> Application: starting up
2026.10.27 16:30:23.633159 [ 9 ] {} <Information> Application: OS name: Linux, version: 5.15.0-130-generic, architecture: x86_64
2026.10.27 16:30:23.640715 [ 9 ] {} <Information> Application: Available RAM: 30.59 GiB; logical cores: 16; used cores: 16.
2026.10.27 16:30:23.640781 [ 9 ] {} <Information> Application: Available CPU instruction sets: SSE, SSE2, SSE3, SSSE3, SSE41, SSE42, F16C, POPCNT, BMI1, BMI2, PCLMUL, AES, AVX, FMA, AVX2, AVX512F, AVX512DQ, AVX512IFMA, AVX512CD, AVX512BW, AVX512VL, AVX512VBMI, AVX512VBMI2, SHA, ADX, RDRAND, RDSEED, RDTSCP, CLFLUSHOPT, CLWB, XSAVE, OSXSAVE
2026.10.27 16:30:23.641068 [ 9 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/thermal
2026.10.27 16:30:23.641092 [ 9 ] {} <Trace> AsynchronousMetrics: Scanning /sys/block
2026.10.27 16:30:23.641239 [ 9 ] {} <Trace> AsynchronousMetrics: Scanning /sys/devices/system/edac
2026.10.27 16:30:23.641268 [ 9 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/hwmon
2026.10.27 16:30:23.646248 [ 9 ] {} <Warning> Context: Delay accounting is not enabled, OSIOWaitMicroseconds will not be gathered. You can enable it using `echo 1 > /proc/sys/kernel/task_delayacct` or by using sysctl.
2026.10.27 16:30:23.786333 [ 9 ] {} <Information> Application: Integrity check of the executable successfully passed (checksum: 1A7CE530C8264B0774F3DDD2784034BD)
2026.10.27 16:30:23.786452 [ 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:30:23.788374 [ 9 ] {} <Debug> Application: rlimit on number of file descriptors is 1048576
2026.10.27 16:30:23.788404 [ 9 ] {} <Debug> Application: rlimit on number of threads is 18446744073709551615
2026.10.27 16:30:23.788418 [ 9 ] {} <Debug> Application: Initializing DateLUT.
2026.10.27 16:30:23.788426 [ 9 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'.
2026.10.27 16:30:23.788492 [ 9 ] {} <Debug> Context: Setting up /var/lib/clickhouse/tmp/ to store temporary data in it
2026.10.27 16:30:23.789483 [ 9 ] {} <Debug> Application: Configuration parameter 'interserver_http_host' doesn't exist or exists and empty. Will use 'github-hetzner-runner-40535428736-122315123900' as replica host.
2026.10.27 16:30:23.789512 [ 9 ] {} <Debug> Application: Initializing interserver credentials.
2026.10.27 16:30:23.789681 [ 9 ] {} <Trace> NamedCollectionsUtils: Loaded 0 collections from config
2026.10.27 16:30:23.789841 [ 9 ] {} <Trace> NamedCollectionsUtils: Loaded 0 collections from SQL
2026.10.27 16:30:23.790055 [ 9 ] {} <Information> CgroupsMemoryUsageObserver: Will read the current memory usage from '/sys/fs/cgroup/' (cgroups version: v2), wait time is 15 sec
2026.10.27 16:30:23.790382 [ 9 ] {} <Debug> ConfigReloader: Loading config '/config/config.xml'
2026.10.27 16:30:23.790393 [ 9 ] {} <Debug> ConfigProcessor: Processing configuration file '/config/config.xml'.
2026.10.27 16:30:23.793953 [ 9 ] {} <Debug> ConfigProcessor: Saved preprocessed configuration to '/var/lib/clickhouse/preprocessed_configs/config.xml'.
2026.10.27 16:30:23.794065 [ 9 ] {} <Debug> ConfigReloader: Loaded config '/config/config.xml', performing update on configuration
2026.10.27 16:30:23.797217 [ 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:30:23.797231 [ 9 ] {} <Information> CgroupsMemoryUsageObserver: Set new limits, soft limit: 24.78 GiB, hard limit: 26.16 GiB
2026.10.27 16:30:23.797240 [ 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:30:23.797248 [ 9 ] {} <Information> Application: Merges and mutations memory limit is set to 15.30 GiB
2026.10.27 16:30:23.797649 [ 9 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads
2026.10.27 16:30:23.798768 [ 9 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 512 threads
2026.10.27 16:30:23.824674 [ 9 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads
2026.10.27 16:30:23.825610 [ 9 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads
2026.10.27 16:30:23.838243 [ 9 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again.
2026.10.27 16:30:23.838305 [ 9 ] {} <Debug> ConfigReloader: Loaded config '/config/config.xml', performed update on configuration
2026.10.27 16:30:23.839406 [ 9 ] {} <Information> Application: Listening for replica communication (interserver): http://[::1]:9009
2026.10.27 16:30:23.839689 [ 9 ] {} <Information> Application: Listening for replica communication (interserver): http://127.0.0.1:9009
2026.10.27 16:30:23.848564 [ 9 ] {} <Debug> ConfigReloader: Loading config '/config/users.xml'
2026.10.27 16:30:23.848583 [ 9 ] {} <Debug> ConfigProcessor: Processing configuration file '/config/users.xml'.
2026.10.27 16:30:23.849071 [ 9 ] {} <Debug> ConfigProcessor: Saved preprocessed configuration to '/var/lib/clickhouse/preprocessed_configs/users.xml'.
2026.10.27 16:30:23.849095 [ 9 ] {} <Debug> ConfigReloader: Loaded config '/config/users.xml', performing update on configuration
2026.10.27 16:30:23.849694 [ 9 ] {} <Debug> ConfigReloader: Loaded config '/config/users.xml', performed update on configuration
2026.10.27 16:30:23.849848 [ 9 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: /config/users.xml
2026.10.27 16:30:23.850031 [ 9 ] {} <Warning> Access(local_directory): File /var/lib/clickhouse/access/users.list doesn't exist
2026.10.27 16:30:23.850050 [ 9 ] {} <Warning> Access(local_directory): Recovering lists in directory /var/lib/clickhouse/access/
2026.10.27 16:30:23.850466 [ 9 ] {} <Debug> Access(user directories): Added local_directory access storage 'local_directory', path: /var/lib/clickhouse/access/
2026.10.27 16:30:23.850560 [ 9 ] {} <Information> CgroupsMemoryUsageObserver: Started cgroup current memory usage observer thread
2026.10.27 16:30:23.850930 [ 580 ] {} <Information> CgroupsMemoryUsageObserver: Memory amount initially available to the process is 30.59 GiB
2026.10.27 16:30:23.851401 [ 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:30:23.852532 [ 9 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8
2026.10.27 16:30:23.853430 [ 9 ] {} <Information> Context: Initialized background executor for fetches with num_threads=16, num_tasks=16
2026.10.27 16:30:23.853816 [ 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:30:23.854764 [ 9 ] {} <Information> DNSCacheUpdater: Update period 15 seconds
2026.10.27 16:30:23.854783 [ 9 ] {} <Information> Application: Loading metadata from /var/lib/clickhouse/
2026.10.27 16:30:23.854819 [ 196 ] {} <Debug> DNSResolver: Updating DNS cache
2026.10.27 16:30:23.856186 [ 196 ] {} <Debug> DNSResolver: Updated DNS cache
2026.10.27 16:30:23.857745 [ 9 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total.
2026.10.27 16:30:23.857758 [ 9 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 7.5333e-05 sec
2026.10.27 16:30:23.857764 [ 9 ] {} <Trace> ReferentialDeps: No tables
2026.10.27 16:30:23.857769 [ 9 ] {} <Trace> LoadingDeps: No tables
2026.10.27 16:30:23.857816 [ 9 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Atomic database system': BgStartup -> FgLoad
2026.10.27 16:30:23.857822 [ 9 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Ordinary database system': BgStartup -> FgLoad
2026.10.27 16:30:23.857831 [ 9 ] {} <Debug> AsyncLoader: Schedule load job 'startup Ordinary database system' into FgLoad
2026.10.27 16:30:23.857837 [ 9 ] {} <Debug> AsyncLoader: Schedule load job 'startup Atomic database system' into FgLoad
2026.10.27 16:30:23.857844 [ 9 ] {} <Debug> AsyncLoader: Change current priority: none -> 0
2026.10.27 16:30:23.857850 [ 9 ] {} <Debug> AsyncLoader: Spawn loader worker #1 in FgLoad
2026.10.27 16:30:23.857917 [ 9 ] {} <Debug> AsyncLoader: Wait load job 'startup Atomic database system' in FgLoad
2026.10.27 16:30:23.857988 [ 645 ] {} <Debug> AsyncLoader: Execute load job 'startup Ordinary database system' in FgLoad
2026.10.27 16:30:23.858024 [ 645 ] {} <Debug> AsyncLoader: Finish load job 'startup Ordinary database system' with status OK
2026.10.27 16:30:23.858031 [ 645 ] {} <Debug> AsyncLoader: Spawn loader worker #2 in FgLoad
2026.10.27 16:30:23.858117 [ 645 ] {} <Debug> AsyncLoader: Execute load job 'startup Atomic database system' in FgLoad
2026.10.27 16:30:23.858146 [ 645 ] {} <Debug> AsyncLoader: Finish load job 'startup Atomic database system' with status OK
2026.10.27 16:30:23.858153 [ 645 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2026.10.27 16:30:23.858162 [ 9 ] {} <Debug> SystemLog: Creating system.query_log from query_log
2026.10.27 16:30:23.858192 [ 646 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2026.10.27 16:30:23.858218 [ 646 ] {} <Debug> AsyncLoader: Change current priority: 0 -> none
2026.10.27 16:30:23.859162 [ 9 ] {} <Debug> SystemLog: Creating system.query_thread_log from query_thread_log
2026.10.27 16:30:23.859544 [ 9 ] {} <Debug> SystemLog: Creating system.part_log from part_log
2026.10.27 16:30:23.859809 [ 9 ] {} <Debug> SystemLog: Creating system.trace_log from trace_log
2026.10.27 16:30:23.859941 [ 9 ] {} <Debug> SystemLog: Creating system.crash_log from crash_log
2026.10.27 16:30:23.860038 [ 9 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config
2026.10.27 16:30:23.860048 [ 9 ] {} <Debug> SystemLog: Creating system.metric_log from metric_log
2026.10.27 16:30:23.864058 [ 9 ] {} <Debug> SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config
2026.10.27 16:30:23.864083 [ 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:30:23.864095 [ 9 ] {} <Debug> SystemLog: Creating system.asynchronous_metric_log from asynchronous_metric_log
2026.10.27 16:30:23.864242 [ 9 ] {} <Debug> SystemLog: Creating system.opentelemetry_span_log from opentelemetry_span_log
2026.10.27 16:30:23.864411 [ 9 ] {} <Debug> SystemLog: Creating system.query_views_log from query_views_log
2026.10.27 16:30:23.864609 [ 9 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config
2026.10.27 16:30:23.864620 [ 9 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config
2026.10.27 16:30:23.864630 [ 9 ] {} <Debug> SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config
2026.10.27 16:30:23.864640 [ 9 ] {} <Debug> SystemLog: Creating system.processors_profile_log from processors_profile_log
2026.10.27 16:30:23.864767 [ 9 ] {} <Debug> SystemLog: Creating system.asynchronous_insert_log from asynchronous_insert_log
2026.10.27 16:30:23.864938 [ 9 ] {} <Debug> SystemLog: Creating system.backup_log from backup_log
2026.10.27 16:30:23.865092 [ 9 ] {} <Debug> SystemLog: Creating system.s3queue_log from s3queue_log
2026.10.27 16:30:23.865245 [ 9 ] {} <Debug> SystemLog: Creating system.blob_storage_log from blob_storage_log
2026.10.27 16:30:23.875938 [ 9 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal.
2026.10.27 16:30:23.877124 [ 9 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total.
2026.10.27 16:30:23.877137 [ 9 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 5.8588e-05 sec
2026.10.27 16:30:23.877144 [ 9 ] {} <Trace> ReferentialDeps: No tables
2026.10.27 16:30:23.877150 [ 9 ] {} <Trace> LoadingDeps: No tables
2026.10.27 16:30:23.877199 [ 9 ] {} <Information> loadMetadata: Start synchronous loading of databases
2026.10.27 16:30:23.877205 [ 9 ] {} <Information> loadMetadata: Start synchronous startup of databases
2026.10.27 16:30:23.877212 [ 9 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Atomic database default': BgStartup -> FgLoad
2026.10.27 16:30:23.877217 [ 9 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Ordinary database default': BgStartup -> FgLoad
2026.10.27 16:30:23.877226 [ 9 ] {} <Debug> AsyncLoader: Schedule load job 'startup Ordinary database default' into FgLoad
2026.10.27 16:30:23.877231 [ 9 ] {} <Debug> AsyncLoader: Schedule load job 'startup Atomic database default' into FgLoad
2026.10.27 16:30:23.877237 [ 9 ] {} <Debug> AsyncLoader: Change current priority: none -> 0
2026.10.27 16:30:23.877243 [ 9 ] {} <Debug> AsyncLoader: Spawn loader worker #1 in FgLoad
2026.10.27 16:30:23.877320 [ 9 ] {} <Debug> AsyncLoader: Wait load job 'startup Atomic database default' in FgLoad
2026.10.27 16:30:23.877390 [ 660 ] {} <Debug> AsyncLoader: Execute load job 'startup Ordinary database default' in FgLoad
2026.10.27 16:30:23.877426 [ 660 ] {} <Debug> AsyncLoader: Finish load job 'startup Ordinary database default' with status OK
2026.10.27 16:30:23.877433 [ 660 ] {} <Debug> AsyncLoader: Spawn loader worker #2 in FgLoad
2026.10.27 16:30:23.877513 [ 660 ] {} <Debug> AsyncLoader: Execute load job 'startup Atomic database default' in FgLoad
2026.10.27 16:30:23.877526 [ 660 ] {} <Debug> AsyncLoader: Finish load job 'startup Atomic database default' with status OK
2026.10.27 16:30:23.877531 [ 660 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2026.10.27 16:30:23.877600 [ 661 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2026.10.27 16:30:23.877635 [ 661 ] {} <Debug> AsyncLoader: Change current priority: 0 -> none
2026.10.27 16:30:23.877677 [ 9 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/lib/clickhouse/user_defined/
2026.10.27 16:30:23.877714 [ 9 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded
2026.10.27 16:30:23.877720 [ 9 ] {} <Debug> Application: Loaded metadata.
2026.10.27 16:30:23.877751 [ 9 ] {} <Trace> Pipe: Pipe capacity is 1.00 MiB
2026.10.27 16:30:23.877784 [ 9 ] {} <Information> Application: Tasks stats provider: procfs
2026.10.27 16:30:23.877790 [ 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:30:23.878258 [ 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 24.3.18.10327.altinitystable (altinity build))
2026.10.27 16:30:23.878321 [ 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 24.3.18.10327.altinitystable (altinity build))
2026.10.27 16:30:23.878327 [ 9 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair.
2026.10.27 16:30:23.954400 [ 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 24.3.18.10327.altinitystable (altinity build))
2026.10.27 16:30:23.954482 [ 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 24.3.18.10327.altinitystable (altinity build))
2026.10.27 16:30:23.954487 [ 9 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair.
2026.10.27 16:30:24.056008 [ 9 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again.
2026.10.27 16:30:24.057070 [ 9 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 49.45 MiB, peak 49.45 MiB, free memory in arenas 43.08 MiB, will set to 447.45 MiB (RSS), difference: 398.00 MiB
2026.10.27 16:30:24.059547 [ 9 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 1.2339e-05 sec.
2026.10.27 16:30:24.060364 [ 9 ] {} <Information> Application: Listening for http://[::1]:8123
2026.10.27 16:30:24.060417 [ 9 ] {} <Information> Application: Listening for native protocol (tcp): [::1]:9000
2026.10.27 16:30:24.060459 [ 9 ] {} <Information> Application: Listening for MySQL compatibility protocol: [::1]:9004
2026.10.27 16:30:24.060522 [ 9 ] {} <Information> Application: Listening for PostgreSQL compatibility protocol: [::1]:9005
2026.10.27 16:30:24.060562 [ 9 ] {} <Information> Application: Listening for http://127.0.0.1:8123
2026.10.27 16:30:24.060601 [ 9 ] {} <Information> Application: Listening for native protocol (tcp): 127.0.0.1:9000
2026.10.27 16:30:24.060646 [ 9 ] {} <Information> Application: Listening for MySQL compatibility protocol: 127.0.0.1:9004
2026.10.27 16:30:24.060686 [ 9 ] {} <Information> Application: Listening for PostgreSQL compatibility protocol: 127.0.0.1:9005
2026.10.27 16:30:24.060692 [ 9 ] {} <Information> Application: Ready for connections.
2026.10.27 16:30:25.000762 [ 661 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 447.47 MiB, peak 447.47 MiB, free memory in arenas 43.14 MiB, will set to 450.09 MiB (RSS), difference: 2.62 MiB
2026.10.27 16:30:28.526187 [ 11 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: 127.0.0.1:49434
2026.10.27 16:30:28.526341 [ 11 ] {} <Debug> TCPHandler: Connected ClickHouse client version 24.3.0, revision: 54467, user: default.
2026.10.27 16:30:28.526369 [ 11 ] {} <Debug> TCP-Session: ec311dde-9e72-40a2-a076-86799dcc9852 Authenticating user 'default' from 127.0.0.1:49434
2026.10.27 16:30:28.526410 [ 11 ] {} <Debug> TCP-Session: ec311dde-9e72-40a2-a076-86799dcc9852 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
2026.10.27 16:30:28.526419 [ 11 ] {} <Debug> TCP-Session: ec311dde-9e72-40a2-a076-86799dcc9852 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
2026.10.27 16:30:28.526549 [ 11 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false
2026.10.27 16:30:28.526586 [ 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, ACCESS MANAGEMENT, SYSTEM, dictGet, displaySecretsInShowAndSelect, INTROSPECTION, SOURCES, CLUSTER ON *.* WITH GRANT OPTION, GRANT SET DEFINER ON * WITH GRANT OPTION, GRANT ALTER NAMED COLLECTION, CREATE NAMED COLLECTION, DROP NAMED COLLECTION, SHOW NAMED COLLECTIONS, NAMED COLLECTION ON * WITH GRANT OPTION
2026.10.27 16:30:28.526602 [ 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, ACCESS MANAGEMENT, SYSTEM, dictGet, displaySecretsInShowAndSelect, INTROSPECTION, SOURCES, CLUSTER ON *.* WITH GRANT OPTION, GRANT SET DEFINER ON * WITH GRANT OPTION, GRANT ALTER NAMED COLLECTION, CREATE NAMED COLLECTION, DROP NAMED COLLECTION, SHOW NAMED COLLECTIONS, NAMED COLLECTION ON * WITH GRANT OPTION
2026.10.27 16:30:28.539197 [ 11 ] {} <Trace> TCP-Session: ec311dde-9e72-40a2-a076-86799dcc9852 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
2026.10.27 16:30:28.539704 [ 11 ] {a7a5617e-6f35-4d5b-85bc-4b4b6977b65d} <Debug> executeQuery: (from 127.0.0.1:49434) select 'OK' (stage: Complete)
2026.10.27 16:30:28.540170 [ 11 ] {a7a5617e-6f35-4d5b-85bc-4b4b6977b65d} <Trace> Planner: Query SELECT 'OK' AS `'OK'` FROM system.one AS __table1 to stage Complete
2026.10.27 16:30:28.540216 [ 11 ] {a7a5617e-6f35-4d5b-85bc-4b4b6977b65d} <Trace> ContextAccess (default): Access granted: SELECT(dummy) ON system.one
2026.10.27 16:30:28.540304 [ 11 ] {a7a5617e-6f35-4d5b-85bc-4b4b6977b65d} <Trace> Planner: Query SELECT 'OK' AS `'OK'` FROM system.one AS __table1 from stage FetchColumns to stage Complete
2026.10.27 16:30:28.541415 [ 11 ] {a7a5617e-6f35-4d5b-85bc-4b4b6977b65d} <Debug> executeQuery: Read 1 rows, 1.00 B in 0.001748 sec., 572.0823798627002 rows/sec., 572.08 B/sec.
2026.10.27 16:30:28.541483 [ 11 ] {a7a5617e-6f35-4d5b-85bc-4b4b6977b65d} <Debug> TCPHandler: Processed in 0.002587822 sec.
2026.10.27 16:30:28.542422 [ 11 ] {} <Debug> TCPHandler: Done processing connection.
2026.10.27 16:30:28.542473 [ 11 ] {} <Debug> TCP-Session: ec311dde-9e72-40a2-a076-86799dcc9852 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db