2026.05.23 01:29:12.208507 [ 8 ] {} <Information> Application: Will watch for the process with pid 10
2026.05.23 01:29:12.208782 [ 10 ] {} <Information> Application: Forked a child process to watch
2026.05.23 01:29:12.209255 [ 10 ] {} <Information> SentryWriter: Sending crash reports is disabled
2026.05.23 01:29:12.209504 [ 10 ] {} <Trace> Pipe: Pipe capacity is 1.00 MiB
2026.05.23 01:29:12.314673 [ 10 ] {} <Information> Application: Starting ClickHouse 24.3.18.10315.altinitystable (revision: 54496, git hash: 7313c1c2f44fa07f14091270bb7e973974ccf548, build id: DF4001FE1D484E49720DB90B1B69DFB717B2BBE8), PID 10
2026.05.23 01:29:12.314825 [ 10 ] {} <Information> Application: starting up
2026.05.23 01:29:12.314839 [ 10 ] {} <Information> Application: OS name: Linux, version: 5.15.0-130-generic, architecture: x86_64
2026.05.23 01:29:12.319436 [ 10 ] {} <Information> Application: Available RAM: 30.59 GiB; logical cores: 16; used cores: 16.
2026.05.23 01:29:12.319474 [ 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.05.23 01:29:12.319658 [ 10 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/thermal
2026.05.23 01:29:12.319676 [ 10 ] {} <Trace> AsynchronousMetrics: Scanning /sys/block
2026.05.23 01:29:12.319772 [ 10 ] {} <Trace> AsynchronousMetrics: Scanning /sys/devices/system/edac
2026.05.23 01:29:12.319790 [ 10 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/hwmon
2026.05.23 01:29:12.323312 [ 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.05.23 01:29:12.452879 [ 10 ] {} <Information> Application: Integrity check of the executable successfully passed (checksum: 5DF44909FF060CC9D38867D50924573F)
2026.05.23 01:29:12.452942 [ 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.05.23 01:29:12.455628 [ 10 ] {} <Debug> Application: rlimit on number of file descriptors is 1048576
2026.05.23 01:29:12.455642 [ 10 ] {} <Debug> Application: rlimit on number of threads is 18446744073709551615
2026.05.23 01:29:12.455650 [ 10 ] {} <Debug> Application: Initializing DateLUT.
2026.05.23 01:29:12.455654 [ 10 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'.
2026.05.23 01:29:12.455677 [ 10 ] {} <Debug> Context: Setting up /var/lib/clickhouse/tmp/ to store temporary data in it
2026.05.23 01:29:12.456228 [ 10 ] {} <Debug> Application: Configuration parameter 'interserver_http_host' doesn't exist or exists and empty. Will use 'github-hetzner-runner-standby-1779499274760544' as replica host.
2026.05.23 01:29:12.456241 [ 10 ] {} <Debug> Application: Initializing interserver credentials.
2026.05.23 01:29:12.456330 [ 10 ] {} <Trace> NamedCollectionsUtils: Loaded 0 collections from config
2026.05.23 01:29:12.456397 [ 10 ] {} <Trace> NamedCollectionsUtils: Loaded 0 collections from SQL
2026.05.23 01:29:12.456499 [ 10 ] {} <Information> CgroupsMemoryUsageObserver: Will read the current memory usage from '/sys/fs/cgroup/' (cgroups version: v2), wait time is 15 sec
2026.05.23 01:29:12.456702 [ 10 ] {} <Debug> ConfigReloader: Loading config '/config/config.xml'
2026.05.23 01:29:12.456708 [ 10 ] {} <Debug> ConfigProcessor: Processing configuration file '/config/config.xml'.
2026.05.23 01:29:12.459673 [ 10 ] {} <Debug> ConfigProcessor: Saved preprocessed configuration to '/var/lib/clickhouse/preprocessed_configs/config.xml'.
2026.05.23 01:29:12.459734 [ 10 ] {} <Debug> ConfigReloader: Loaded config '/config/config.xml', performing update on configuration
2026.05.23 01:29:12.462764 [ 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.05.23 01:29:12.462773 [ 10 ] {} <Information> CgroupsMemoryUsageObserver: Set new limits, soft limit: 24.78 GiB, hard limit: 26.16 GiB
2026.05.23 01:29:12.462778 [ 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.05.23 01:29:12.462782 [ 10 ] {} <Information> Application: Merges and mutations memory limit is set to 15.30 GiB
2026.05.23 01:29:12.463069 [ 10 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads
2026.05.23 01:29:12.465009 [ 10 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 512 threads
2026.05.23 01:29:12.587220 [ 10 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads
2026.05.23 01:29:12.588390 [ 10 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads
2026.05.23 01:29:12.589719 [ 10 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again.
2026.05.23 01:29:12.589778 [ 10 ] {} <Debug> ConfigReloader: Loaded config '/config/config.xml', performed update on configuration
2026.05.23 01:29:12.595449 [ 10 ] {} <Information> Application: Listening for replica communication (interserver): http://[::1]:9009
2026.05.23 01:29:12.595806 [ 10 ] {} <Information> Application: Listening for replica communication (interserver): http://127.0.0.1:9009
2026.05.23 01:29:12.601150 [ 10 ] {} <Debug> ConfigReloader: Loading config '/config/users.xml'
2026.05.23 01:29:12.601191 [ 10 ] {} <Debug> ConfigProcessor: Processing configuration file '/config/users.xml'.
2026.05.23 01:29:12.602066 [ 10 ] {} <Debug> ConfigProcessor: Saved preprocessed configuration to '/var/lib/clickhouse/preprocessed_configs/users.xml'.
2026.05.23 01:29:12.602109 [ 10 ] {} <Debug> ConfigReloader: Loaded config '/config/users.xml', performing update on configuration
2026.05.23 01:29:12.603438 [ 10 ] {} <Debug> ConfigReloader: Loaded config '/config/users.xml', performed update on configuration
2026.05.23 01:29:12.603683 [ 10 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: /config/users.xml
2026.05.23 01:29:12.603940 [ 10 ] {} <Warning> Access(local_directory): File /var/lib/clickhouse/access/users.list doesn't exist
2026.05.23 01:29:12.603963 [ 10 ] {} <Warning> Access(local_directory): Recovering lists in directory /var/lib/clickhouse/access/
2026.05.23 01:29:12.604392 [ 10 ] {} <Debug> Access(user directories): Added local_directory access storage 'local_directory', path: /var/lib/clickhouse/access/
2026.05.23 01:29:12.604554 [ 10 ] {} <Information> CgroupsMemoryUsageObserver: Started cgroup current memory usage observer thread
2026.05.23 01:29:12.605157 [ 581 ] {} <Information> CgroupsMemoryUsageObserver: Memory amount initially available to the process is 30.59 GiB
2026.05.23 01:29:12.605773 [ 10 ] {} <Information> Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32, scheduling_policy=round_robin
2026.05.23 01:29:12.606443 [ 10 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8
2026.05.23 01:29:12.608683 [ 10 ] {} <Information> Context: Initialized background executor for fetches with num_threads=16, num_tasks=16
2026.05.23 01:29:12.609067 [ 10 ] {} <Information> Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8
2026.05.23 01:29:12.616724 [ 10 ] {} <Information> DNSCacheUpdater: Update period 15 seconds
2026.05.23 01:29:12.616777 [ 10 ] {} <Information> Application: Loading metadata from /var/lib/clickhouse/
2026.05.23 01:29:12.616914 [ 46 ] {} <Debug> DNSResolver: Updating DNS cache
2026.05.23 01:29:12.618263 [ 46 ] {} <Debug> DNSResolver: Updated DNS cache
2026.05.23 01:29:12.623450 [ 10 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total.
2026.05.23 01:29:12.623474 [ 10 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.000144151 sec
2026.05.23 01:29:12.623486 [ 10 ] {} <Trace> ReferentialDeps: No tables
2026.05.23 01:29:12.623495 [ 10 ] {} <Trace> LoadingDeps: No tables
2026.05.23 01:29:12.623563 [ 10 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Atomic database system': BgStartup -> FgLoad
2026.05.23 01:29:12.623575 [ 10 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Ordinary database system': BgStartup -> FgLoad
2026.05.23 01:29:12.623588 [ 10 ] {} <Debug> AsyncLoader: Schedule load job 'startup Ordinary database system' into FgLoad
2026.05.23 01:29:12.623599 [ 10 ] {} <Debug> AsyncLoader: Schedule load job 'startup Atomic database system' into FgLoad
2026.05.23 01:29:12.623660 [ 10 ] {} <Debug> AsyncLoader: Change current priority: none -> 0
2026.05.23 01:29:12.623673 [ 10 ] {} <Debug> AsyncLoader: Spawn loader worker #1 in FgLoad
2026.05.23 01:29:12.623803 [ 10 ] {} <Debug> AsyncLoader: Wait load job 'startup Atomic database system' in FgLoad
2026.05.23 01:29:12.624026 [ 646 ] {} <Debug> AsyncLoader: Execute load job 'startup Ordinary database system' in FgLoad
2026.05.23 01:29:12.624126 [ 646 ] {} <Debug> AsyncLoader: Finish load job 'startup Ordinary database system' with status OK
2026.05.23 01:29:12.624142 [ 646 ] {} <Debug> AsyncLoader: Spawn loader worker #2 in FgLoad
2026.05.23 01:29:12.624361 [ 646 ] {} <Debug> AsyncLoader: Execute load job 'startup Atomic database system' in FgLoad
2026.05.23 01:29:12.624433 [ 646 ] {} <Debug> AsyncLoader: Finish load job 'startup Atomic database system' with status OK
2026.05.23 01:29:12.624450 [ 646 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2026.05.23 01:29:12.624483 [ 10 ] {} <Debug> SystemLog: Creating system.query_log from query_log
2026.05.23 01:29:12.624519 [ 647 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2026.05.23 01:29:12.624602 [ 647 ] {} <Debug> AsyncLoader: Change current priority: 0 -> none
2026.05.23 01:29:12.626507 [ 10 ] {} <Debug> SystemLog: Creating system.query_thread_log from query_thread_log
2026.05.23 01:29:12.627223 [ 10 ] {} <Debug> SystemLog: Creating system.part_log from part_log
2026.05.23 01:29:12.627858 [ 10 ] {} <Debug> SystemLog: Creating system.trace_log from trace_log
2026.05.23 01:29:12.628219 [ 10 ] {} <Debug> SystemLog: Creating system.crash_log from crash_log
2026.05.23 01:29:12.628476 [ 10 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config
2026.05.23 01:29:12.628497 [ 10 ] {} <Debug> SystemLog: Creating system.metric_log from metric_log
2026.05.23 01:29:12.639835 [ 10 ] {} <Debug> SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config
2026.05.23 01:29:12.639884 [ 10 ] {} <Debug> SystemLog: Not creating system.filesystem_read_prefetches_log since corresponding section 'filesystem_read_prefetches_log' is missing from config
2026.05.23 01:29:12.639902 [ 10 ] {} <Debug> SystemLog: Creating system.asynchronous_metric_log from asynchronous_metric_log
2026.05.23 01:29:12.640320 [ 10 ] {} <Debug> SystemLog: Creating system.opentelemetry_span_log from opentelemetry_span_log
2026.05.23 01:29:12.640717 [ 10 ] {} <Debug> SystemLog: Creating system.query_views_log from query_views_log
2026.05.23 01:29:12.641084 [ 10 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config
2026.05.23 01:29:12.641104 [ 10 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config
2026.05.23 01:29:12.641119 [ 10 ] {} <Debug> SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config
2026.05.23 01:29:12.641148 [ 10 ] {} <Debug> SystemLog: Creating system.processors_profile_log from processors_profile_log
2026.05.23 01:29:12.641426 [ 10 ] {} <Debug> SystemLog: Creating system.asynchronous_insert_log from asynchronous_insert_log
2026.05.23 01:29:12.641787 [ 10 ] {} <Debug> SystemLog: Creating system.backup_log from backup_log
2026.05.23 01:29:12.642052 [ 10 ] {} <Debug> SystemLog: Creating system.s3queue_log from s3queue_log
2026.05.23 01:29:12.642362 [ 10 ] {} <Debug> SystemLog: Creating system.blob_storage_log from blob_storage_log
2026.05.23 01:29:12.661748 [ 10 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal.
2026.05.23 01:29:12.664129 [ 10 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total.
2026.05.23 01:29:12.664144 [ 10 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 5.828e-05 sec
2026.05.23 01:29:12.664151 [ 10 ] {} <Trace> ReferentialDeps: No tables
2026.05.23 01:29:12.664155 [ 10 ] {} <Trace> LoadingDeps: No tables
2026.05.23 01:29:12.664198 [ 10 ] {} <Information> loadMetadata: Start synchronous loading of databases
2026.05.23 01:29:12.664203 [ 10 ] {} <Information> loadMetadata: Start synchronous startup of databases
2026.05.23 01:29:12.664208 [ 10 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Atomic database default': BgStartup -> FgLoad
2026.05.23 01:29:12.664212 [ 10 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Ordinary database default': BgStartup -> FgLoad
2026.05.23 01:29:12.664218 [ 10 ] {} <Debug> AsyncLoader: Schedule load job 'startup Ordinary database default' into FgLoad
2026.05.23 01:29:12.664222 [ 10 ] {} <Debug> AsyncLoader: Schedule load job 'startup Atomic database default' into FgLoad
2026.05.23 01:29:12.664226 [ 10 ] {} <Debug> AsyncLoader: Change current priority: none -> 0
2026.05.23 01:29:12.664230 [ 10 ] {} <Debug> AsyncLoader: Spawn loader worker #1 in FgLoad
2026.05.23 01:29:12.664318 [ 10 ] {} <Debug> AsyncLoader: Wait load job 'startup Atomic database default' in FgLoad
2026.05.23 01:29:12.664487 [ 661 ] {} <Debug> AsyncLoader: Execute load job 'startup Ordinary database default' in FgLoad
2026.05.23 01:29:12.664563 [ 661 ] {} <Debug> AsyncLoader: Finish load job 'startup Ordinary database default' with status OK
2026.05.23 01:29:12.664575 [ 661 ] {} <Debug> AsyncLoader: Spawn loader worker #2 in FgLoad
2026.05.23 01:29:12.664715 [ 661 ] {} <Debug> AsyncLoader: Execute load job 'startup Atomic database default' in FgLoad
2026.05.23 01:29:12.664738 [ 661 ] {} <Debug> AsyncLoader: Finish load job 'startup Atomic database default' with status OK
2026.05.23 01:29:12.664748 [ 661 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2026.05.23 01:29:12.664924 [ 10 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/lib/clickhouse/user_defined/
2026.05.23 01:29:12.664899 [ 662 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2026.05.23 01:29:12.664973 [ 10 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded
2026.05.23 01:29:12.664987 [ 10 ] {} <Debug> Application: Loaded metadata.
2026.05.23 01:29:12.664974 [ 662 ] {} <Debug> AsyncLoader: Change current priority: 0 -> none
2026.05.23 01:29:12.665016 [ 10 ] {} <Trace> Pipe: Pipe capacity is 1.00 MiB
2026.05.23 01:29:12.665075 [ 10 ] {} <Information> Application: Tasks stats provider: procfs
2026.05.23 01:29:12.665080 [ 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.05.23 01:29:12.665449 [ 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.10315.altinitystable (altinity build))
2026.05.23 01:29:12.665516 [ 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.10315.altinitystable (altinity build))
2026.05.23 01:29:12.665521 [ 10 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair.
2026.05.23 01:29:12.701983 [ 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.10315.altinitystable (altinity build))
2026.05.23 01:29:12.702052 [ 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.10315.altinitystable (altinity build))
2026.05.23 01:29:12.702057 [ 10 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair.
2026.05.23 01:29:12.739630 [ 10 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again.
2026.05.23 01:29:12.740579 [ 10 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 49.41 MiB, peak 49.41 MiB, free memory in arenas 38.07 MiB, will set to 446.56 MiB (RSS), difference: 397.16 MiB
2026.05.23 01:29:12.742118 [ 10 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 1.209e-05 sec.
2026.05.23 01:29:12.743143 [ 10 ] {} <Information> Application: Listening for http://[::1]:8123
2026.05.23 01:29:12.743293 [ 10 ] {} <Information> Application: Listening for native protocol (tcp): [::1]:9000
2026.05.23 01:29:12.743336 [ 10 ] {} <Information> Application: Listening for MySQL compatibility protocol: [::1]:9004
2026.05.23 01:29:12.743379 [ 10 ] {} <Information> Application: Listening for PostgreSQL compatibility protocol: [::1]:9005
2026.05.23 01:29:12.743418 [ 10 ] {} <Information> Application: Listening for http://127.0.0.1:8123
2026.05.23 01:29:12.743459 [ 10 ] {} <Information> Application: Listening for native protocol (tcp): 127.0.0.1:9000
2026.05.23 01:29:12.743498 [ 10 ] {} <Information> Application: Listening for MySQL compatibility protocol: 127.0.0.1:9004
2026.05.23 01:29:12.743535 [ 10 ] {} <Information> Application: Listening for PostgreSQL compatibility protocol: 127.0.0.1:9005
2026.05.23 01:29:12.743540 [ 10 ] {} <Information> Application: Ready for connections.
2026.05.23 01:29:13.000727 [ 663 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 446.59 MiB, peak 446.59 MiB, free memory in arenas 38.12 MiB, will set to 449.30 MiB (RSS), difference: 2.72 MiB
2026.05.23 01:29:17.218635 [ 12 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:54344
2026.05.23 01:29:17.218754 [ 12 ] {} <Debug> TCPHandler: Connected ClickHouse client version 24.3.0, revision: 54467, user: default.
2026.05.23 01:29:17.218778 [ 12 ] {} <Debug> TCP-Session: 353e936c-90d3-4467-9b85-6ad016c4dcb1 Authenticating user 'default' from [::1]:54344
2026.05.23 01:29:17.218806 [ 12 ] {} <Debug> TCP-Session: 353e936c-90d3-4467-9b85-6ad016c4dcb1 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
2026.05.23 01:29:17.218812 [ 12 ] {} <Debug> TCP-Session: 353e936c-90d3-4467-9b85-6ad016c4dcb1 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
2026.05.23 01:29:17.218899 [ 12 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false
2026.05.23 01:29:17.218919 [ 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.05.23 01:29:17.218938 [ 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.05.23 01:29:17.238642 [ 12 ] {} <Trace> TCP-Session: 353e936c-90d3-4467-9b85-6ad016c4dcb1 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
2026.05.23 01:29:17.238933 [ 12 ] {8288b9bf-bf82-4737-864d-fe614e9b9097} <Debug> executeQuery: (from [::1]:54344) select 'OK' (stage: Complete)
2026.05.23 01:29:17.239112 [ 12 ] {8288b9bf-bf82-4737-864d-fe614e9b9097} <Trace> Planner: Query SELECT 'OK' AS `'OK'` FROM system.one AS __table1 to stage Complete
2026.05.23 01:29:17.239147 [ 12 ] {8288b9bf-bf82-4737-864d-fe614e9b9097} <Trace> ContextAccess (default): Access granted: SELECT(dummy) ON system.one
2026.05.23 01:29:17.239195 [ 12 ] {8288b9bf-bf82-4737-864d-fe614e9b9097} <Trace> Planner: Query SELECT 'OK' AS `'OK'` FROM system.one AS __table1 from stage FetchColumns to stage Complete
2026.05.23 01:29:17.240148 [ 12 ] {8288b9bf-bf82-4737-864d-fe614e9b9097} <Debug> executeQuery: Read 1 rows, 1.00 B in 0.001244 sec., 803.8585209003215 rows/sec., 803.86 B/sec.
2026.05.23 01:29:17.240183 [ 12 ] {8288b9bf-bf82-4737-864d-fe614e9b9097} <Debug> TCPHandler: Processed in 0.001715242 sec.
2026.05.23 01:29:17.242184 [ 12 ] {} <Debug> TCPHandler: Done processing connection.
2026.05.23 01:29:17.242199 [ 12 ] {} <Debug> TCP-Session: 353e936c-90d3-4467-9b85-6ad016c4dcb1 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
2026.05.23 01:29:17.612475 [ 7 ] {} <Information> Application: Will watch for the process with pid 9
2026.05.23 01:29:17.612724 [ 9 ] {} <Information> Application: Forked a child process to watch
2026.05.23 01:29:17.613085 [ 9 ] {} <Information> SentryWriter: Sending crash reports is disabled
2026.05.23 01:29:17.613315 [ 9 ] {} <Trace> Pipe: Pipe capacity is 1.00 MiB
2026.05.23 01:29:17.702032 [ 9 ] {} <Information> Application: Starting ClickHouse 24.3.18.10315.altinitystable (revision: 54496, git hash: 7313c1c2f44fa07f14091270bb7e973974ccf548, build id: DF4001FE1D484E49720DB90B1B69DFB717B2BBE8), PID 9
2026.05.23 01:29:17.702188 [ 9 ] {} <Information> Application: starting up
2026.05.23 01:29:17.702205 [ 9 ] {} <Information> Application: OS name: Linux, version: 5.15.0-130-generic, architecture: x86_64
2026.05.23 01:29:17.707099 [ 9 ] {} <Information> Application: Available RAM: 30.59 GiB; logical cores: 16; used cores: 16.
2026.05.23 01:29:17.707145 [ 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.05.23 01:29:17.707319 [ 9 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/thermal
2026.05.23 01:29:17.707333 [ 9 ] {} <Trace> AsynchronousMetrics: Scanning /sys/block
2026.05.23 01:29:17.707425 [ 9 ] {} <Trace> AsynchronousMetrics: Scanning /sys/devices/system/edac
2026.05.23 01:29:17.707443 [ 9 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/hwmon
2026.05.23 01:29:17.710920 [ 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.05.23 01:29:17.840310 [ 9 ] {} <Information> Application: Integrity check of the executable successfully passed (checksum: 5DF44909FF060CC9D38867D50924573F)
2026.05.23 01:29:17.840389 [ 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.05.23 01:29:17.842928 [ 9 ] {} <Debug> Application: rlimit on number of file descriptors is 1048576
2026.05.23 01:29:17.842944 [ 9 ] {} <Debug> Application: rlimit on number of threads is 18446744073709551615
2026.05.23 01:29:17.842953 [ 9 ] {} <Debug> Application: Initializing DateLUT.
2026.05.23 01:29:17.842959 [ 9 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'.
2026.05.23 01:29:17.842985 [ 9 ] {} <Debug> Context: Setting up /var/lib/clickhouse/tmp/ to store temporary data in it
2026.05.23 01:29:17.843569 [ 9 ] {} <Debug> Application: Configuration parameter 'interserver_http_host' doesn't exist or exists and empty. Will use 'github-hetzner-runner-standby-1779499274760544' as replica host.
2026.05.23 01:29:17.843583 [ 9 ] {} <Debug> Application: Initializing interserver credentials.
2026.05.23 01:29:17.843716 [ 9 ] {} <Trace> NamedCollectionsUtils: Loaded 0 collections from config
2026.05.23 01:29:17.843793 [ 9 ] {} <Trace> NamedCollectionsUtils: Loaded 0 collections from SQL
2026.05.23 01:29:17.843897 [ 9 ] {} <Information> CgroupsMemoryUsageObserver: Will read the current memory usage from '/sys/fs/cgroup/' (cgroups version: v2), wait time is 15 sec
2026.05.23 01:29:17.844109 [ 9 ] {} <Debug> ConfigReloader: Loading config '/config/config.xml'
2026.05.23 01:29:17.844116 [ 9 ] {} <Debug> ConfigProcessor: Processing configuration file '/config/config.xml'.
2026.05.23 01:29:17.847095 [ 9 ] {} <Debug> ConfigProcessor: Saved preprocessed configuration to '/var/lib/clickhouse/preprocessed_configs/config.xml'.
2026.05.23 01:29:17.847153 [ 9 ] {} <Debug> ConfigReloader: Loaded config '/config/config.xml', performing update on configuration
2026.05.23 01:29:17.850195 [ 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.05.23 01:29:17.850205 [ 9 ] {} <Information> CgroupsMemoryUsageObserver: Set new limits, soft limit: 24.78 GiB, hard limit: 26.16 GiB
2026.05.23 01:29:17.850236 [ 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.05.23 01:29:17.850242 [ 9 ] {} <Information> Application: Merges and mutations memory limit is set to 15.30 GiB
2026.05.23 01:29:17.850487 [ 9 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads
2026.05.23 01:29:17.851491 [ 9 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 512 threads
2026.05.23 01:29:17.929148 [ 9 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads
2026.05.23 01:29:17.930786 [ 9 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads
2026.05.23 01:29:17.959254 [ 9 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again.
2026.05.23 01:29:17.959368 [ 9 ] {} <Debug> ConfigReloader: Loaded config '/config/config.xml', performed update on configuration
2026.05.23 01:29:17.962049 [ 9 ] {} <Information> Application: Listening for replica communication (interserver): http://[::1]:9009
2026.05.23 01:29:17.962687 [ 9 ] {} <Information> Application: Listening for replica communication (interserver): http://127.0.0.1:9009
2026.05.23 01:29:17.978598 [ 9 ] {} <Debug> ConfigReloader: Loading config '/config/users.xml'
2026.05.23 01:29:17.978638 [ 9 ] {} <Debug> ConfigProcessor: Processing configuration file '/config/users.xml'.
2026.05.23 01:29:17.979678 [ 9 ] {} <Debug> ConfigProcessor: Saved preprocessed configuration to '/var/lib/clickhouse/preprocessed_configs/users.xml'.
2026.05.23 01:29:17.979711 [ 9 ] {} <Debug> ConfigReloader: Loaded config '/config/users.xml', performing update on configuration
2026.05.23 01:29:17.980970 [ 9 ] {} <Debug> ConfigReloader: Loaded config '/config/users.xml', performed update on configuration
2026.05.23 01:29:17.981165 [ 9 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: /config/users.xml
2026.05.23 01:29:17.981441 [ 9 ] {} <Warning> Access(local_directory): File /var/lib/clickhouse/access/users.list doesn't exist
2026.05.23 01:29:17.981468 [ 9 ] {} <Warning> Access(local_directory): Recovering lists in directory /var/lib/clickhouse/access/
2026.05.23 01:29:17.982056 [ 9 ] {} <Debug> Access(user directories): Added local_directory access storage 'local_directory', path: /var/lib/clickhouse/access/
2026.05.23 01:29:17.982250 [ 9 ] {} <Information> CgroupsMemoryUsageObserver: Started cgroup current memory usage observer thread
2026.05.23 01:29:17.982864 [ 580 ] {} <Information> CgroupsMemoryUsageObserver: Memory amount initially available to the process is 30.59 GiB
2026.05.23 01:29:17.984116 [ 9 ] {} <Information> Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32, scheduling_policy=round_robin
2026.05.23 01:29:17.985054 [ 9 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8
2026.05.23 01:29:17.986699 [ 9 ] {} <Information> Context: Initialized background executor for fetches with num_threads=16, num_tasks=16
2026.05.23 01:29:17.987478 [ 9 ] {} <Information> Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8
2026.05.23 01:29:17.995971 [ 9 ] {} <Information> DNSCacheUpdater: Update period 15 seconds
2026.05.23 01:29:17.996348 [ 9 ] {} <Information> Application: Loading metadata from /var/lib/clickhouse/
2026.05.23 01:29:17.996135 [ 37 ] {} <Debug> DNSResolver: Updating DNS cache
2026.05.23 01:29:17.997650 [ 37 ] {} <Debug> DNSResolver: Updated DNS cache
2026.05.23 01:29:18.004295 [ 9 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total.
2026.05.23 01:29:18.004333 [ 9 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.00024722 sec
2026.05.23 01:29:18.004352 [ 9 ] {} <Trace> ReferentialDeps: No tables
2026.05.23 01:29:18.004367 [ 9 ] {} <Trace> LoadingDeps: No tables
2026.05.23 01:29:18.004456 [ 9 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Atomic database system': BgStartup -> FgLoad
2026.05.23 01:29:18.004478 [ 9 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Ordinary database system': BgStartup -> FgLoad
2026.05.23 01:29:18.004498 [ 9 ] {} <Debug> AsyncLoader: Schedule load job 'startup Ordinary database system' into FgLoad
2026.05.23 01:29:18.004515 [ 9 ] {} <Debug> AsyncLoader: Schedule load job 'startup Atomic database system' into FgLoad
2026.05.23 01:29:18.004533 [ 9 ] {} <Debug> AsyncLoader: Change current priority: none -> 0
2026.05.23 01:29:18.004549 [ 9 ] {} <Debug> AsyncLoader: Spawn loader worker #1 in FgLoad
2026.05.23 01:29:18.004730 [ 9 ] {} <Debug> AsyncLoader: Wait load job 'startup Atomic database system' in FgLoad
2026.05.23 01:29:18.004910 [ 645 ] {} <Debug> AsyncLoader: Execute load job 'startup Ordinary database system' in FgLoad
2026.05.23 01:29:18.004985 [ 645 ] {} <Debug> AsyncLoader: Finish load job 'startup Ordinary database system' with status OK
2026.05.23 01:29:18.005000 [ 645 ] {} <Debug> AsyncLoader: Spawn loader worker #2 in FgLoad
2026.05.23 01:29:18.005154 [ 645 ] {} <Debug> AsyncLoader: Execute load job 'startup Atomic database system' in FgLoad
2026.05.23 01:29:18.005230 [ 645 ] {} <Debug> AsyncLoader: Finish load job 'startup Atomic database system' with status OK
2026.05.23 01:29:18.005247 [ 645 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2026.05.23 01:29:18.005307 [ 9 ] {} <Debug> SystemLog: Creating system.query_log from query_log
2026.05.23 01:29:18.005427 [ 646 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2026.05.23 01:29:18.005524 [ 646 ] {} <Debug> AsyncLoader: Change current priority: 0 -> none
2026.05.23 01:29:18.007922 [ 9 ] {} <Debug> SystemLog: Creating system.query_thread_log from query_thread_log
2026.05.23 01:29:18.008602 [ 9 ] {} <Debug> SystemLog: Creating system.part_log from part_log
2026.05.23 01:29:18.009433 [ 9 ] {} <Debug> SystemLog: Creating system.trace_log from trace_log
2026.05.23 01:29:18.009809 [ 9 ] {} <Debug> SystemLog: Creating system.crash_log from crash_log
2026.05.23 01:29:18.010044 [ 9 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config
2026.05.23 01:29:18.010067 [ 9 ] {} <Debug> SystemLog: Creating system.metric_log from metric_log
2026.05.23 01:29:18.019058 [ 9 ] {} <Debug> SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config
2026.05.23 01:29:18.019101 [ 9 ] {} <Debug> SystemLog: Not creating system.filesystem_read_prefetches_log since corresponding section 'filesystem_read_prefetches_log' is missing from config
2026.05.23 01:29:18.019120 [ 9 ] {} <Debug> SystemLog: Creating system.asynchronous_metric_log from asynchronous_metric_log
2026.05.23 01:29:18.019439 [ 9 ] {} <Debug> SystemLog: Creating system.opentelemetry_span_log from opentelemetry_span_log
2026.05.23 01:29:18.019883 [ 9 ] {} <Debug> SystemLog: Creating system.query_views_log from query_views_log
2026.05.23 01:29:18.020315 [ 9 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config
2026.05.23 01:29:18.020345 [ 9 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config
2026.05.23 01:29:18.020367 [ 9 ] {} <Debug> SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config
2026.05.23 01:29:18.020388 [ 9 ] {} <Debug> SystemLog: Creating system.processors_profile_log from processors_profile_log
2026.05.23 01:29:18.020705 [ 9 ] {} <Debug> SystemLog: Creating system.asynchronous_insert_log from asynchronous_insert_log
2026.05.23 01:29:18.021072 [ 9 ] {} <Debug> SystemLog: Creating system.backup_log from backup_log
2026.05.23 01:29:18.021444 [ 9 ] {} <Debug> SystemLog: Creating system.s3queue_log from s3queue_log
2026.05.23 01:29:18.021848 [ 9 ] {} <Debug> SystemLog: Creating system.blob_storage_log from blob_storage_log
2026.05.23 01:29:18.041580 [ 9 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal.
2026.05.23 01:29:18.043759 [ 9 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total.
2026.05.23 01:29:18.043774 [ 9 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 5.374e-05 sec
2026.05.23 01:29:18.043781 [ 9 ] {} <Trace> ReferentialDeps: No tables
2026.05.23 01:29:18.043785 [ 9 ] {} <Trace> LoadingDeps: No tables
2026.05.23 01:29:18.043817 [ 9 ] {} <Information> loadMetadata: Start synchronous loading of databases
2026.05.23 01:29:18.043822 [ 9 ] {} <Information> loadMetadata: Start synchronous startup of databases
2026.05.23 01:29:18.043827 [ 9 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Atomic database default': BgStartup -> FgLoad
2026.05.23 01:29:18.043832 [ 9 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Ordinary database default': BgStartup -> FgLoad
2026.05.23 01:29:18.043838 [ 9 ] {} <Debug> AsyncLoader: Schedule load job 'startup Ordinary database default' into FgLoad
2026.05.23 01:29:18.043843 [ 9 ] {} <Debug> AsyncLoader: Schedule load job 'startup Atomic database default' into FgLoad
2026.05.23 01:29:18.043848 [ 9 ] {} <Debug> AsyncLoader: Change current priority: none -> 0
2026.05.23 01:29:18.043853 [ 9 ] {} <Debug> AsyncLoader: Spawn loader worker #1 in FgLoad
2026.05.23 01:29:18.043946 [ 9 ] {} <Debug> AsyncLoader: Wait load job 'startup Atomic database default' in FgLoad
2026.05.23 01:29:18.044101 [ 660 ] {} <Debug> AsyncLoader: Execute load job 'startup Ordinary database default' in FgLoad
2026.05.23 01:29:18.044168 [ 660 ] {} <Debug> AsyncLoader: Finish load job 'startup Ordinary database default' with status OK
2026.05.23 01:29:18.044182 [ 660 ] {} <Debug> AsyncLoader: Spawn loader worker #2 in FgLoad
2026.05.23 01:29:18.044350 [ 660 ] {} <Debug> AsyncLoader: Execute load job 'startup Atomic database default' in FgLoad
2026.05.23 01:29:18.044375 [ 660 ] {} <Debug> AsyncLoader: Finish load job 'startup Atomic database default' with status OK
2026.05.23 01:29:18.044387 [ 660 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2026.05.23 01:29:18.044540 [ 9 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/lib/clickhouse/user_defined/
2026.05.23 01:29:18.044534 [ 661 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2026.05.23 01:29:18.044589 [ 9 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded
2026.05.23 01:29:18.044595 [ 661 ] {} <Debug> AsyncLoader: Change current priority: 0 -> none
2026.05.23 01:29:18.044597 [ 9 ] {} <Debug> Application: Loaded metadata.
2026.05.23 01:29:18.044654 [ 9 ] {} <Trace> Pipe: Pipe capacity is 1.00 MiB
2026.05.23 01:29:18.044694 [ 9 ] {} <Information> Application: Tasks stats provider: procfs
2026.05.23 01:29:18.044701 [ 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.05.23 01:29:18.045045 [ 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.10315.altinitystable (altinity build))
2026.05.23 01:29:18.045103 [ 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.10315.altinitystable (altinity build))
2026.05.23 01:29:18.045109 [ 9 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair.
2026.05.23 01:29:18.100804 [ 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.10315.altinitystable (altinity build))
2026.05.23 01:29:18.100874 [ 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.10315.altinitystable (altinity build))
2026.05.23 01:29:18.100879 [ 9 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair.
2026.05.23 01:29:18.177247 [ 9 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again.
2026.05.23 01:29:18.178173 [ 9 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 49.45 MiB, peak 49.45 MiB, free memory in arenas 44.52 MiB, will set to 449.59 MiB (RSS), difference: 400.14 MiB
2026.05.23 01:29:18.180078 [ 9 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 1.152e-05 sec.
2026.05.23 01:29:18.181048 [ 9 ] {} <Information> Application: Listening for http://[::1]:8123
2026.05.23 01:29:18.181122 [ 9 ] {} <Information> Application: Listening for native protocol (tcp): [::1]:9000
2026.05.23 01:29:18.181161 [ 9 ] {} <Information> Application: Listening for MySQL compatibility protocol: [::1]:9004
2026.05.23 01:29:18.181202 [ 9 ] {} <Information> Application: Listening for PostgreSQL compatibility protocol: [::1]:9005
2026.05.23 01:29:18.181264 [ 9 ] {} <Information> Application: Listening for http://127.0.0.1:8123
2026.05.23 01:29:18.181304 [ 9 ] {} <Information> Application: Listening for native protocol (tcp): 127.0.0.1:9000
2026.05.23 01:29:18.181343 [ 9 ] {} <Information> Application: Listening for MySQL compatibility protocol: 127.0.0.1:9004
2026.05.23 01:29:18.181386 [ 9 ] {} <Information> Application: Listening for PostgreSQL compatibility protocol: 127.0.0.1:9005
2026.05.23 01:29:18.181390 [ 9 ] {} <Information> Application: Ready for connections.
2026.05.23 01:29:19.000693 [ 661 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 449.62 MiB, peak 449.62 MiB, free memory in arenas 44.49 MiB, will set to 452.16 MiB (RSS), difference: 2.54 MiB
2026.05.23 01:29:22.619936 [ 11 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: 127.0.0.1:50368
2026.05.23 01:29:22.620143 [ 11 ] {} <Debug> TCPHandler: Connected ClickHouse client version 24.3.0, revision: 54467, user: default.
2026.05.23 01:29:22.620202 [ 11 ] {} <Debug> TCP-Session: 07802337-6292-48b2-adbd-ad46bb3a6478 Authenticating user 'default' from 127.0.0.1:50368
2026.05.23 01:29:22.620278 [ 11 ] {} <Debug> TCP-Session: 07802337-6292-48b2-adbd-ad46bb3a6478 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
2026.05.23 01:29:22.620292 [ 11 ] {} <Debug> TCP-Session: 07802337-6292-48b2-adbd-ad46bb3a6478 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
2026.05.23 01:29:22.620438 [ 11 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false
2026.05.23 01:29:22.620475 [ 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.05.23 01:29:22.620511 [ 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.05.23 01:29:22.638866 [ 11 ] {} <Trace> TCP-Session: 07802337-6292-48b2-adbd-ad46bb3a6478 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
2026.05.23 01:29:22.639240 [ 11 ] {3d48be04-11e9-4f25-9ba8-ea7707396dee} <Debug> executeQuery: (from 127.0.0.1:50368) select 'OK' (stage: Complete)
2026.05.23 01:29:22.639555 [ 11 ] {3d48be04-11e9-4f25-9ba8-ea7707396dee} <Trace> Planner: Query SELECT 'OK' AS `'OK'` FROM system.one AS __table1 to stage Complete
2026.05.23 01:29:22.639605 [ 11 ] {3d48be04-11e9-4f25-9ba8-ea7707396dee} <Trace> ContextAccess (default): Access granted: SELECT(dummy) ON system.one
2026.05.23 01:29:22.639762 [ 11 ] {3d48be04-11e9-4f25-9ba8-ea7707396dee} <Trace> Planner: Query SELECT 'OK' AS `'OK'` FROM system.one AS __table1 from stage FetchColumns to stage Complete
2026.05.23 01:29:22.641116 [ 11 ] {3d48be04-11e9-4f25-9ba8-ea7707396dee} <Debug> executeQuery: Read 1 rows, 1.00 B in 0.001897 sec., 527.1481286241434 rows/sec., 527.15 B/sec.
2026.05.23 01:29:22.641174 [ 11 ] {3d48be04-11e9-4f25-9ba8-ea7707396dee} <Debug> TCPHandler: Processed in 0.002462742 sec.
2026.05.23 01:29:22.642857 [ 11 ] {} <Debug> TCPHandler: Done processing connection.
2026.05.23 01:29:22.642901 [ 11 ] {} <Debug> TCP-Session: 07802337-6292-48b2-adbd-ad46bb3a6478 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db