2025.05.23 22:17:15.865753 [ 8 ] {} <Information> Application: Will watch for the process with pid 10
2025.05.23 22:17:15.865985 [ 10 ] {} <Information> Application: Forked a child process to watch
2025.05.23 22:17:15.866355 [ 10 ] {} <Information> SentryWriter: Sending crash reports is disabled
2025.05.23 22:17:15.866556 [ 10 ] {} <Trace> Pipe: Pipe capacity is 1.00 MiB
2025.05.23 22:17:15.993812 [ 10 ] {} <Information> Application: Starting ClickHouse 24.3.18.10388.altinitystable (revision: 54496, git hash: 0ce6c8f2a4d3031f31446142fde2337a95087b3b, build id: 3B84B7D8EF86A1D6CC2AF2855A1AA2F1EDB823A7), PID 10
2025.05.23 22:17:15.993986 [ 10 ] {} <Information> Application: starting up
2025.05.23 22:17:15.994000 [ 10 ] {} <Information> Application: OS name: Linux, version: 5.15.0-130-generic, architecture: x86_64
2025.05.23 22:17:16.001292 [ 10 ] {} <Information> Application: Available RAM: 30.60 GiB; logical cores: 16; used cores: 16.
2025.05.23 22:17:16.001350 [ 10 ] {} <Information> Application: Available CPU instruction sets: SSE, SSE2, SSE3, SSSE3, SSE41, SSE42, F16C, POPCNT, BMI1, BMI2, PCLMUL, AES, AVX, FMA, AVX2, SHA, ADX, RDRAND, RDSEED, RDTSCP, CLFLUSHOPT, CLWB, XSAVE, OSXSAVE
2025.05.23 22:17:16.001531 [ 10 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/thermal
2025.05.23 22:17:16.001553 [ 10 ] {} <Trace> AsynchronousMetrics: Scanning /sys/block
2025.05.23 22:17:16.001674 [ 10 ] {} <Trace> AsynchronousMetrics: Scanning /sys/devices/system/edac
2025.05.23 22:17:16.001692 [ 10 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/hwmon
2025.05.23 22:17:16.006423 [ 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.
2025.05.23 22:17:16.167891 [ 10 ] {} <Information> Application: Integrity check of the executable successfully passed (checksum: 8FAB96359DCBEE06EDE3813EBB2A9026)
2025.05.23 22:17:16.168030 [ 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.
2025.05.23 22:17:16.171386 [ 10 ] {} <Debug> Application: rlimit on number of file descriptors is 1048576
2025.05.23 22:17:16.171401 [ 10 ] {} <Debug> Application: rlimit on number of threads is 18446744073709551615
2025.05.23 22:17:16.171412 [ 10 ] {} <Debug> Application: Initializing DateLUT.
2025.05.23 22:17:16.171416 [ 10 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'.
2025.05.23 22:17:16.171449 [ 10 ] {} <Debug> Context: Setting up /var/lib/clickhouse/tmp/ to store temporary data in it
2025.05.23 22:17:16.172253 [ 10 ] {} <Debug> Application: Configuration parameter 'interserver_http_host' doesn't exist or exists and empty. Will use 'github-hetzner-runner-15219621669-42813761705' as replica host.
2025.05.23 22:17:16.172267 [ 10 ] {} <Debug> Application: Initializing interserver credentials.
2025.05.23 22:17:16.172401 [ 10 ] {} <Trace> NamedCollectionsUtils: Loaded 0 collections from config
2025.05.23 22:17:16.172470 [ 10 ] {} <Trace> NamedCollectionsUtils: Loaded 0 collections from SQL
2025.05.23 22:17:16.172582 [ 10 ] {} <Information> CgroupsMemoryUsageObserver: Will read the current memory usage from '/sys/fs/cgroup/' (cgroups version: v2), wait time is 15 sec
2025.05.23 22:17:16.173344 [ 10 ] {} <Debug> ConfigReloader: Loading config '/config/config.xml'
2025.05.23 22:17:16.173354 [ 10 ] {} <Debug> ConfigProcessor: Processing configuration file '/config/config.xml'.
2025.05.23 22:17:16.178624 [ 10 ] {} <Debug> ConfigProcessor: Saved preprocessed configuration to '/var/lib/clickhouse/preprocessed_configs/config.xml'.
2025.05.23 22:17:16.179378 [ 10 ] {} <Debug> ConfigReloader: Loaded config '/config/config.xml', performing update on configuration
2025.05.23 22:17:16.183141 [ 10 ] {} <Information> Application: Setting max_server_memory_usage was set to 27.54 GiB (30.60 GiB available * 0.90 max_server_memory_usage_to_ram_ratio)
2025.05.23 22:17:16.183157 [ 10 ] {} <Information> CgroupsMemoryUsageObserver: Set new limits, soft limit: 24.79 GiB, hard limit: 26.16 GiB
2025.05.23 22:17:16.183161 [ 10 ] {} <Information> Application: Setting merges_mutations_memory_usage_soft_limit was set to 15.30 GiB (30.60 GiB available * 0.50 merges_mutations_memory_usage_to_ram_ratio)
2025.05.23 22:17:16.183165 [ 10 ] {} <Information> Application: Merges and mutations memory limit is set to 15.30 GiB
2025.05.23 22:17:16.183535 [ 10 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads
2025.05.23 22:17:16.186079 [ 10 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 512 threads
2025.05.23 22:17:16.304978 [ 10 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads
2025.05.23 22:17:16.317936 [ 10 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads
2025.05.23 22:17:16.320819 [ 10 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again.
2025.05.23 22:17:16.320892 [ 10 ] {} <Debug> ConfigReloader: Loaded config '/config/config.xml', performed update on configuration
2025.05.23 22:17:16.322485 [ 10 ] {} <Information> Application: Listening for replica communication (interserver): http://[::1]:9009
2025.05.23 22:17:16.323010 [ 10 ] {} <Information> Application: Listening for replica communication (interserver): http://127.0.0.1:9009
2025.05.23 22:17:16.325204 [ 10 ] {} <Debug> ConfigReloader: Loading config '/config/users.xml'
2025.05.23 22:17:16.325230 [ 10 ] {} <Debug> ConfigProcessor: Processing configuration file '/config/users.xml'.
2025.05.23 22:17:16.325796 [ 10 ] {} <Debug> ConfigProcessor: Saved preprocessed configuration to '/var/lib/clickhouse/preprocessed_configs/users.xml'.
2025.05.23 22:17:16.325812 [ 10 ] {} <Debug> ConfigReloader: Loaded config '/config/users.xml', performing update on configuration
2025.05.23 22:17:16.326629 [ 10 ] {} <Debug> ConfigReloader: Loaded config '/config/users.xml', performed update on configuration
2025.05.23 22:17:16.326840 [ 10 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: /config/users.xml
2025.05.23 22:17:16.326974 [ 10 ] {} <Warning> Access(local_directory): File /var/lib/clickhouse/access/users.list doesn't exist
2025.05.23 22:17:16.326984 [ 10 ] {} <Warning> Access(local_directory): Recovering lists in directory /var/lib/clickhouse/access/
2025.05.23 22:17:16.327169 [ 10 ] {} <Debug> Access(user directories): Added local_directory access storage 'local_directory', path: /var/lib/clickhouse/access/
2025.05.23 22:17:16.327294 [ 10 ] {} <Information> CgroupsMemoryUsageObserver: Started cgroup current memory usage observer thread
2025.05.23 22:17:16.327973 [ 581 ] {} <Information> CgroupsMemoryUsageObserver: Memory amount initially available to the process is 30.60 GiB
2025.05.23 22:17:16.329462 [ 10 ] {} <Information> Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32, scheduling_policy=round_robin
2025.05.23 22:17:16.330365 [ 10 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8
2025.05.23 22:17:16.331993 [ 10 ] {} <Information> Context: Initialized background executor for fetches with num_threads=16, num_tasks=16
2025.05.23 22:17:16.336487 [ 10 ] {} <Information> Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8
2025.05.23 22:17:16.339160 [ 10 ] {} <Information> DNSCacheUpdater: Update period 15 seconds
2025.05.23 22:17:16.339219 [ 10 ] {} <Information> Application: Loading metadata from /var/lib/clickhouse/
2025.05.23 22:17:16.339630 [ 46 ] {} <Debug> DNSResolver: Updating DNS cache
2025.05.23 22:17:16.342359 [ 46 ] {} <Debug> DNSResolver: Updated DNS cache
2025.05.23 22:17:16.349541 [ 10 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total.
2025.05.23 22:17:16.349579 [ 10 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.000171913 sec
2025.05.23 22:17:16.349588 [ 10 ] {} <Trace> ReferentialDeps: No tables
2025.05.23 22:17:16.349594 [ 10 ] {} <Trace> LoadingDeps: No tables
2025.05.23 22:17:16.349670 [ 10 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Atomic database system': BgStartup -> FgLoad
2025.05.23 22:17:16.349681 [ 10 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Ordinary database system': BgStartup -> FgLoad
2025.05.23 22:17:16.349691 [ 10 ] {} <Debug> AsyncLoader: Schedule load job 'startup Ordinary database system' into FgLoad
2025.05.23 22:17:16.349700 [ 10 ] {} <Debug> AsyncLoader: Schedule load job 'startup Atomic database system' into FgLoad
2025.05.23 22:17:16.349739 [ 10 ] {} <Debug> AsyncLoader: Change current priority: none -> 0
2025.05.23 22:17:16.349748 [ 10 ] {} <Debug> AsyncLoader: Spawn loader worker #1 in FgLoad
2025.05.23 22:17:16.349866 [ 10 ] {} <Debug> AsyncLoader: Wait load job 'startup Atomic database system' in FgLoad
2025.05.23 22:17:16.349997 [ 646 ] {} <Debug> AsyncLoader: Execute load job 'startup Ordinary database system' in FgLoad
2025.05.23 22:17:16.350086 [ 646 ] {} <Debug> AsyncLoader: Finish load job 'startup Ordinary database system' with status OK
2025.05.23 22:17:16.350096 [ 646 ] {} <Debug> AsyncLoader: Spawn loader worker #2 in FgLoad
2025.05.23 22:17:16.350252 [ 646 ] {} <Debug> AsyncLoader: Execute load job 'startup Atomic database system' in FgLoad
2025.05.23 22:17:16.350338 [ 646 ] {} <Debug> AsyncLoader: Finish load job 'startup Atomic database system' with status OK
2025.05.23 22:17:16.350349 [ 646 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2025.05.23 22:17:16.350401 [ 10 ] {} <Debug> SystemLog: Creating system.query_log from query_log
2025.05.23 22:17:16.350404 [ 647 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2025.05.23 22:17:16.350450 [ 647 ] {} <Debug> AsyncLoader: Change current priority: 0 -> none
2025.05.23 22:17:16.352590 [ 10 ] {} <Debug> SystemLog: Creating system.query_thread_log from query_thread_log
2025.05.23 22:17:16.353459 [ 10 ] {} <Debug> SystemLog: Creating system.part_log from part_log
2025.05.23 22:17:16.354172 [ 10 ] {} <Debug> SystemLog: Creating system.trace_log from trace_log
2025.05.23 22:17:16.354590 [ 10 ] {} <Debug> SystemLog: Creating system.crash_log from crash_log
2025.05.23 22:17:16.354892 [ 10 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config
2025.05.23 22:17:16.354913 [ 10 ] {} <Debug> SystemLog: Creating system.metric_log from metric_log
2025.05.23 22:17:16.365430 [ 10 ] {} <Debug> SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config
2025.05.23 22:17:16.365462 [ 10 ] {} <Debug> SystemLog: Not creating system.filesystem_read_prefetches_log since corresponding section 'filesystem_read_prefetches_log' is missing from config
2025.05.23 22:17:16.365480 [ 10 ] {} <Debug> SystemLog: Creating system.asynchronous_metric_log from asynchronous_metric_log
2025.05.23 22:17:16.365910 [ 10 ] {} <Debug> SystemLog: Creating system.opentelemetry_span_log from opentelemetry_span_log
2025.05.23 22:17:16.366443 [ 10 ] {} <Debug> SystemLog: Creating system.query_views_log from query_views_log
2025.05.23 22:17:16.367021 [ 10 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config
2025.05.23 22:17:16.367070 [ 10 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config
2025.05.23 22:17:16.367086 [ 10 ] {} <Debug> SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config
2025.05.23 22:17:16.367102 [ 10 ] {} <Debug> SystemLog: Creating system.processors_profile_log from processors_profile_log
2025.05.23 22:17:16.367528 [ 10 ] {} <Debug> SystemLog: Creating system.asynchronous_insert_log from asynchronous_insert_log
2025.05.23 22:17:16.368281 [ 10 ] {} <Debug> SystemLog: Creating system.backup_log from backup_log
2025.05.23 22:17:16.368755 [ 10 ] {} <Debug> SystemLog: Creating system.s3queue_log from s3queue_log
2025.05.23 22:17:16.369220 [ 10 ] {} <Debug> SystemLog: Creating system.blob_storage_log from blob_storage_log
2025.05.23 22:17:16.397257 [ 10 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal.
2025.05.23 22:17:16.400420 [ 10 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total.
2025.05.23 22:17:16.400434 [ 10 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 4.8892e-05 sec
2025.05.23 22:17:16.400442 [ 10 ] {} <Trace> ReferentialDeps: No tables
2025.05.23 22:17:16.400447 [ 10 ] {} <Trace> LoadingDeps: No tables
2025.05.23 22:17:16.400509 [ 10 ] {} <Information> loadMetadata: Start synchronous loading of databases
2025.05.23 22:17:16.400514 [ 10 ] {} <Information> loadMetadata: Start synchronous startup of databases
2025.05.23 22:17:16.400520 [ 10 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Atomic database default': BgStartup -> FgLoad
2025.05.23 22:17:16.400524 [ 10 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Ordinary database default': BgStartup -> FgLoad
2025.05.23 22:17:16.400533 [ 10 ] {} <Debug> AsyncLoader: Schedule load job 'startup Ordinary database default' into FgLoad
2025.05.23 22:17:16.400537 [ 10 ] {} <Debug> AsyncLoader: Schedule load job 'startup Atomic database default' into FgLoad
2025.05.23 22:17:16.400543 [ 10 ] {} <Debug> AsyncLoader: Change current priority: none -> 0
2025.05.23 22:17:16.400547 [ 10 ] {} <Debug> AsyncLoader: Spawn loader worker #1 in FgLoad
2025.05.23 22:17:16.400670 [ 10 ] {} <Debug> AsyncLoader: Wait load job 'startup Atomic database default' in FgLoad
2025.05.23 22:17:16.401199 [ 661 ] {} <Debug> AsyncLoader: Execute load job 'startup Ordinary database default' in FgLoad
2025.05.23 22:17:16.401363 [ 661 ] {} <Debug> AsyncLoader: Finish load job 'startup Ordinary database default' with status OK
2025.05.23 22:17:16.401377 [ 661 ] {} <Debug> AsyncLoader: Spawn loader worker #2 in FgLoad
2025.05.23 22:17:16.401565 [ 661 ] {} <Debug> AsyncLoader: Execute load job 'startup Atomic database default' in FgLoad
2025.05.23 22:17:16.401595 [ 661 ] {} <Debug> AsyncLoader: Finish load job 'startup Atomic database default' with status OK
2025.05.23 22:17:16.401602 [ 661 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2025.05.23 22:17:16.401622 [ 661 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2025.05.23 22:17:16.401631 [ 661 ] {} <Debug> AsyncLoader: Change current priority: 0 -> none
2025.05.23 22:17:16.401829 [ 10 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/lib/clickhouse/user_defined/
2025.05.23 22:17:16.401898 [ 10 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded
2025.05.23 22:17:16.401906 [ 10 ] {} <Debug> Application: Loaded metadata.
2025.05.23 22:17:16.401954 [ 10 ] {} <Trace> Pipe: Pipe capacity is 1.00 MiB
2025.05.23 22:17:16.402012 [ 10 ] {} <Information> Application: Tasks stats provider: procfs
2025.05.23 22:17:16.402021 [ 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.
2025.05.23 22:17:16.402794 [ 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.10388.altinitystable (altinity build))
2025.05.23 22:17:16.402930 [ 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.10388.altinitystable (altinity build))
2025.05.23 22:17:16.402938 [ 10 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair.
2025.05.23 22:17:16.550165 [ 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.10388.altinitystable (altinity build))
2025.05.23 22:17:16.550249 [ 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.10388.altinitystable (altinity build))
2025.05.23 22:17:16.550253 [ 10 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair.
2025.05.23 22:17:16.656287 [ 10 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again.
2025.05.23 22:17:16.657282 [ 10 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 49.38 MiB, peak 49.38 MiB, free memory in arenas 31.11 MiB, will set to 435.39 MiB (RSS), difference: 386.01 MiB
2025.05.23 22:17:16.658812 [ 10 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 1.5409e-05 sec.
2025.05.23 22:17:16.660068 [ 10 ] {} <Information> Application: Listening for http://[::1]:8123
2025.05.23 22:17:16.660138 [ 10 ] {} <Information> Application: Listening for native protocol (tcp): [::1]:9000
2025.05.23 22:17:16.660185 [ 10 ] {} <Information> Application: Listening for MySQL compatibility protocol: [::1]:9004
2025.05.23 22:17:16.660220 [ 10 ] {} <Information> Application: Listening for PostgreSQL compatibility protocol: [::1]:9005
2025.05.23 22:17:16.660256 [ 10 ] {} <Information> Application: Listening for http://127.0.0.1:8123
2025.05.23 22:17:16.660299 [ 10 ] {} <Information> Application: Listening for native protocol (tcp): 127.0.0.1:9000
2025.05.23 22:17:16.660337 [ 10 ] {} <Information> Application: Listening for MySQL compatibility protocol: 127.0.0.1:9004
2025.05.23 22:17:16.660380 [ 10 ] {} <Information> Application: Listening for PostgreSQL compatibility protocol: 127.0.0.1:9005
2025.05.23 22:17:16.660384 [ 10 ] {} <Information> Application: Ready for connections.
2025.05.23 22:17:17.001317 [ 663 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 435.42 MiB, peak 435.42 MiB, free memory in arenas 31.18 MiB, will set to 437.90 MiB (RSS), difference: 2.48 MiB
2025.05.23 22:17:20.843660 [ 12 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:32834
2025.05.23 22:17:20.843858 [ 12 ] {} <Debug> TCPHandler: Connected ClickHouse client version 24.3.0, revision: 54467, user: default.
2025.05.23 22:17:20.843899 [ 12 ] {} <Debug> TCP-Session: 314295e1-bf76-40c7-87f2-49ce2694c12d Authenticating user 'default' from [::1]:32834
2025.05.23 22:17:20.843950 [ 12 ] {} <Debug> TCP-Session: 314295e1-bf76-40c7-87f2-49ce2694c12d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
2025.05.23 22:17:20.843960 [ 12 ] {} <Debug> TCP-Session: 314295e1-bf76-40c7-87f2-49ce2694c12d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
2025.05.23 22:17:20.844114 [ 12 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false
2025.05.23 22:17:20.844151 [ 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
2025.05.23 22:17:20.844187 [ 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
2025.05.23 22:17:20.866477 [ 12 ] {} <Trace> TCP-Session: 314295e1-bf76-40c7-87f2-49ce2694c12d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
2025.05.23 22:17:20.866902 [ 12 ] {a92cffb4-11bd-44f6-9073-8fdda55588e7} <Debug> executeQuery: (from [::1]:32834) select 'OK' (stage: Complete)
2025.05.23 22:17:20.867215 [ 12 ] {a92cffb4-11bd-44f6-9073-8fdda55588e7} <Trace> Planner: Query SELECT 'OK' AS `'OK'` FROM system.one AS __table1 to stage Complete
2025.05.23 22:17:20.867263 [ 12 ] {a92cffb4-11bd-44f6-9073-8fdda55588e7} <Trace> ContextAccess (default): Access granted: SELECT(dummy) ON system.one
2025.05.23 22:17:20.867353 [ 12 ] {a92cffb4-11bd-44f6-9073-8fdda55588e7} <Trace> Planner: Query SELECT 'OK' AS `'OK'` FROM system.one AS __table1 from stage FetchColumns to stage Complete
2025.05.23 22:17:20.868941 [ 12 ] {a92cffb4-11bd-44f6-9073-8fdda55588e7} <Debug> executeQuery: Read 1 rows, 1.00 B in 0.002083 sec., 480.07681228996637 rows/sec., 480.08 B/sec.
2025.05.23 22:17:20.869006 [ 12 ] {a92cffb4-11bd-44f6-9073-8fdda55588e7} <Debug> TCPHandler: Processed in 0.002807705 sec.
2025.05.23 22:17:20.870400 [ 12 ] {} <Debug> TCPHandler: Done processing connection.
2025.05.23 22:17:20.870435 [ 12 ] {} <Debug> TCP-Session: 314295e1-bf76-40c7-87f2-49ce2694c12d Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
2025.05.23 22:17:21.257473 [ 7 ] {} <Information> Application: Will watch for the process with pid 9
2025.05.23 22:17:21.257751 [ 9 ] {} <Information> Application: Forked a child process to watch
2025.05.23 22:17:21.258128 [ 9 ] {} <Information> SentryWriter: Sending crash reports is disabled
2025.05.23 22:17:21.258331 [ 9 ] {} <Trace> Pipe: Pipe capacity is 1.00 MiB
2025.05.23 22:17:21.382606 [ 9 ] {} <Information> Application: Starting ClickHouse 24.3.18.10388.altinitystable (revision: 54496, git hash: 0ce6c8f2a4d3031f31446142fde2337a95087b3b, build id: 3B84B7D8EF86A1D6CC2AF2855A1AA2F1EDB823A7), PID 9
2025.05.23 22:17:21.382805 [ 9 ] {} <Information> Application: starting up
2025.05.23 22:17:21.382823 [ 9 ] {} <Information> Application: OS name: Linux, version: 5.15.0-130-generic, architecture: x86_64
2025.05.23 22:17:21.387764 [ 9 ] {} <Information> Application: Available RAM: 30.60 GiB; logical cores: 16; used cores: 16.
2025.05.23 22:17:21.387805 [ 9 ] {} <Information> Application: Available CPU instruction sets: SSE, SSE2, SSE3, SSSE3, SSE41, SSE42, F16C, POPCNT, BMI1, BMI2, PCLMUL, AES, AVX, FMA, AVX2, SHA, ADX, RDRAND, RDSEED, RDTSCP, CLFLUSHOPT, CLWB, XSAVE, OSXSAVE
2025.05.23 22:17:21.387947 [ 9 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/thermal
2025.05.23 22:17:21.387959 [ 9 ] {} <Trace> AsynchronousMetrics: Scanning /sys/block
2025.05.23 22:17:21.388041 [ 9 ] {} <Trace> AsynchronousMetrics: Scanning /sys/devices/system/edac
2025.05.23 22:17:21.388056 [ 9 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/hwmon
2025.05.23 22:17:21.392358 [ 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.
2025.05.23 22:17:21.543848 [ 9 ] {} <Information> Application: Integrity check of the executable successfully passed (checksum: 8FAB96359DCBEE06EDE3813EBB2A9026)
2025.05.23 22:17:21.543933 [ 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.
2025.05.23 22:17:21.547333 [ 9 ] {} <Debug> Application: rlimit on number of file descriptors is 1048576
2025.05.23 22:17:21.547348 [ 9 ] {} <Debug> Application: rlimit on number of threads is 18446744073709551615
2025.05.23 22:17:21.547356 [ 9 ] {} <Debug> Application: Initializing DateLUT.
2025.05.23 22:17:21.547360 [ 9 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'.
2025.05.23 22:17:21.547382 [ 9 ] {} <Debug> Context: Setting up /var/lib/clickhouse/tmp/ to store temporary data in it
2025.05.23 22:17:21.547960 [ 9 ] {} <Debug> Application: Configuration parameter 'interserver_http_host' doesn't exist or exists and empty. Will use 'github-hetzner-runner-15219621669-42813761705' as replica host.
2025.05.23 22:17:21.547975 [ 9 ] {} <Debug> Application: Initializing interserver credentials.
2025.05.23 22:17:21.548082 [ 9 ] {} <Trace> NamedCollectionsUtils: Loaded 0 collections from config
2025.05.23 22:17:21.548147 [ 9 ] {} <Trace> NamedCollectionsUtils: Loaded 0 collections from SQL
2025.05.23 22:17:21.548237 [ 9 ] {} <Information> CgroupsMemoryUsageObserver: Will read the current memory usage from '/sys/fs/cgroup/' (cgroups version: v2), wait time is 15 sec
2025.05.23 22:17:21.548664 [ 9 ] {} <Debug> ConfigReloader: Loading config '/config/config.xml'
2025.05.23 22:17:21.548670 [ 9 ] {} <Debug> ConfigProcessor: Processing configuration file '/config/config.xml'.
2025.05.23 22:17:21.553148 [ 9 ] {} <Debug> ConfigProcessor: Saved preprocessed configuration to '/var/lib/clickhouse/preprocessed_configs/config.xml'.
2025.05.23 22:17:21.553229 [ 9 ] {} <Debug> ConfigReloader: Loaded config '/config/config.xml', performing update on configuration
2025.05.23 22:17:21.557007 [ 9 ] {} <Information> Application: Setting max_server_memory_usage was set to 27.54 GiB (30.60 GiB available * 0.90 max_server_memory_usage_to_ram_ratio)
2025.05.23 22:17:21.557021 [ 9 ] {} <Information> CgroupsMemoryUsageObserver: Set new limits, soft limit: 24.79 GiB, hard limit: 26.16 GiB
2025.05.23 22:17:21.557027 [ 9 ] {} <Information> Application: Setting merges_mutations_memory_usage_soft_limit was set to 15.30 GiB (30.60 GiB available * 0.50 merges_mutations_memory_usage_to_ram_ratio)
2025.05.23 22:17:21.557032 [ 9 ] {} <Information> Application: Merges and mutations memory limit is set to 15.30 GiB
2025.05.23 22:17:21.557390 [ 9 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads
2025.05.23 22:17:21.559970 [ 9 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 512 threads
2025.05.23 22:17:21.658114 [ 9 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads
2025.05.23 22:17:21.660243 [ 9 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads
2025.05.23 22:17:21.662283 [ 9 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again.
2025.05.23 22:17:21.662351 [ 9 ] {} <Debug> ConfigReloader: Loaded config '/config/config.xml', performed update on configuration
2025.05.23 22:17:21.664488 [ 9 ] {} <Information> Application: Listening for replica communication (interserver): http://[::1]:9009
2025.05.23 22:17:21.665671 [ 9 ] {} <Information> Application: Listening for replica communication (interserver): http://127.0.0.1:9009
2025.05.23 22:17:21.674335 [ 9 ] {} <Debug> ConfigReloader: Loading config '/config/users.xml'
2025.05.23 22:17:21.674361 [ 9 ] {} <Debug> ConfigProcessor: Processing configuration file '/config/users.xml'.
2025.05.23 22:17:21.675590 [ 9 ] {} <Debug> ConfigProcessor: Saved preprocessed configuration to '/var/lib/clickhouse/preprocessed_configs/users.xml'.
2025.05.23 22:17:21.675628 [ 9 ] {} <Debug> ConfigReloader: Loaded config '/config/users.xml', performing update on configuration
2025.05.23 22:17:21.677363 [ 9 ] {} <Debug> ConfigReloader: Loaded config '/config/users.xml', performed update on configuration
2025.05.23 22:17:21.677670 [ 9 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: /config/users.xml
2025.05.23 22:17:21.677901 [ 9 ] {} <Warning> Access(local_directory): File /var/lib/clickhouse/access/users.list doesn't exist
2025.05.23 22:17:21.677929 [ 9 ] {} <Warning> Access(local_directory): Recovering lists in directory /var/lib/clickhouse/access/
2025.05.23 22:17:21.678748 [ 9 ] {} <Debug> Access(user directories): Added local_directory access storage 'local_directory', path: /var/lib/clickhouse/access/
2025.05.23 22:17:21.678931 [ 9 ] {} <Information> CgroupsMemoryUsageObserver: Started cgroup current memory usage observer thread
2025.05.23 22:17:21.679580 [ 580 ] {} <Information> CgroupsMemoryUsageObserver: Memory amount initially available to the process is 30.60 GiB
2025.05.23 22:17:21.680762 [ 9 ] {} <Information> Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32, scheduling_policy=round_robin
2025.05.23 22:17:21.681429 [ 9 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8
2025.05.23 22:17:21.685615 [ 9 ] {} <Information> Context: Initialized background executor for fetches with num_threads=16, num_tasks=16
2025.05.23 22:17:21.686379 [ 9 ] {} <Information> Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8
2025.05.23 22:17:21.688088 [ 9 ] {} <Information> DNSCacheUpdater: Update period 15 seconds
2025.05.23 22:17:21.688121 [ 9 ] {} <Information> Application: Loading metadata from /var/lib/clickhouse/
2025.05.23 22:17:21.688238 [ 59 ] {} <Debug> DNSResolver: Updating DNS cache
2025.05.23 22:17:21.691592 [ 59 ] {} <Debug> DNSResolver: Updated DNS cache
2025.05.23 22:17:21.696595 [ 9 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total.
2025.05.23 22:17:21.696620 [ 9 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.000133481 sec
2025.05.23 22:17:21.696629 [ 9 ] {} <Trace> ReferentialDeps: No tables
2025.05.23 22:17:21.696637 [ 9 ] {} <Trace> LoadingDeps: No tables
2025.05.23 22:17:21.696701 [ 9 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Atomic database system': BgStartup -> FgLoad
2025.05.23 22:17:21.696716 [ 9 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Ordinary database system': BgStartup -> FgLoad
2025.05.23 22:17:21.696728 [ 9 ] {} <Debug> AsyncLoader: Schedule load job 'startup Ordinary database system' into FgLoad
2025.05.23 22:17:21.696737 [ 9 ] {} <Debug> AsyncLoader: Schedule load job 'startup Atomic database system' into FgLoad
2025.05.23 22:17:21.696746 [ 9 ] {} <Debug> AsyncLoader: Change current priority: none -> 0
2025.05.23 22:17:21.696756 [ 9 ] {} <Debug> AsyncLoader: Spawn loader worker #1 in FgLoad
2025.05.23 22:17:21.696869 [ 9 ] {} <Debug> AsyncLoader: Wait load job 'startup Atomic database system' in FgLoad
2025.05.23 22:17:21.697009 [ 645 ] {} <Debug> AsyncLoader: Execute load job 'startup Ordinary database system' in FgLoad
2025.05.23 22:17:21.697058 [ 645 ] {} <Debug> AsyncLoader: Finish load job 'startup Ordinary database system' with status OK
2025.05.23 22:17:21.697097 [ 645 ] {} <Debug> AsyncLoader: Spawn loader worker #2 in FgLoad
2025.05.23 22:17:21.697247 [ 645 ] {} <Debug> AsyncLoader: Execute load job 'startup Atomic database system' in FgLoad
2025.05.23 22:17:21.697311 [ 645 ] {} <Debug> AsyncLoader: Finish load job 'startup Atomic database system' with status OK
2025.05.23 22:17:21.697326 [ 645 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2025.05.23 22:17:21.697367 [ 9 ] {} <Debug> SystemLog: Creating system.query_log from query_log
2025.05.23 22:17:21.697402 [ 646 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2025.05.23 22:17:21.697488 [ 646 ] {} <Debug> AsyncLoader: Change current priority: 0 -> none
2025.05.23 22:17:21.699732 [ 9 ] {} <Debug> SystemLog: Creating system.query_thread_log from query_thread_log
2025.05.23 22:17:21.700675 [ 9 ] {} <Debug> SystemLog: Creating system.part_log from part_log
2025.05.23 22:17:21.701548 [ 9 ] {} <Debug> SystemLog: Creating system.trace_log from trace_log
2025.05.23 22:17:21.702055 [ 9 ] {} <Debug> SystemLog: Creating system.crash_log from crash_log
2025.05.23 22:17:21.702381 [ 9 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config
2025.05.23 22:17:21.702404 [ 9 ] {} <Debug> SystemLog: Creating system.metric_log from metric_log
2025.05.23 22:17:21.713863 [ 9 ] {} <Debug> SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config
2025.05.23 22:17:21.713905 [ 9 ] {} <Debug> SystemLog: Not creating system.filesystem_read_prefetches_log since corresponding section 'filesystem_read_prefetches_log' is missing from config
2025.05.23 22:17:21.713926 [ 9 ] {} <Debug> SystemLog: Creating system.asynchronous_metric_log from asynchronous_metric_log
2025.05.23 22:17:21.714513 [ 9 ] {} <Debug> SystemLog: Creating system.opentelemetry_span_log from opentelemetry_span_log
2025.05.23 22:17:21.715235 [ 9 ] {} <Debug> SystemLog: Creating system.query_views_log from query_views_log
2025.05.23 22:17:21.716056 [ 9 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config
2025.05.23 22:17:21.716081 [ 9 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config
2025.05.23 22:17:21.716099 [ 9 ] {} <Debug> SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config
2025.05.23 22:17:21.716117 [ 9 ] {} <Debug> SystemLog: Creating system.processors_profile_log from processors_profile_log
2025.05.23 22:17:21.716548 [ 9 ] {} <Debug> SystemLog: Creating system.asynchronous_insert_log from asynchronous_insert_log
2025.05.23 22:17:21.717130 [ 9 ] {} <Debug> SystemLog: Creating system.backup_log from backup_log
2025.05.23 22:17:21.717797 [ 9 ] {} <Debug> SystemLog: Creating system.s3queue_log from s3queue_log
2025.05.23 22:17:21.718197 [ 9 ] {} <Debug> SystemLog: Creating system.blob_storage_log from blob_storage_log
2025.05.23 22:17:21.744971 [ 9 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal.
2025.05.23 22:17:21.747979 [ 9 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total.
2025.05.23 22:17:21.747996 [ 9 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 5.358e-05 sec
2025.05.23 22:17:21.748004 [ 9 ] {} <Trace> ReferentialDeps: No tables
2025.05.23 22:17:21.748009 [ 9 ] {} <Trace> LoadingDeps: No tables
2025.05.23 22:17:21.748057 [ 9 ] {} <Information> loadMetadata: Start synchronous loading of databases
2025.05.23 22:17:21.748063 [ 9 ] {} <Information> loadMetadata: Start synchronous startup of databases
2025.05.23 22:17:21.748071 [ 9 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Atomic database default': BgStartup -> FgLoad
2025.05.23 22:17:21.748077 [ 9 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Ordinary database default': BgStartup -> FgLoad
2025.05.23 22:17:21.748086 [ 9 ] {} <Debug> AsyncLoader: Schedule load job 'startup Ordinary database default' into FgLoad
2025.05.23 22:17:21.748092 [ 9 ] {} <Debug> AsyncLoader: Schedule load job 'startup Atomic database default' into FgLoad
2025.05.23 22:17:21.748099 [ 9 ] {} <Debug> AsyncLoader: Change current priority: none -> 0
2025.05.23 22:17:21.748104 [ 9 ] {} <Debug> AsyncLoader: Spawn loader worker #1 in FgLoad
2025.05.23 22:17:21.748215 [ 9 ] {} <Debug> AsyncLoader: Wait load job 'startup Atomic database default' in FgLoad
2025.05.23 22:17:21.748432 [ 660 ] {} <Debug> AsyncLoader: Execute load job 'startup Ordinary database default' in FgLoad
2025.05.23 22:17:21.748553 [ 660 ] {} <Debug> AsyncLoader: Finish load job 'startup Ordinary database default' with status OK
2025.05.23 22:17:21.748565 [ 660 ] {} <Debug> AsyncLoader: Spawn loader worker #2 in FgLoad
2025.05.23 22:17:21.748727 [ 660 ] {} <Debug> AsyncLoader: Execute load job 'startup Atomic database default' in FgLoad
2025.05.23 22:17:21.748751 [ 660 ] {} <Debug> AsyncLoader: Finish load job 'startup Atomic database default' with status OK
2025.05.23 22:17:21.748759 [ 660 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2025.05.23 22:17:21.748907 [ 661 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2025.05.23 22:17:21.749000 [ 661 ] {} <Debug> AsyncLoader: Change current priority: 0 -> none
2025.05.23 22:17:21.748951 [ 9 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/lib/clickhouse/user_defined/
2025.05.23 22:17:21.749062 [ 9 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded
2025.05.23 22:17:21.749093 [ 9 ] {} <Debug> Application: Loaded metadata.
2025.05.23 22:17:21.749128 [ 9 ] {} <Trace> Pipe: Pipe capacity is 1.00 MiB
2025.05.23 22:17:21.749163 [ 9 ] {} <Information> Application: Tasks stats provider: procfs
2025.05.23 22:17:21.749171 [ 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.
2025.05.23 22:17:21.749671 [ 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.10388.altinitystable (altinity build))
2025.05.23 22:17:21.749770 [ 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.10388.altinitystable (altinity build))
2025.05.23 22:17:21.749777 [ 9 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair.
2025.05.23 22:17:21.871901 [ 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.10388.altinitystable (altinity build))
2025.05.23 22:17:21.871960 [ 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.10388.altinitystable (altinity build))
2025.05.23 22:17:21.871963 [ 9 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair.
2025.05.23 22:17:21.962869 [ 9 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again.
2025.05.23 22:17:21.964015 [ 9 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 49.38 MiB, peak 49.38 MiB, free memory in arenas 38.15 MiB, will set to 448.09 MiB (RSS), difference: 398.71 MiB
2025.05.23 22:17:21.965811 [ 9 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 1.5509e-05 sec.
2025.05.23 22:17:21.966859 [ 9 ] {} <Information> Application: Listening for http://[::1]:8123
2025.05.23 22:17:21.966911 [ 9 ] {} <Information> Application: Listening for native protocol (tcp): [::1]:9000
2025.05.23 22:17:21.966944 [ 9 ] {} <Information> Application: Listening for MySQL compatibility protocol: [::1]:9004
2025.05.23 22:17:21.966983 [ 9 ] {} <Information> Application: Listening for PostgreSQL compatibility protocol: [::1]:9005
2025.05.23 22:17:21.967018 [ 9 ] {} <Information> Application: Listening for http://127.0.0.1:8123
2025.05.23 22:17:21.967061 [ 9 ] {} <Information> Application: Listening for native protocol (tcp): 127.0.0.1:9000
2025.05.23 22:17:21.967094 [ 9 ] {} <Information> Application: Listening for MySQL compatibility protocol: 127.0.0.1:9004
2025.05.23 22:17:21.967124 [ 9 ] {} <Information> Application: Listening for PostgreSQL compatibility protocol: 127.0.0.1:9005
2025.05.23 22:17:21.967129 [ 9 ] {} <Information> Application: Ready for connections.
2025.05.23 22:17:26.241631 [ 11 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: 127.0.0.1:43512
2025.05.23 22:17:26.242256 [ 11 ] {} <Debug> TCPHandler: Connected ClickHouse client version 24.3.0, revision: 54467, user: default.
2025.05.23 22:17:26.242300 [ 11 ] {} <Debug> TCP-Session: 2ee7c54f-6d1d-4fc3-93bb-a591dec2a897 Authenticating user 'default' from 127.0.0.1:43512
2025.05.23 22:17:26.242535 [ 11 ] {} <Debug> TCP-Session: 2ee7c54f-6d1d-4fc3-93bb-a591dec2a897 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
2025.05.23 22:17:26.242547 [ 11 ] {} <Debug> TCP-Session: 2ee7c54f-6d1d-4fc3-93bb-a591dec2a897 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
2025.05.23 22:17:26.242709 [ 11 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false
2025.05.23 22:17:26.242778 [ 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
2025.05.23 22:17:26.242822 [ 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
2025.05.23 22:17:26.264715 [ 11 ] {} <Trace> TCP-Session: 2ee7c54f-6d1d-4fc3-93bb-a591dec2a897 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
2025.05.23 22:17:26.265218 [ 11 ] {63d171c8-3a94-43f9-ab6f-12d1b4a2b9b4} <Debug> executeQuery: (from 127.0.0.1:43512) select 'OK' (stage: Complete)
2025.05.23 22:17:26.265526 [ 11 ] {63d171c8-3a94-43f9-ab6f-12d1b4a2b9b4} <Trace> Planner: Query SELECT 'OK' AS `'OK'` FROM system.one AS __table1 to stage Complete
2025.05.23 22:17:26.265575 [ 11 ] {63d171c8-3a94-43f9-ab6f-12d1b4a2b9b4} <Trace> ContextAccess (default): Access granted: SELECT(dummy) ON system.one
2025.05.23 22:17:26.265665 [ 11 ] {63d171c8-3a94-43f9-ab6f-12d1b4a2b9b4} <Trace> Planner: Query SELECT 'OK' AS `'OK'` FROM system.one AS __table1 from stage FetchColumns to stage Complete
2025.05.23 22:17:26.267031 [ 11 ] {63d171c8-3a94-43f9-ab6f-12d1b4a2b9b4} <Debug> executeQuery: Read 1 rows, 1.00 B in 0.001846 sec., 541.7118093174431 rows/sec., 541.71 B/sec.
2025.05.23 22:17:26.267110 [ 11 ] {63d171c8-3a94-43f9-ab6f-12d1b4a2b9b4} <Debug> TCPHandler: Processed in 0.002653035 sec.
2025.05.23 22:17:26.268854 [ 11 ] {} <Debug> TCPHandler: Done processing connection.
2025.05.23 22:17:26.268896 [ 11 ] {} <Debug> TCP-Session: 2ee7c54f-6d1d-4fc3-93bb-a591dec2a897 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db