2026.10.27 22:58:19.220597 [ 8 ] {} <Information> Application: Will watch for the process with pid 10
2026.10.27 22:58:19.220883 [ 10 ] {} <Information> Application: Forked a child process to watch
2026.10.27 22:58:19.221291 [ 10 ] {} <Information> SentryWriter: Sending crash reports is disabled
2026.10.27 22:58:19.221552 [ 10 ] {} <Trace> Pipe: Pipe capacity is 1.00 MiB
2026.10.27 22:58:19.329333 [ 10 ] {} <Information> Application: Starting ClickHouse 24.3.18.10331.altinitystable (revision: 54496, git hash: 81d000ac5be5c5838c19d9551a09b9bb596ada4a, build id: 3F3D44F4F65F1E46C8A5D134EB32A9D9BA95112B), PID 10
2026.10.27 22:58:19.329480 [ 10 ] {} <Information> Application: starting up
2026.10.27 22:58:19.329495 [ 10 ] {} <Information> Application: OS name: Linux, version: 5.15.0-130-generic, architecture: x86_64
2026.10.27 22:58:19.334075 [ 10 ] {} <Information> Application: Available RAM: 30.59 GiB; logical cores: 16; used cores: 16.
2026.10.27 22:58:19.334116 [ 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 22:58:19.334278 [ 10 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/thermal
2026.10.27 22:58:19.334294 [ 10 ] {} <Trace> AsynchronousMetrics: Scanning /sys/block
2026.10.27 22:58:19.334389 [ 10 ] {} <Trace> AsynchronousMetrics: Scanning /sys/devices/system/edac
2026.10.27 22:58:19.334407 [ 10 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/hwmon
2026.10.27 22:58:19.337939 [ 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 22:58:19.466961 [ 10 ] {} <Information> Application: Integrity check of the executable successfully passed (checksum: 2550EB5EAEA4CD3D7A10BE4DE8D6C743)
2026.10.27 22:58:19.467035 [ 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 22:58:19.469433 [ 10 ] {} <Debug> Application: rlimit on number of file descriptors is 1048576
2026.10.27 22:58:19.469447 [ 10 ] {} <Debug> Application: rlimit on number of threads is 18446744073709551615
2026.10.27 22:58:19.469455 [ 10 ] {} <Debug> Application: Initializing DateLUT.
2026.10.27 22:58:19.469459 [ 10 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'.
2026.10.27 22:58:19.469482 [ 10 ] {} <Debug> Context: Setting up /var/lib/clickhouse/tmp/ to store temporary data in it
2026.10.27 22:58:19.470024 [ 10 ] {} <Debug> Application: Configuration parameter 'interserver_http_host' doesn't exist or exists and empty. Will use 'github-hetzner-runner-40571922462-122517204571' as replica host.
2026.10.27 22:58:19.470038 [ 10 ] {} <Debug> Application: Initializing interserver credentials.
2026.10.27 22:58:19.470130 [ 10 ] {} <Trace> NamedCollectionsUtils: Loaded 0 collections from config
2026.10.27 22:58:19.470199 [ 10 ] {} <Trace> NamedCollectionsUtils: Loaded 0 collections from SQL
2026.10.27 22:58:19.470308 [ 10 ] {} <Information> CgroupsMemoryUsageObserver: Will read the current memory usage from '/sys/fs/cgroup/' (cgroups version: v2), wait time is 15 sec
2026.10.27 22:58:19.470531 [ 10 ] {} <Debug> ConfigReloader: Loading config '/config/config.xml'
2026.10.27 22:58:19.470538 [ 10 ] {} <Debug> ConfigProcessor: Processing configuration file '/config/config.xml'.
2026.10.27 22:58:19.473559 [ 10 ] {} <Debug> ConfigProcessor: Saved preprocessed configuration to '/var/lib/clickhouse/preprocessed_configs/config.xml'.
2026.10.27 22:58:19.473619 [ 10 ] {} <Debug> ConfigReloader: Loaded config '/config/config.xml', performing update on configuration
2026.10.27 22:58:19.476633 [ 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 22:58:19.476642 [ 10 ] {} <Information> CgroupsMemoryUsageObserver: Set new limits, soft limit: 24.78 GiB, hard limit: 26.16 GiB
2026.10.27 22:58:19.476647 [ 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 22:58:19.476651 [ 10 ] {} <Information> Application: Merges and mutations memory limit is set to 15.30 GiB
2026.10.27 22:58:19.476942 [ 10 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads
2026.10.27 22:58:19.479110 [ 10 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 512 threads
2026.10.27 22:58:19.545206 [ 10 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads
2026.10.27 22:58:19.548019 [ 10 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads
2026.10.27 22:58:19.549816 [ 10 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again.
2026.10.27 22:58:19.550023 [ 10 ] {} <Debug> ConfigReloader: Loaded config '/config/config.xml', performed update on configuration
2026.10.27 22:58:19.559210 [ 10 ] {} <Information> Application: Listening for replica communication (interserver): http://[::1]:9009
2026.10.27 22:58:19.572766 [ 10 ] {} <Information> Application: Listening for replica communication (interserver): http://127.0.0.1:9009
2026.10.27 22:58:19.617136 [ 10 ] {} <Debug> ConfigReloader: Loading config '/config/users.xml'
2026.10.27 22:58:19.617166 [ 10 ] {} <Debug> ConfigProcessor: Processing configuration file '/config/users.xml'.
2026.10.27 22:58:19.618311 [ 10 ] {} <Debug> ConfigProcessor: Saved preprocessed configuration to '/var/lib/clickhouse/preprocessed_configs/users.xml'.
2026.10.27 22:58:19.618338 [ 10 ] {} <Debug> ConfigReloader: Loaded config '/config/users.xml', performing update on configuration
2026.10.27 22:58:19.619654 [ 10 ] {} <Debug> ConfigReloader: Loaded config '/config/users.xml', performed update on configuration
2026.10.27 22:58:19.619822 [ 10 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: /config/users.xml
2026.10.27 22:58:19.620049 [ 10 ] {} <Warning> Access(local_directory): File /var/lib/clickhouse/access/users.list doesn't exist
2026.10.27 22:58:19.620068 [ 10 ] {} <Warning> Access(local_directory): Recovering lists in directory /var/lib/clickhouse/access/
2026.10.27 22:58:19.620556 [ 10 ] {} <Debug> Access(user directories): Added local_directory access storage 'local_directory', path: /var/lib/clickhouse/access/
2026.10.27 22:58:19.620701 [ 10 ] {} <Information> CgroupsMemoryUsageObserver: Started cgroup current memory usage observer thread
2026.10.27 22:58:19.621416 [ 581 ] {} <Information> CgroupsMemoryUsageObserver: Memory amount initially available to the process is 30.59 GiB
2026.10.27 22:58:19.622317 [ 10 ] {} <Information> Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32, scheduling_policy=round_robin
2026.10.27 22:58:19.623056 [ 10 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8
2026.10.27 22:58:19.624198 [ 10 ] {} <Information> Context: Initialized background executor for fetches with num_threads=16, num_tasks=16
2026.10.27 22:58:19.624753 [ 10 ] {} <Information> Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8
2026.10.27 22:58:19.626783 [ 10 ] {} <Information> DNSCacheUpdater: Update period 15 seconds
2026.10.27 22:58:19.626814 [ 10 ] {} <Information> Application: Loading metadata from /var/lib/clickhouse/
2026.10.27 22:58:19.627208 [ 45 ] {} <Debug> DNSResolver: Updating DNS cache
2026.10.27 22:58:19.634090 [ 10 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total.
2026.10.27 22:58:19.634111 [ 10 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.000135 sec
2026.10.27 22:58:19.634121 [ 10 ] {} <Trace> ReferentialDeps: No tables
2026.10.27 22:58:19.634128 [ 10 ] {} <Trace> LoadingDeps: No tables
2026.10.27 22:58:19.635320 [ 10 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Atomic database system': BgStartup -> FgLoad
2026.10.27 22:58:19.635339 [ 10 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Ordinary database system': BgStartup -> FgLoad
2026.10.27 22:58:19.635350 [ 10 ] {} <Debug> AsyncLoader: Schedule load job 'startup Ordinary database system' into FgLoad
2026.10.27 22:58:19.635359 [ 10 ] {} <Debug> AsyncLoader: Schedule load job 'startup Atomic database system' into FgLoad
2026.10.27 22:58:19.635368 [ 10 ] {} <Debug> AsyncLoader: Change current priority: none -> 0
2026.10.27 22:58:19.635376 [ 10 ] {} <Debug> AsyncLoader: Spawn loader worker #1 in FgLoad
2026.10.27 22:58:19.636087 [ 10 ] {} <Debug> AsyncLoader: Wait load job 'startup Atomic database system' in FgLoad
2026.10.27 22:58:19.636099 [ 45 ] {} <Debug> DNSResolver: Updated DNS cache
2026.10.27 22:58:19.636241 [ 646 ] {} <Debug> AsyncLoader: Execute load job 'startup Ordinary database system' in FgLoad
2026.10.27 22:58:19.636312 [ 646 ] {} <Debug> AsyncLoader: Finish load job 'startup Ordinary database system' with status OK
2026.10.27 22:58:19.636325 [ 646 ] {} <Debug> AsyncLoader: Spawn loader worker #2 in FgLoad
2026.10.27 22:58:19.636473 [ 646 ] {} <Debug> AsyncLoader: Execute load job 'startup Atomic database system' in FgLoad
2026.10.27 22:58:19.636525 [ 646 ] {} <Debug> AsyncLoader: Finish load job 'startup Atomic database system' with status OK
2026.10.27 22:58:19.636541 [ 646 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2026.10.27 22:58:19.636550 [ 10 ] {} <Debug> SystemLog: Creating system.query_log from query_log
2026.10.27 22:58:19.636724 [ 647 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2026.10.27 22:58:19.636839 [ 647 ] {} <Debug> AsyncLoader: Change current priority: 0 -> none
2026.10.27 22:58:19.638363 [ 10 ] {} <Debug> SystemLog: Creating system.query_thread_log from query_thread_log
2026.10.27 22:58:19.638861 [ 10 ] {} <Debug> SystemLog: Creating system.part_log from part_log
2026.10.27 22:58:19.639384 [ 10 ] {} <Debug> SystemLog: Creating system.trace_log from trace_log
2026.10.27 22:58:19.639644 [ 10 ] {} <Debug> SystemLog: Creating system.crash_log from crash_log
2026.10.27 22:58:19.639893 [ 10 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config
2026.10.27 22:58:19.639913 [ 10 ] {} <Debug> SystemLog: Creating system.metric_log from metric_log
2026.10.27 22:58:19.647196 [ 10 ] {} <Debug> SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config
2026.10.27 22:58:19.647226 [ 10 ] {} <Debug> SystemLog: Not creating system.filesystem_read_prefetches_log since corresponding section 'filesystem_read_prefetches_log' is missing from config
2026.10.27 22:58:19.647243 [ 10 ] {} <Debug> SystemLog: Creating system.asynchronous_metric_log from asynchronous_metric_log
2026.10.27 22:58:19.647520 [ 10 ] {} <Debug> SystemLog: Creating system.opentelemetry_span_log from opentelemetry_span_log
2026.10.27 22:58:19.647870 [ 10 ] {} <Debug> SystemLog: Creating system.query_views_log from query_views_log
2026.10.27 22:58:19.648237 [ 10 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config
2026.10.27 22:58:19.648257 [ 10 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config
2026.10.27 22:58:19.648272 [ 10 ] {} <Debug> SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config
2026.10.27 22:58:19.648298 [ 10 ] {} <Debug> SystemLog: Creating system.processors_profile_log from processors_profile_log
2026.10.27 22:58:19.648549 [ 10 ] {} <Debug> SystemLog: Creating system.asynchronous_insert_log from asynchronous_insert_log
2026.10.27 22:58:19.648967 [ 10 ] {} <Debug> SystemLog: Creating system.backup_log from backup_log
2026.10.27 22:58:19.649299 [ 10 ] {} <Debug> SystemLog: Creating system.s3queue_log from s3queue_log
2026.10.27 22:58:19.649550 [ 10 ] {} <Debug> SystemLog: Creating system.blob_storage_log from blob_storage_log
2026.10.27 22:58:19.676563 [ 10 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal.
2026.10.27 22:58:19.679385 [ 10 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total.
2026.10.27 22:58:19.679409 [ 10 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 8.214e-05 sec
2026.10.27 22:58:19.679421 [ 10 ] {} <Trace> ReferentialDeps: No tables
2026.10.27 22:58:19.679430 [ 10 ] {} <Trace> LoadingDeps: No tables
2026.10.27 22:58:19.679489 [ 10 ] {} <Information> loadMetadata: Start synchronous loading of databases
2026.10.27 22:58:19.679499 [ 10 ] {} <Information> loadMetadata: Start synchronous startup of databases
2026.10.27 22:58:19.679508 [ 10 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Atomic database default': BgStartup -> FgLoad
2026.10.27 22:58:19.679517 [ 10 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Ordinary database default': BgStartup -> FgLoad
2026.10.27 22:58:19.679532 [ 10 ] {} <Debug> AsyncLoader: Schedule load job 'startup Ordinary database default' into FgLoad
2026.10.27 22:58:19.679544 [ 10 ] {} <Debug> AsyncLoader: Schedule load job 'startup Atomic database default' into FgLoad
2026.10.27 22:58:19.679557 [ 10 ] {} <Debug> AsyncLoader: Change current priority: none -> 0
2026.10.27 22:58:19.679586 [ 10 ] {} <Debug> AsyncLoader: Spawn loader worker #1 in FgLoad
2026.10.27 22:58:19.679744 [ 10 ] {} <Debug> AsyncLoader: Wait load job 'startup Atomic database default' in FgLoad
2026.10.27 22:58:19.679889 [ 661 ] {} <Debug> AsyncLoader: Execute load job 'startup Ordinary database default' in FgLoad
2026.10.27 22:58:19.679954 [ 661 ] {} <Debug> AsyncLoader: Finish load job 'startup Ordinary database default' with status OK
2026.10.27 22:58:19.679966 [ 661 ] {} <Debug> AsyncLoader: Spawn loader worker #2 in FgLoad
2026.10.27 22:58:19.680111 [ 661 ] {} <Debug> AsyncLoader: Execute load job 'startup Atomic database default' in FgLoad
2026.10.27 22:58:19.680135 [ 661 ] {} <Debug> AsyncLoader: Finish load job 'startup Atomic database default' with status OK
2026.10.27 22:58:19.680144 [ 661 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2026.10.27 22:58:19.680358 [ 662 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2026.10.27 22:58:19.680407 [ 662 ] {} <Debug> AsyncLoader: Change current priority: 0 -> none
2026.10.27 22:58:19.680497 [ 10 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/lib/clickhouse/user_defined/
2026.10.27 22:58:19.680599 [ 10 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded
2026.10.27 22:58:19.680610 [ 10 ] {} <Debug> Application: Loaded metadata.
2026.10.27 22:58:19.680653 [ 10 ] {} <Trace> Pipe: Pipe capacity is 1.00 MiB
2026.10.27 22:58:19.680718 [ 10 ] {} <Information> Application: Tasks stats provider: procfs
2026.10.27 22:58:19.680728 [ 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 22:58:19.681573 [ 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.10331.altinitystable (altinity build))
2026.10.27 22:58:19.681714 [ 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.10331.altinitystable (altinity build))
2026.10.27 22:58:19.681724 [ 10 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair.
2026.10.27 22:58:19.758358 [ 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.10331.altinitystable (altinity build))
2026.10.27 22:58:19.758421 [ 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.10331.altinitystable (altinity build))
2026.10.27 22:58:19.758425 [ 10 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair.
2026.10.27 22:58:19.843639 [ 10 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again.
2026.10.27 22:58:19.844509 [ 10 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 49.45 MiB, peak 49.45 MiB, free memory in arenas 44.19 MiB, will set to 449.51 MiB (RSS), difference: 400.06 MiB
2026.10.27 22:58:19.846028 [ 10 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 1.226e-05 sec.
2026.10.27 22:58:19.847131 [ 10 ] {} <Information> Application: Listening for http://[::1]:8123
2026.10.27 22:58:19.847189 [ 10 ] {} <Information> Application: Listening for native protocol (tcp): [::1]:9000
2026.10.27 22:58:19.847225 [ 10 ] {} <Information> Application: Listening for MySQL compatibility protocol: [::1]:9004
2026.10.27 22:58:19.847263 [ 10 ] {} <Information> Application: Listening for PostgreSQL compatibility protocol: [::1]:9005
2026.10.27 22:58:19.847300 [ 10 ] {} <Information> Application: Listening for http://127.0.0.1:8123
2026.10.27 22:58:19.847342 [ 10 ] {} <Information> Application: Listening for native protocol (tcp): 127.0.0.1:9000
2026.10.27 22:58:19.847378 [ 10 ] {} <Information> Application: Listening for MySQL compatibility protocol: 127.0.0.1:9004
2026.10.27 22:58:19.847412 [ 10 ] {} <Information> Application: Listening for PostgreSQL compatibility protocol: 127.0.0.1:9005
2026.10.27 22:58:19.847416 [ 10 ] {} <Information> Application: Ready for connections.
2026.10.27 22:58:20.000964 [ 662 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 449.54 MiB, peak 449.54 MiB, free memory in arenas 44.11 MiB, will set to 452.17 MiB (RSS), difference: 2.63 MiB
2026.10.27 22:58:24.210451 [ 12 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:33456
2026.10.27 22:58:24.210672 [ 12 ] {} <Debug> TCPHandler: Connected ClickHouse client version 24.3.0, revision: 54467, user: default.
2026.10.27 22:58:24.210715 [ 12 ] {} <Debug> TCP-Session: 87edeccd-5d70-4f55-a544-9e7d38617e9e Authenticating user 'default' from [::1]:33456
2026.10.27 22:58:24.210762 [ 12 ] {} <Debug> TCP-Session: 87edeccd-5d70-4f55-a544-9e7d38617e9e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
2026.10.27 22:58:24.210774 [ 12 ] {} <Debug> TCP-Session: 87edeccd-5d70-4f55-a544-9e7d38617e9e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
2026.10.27 22:58:24.210946 [ 12 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false
2026.10.27 22:58:24.210983 [ 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 22:58:24.211023 [ 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 22:58:24.231131 [ 12 ] {} <Trace> TCP-Session: 87edeccd-5d70-4f55-a544-9e7d38617e9e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
2026.10.27 22:58:24.231563 [ 12 ] {07530458-d2c1-4a06-a40b-d5dcc6574a88} <Debug> executeQuery: (from [::1]:33456) select 'OK' (stage: Complete)
2026.10.27 22:58:24.231894 [ 12 ] {07530458-d2c1-4a06-a40b-d5dcc6574a88} <Trace> Planner: Query SELECT 'OK' AS `'OK'` FROM system.one AS __table1 to stage Complete
2026.10.27 22:58:24.231934 [ 12 ] {07530458-d2c1-4a06-a40b-d5dcc6574a88} <Trace> ContextAccess (default): Access granted: SELECT(dummy) ON system.one
2026.10.27 22:58:24.232023 [ 12 ] {07530458-d2c1-4a06-a40b-d5dcc6574a88} <Trace> Planner: Query SELECT 'OK' AS `'OK'` FROM system.one AS __table1 from stage FetchColumns to stage Complete
2026.10.27 22:58:24.233225 [ 12 ] {07530458-d2c1-4a06-a40b-d5dcc6574a88} <Debug> executeQuery: Read 1 rows, 1.00 B in 0.001696 sec., 589.622641509434 rows/sec., 589.62 B/sec.
2026.10.27 22:58:24.233290 [ 12 ] {07530458-d2c1-4a06-a40b-d5dcc6574a88} <Debug> TCPHandler: Processed in 0.002384529 sec.
2026.10.27 22:58:24.234913 [ 12 ] {} <Debug> TCPHandler: Done processing connection.
2026.10.27 22:58:24.234937 [ 12 ] {} <Debug> TCP-Session: 87edeccd-5d70-4f55-a544-9e7d38617e9e Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
2026.10.27 22:58:24.639285 [ 7 ] {} <Information> Application: Will watch for the process with pid 9
2026.10.27 22:58:24.639652 [ 9 ] {} <Information> Application: Forked a child process to watch
2026.10.27 22:58:24.640143 [ 9 ] {} <Information> SentryWriter: Sending crash reports is disabled
2026.10.27 22:58:24.640417 [ 9 ] {} <Trace> Pipe: Pipe capacity is 1.00 MiB
2026.10.27 22:58:24.749573 [ 9 ] {} <Information> Application: Starting ClickHouse 24.3.18.10331.altinitystable (revision: 54496, git hash: 81d000ac5be5c5838c19d9551a09b9bb596ada4a, build id: 3F3D44F4F65F1E46C8A5D134EB32A9D9BA95112B), PID 9
2026.10.27 22:58:24.749722 [ 9 ] {} <Information> Application: starting up
2026.10.27 22:58:24.749739 [ 9 ] {} <Information> Application: OS name: Linux, version: 5.15.0-130-generic, architecture: x86_64
2026.10.27 22:58:24.754611 [ 9 ] {} <Information> Application: Available RAM: 30.59 GiB; logical cores: 16; used cores: 16.
2026.10.27 22:58:24.754659 [ 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 22:58:24.754849 [ 9 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/thermal
2026.10.27 22:58:24.754864 [ 9 ] {} <Trace> AsynchronousMetrics: Scanning /sys/block
2026.10.27 22:58:24.754963 [ 9 ] {} <Trace> AsynchronousMetrics: Scanning /sys/devices/system/edac
2026.10.27 22:58:24.754986 [ 9 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/hwmon
2026.10.27 22:58:24.758527 [ 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 22:58:24.888434 [ 9 ] {} <Information> Application: Integrity check of the executable successfully passed (checksum: 2550EB5EAEA4CD3D7A10BE4DE8D6C743)
2026.10.27 22:58:24.888513 [ 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 22:58:24.890679 [ 9 ] {} <Debug> Application: rlimit on number of file descriptors is 1048576
2026.10.27 22:58:24.890694 [ 9 ] {} <Debug> Application: rlimit on number of threads is 18446744073709551615
2026.10.27 22:58:24.890703 [ 9 ] {} <Debug> Application: Initializing DateLUT.
2026.10.27 22:58:24.890708 [ 9 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'.
2026.10.27 22:58:24.890738 [ 9 ] {} <Debug> Context: Setting up /var/lib/clickhouse/tmp/ to store temporary data in it
2026.10.27 22:58:24.891290 [ 9 ] {} <Debug> Application: Configuration parameter 'interserver_http_host' doesn't exist or exists and empty. Will use 'github-hetzner-runner-40571922462-122517204571' as replica host.
2026.10.27 22:58:24.891304 [ 9 ] {} <Debug> Application: Initializing interserver credentials.
2026.10.27 22:58:24.891404 [ 9 ] {} <Trace> NamedCollectionsUtils: Loaded 0 collections from config
2026.10.27 22:58:24.891478 [ 9 ] {} <Trace> NamedCollectionsUtils: Loaded 0 collections from SQL
2026.10.27 22:58:24.891583 [ 9 ] {} <Information> CgroupsMemoryUsageObserver: Will read the current memory usage from '/sys/fs/cgroup/' (cgroups version: v2), wait time is 15 sec
2026.10.27 22:58:24.891796 [ 9 ] {} <Debug> ConfigReloader: Loading config '/config/config.xml'
2026.10.27 22:58:24.891803 [ 9 ] {} <Debug> ConfigProcessor: Processing configuration file '/config/config.xml'.
2026.10.27 22:58:24.895032 [ 9 ] {} <Debug> ConfigProcessor: Saved preprocessed configuration to '/var/lib/clickhouse/preprocessed_configs/config.xml'.
2026.10.27 22:58:24.895102 [ 9 ] {} <Debug> ConfigReloader: Loaded config '/config/config.xml', performing update on configuration
2026.10.27 22:58:24.898146 [ 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 22:58:24.898157 [ 9 ] {} <Information> CgroupsMemoryUsageObserver: Set new limits, soft limit: 24.78 GiB, hard limit: 26.16 GiB
2026.10.27 22:58:24.898163 [ 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 22:58:24.898168 [ 9 ] {} <Information> Application: Merges and mutations memory limit is set to 15.30 GiB
2026.10.27 22:58:24.898403 [ 9 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads
2026.10.27 22:58:24.899825 [ 9 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 512 threads
2026.10.27 22:58:24.974764 [ 9 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads
2026.10.27 22:58:24.976557 [ 9 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads
2026.10.27 22:58:24.979428 [ 9 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again.
2026.10.27 22:58:24.979759 [ 9 ] {} <Debug> ConfigReloader: Loaded config '/config/config.xml', performed update on configuration
2026.10.27 22:58:25.012414 [ 9 ] {} <Information> Application: Listening for replica communication (interserver): http://[::1]:9009
2026.10.27 22:58:25.013827 [ 9 ] {} <Information> Application: Listening for replica communication (interserver): http://127.0.0.1:9009
2026.10.27 22:58:25.020598 [ 9 ] {} <Debug> ConfigReloader: Loading config '/config/users.xml'
2026.10.27 22:58:25.020639 [ 9 ] {} <Debug> ConfigProcessor: Processing configuration file '/config/users.xml'.
2026.10.27 22:58:25.021443 [ 9 ] {} <Debug> ConfigProcessor: Saved preprocessed configuration to '/var/lib/clickhouse/preprocessed_configs/users.xml'.
2026.10.27 22:58:25.021471 [ 9 ] {} <Debug> ConfigReloader: Loaded config '/config/users.xml', performing update on configuration
2026.10.27 22:58:25.022557 [ 9 ] {} <Debug> ConfigReloader: Loaded config '/config/users.xml', performed update on configuration
2026.10.27 22:58:25.022738 [ 9 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: /config/users.xml
2026.10.27 22:58:25.022967 [ 9 ] {} <Warning> Access(local_directory): File /var/lib/clickhouse/access/users.list doesn't exist
2026.10.27 22:58:25.022988 [ 9 ] {} <Warning> Access(local_directory): Recovering lists in directory /var/lib/clickhouse/access/
2026.10.27 22:58:25.023313 [ 9 ] {} <Debug> Access(user directories): Added local_directory access storage 'local_directory', path: /var/lib/clickhouse/access/
2026.10.27 22:58:25.023464 [ 9 ] {} <Information> CgroupsMemoryUsageObserver: Started cgroup current memory usage observer thread
2026.10.27 22:58:25.024117 [ 580 ] {} <Information> CgroupsMemoryUsageObserver: Memory amount initially available to the process is 30.59 GiB
2026.10.27 22:58:25.024992 [ 9 ] {} <Information> Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32, scheduling_policy=round_robin
2026.10.27 22:58:25.025723 [ 9 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8
2026.10.27 22:58:25.026911 [ 9 ] {} <Information> Context: Initialized background executor for fetches with num_threads=16, num_tasks=16
2026.10.27 22:58:25.027499 [ 9 ] {} <Information> Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8
2026.10.27 22:58:25.029016 [ 9 ] {} <Information> DNSCacheUpdater: Update period 15 seconds
2026.10.27 22:58:25.029043 [ 9 ] {} <Information> Application: Loading metadata from /var/lib/clickhouse/
2026.10.27 22:58:25.029135 [ 23 ] {} <Debug> DNSResolver: Updating DNS cache
2026.10.27 22:58:25.032477 [ 23 ] {} <Debug> DNSResolver: Updated DNS cache
2026.10.27 22:58:25.035662 [ 9 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total.
2026.10.27 22:58:25.035680 [ 9 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.00014906 sec
2026.10.27 22:58:25.035686 [ 9 ] {} <Trace> ReferentialDeps: No tables
2026.10.27 22:58:25.035695 [ 9 ] {} <Trace> LoadingDeps: No tables
2026.10.27 22:58:25.035894 [ 9 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Atomic database system': BgStartup -> FgLoad
2026.10.27 22:58:25.035902 [ 9 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Ordinary database system': BgStartup -> FgLoad
2026.10.27 22:58:25.035913 [ 9 ] {} <Debug> AsyncLoader: Schedule load job 'startup Ordinary database system' into FgLoad
2026.10.27 22:58:25.035919 [ 9 ] {} <Debug> AsyncLoader: Schedule load job 'startup Atomic database system' into FgLoad
2026.10.27 22:58:25.035925 [ 9 ] {} <Debug> AsyncLoader: Change current priority: none -> 0
2026.10.27 22:58:25.035931 [ 9 ] {} <Debug> AsyncLoader: Spawn loader worker #1 in FgLoad
2026.10.27 22:58:25.036185 [ 9 ] {} <Debug> AsyncLoader: Wait load job 'startup Atomic database system' in FgLoad
2026.10.27 22:58:25.037199 [ 645 ] {} <Debug> AsyncLoader: Execute load job 'startup Ordinary database system' in FgLoad
2026.10.27 22:58:25.037496 [ 645 ] {} <Debug> AsyncLoader: Finish load job 'startup Ordinary database system' with status OK
2026.10.27 22:58:25.037501 [ 645 ] {} <Debug> AsyncLoader: Spawn loader worker #2 in FgLoad
2026.10.27 22:58:25.037652 [ 645 ] {} <Debug> AsyncLoader: Execute load job 'startup Atomic database system' in FgLoad
2026.10.27 22:58:25.037672 [ 645 ] {} <Debug> AsyncLoader: Finish load job 'startup Atomic database system' with status OK
2026.10.27 22:58:25.037678 [ 645 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2026.10.27 22:58:25.037696 [ 9 ] {} <Debug> SystemLog: Creating system.query_log from query_log
2026.10.27 22:58:25.037823 [ 646 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2026.10.27 22:58:25.037925 [ 646 ] {} <Debug> AsyncLoader: Change current priority: 0 -> none
2026.10.27 22:58:25.038588 [ 9 ] {} <Debug> SystemLog: Creating system.query_thread_log from query_thread_log
2026.10.27 22:58:25.038882 [ 9 ] {} <Debug> SystemLog: Creating system.part_log from part_log
2026.10.27 22:58:25.039103 [ 9 ] {} <Debug> SystemLog: Creating system.trace_log from trace_log
2026.10.27 22:58:25.039232 [ 9 ] {} <Debug> SystemLog: Creating system.crash_log from crash_log
2026.10.27 22:58:25.039326 [ 9 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config
2026.10.27 22:58:25.039336 [ 9 ] {} <Debug> SystemLog: Creating system.metric_log from metric_log
2026.10.27 22:58:25.042994 [ 9 ] {} <Debug> SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config
2026.10.27 22:58:25.043011 [ 9 ] {} <Debug> SystemLog: Not creating system.filesystem_read_prefetches_log since corresponding section 'filesystem_read_prefetches_log' is missing from config
2026.10.27 22:58:25.043021 [ 9 ] {} <Debug> SystemLog: Creating system.asynchronous_metric_log from asynchronous_metric_log
2026.10.27 22:58:25.043170 [ 9 ] {} <Debug> SystemLog: Creating system.opentelemetry_span_log from opentelemetry_span_log
2026.10.27 22:58:25.043372 [ 9 ] {} <Debug> SystemLog: Creating system.query_views_log from query_views_log
2026.10.27 22:58:25.043583 [ 9 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config
2026.10.27 22:58:25.043594 [ 9 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config
2026.10.27 22:58:25.043603 [ 9 ] {} <Debug> SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config
2026.10.27 22:58:25.043612 [ 9 ] {} <Debug> SystemLog: Creating system.processors_profile_log from processors_profile_log
2026.10.27 22:58:25.043739 [ 9 ] {} <Debug> SystemLog: Creating system.asynchronous_insert_log from asynchronous_insert_log
2026.10.27 22:58:25.043937 [ 9 ] {} <Debug> SystemLog: Creating system.backup_log from backup_log
2026.10.27 22:58:25.044088 [ 9 ] {} <Debug> SystemLog: Creating system.s3queue_log from s3queue_log
2026.10.27 22:58:25.044215 [ 9 ] {} <Debug> SystemLog: Creating system.blob_storage_log from blob_storage_log
2026.10.27 22:58:25.054792 [ 9 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal.
2026.10.27 22:58:25.056703 [ 9 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total.
2026.10.27 22:58:25.056713 [ 9 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 3.426e-05 sec
2026.10.27 22:58:25.056719 [ 9 ] {} <Trace> ReferentialDeps: No tables
2026.10.27 22:58:25.056724 [ 9 ] {} <Trace> LoadingDeps: No tables
2026.10.27 22:58:25.056755 [ 9 ] {} <Information> loadMetadata: Start synchronous loading of databases
2026.10.27 22:58:25.056760 [ 9 ] {} <Information> loadMetadata: Start synchronous startup of databases
2026.10.27 22:58:25.056765 [ 9 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Atomic database default': BgStartup -> FgLoad
2026.10.27 22:58:25.056769 [ 9 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Ordinary database default': BgStartup -> FgLoad
2026.10.27 22:58:25.056776 [ 9 ] {} <Debug> AsyncLoader: Schedule load job 'startup Ordinary database default' into FgLoad
2026.10.27 22:58:25.056804 [ 9 ] {} <Debug> AsyncLoader: Schedule load job 'startup Atomic database default' into FgLoad
2026.10.27 22:58:25.056810 [ 9 ] {} <Debug> AsyncLoader: Change current priority: none -> 0
2026.10.27 22:58:25.056815 [ 9 ] {} <Debug> AsyncLoader: Spawn loader worker #1 in FgLoad
2026.10.27 22:58:25.056887 [ 9 ] {} <Debug> AsyncLoader: Wait load job 'startup Atomic database default' in FgLoad
2026.10.27 22:58:25.057070 [ 660 ] {} <Debug> AsyncLoader: Execute load job 'startup Ordinary database default' in FgLoad
2026.10.27 22:58:25.057150 [ 660 ] {} <Debug> AsyncLoader: Finish load job 'startup Ordinary database default' with status OK
2026.10.27 22:58:25.057166 [ 660 ] {} <Debug> AsyncLoader: Spawn loader worker #2 in FgLoad
2026.10.27 22:58:25.057364 [ 660 ] {} <Debug> AsyncLoader: Execute load job 'startup Atomic database default' in FgLoad
2026.10.27 22:58:25.057393 [ 660 ] {} <Debug> AsyncLoader: Finish load job 'startup Atomic database default' with status OK
2026.10.27 22:58:25.057406 [ 660 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2026.10.27 22:58:25.057529 [ 9 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/lib/clickhouse/user_defined/
2026.10.27 22:58:25.057578 [ 9 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded
2026.10.27 22:58:25.057545 [ 661 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2026.10.27 22:58:25.057583 [ 9 ] {} <Debug> Application: Loaded metadata.
2026.10.27 22:58:25.057624 [ 661 ] {} <Debug> AsyncLoader: Change current priority: 0 -> none
2026.10.27 22:58:25.057648 [ 9 ] {} <Trace> Pipe: Pipe capacity is 1.00 MiB
2026.10.27 22:58:25.057678 [ 9 ] {} <Information> Application: Tasks stats provider: procfs
2026.10.27 22:58:25.057683 [ 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 22:58:25.058040 [ 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.10331.altinitystable (altinity build))
2026.10.27 22:58:25.058096 [ 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.10331.altinitystable (altinity build))
2026.10.27 22:58:25.058101 [ 9 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair.
2026.10.27 22:58:25.130196 [ 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.10331.altinitystable (altinity build))
2026.10.27 22:58:25.130258 [ 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.10331.altinitystable (altinity build))
2026.10.27 22:58:25.130263 [ 9 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair.
2026.10.27 22:58:25.169045 [ 9 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again.
2026.10.27 22:58:25.170159 [ 9 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 49.45 MiB, peak 49.45 MiB, free memory in arenas 37.56 MiB, will set to 447.68 MiB (RSS), difference: 398.23 MiB
2026.10.27 22:58:25.172481 [ 9 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 1.626e-05 sec.
2026.10.27 22:58:25.173537 [ 9 ] {} <Information> Application: Listening for http://[::1]:8123
2026.10.27 22:58:25.173624 [ 9 ] {} <Information> Application: Listening for native protocol (tcp): [::1]:9000
2026.10.27 22:58:25.173674 [ 9 ] {} <Information> Application: Listening for MySQL compatibility protocol: [::1]:9004
2026.10.27 22:58:25.173726 [ 9 ] {} <Information> Application: Listening for PostgreSQL compatibility protocol: [::1]:9005
2026.10.27 22:58:25.173785 [ 9 ] {} <Information> Application: Listening for http://127.0.0.1:8123
2026.10.27 22:58:25.173848 [ 9 ] {} <Information> Application: Listening for native protocol (tcp): 127.0.0.1:9000
2026.10.27 22:58:25.173899 [ 9 ] {} <Information> Application: Listening for MySQL compatibility protocol: 127.0.0.1:9004
2026.10.27 22:58:25.173950 [ 9 ] {} <Information> Application: Listening for PostgreSQL compatibility protocol: 127.0.0.1:9005
2026.10.27 22:58:25.173956 [ 9 ] {} <Information> Application: Ready for connections.
2026.10.27 22:58:26.001037 [ 661 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 447.71 MiB, peak 447.71 MiB, free memory in arenas 37.56 MiB, will set to 450.31 MiB (RSS), difference: 2.60 MiB
2026.10.27 22:58:29.623541 [ 11 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: 127.0.0.1:55994
2026.10.27 22:58:29.623674 [ 11 ] {} <Debug> TCPHandler: Connected ClickHouse client version 24.3.0, revision: 54467, user: default.
2026.10.27 22:58:29.623696 [ 11 ] {} <Debug> TCP-Session: 0beda78d-79ba-4731-a211-ee6a66550103 Authenticating user 'default' from 127.0.0.1:55994
2026.10.27 22:58:29.623736 [ 11 ] {} <Debug> TCP-Session: 0beda78d-79ba-4731-a211-ee6a66550103 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
2026.10.27 22:58:29.623742 [ 11 ] {} <Debug> TCP-Session: 0beda78d-79ba-4731-a211-ee6a66550103 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
2026.10.27 22:58:29.623826 [ 11 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false
2026.10.27 22:58:29.623844 [ 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 22:58:29.623857 [ 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 22:58:29.642363 [ 11 ] {} <Trace> TCP-Session: 0beda78d-79ba-4731-a211-ee6a66550103 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
2026.10.27 22:58:29.642856 [ 11 ] {9bdb3089-e811-4a28-bd89-6afb2332b125} <Debug> executeQuery: (from 127.0.0.1:55994) select 'OK' (stage: Complete)
2026.10.27 22:58:29.643143 [ 11 ] {9bdb3089-e811-4a28-bd89-6afb2332b125} <Trace> Planner: Query SELECT 'OK' AS `'OK'` FROM system.one AS __table1 to stage Complete
2026.10.27 22:58:29.643177 [ 11 ] {9bdb3089-e811-4a28-bd89-6afb2332b125} <Trace> ContextAccess (default): Access granted: SELECT(dummy) ON system.one
2026.10.27 22:58:29.643250 [ 11 ] {9bdb3089-e811-4a28-bd89-6afb2332b125} <Trace> Planner: Query SELECT 'OK' AS `'OK'` FROM system.one AS __table1 from stage FetchColumns to stage Complete
2026.10.27 22:58:29.644426 [ 11 ] {9bdb3089-e811-4a28-bd89-6afb2332b125} <Debug> executeQuery: Read 1 rows, 1.00 B in 0.001601 sec., 624.6096189881324 rows/sec., 624.61 B/sec.
2026.10.27 22:58:29.644478 [ 11 ] {9bdb3089-e811-4a28-bd89-6afb2332b125} <Debug> TCPHandler: Processed in 0.002338249 sec.
2026.10.27 22:58:29.646481 [ 11 ] {} <Debug> TCPHandler: Done processing connection.
2026.10.27 22:58:29.646528 [ 11 ] {} <Debug> TCP-Session: 0beda78d-79ba-4731-a211-ee6a66550103 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db