2025.05.26 13:53:12.225575 [ 8 ] {} <Information> Application: Will watch for the process with pid 10
2025.05.26 13:53:12.225619 [ 10 ] {} <Information> Application: Forked a child process to watch
2025.05.26 13:53:12.225752 [ 10 ] {} <Information> SentryWriter: Sending crash reports is disabled
2025.05.26 13:53:12.225836 [ 10 ] {} <Trace> Pipe: Pipe capacity is 1.00 MiB
2025.05.26 13:53:12.311610 [ 10 ] {} <Information> Application: Starting ClickHouse 24.3.18.10388.altinitystable (revision: 54496, git hash: 0ce6c8f2a4d3031f31446142fde2337a95087b3b, build id: 3B84B7D8EF86A1D6CC2AF2855A1AA2F1EDB823A7), PID 10
2025.05.26 13:53:12.311757 [ 10 ] {} <Information> Application: starting up
2025.05.26 13:53:12.311770 [ 10 ] {} <Information> Application: OS name: Linux, version: 5.15.0-130-generic, architecture: x86_64
2025.05.26 13:53:12.316030 [ 10 ] {} <Information> Application: Available RAM: 30.60 GiB; logical cores: 16; used cores: 16.
2025.05.26 13:53:12.316054 [ 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.26 13:53:12.316171 [ 10 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/thermal
2025.05.26 13:53:12.316184 [ 10 ] {} <Trace> AsynchronousMetrics: Scanning /sys/block
2025.05.26 13:53:12.316258 [ 10 ] {} <Trace> AsynchronousMetrics: Scanning /sys/devices/system/edac
2025.05.26 13:53:12.316271 [ 10 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/hwmon
2025.05.26 13:53:12.320659 [ 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.26 13:53:12.454490 [ 10 ] {} <Information> Application: Integrity check of the executable successfully passed (checksum: 8FAB96359DCBEE06EDE3813EBB2A9026)
2025.05.26 13:53:12.454540 [ 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.26 13:53:12.456321 [ 10 ] {} <Debug> Application: rlimit on number of file descriptors is 1048576
2025.05.26 13:53:12.456334 [ 10 ] {} <Debug> Application: rlimit on number of threads is 18446744073709551615
2025.05.26 13:53:12.456341 [ 10 ] {} <Debug> Application: Initializing DateLUT.
2025.05.26 13:53:12.456345 [ 10 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'.
2025.05.26 13:53:12.456375 [ 10 ] {} <Debug> Context: Setting up /var/lib/clickhouse/tmp/ to store temporary data in it
2025.05.26 13:53:12.457035 [ 10 ] {} <Debug> Application: Configuration parameter 'interserver_http_host' doesn't exist or exists and empty. Will use 'github-hetzner-runner-standby-17482672878697352' as replica host.
2025.05.26 13:53:12.457051 [ 10 ] {} <Debug> Application: Initializing interserver credentials.
2025.05.26 13:53:12.457153 [ 10 ] {} <Trace> NamedCollectionsUtils: Loaded 0 collections from config
2025.05.26 13:53:12.457214 [ 10 ] {} <Trace> NamedCollectionsUtils: Loaded 0 collections from SQL
2025.05.26 13:53:12.457305 [ 10 ] {} <Information> CgroupsMemoryUsageObserver: Will read the current memory usage from '/sys/fs/cgroup/' (cgroups version: v2), wait time is 15 sec
2025.05.26 13:53:12.457627 [ 10 ] {} <Debug> ConfigReloader: Loading config '/config/config.xml'
2025.05.26 13:53:12.457633 [ 10 ] {} <Debug> ConfigProcessor: Processing configuration file '/config/config.xml'.
2025.05.26 13:53:12.461278 [ 10 ] {} <Debug> ConfigProcessor: Saved preprocessed configuration to '/var/lib/clickhouse/preprocessed_configs/config.xml'.
2025.05.26 13:53:12.461348 [ 10 ] {} <Debug> ConfigReloader: Loaded config '/config/config.xml', performing update on configuration
2025.05.26 13:53:12.465119 [ 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.26 13:53:12.465134 [ 10 ] {} <Information> CgroupsMemoryUsageObserver: Set new limits, soft limit: 24.79 GiB, hard limit: 26.16 GiB
2025.05.26 13:53:12.465139 [ 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.26 13:53:12.465142 [ 10 ] {} <Information> Application: Merges and mutations memory limit is set to 15.30 GiB
2025.05.26 13:53:12.465428 [ 10 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads
2025.05.26 13:53:12.466620 [ 10 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 512 threads
2025.05.26 13:53:12.526900 [ 10 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads
2025.05.26 13:53:12.527815 [ 10 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads
2025.05.26 13:53:12.529155 [ 10 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again.
2025.05.26 13:53:12.529186 [ 10 ] {} <Debug> ConfigReloader: Loaded config '/config/config.xml', performed update on configuration
2025.05.26 13:53:12.531057 [ 10 ] {} <Information> Application: Listening for replica communication (interserver): http://[::1]:9009
2025.05.26 13:53:12.531110 [ 10 ] {} <Information> Application: Listening for replica communication (interserver): http://127.0.0.1:9009
2025.05.26 13:53:12.533206 [ 10 ] {} <Debug> ConfigReloader: Loading config '/config/users.xml'
2025.05.26 13:53:12.533215 [ 10 ] {} <Debug> ConfigProcessor: Processing configuration file '/config/users.xml'.
2025.05.26 13:53:12.533727 [ 10 ] {} <Debug> ConfigProcessor: Saved preprocessed configuration to '/var/lib/clickhouse/preprocessed_configs/users.xml'.
2025.05.26 13:53:12.533742 [ 10 ] {} <Debug> ConfigReloader: Loaded config '/config/users.xml', performing update on configuration
2025.05.26 13:53:12.534511 [ 10 ] {} <Debug> ConfigReloader: Loaded config '/config/users.xml', performed update on configuration
2025.05.26 13:53:12.534657 [ 10 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: /config/users.xml
2025.05.26 13:53:12.534767 [ 10 ] {} <Warning> Access(local_directory): File /var/lib/clickhouse/access/users.list doesn't exist
2025.05.26 13:53:12.534778 [ 10 ] {} <Warning> Access(local_directory): Recovering lists in directory /var/lib/clickhouse/access/
2025.05.26 13:53:12.534951 [ 10 ] {} <Debug> Access(user directories): Added local_directory access storage 'local_directory', path: /var/lib/clickhouse/access/
2025.05.26 13:53:12.535022 [ 10 ] {} <Information> CgroupsMemoryUsageObserver: Started cgroup current memory usage observer thread
2025.05.26 13:53:12.535336 [ 581 ] {} <Information> CgroupsMemoryUsageObserver: Memory amount initially available to the process is 30.60 GiB
2025.05.26 13:53:12.535910 [ 10 ] {} <Information> Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32, scheduling_policy=round_robin
2025.05.26 13:53:12.536343 [ 10 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8
2025.05.26 13:53:12.537528 [ 10 ] {} <Information> Context: Initialized background executor for fetches with num_threads=16, num_tasks=16
2025.05.26 13:53:12.537928 [ 10 ] {} <Information> Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8
2025.05.26 13:53:12.538817 [ 10 ] {} <Information> DNSCacheUpdater: Update period 15 seconds
2025.05.26 13:53:12.538881 [ 58 ] {} <Debug> DNSResolver: Updating DNS cache
2025.05.26 13:53:12.538987 [ 10 ] {} <Information> Application: Loading metadata from /var/lib/clickhouse/
2025.05.26 13:53:12.541217 [ 58 ] {} <Debug> DNSResolver: Updated DNS cache
2025.05.26 13:53:12.543814 [ 10 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total.
2025.05.26 13:53:12.543826 [ 10 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 6.4671e-05 sec
2025.05.26 13:53:12.543831 [ 10 ] {} <Trace> ReferentialDeps: No tables
2025.05.26 13:53:12.543835 [ 10 ] {} <Trace> LoadingDeps: No tables
2025.05.26 13:53:12.543867 [ 10 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Atomic database system': BgStartup -> FgLoad
2025.05.26 13:53:12.543873 [ 10 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Ordinary database system': BgStartup -> FgLoad
2025.05.26 13:53:12.543879 [ 10 ] {} <Debug> AsyncLoader: Schedule load job 'startup Ordinary database system' into FgLoad
2025.05.26 13:53:12.543884 [ 10 ] {} <Debug> AsyncLoader: Schedule load job 'startup Atomic database system' into FgLoad
2025.05.26 13:53:12.543888 [ 10 ] {} <Debug> AsyncLoader: Change current priority: none -> 0
2025.05.26 13:53:12.543893 [ 10 ] {} <Debug> AsyncLoader: Spawn loader worker #1 in FgLoad
2025.05.26 13:53:12.543949 [ 10 ] {} <Debug> AsyncLoader: Wait load job 'startup Atomic database system' in FgLoad
2025.05.26 13:53:12.544215 [ 646 ] {} <Debug> AsyncLoader: Execute load job 'startup Ordinary database system' in FgLoad
2025.05.26 13:53:12.544238 [ 646 ] {} <Debug> AsyncLoader: Finish load job 'startup Ordinary database system' with status OK
2025.05.26 13:53:12.544242 [ 646 ] {} <Debug> AsyncLoader: Spawn loader worker #2 in FgLoad
2025.05.26 13:53:12.544293 [ 646 ] {} <Debug> AsyncLoader: Execute load job 'startup Atomic database system' in FgLoad
2025.05.26 13:53:12.544310 [ 646 ] {} <Debug> AsyncLoader: Finish load job 'startup Atomic database system' with status OK
2025.05.26 13:53:12.544313 [ 646 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2025.05.26 13:53:12.544343 [ 10 ] {} <Debug> SystemLog: Creating system.query_log from query_log
2025.05.26 13:53:12.544375 [ 647 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2025.05.26 13:53:12.544403 [ 647 ] {} <Debug> AsyncLoader: Change current priority: 0 -> none
2025.05.26 13:53:12.545409 [ 10 ] {} <Debug> SystemLog: Creating system.query_thread_log from query_thread_log
2025.05.26 13:53:12.545842 [ 10 ] {} <Debug> SystemLog: Creating system.part_log from part_log
2025.05.26 13:53:12.546229 [ 10 ] {} <Debug> SystemLog: Creating system.trace_log from trace_log
2025.05.26 13:53:12.546508 [ 10 ] {} <Debug> SystemLog: Creating system.crash_log from crash_log
2025.05.26 13:53:12.546675 [ 10 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config
2025.05.26 13:53:12.546688 [ 10 ] {} <Debug> SystemLog: Creating system.metric_log from metric_log
2025.05.26 13:53:12.550998 [ 10 ] {} <Debug> SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config
2025.05.26 13:53:12.551016 [ 10 ] {} <Debug> SystemLog: Not creating system.filesystem_read_prefetches_log since corresponding section 'filesystem_read_prefetches_log' is missing from config
2025.05.26 13:53:12.551026 [ 10 ] {} <Debug> SystemLog: Creating system.asynchronous_metric_log from asynchronous_metric_log
2025.05.26 13:53:12.551247 [ 10 ] {} <Debug> SystemLog: Creating system.opentelemetry_span_log from opentelemetry_span_log
2025.05.26 13:53:12.551540 [ 10 ] {} <Debug> SystemLog: Creating system.query_views_log from query_views_log
2025.05.26 13:53:12.551841 [ 10 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config
2025.05.26 13:53:12.551855 [ 10 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config
2025.05.26 13:53:12.551865 [ 10 ] {} <Debug> SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config
2025.05.26 13:53:12.551873 [ 10 ] {} <Debug> SystemLog: Creating system.processors_profile_log from processors_profile_log
2025.05.26 13:53:12.552109 [ 10 ] {} <Debug> SystemLog: Creating system.asynchronous_insert_log from asynchronous_insert_log
2025.05.26 13:53:12.552411 [ 10 ] {} <Debug> SystemLog: Creating system.backup_log from backup_log
2025.05.26 13:53:12.552660 [ 10 ] {} <Debug> SystemLog: Creating system.s3queue_log from s3queue_log
2025.05.26 13:53:12.552937 [ 10 ] {} <Debug> SystemLog: Creating system.blob_storage_log from blob_storage_log
2025.05.26 13:53:12.564634 [ 10 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal.
2025.05.26 13:53:12.565926 [ 10 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total.
2025.05.26 13:53:12.565935 [ 10 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 3.235e-05 sec
2025.05.26 13:53:12.565939 [ 10 ] {} <Trace> ReferentialDeps: No tables
2025.05.26 13:53:12.565942 [ 10 ] {} <Trace> LoadingDeps: No tables
2025.05.26 13:53:12.565972 [ 10 ] {} <Information> loadMetadata: Start synchronous loading of databases
2025.05.26 13:53:12.565975 [ 10 ] {} <Information> loadMetadata: Start synchronous startup of databases
2025.05.26 13:53:12.565978 [ 10 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Atomic database default': BgStartup -> FgLoad
2025.05.26 13:53:12.565981 [ 10 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Ordinary database default': BgStartup -> FgLoad
2025.05.26 13:53:12.565986 [ 10 ] {} <Debug> AsyncLoader: Schedule load job 'startup Ordinary database default' into FgLoad
2025.05.26 13:53:12.565988 [ 10 ] {} <Debug> AsyncLoader: Schedule load job 'startup Atomic database default' into FgLoad
2025.05.26 13:53:12.565991 [ 10 ] {} <Debug> AsyncLoader: Change current priority: none -> 0
2025.05.26 13:53:12.565994 [ 10 ] {} <Debug> AsyncLoader: Spawn loader worker #1 in FgLoad
2025.05.26 13:53:12.566043 [ 10 ] {} <Debug> AsyncLoader: Wait load job 'startup Atomic database default' in FgLoad
2025.05.26 13:53:12.566118 [ 661 ] {} <Debug> AsyncLoader: Execute load job 'startup Ordinary database default' in FgLoad
2025.05.26 13:53:12.566149 [ 661 ] {} <Debug> AsyncLoader: Finish load job 'startup Ordinary database default' with status OK
2025.05.26 13:53:12.566154 [ 661 ] {} <Debug> AsyncLoader: Spawn loader worker #2 in FgLoad
2025.05.26 13:53:12.566210 [ 661 ] {} <Debug> AsyncLoader: Execute load job 'startup Atomic database default' in FgLoad
2025.05.26 13:53:12.566222 [ 661 ] {} <Debug> AsyncLoader: Finish load job 'startup Atomic database default' with status OK
2025.05.26 13:53:12.566225 [ 661 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2025.05.26 13:53:12.566285 [ 662 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2025.05.26 13:53:12.566310 [ 662 ] {} <Debug> AsyncLoader: Change current priority: 0 -> none
2025.05.26 13:53:12.566334 [ 10 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/lib/clickhouse/user_defined/
2025.05.26 13:53:12.566363 [ 10 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded
2025.05.26 13:53:12.566367 [ 10 ] {} <Debug> Application: Loaded metadata.
2025.05.26 13:53:12.566388 [ 10 ] {} <Trace> Pipe: Pipe capacity is 1.00 MiB
2025.05.26 13:53:12.566414 [ 10 ] {} <Information> Application: Tasks stats provider: procfs
2025.05.26 13:53:12.566418 [ 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.26 13:53:12.566706 [ 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.26 13:53:12.566762 [ 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.26 13:53:12.566765 [ 10 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair.
2025.05.26 13:53:12.652778 [ 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.26 13:53:12.652843 [ 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.26 13:53:12.652847 [ 10 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair.
2025.05.26 13:53:12.754122 [ 10 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again.
2025.05.26 13:53:12.755026 [ 10 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 49.41 MiB, peak 49.41 MiB, free memory in arenas 43.19 MiB, will set to 447.54 MiB (RSS), difference: 398.13 MiB
2025.05.26 13:53:12.756457 [ 10 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 1.7623e-05 sec.
2025.05.26 13:53:12.757466 [ 10 ] {} <Information> Application: Listening for http://[::1]:8123
2025.05.26 13:53:12.757522 [ 10 ] {} <Information> Application: Listening for native protocol (tcp): [::1]:9000
2025.05.26 13:53:12.757562 [ 10 ] {} <Information> Application: Listening for MySQL compatibility protocol: [::1]:9004
2025.05.26 13:53:12.757897 [ 10 ] {} <Information> Application: Listening for PostgreSQL compatibility protocol: [::1]:9005
2025.05.26 13:53:12.757942 [ 10 ] {} <Information> Application: Listening for http://127.0.0.1:8123
2025.05.26 13:53:12.757979 [ 10 ] {} <Information> Application: Listening for native protocol (tcp): 127.0.0.1:9000
2025.05.26 13:53:12.758014 [ 10 ] {} <Information> Application: Listening for MySQL compatibility protocol: 127.0.0.1:9004
2025.05.26 13:53:12.758045 [ 10 ] {} <Information> Application: Listening for PostgreSQL compatibility protocol: 127.0.0.1:9005
2025.05.26 13:53:12.758051 [ 10 ] {} <Information> Application: Ready for connections.
2025.05.26 13:53:13.000726 [ 662 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 447.56 MiB, peak 447.56 MiB, free memory in arenas 43.24 MiB, will set to 450.04 MiB (RSS), difference: 2.48 MiB
2025.05.26 13:53:17.218116 [ 12 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:50952
2025.05.26 13:53:17.218243 [ 12 ] {} <Debug> TCPHandler: Connected ClickHouse client version 24.3.0, revision: 54467, user: default.
2025.05.26 13:53:17.218271 [ 12 ] {} <Debug> TCP-Session: fb8d81c4-a698-4d51-9208-86bd01eb2fc2 Authenticating user 'default' from [::1]:50952
2025.05.26 13:53:17.218312 [ 12 ] {} <Debug> TCP-Session: fb8d81c4-a698-4d51-9208-86bd01eb2fc2 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
2025.05.26 13:53:17.218321 [ 12 ] {} <Debug> TCP-Session: fb8d81c4-a698-4d51-9208-86bd01eb2fc2 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
2025.05.26 13:53:17.218420 [ 12 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false
2025.05.26 13:53:17.218448 [ 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.26 13:53:17.218473 [ 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.26 13:53:17.227349 [ 12 ] {} <Trace> TCP-Session: fb8d81c4-a698-4d51-9208-86bd01eb2fc2 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
2025.05.26 13:53:17.227678 [ 12 ] {58ab51f8-ee3d-4219-ab58-9b7df00bd582} <Debug> executeQuery: (from [::1]:50952) select 'OK' (stage: Complete)
2025.05.26 13:53:17.227896 [ 12 ] {58ab51f8-ee3d-4219-ab58-9b7df00bd582} <Trace> Planner: Query SELECT 'OK' AS `'OK'` FROM system.one AS __table1 to stage Complete
2025.05.26 13:53:17.227930 [ 12 ] {58ab51f8-ee3d-4219-ab58-9b7df00bd582} <Trace> ContextAccess (default): Access granted: SELECT(dummy) ON system.one
2025.05.26 13:53:17.227999 [ 12 ] {58ab51f8-ee3d-4219-ab58-9b7df00bd582} <Trace> Planner: Query SELECT 'OK' AS `'OK'` FROM system.one AS __table1 from stage FetchColumns to stage Complete
2025.05.26 13:53:17.228775 [ 12 ] {58ab51f8-ee3d-4219-ab58-9b7df00bd582} <Debug> executeQuery: Read 1 rows, 1.00 B in 0.001138 sec., 878.7346221441126 rows/sec., 878.73 B/sec.
2025.05.26 13:53:17.228817 [ 12 ] {58ab51f8-ee3d-4219-ab58-9b7df00bd582} <Debug> TCPHandler: Processed in 0.001571948 sec.
2025.05.26 13:53:17.229611 [ 12 ] {} <Debug> TCPHandler: Done processing connection.
2025.05.26 13:53:17.229665 [ 12 ] {} <Debug> TCP-Session: fb8d81c4-a698-4d51-9208-86bd01eb2fc2 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
2025.05.26 13:53:17.472606 [ 7 ] {} <Information> Application: Will watch for the process with pid 9
2025.05.26 13:53:17.472740 [ 9 ] {} <Information> Application: Forked a child process to watch
2025.05.26 13:53:17.472947 [ 9 ] {} <Information> SentryWriter: Sending crash reports is disabled
2025.05.26 13:53:17.473043 [ 9 ] {} <Trace> Pipe: Pipe capacity is 1.00 MiB
2025.05.26 13:53:17.558668 [ 9 ] {} <Information> Application: Starting ClickHouse 24.3.18.10388.altinitystable (revision: 54496, git hash: 0ce6c8f2a4d3031f31446142fde2337a95087b3b, build id: 3B84B7D8EF86A1D6CC2AF2855A1AA2F1EDB823A7), PID 9
2025.05.26 13:53:17.558813 [ 9 ] {} <Information> Application: starting up
2025.05.26 13:53:17.558830 [ 9 ] {} <Information> Application: OS name: Linux, version: 5.15.0-130-generic, architecture: x86_64
2025.05.26 13:53:17.562909 [ 9 ] {} <Information> Application: Available RAM: 30.60 GiB; logical cores: 16; used cores: 16.
2025.05.26 13:53:17.562930 [ 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.26 13:53:17.563045 [ 9 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/thermal
2025.05.26 13:53:17.563058 [ 9 ] {} <Trace> AsynchronousMetrics: Scanning /sys/block
2025.05.26 13:53:17.563124 [ 9 ] {} <Trace> AsynchronousMetrics: Scanning /sys/devices/system/edac
2025.05.26 13:53:17.563136 [ 9 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/hwmon
2025.05.26 13:53:17.567363 [ 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.26 13:53:17.702243 [ 9 ] {} <Information> Application: Integrity check of the executable successfully passed (checksum: 8FAB96359DCBEE06EDE3813EBB2A9026)
2025.05.26 13:53:17.702306 [ 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.26 13:53:17.703941 [ 9 ] {} <Debug> Application: rlimit on number of file descriptors is 1048576
2025.05.26 13:53:17.703953 [ 9 ] {} <Debug> Application: rlimit on number of threads is 18446744073709551615
2025.05.26 13:53:17.703960 [ 9 ] {} <Debug> Application: Initializing DateLUT.
2025.05.26 13:53:17.703964 [ 9 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'.
2025.05.26 13:53:17.703986 [ 9 ] {} <Debug> Context: Setting up /var/lib/clickhouse/tmp/ to store temporary data in it
2025.05.26 13:53:17.704420 [ 9 ] {} <Debug> Application: Configuration parameter 'interserver_http_host' doesn't exist or exists and empty. Will use 'github-hetzner-runner-standby-17482672878697352' as replica host.
2025.05.26 13:53:17.704435 [ 9 ] {} <Debug> Application: Initializing interserver credentials.
2025.05.26 13:53:17.704539 [ 9 ] {} <Trace> NamedCollectionsUtils: Loaded 0 collections from config
2025.05.26 13:53:17.704598 [ 9 ] {} <Trace> NamedCollectionsUtils: Loaded 0 collections from SQL
2025.05.26 13:53:17.704710 [ 9 ] {} <Information> CgroupsMemoryUsageObserver: Will read the current memory usage from '/sys/fs/cgroup/' (cgroups version: v2), wait time is 15 sec
2025.05.26 13:53:17.705015 [ 9 ] {} <Debug> ConfigReloader: Loading config '/config/config.xml'
2025.05.26 13:53:17.705020 [ 9 ] {} <Debug> ConfigProcessor: Processing configuration file '/config/config.xml'.
2025.05.26 13:53:17.708531 [ 9 ] {} <Debug> ConfigProcessor: Saved preprocessed configuration to '/var/lib/clickhouse/preprocessed_configs/config.xml'.
2025.05.26 13:53:17.708609 [ 9 ] {} <Debug> ConfigReloader: Loaded config '/config/config.xml', performing update on configuration
2025.05.26 13:53:17.712445 [ 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.26 13:53:17.712455 [ 9 ] {} <Information> CgroupsMemoryUsageObserver: Set new limits, soft limit: 24.79 GiB, hard limit: 26.16 GiB
2025.05.26 13:53:17.712460 [ 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.26 13:53:17.712463 [ 9 ] {} <Information> Application: Merges and mutations memory limit is set to 15.30 GiB
2025.05.26 13:53:17.712717 [ 9 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads
2025.05.26 13:53:17.714039 [ 9 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 512 threads
2025.05.26 13:53:17.763563 [ 9 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads
2025.05.26 13:53:17.764518 [ 9 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads
2025.05.26 13:53:17.765393 [ 9 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again.
2025.05.26 13:53:17.765431 [ 9 ] {} <Debug> ConfigReloader: Loaded config '/config/config.xml', performed update on configuration
2025.05.26 13:53:17.766615 [ 9 ] {} <Information> Application: Listening for replica communication (interserver): http://[::1]:9009
2025.05.26 13:53:17.767044 [ 9 ] {} <Information> Application: Listening for replica communication (interserver): http://127.0.0.1:9009
2025.05.26 13:53:17.767998 [ 9 ] {} <Debug> ConfigReloader: Loading config '/config/users.xml'
2025.05.26 13:53:17.768014 [ 9 ] {} <Debug> ConfigProcessor: Processing configuration file '/config/users.xml'.
2025.05.26 13:53:17.768857 [ 9 ] {} <Debug> ConfigProcessor: Saved preprocessed configuration to '/var/lib/clickhouse/preprocessed_configs/users.xml'.
2025.05.26 13:53:17.768889 [ 9 ] {} <Debug> ConfigReloader: Loaded config '/config/users.xml', performing update on configuration
2025.05.26 13:53:17.770049 [ 9 ] {} <Debug> ConfigReloader: Loaded config '/config/users.xml', performed update on configuration
2025.05.26 13:53:17.770364 [ 9 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: /config/users.xml
2025.05.26 13:53:17.770493 [ 9 ] {} <Warning> Access(local_directory): File /var/lib/clickhouse/access/users.list doesn't exist
2025.05.26 13:53:17.770506 [ 9 ] {} <Warning> Access(local_directory): Recovering lists in directory /var/lib/clickhouse/access/
2025.05.26 13:53:17.770772 [ 9 ] {} <Debug> Access(user directories): Added local_directory access storage 'local_directory', path: /var/lib/clickhouse/access/
2025.05.26 13:53:17.770858 [ 9 ] {} <Information> CgroupsMemoryUsageObserver: Started cgroup current memory usage observer thread
2025.05.26 13:53:17.771156 [ 580 ] {} <Information> CgroupsMemoryUsageObserver: Memory amount initially available to the process is 30.60 GiB
2025.05.26 13:53:17.771668 [ 9 ] {} <Information> Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32, scheduling_policy=round_robin
2025.05.26 13:53:17.772162 [ 9 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8
2025.05.26 13:53:17.772845 [ 9 ] {} <Information> Context: Initialized background executor for fetches with num_threads=16, num_tasks=16
2025.05.26 13:53:17.775538 [ 9 ] {} <Information> Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8
2025.05.26 13:53:17.776475 [ 9 ] {} <Information> DNSCacheUpdater: Update period 15 seconds
2025.05.26 13:53:17.776498 [ 9 ] {} <Information> Application: Loading metadata from /var/lib/clickhouse/
2025.05.26 13:53:17.777082 [ 33 ] {} <Debug> DNSResolver: Updating DNS cache
2025.05.26 13:53:17.777973 [ 33 ] {} <Debug> DNSResolver: Updated DNS cache
2025.05.26 13:53:17.780597 [ 9 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total.
2025.05.26 13:53:17.780611 [ 9 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 6.5523e-05 sec
2025.05.26 13:53:17.780617 [ 9 ] {} <Trace> ReferentialDeps: No tables
2025.05.26 13:53:17.780621 [ 9 ] {} <Trace> LoadingDeps: No tables
2025.05.26 13:53:17.780676 [ 9 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Atomic database system': BgStartup -> FgLoad
2025.05.26 13:53:17.780682 [ 9 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Ordinary database system': BgStartup -> FgLoad
2025.05.26 13:53:17.780689 [ 9 ] {} <Debug> AsyncLoader: Schedule load job 'startup Ordinary database system' into FgLoad
2025.05.26 13:53:17.780694 [ 9 ] {} <Debug> AsyncLoader: Schedule load job 'startup Atomic database system' into FgLoad
2025.05.26 13:53:17.780700 [ 9 ] {} <Debug> AsyncLoader: Change current priority: none -> 0
2025.05.26 13:53:17.780705 [ 9 ] {} <Debug> AsyncLoader: Spawn loader worker #1 in FgLoad
2025.05.26 13:53:17.780761 [ 9 ] {} <Debug> AsyncLoader: Wait load job 'startup Atomic database system' in FgLoad
2025.05.26 13:53:17.780858 [ 645 ] {} <Debug> AsyncLoader: Execute load job 'startup Ordinary database system' in FgLoad
2025.05.26 13:53:17.780890 [ 645 ] {} <Debug> AsyncLoader: Finish load job 'startup Ordinary database system' with status OK
2025.05.26 13:53:17.780897 [ 645 ] {} <Debug> AsyncLoader: Spawn loader worker #2 in FgLoad
2025.05.26 13:53:17.780967 [ 645 ] {} <Debug> AsyncLoader: Execute load job 'startup Atomic database system' in FgLoad
2025.05.26 13:53:17.780991 [ 645 ] {} <Debug> AsyncLoader: Finish load job 'startup Atomic database system' with status OK
2025.05.26 13:53:17.780997 [ 645 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2025.05.26 13:53:17.781023 [ 9 ] {} <Debug> SystemLog: Creating system.query_log from query_log
2025.05.26 13:53:17.781080 [ 646 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2025.05.26 13:53:17.781138 [ 646 ] {} <Debug> AsyncLoader: Change current priority: 0 -> none
2025.05.26 13:53:17.782122 [ 9 ] {} <Debug> SystemLog: Creating system.query_thread_log from query_thread_log
2025.05.26 13:53:17.782546 [ 9 ] {} <Debug> SystemLog: Creating system.part_log from part_log
2025.05.26 13:53:17.782911 [ 9 ] {} <Debug> SystemLog: Creating system.trace_log from trace_log
2025.05.26 13:53:17.783128 [ 9 ] {} <Debug> SystemLog: Creating system.crash_log from crash_log
2025.05.26 13:53:17.783286 [ 9 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config
2025.05.26 13:53:17.783299 [ 9 ] {} <Debug> SystemLog: Creating system.metric_log from metric_log
2025.05.26 13:53:17.787595 [ 9 ] {} <Debug> SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config
2025.05.26 13:53:17.787614 [ 9 ] {} <Debug> SystemLog: Not creating system.filesystem_read_prefetches_log since corresponding section 'filesystem_read_prefetches_log' is missing from config
2025.05.26 13:53:17.787625 [ 9 ] {} <Debug> SystemLog: Creating system.asynchronous_metric_log from asynchronous_metric_log
2025.05.26 13:53:17.787889 [ 9 ] {} <Debug> SystemLog: Creating system.opentelemetry_span_log from opentelemetry_span_log
2025.05.26 13:53:17.788148 [ 9 ] {} <Debug> SystemLog: Creating system.query_views_log from query_views_log
2025.05.26 13:53:17.788465 [ 9 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config
2025.05.26 13:53:17.788481 [ 9 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config
2025.05.26 13:53:17.788491 [ 9 ] {} <Debug> SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config
2025.05.26 13:53:17.788501 [ 9 ] {} <Debug> SystemLog: Creating system.processors_profile_log from processors_profile_log
2025.05.26 13:53:17.788727 [ 9 ] {} <Debug> SystemLog: Creating system.asynchronous_insert_log from asynchronous_insert_log
2025.05.26 13:53:17.788993 [ 9 ] {} <Debug> SystemLog: Creating system.backup_log from backup_log
2025.05.26 13:53:17.789222 [ 9 ] {} <Debug> SystemLog: Creating system.s3queue_log from s3queue_log
2025.05.26 13:53:17.789435 [ 9 ] {} <Debug> SystemLog: Creating system.blob_storage_log from blob_storage_log
2025.05.26 13:53:17.806840 [ 9 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal.
2025.05.26 13:53:17.808525 [ 9 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total.
2025.05.26 13:53:17.808539 [ 9 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 4.4684e-05 sec
2025.05.26 13:53:17.808546 [ 9 ] {} <Trace> ReferentialDeps: No tables
2025.05.26 13:53:17.808551 [ 9 ] {} <Trace> LoadingDeps: No tables
2025.05.26 13:53:17.808600 [ 9 ] {} <Information> loadMetadata: Start synchronous loading of databases
2025.05.26 13:53:17.808606 [ 9 ] {} <Information> loadMetadata: Start synchronous startup of databases
2025.05.26 13:53:17.808613 [ 9 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Atomic database default': BgStartup -> FgLoad
2025.05.26 13:53:17.808617 [ 9 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Ordinary database default': BgStartup -> FgLoad
2025.05.26 13:53:17.808626 [ 9 ] {} <Debug> AsyncLoader: Schedule load job 'startup Ordinary database default' into FgLoad
2025.05.26 13:53:17.808631 [ 9 ] {} <Debug> AsyncLoader: Schedule load job 'startup Atomic database default' into FgLoad
2025.05.26 13:53:17.808637 [ 9 ] {} <Debug> AsyncLoader: Change current priority: none -> 0
2025.05.26 13:53:17.808642 [ 9 ] {} <Debug> AsyncLoader: Spawn loader worker #1 in FgLoad
2025.05.26 13:53:17.808728 [ 9 ] {} <Debug> AsyncLoader: Wait load job 'startup Atomic database default' in FgLoad
2025.05.26 13:53:17.808820 [ 660 ] {} <Debug> AsyncLoader: Execute load job 'startup Ordinary database default' in FgLoad
2025.05.26 13:53:17.808859 [ 660 ] {} <Debug> AsyncLoader: Finish load job 'startup Ordinary database default' with status OK
2025.05.26 13:53:17.808866 [ 660 ] {} <Debug> AsyncLoader: Spawn loader worker #2 in FgLoad
2025.05.26 13:53:17.808930 [ 660 ] {} <Debug> AsyncLoader: Execute load job 'startup Atomic database default' in FgLoad
2025.05.26 13:53:17.808945 [ 660 ] {} <Debug> AsyncLoader: Finish load job 'startup Atomic database default' with status OK
2025.05.26 13:53:17.808950 [ 660 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2025.05.26 13:53:17.809015 [ 661 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2025.05.26 13:53:17.809045 [ 661 ] {} <Debug> AsyncLoader: Change current priority: 0 -> none
2025.05.26 13:53:17.809092 [ 9 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/lib/clickhouse/user_defined/
2025.05.26 13:53:17.809128 [ 9 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded
2025.05.26 13:53:17.809134 [ 9 ] {} <Debug> Application: Loaded metadata.
2025.05.26 13:53:17.809160 [ 9 ] {} <Trace> Pipe: Pipe capacity is 1.00 MiB
2025.05.26 13:53:17.809196 [ 9 ] {} <Information> Application: Tasks stats provider: procfs
2025.05.26 13:53:17.809202 [ 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.26 13:53:17.809598 [ 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.26 13:53:17.809692 [ 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.26 13:53:17.809699 [ 9 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair.
2025.05.26 13:53:17.902206 [ 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.26 13:53:17.902273 [ 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.26 13:53:17.902278 [ 9 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair.
2025.05.26 13:53:17.960950 [ 9 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again.
2025.05.26 13:53:17.961976 [ 9 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 49.41 MiB, peak 49.41 MiB, free memory in arenas 6.81 MiB, will set to 445.54 MiB (RSS), difference: 396.13 MiB
2025.05.26 13:53:17.963435 [ 9 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 1.5478e-05 sec.
2025.05.26 13:53:17.964144 [ 9 ] {} <Information> Application: Listening for http://[::1]:8123
2025.05.26 13:53:17.964185 [ 9 ] {} <Information> Application: Listening for native protocol (tcp): [::1]:9000
2025.05.26 13:53:17.964221 [ 9 ] {} <Information> Application: Listening for MySQL compatibility protocol: [::1]:9004
2025.05.26 13:53:17.964253 [ 9 ] {} <Information> Application: Listening for PostgreSQL compatibility protocol: [::1]:9005
2025.05.26 13:53:17.964285 [ 9 ] {} <Information> Application: Listening for http://127.0.0.1:8123
2025.05.26 13:53:17.964325 [ 9 ] {} <Information> Application: Listening for native protocol (tcp): 127.0.0.1:9000
2025.05.26 13:53:17.964360 [ 9 ] {} <Information> Application: Listening for MySQL compatibility protocol: 127.0.0.1:9004
2025.05.26 13:53:17.964392 [ 9 ] {} <Information> Application: Listening for PostgreSQL compatibility protocol: 127.0.0.1:9005
2025.05.26 13:53:17.964397 [ 9 ] {} <Information> Application: Ready for connections.
2025.05.26 13:53:22.466836 [ 11 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: 127.0.0.1:54984
2025.05.26 13:53:22.466955 [ 11 ] {} <Debug> TCPHandler: Connected ClickHouse client version 24.3.0, revision: 54467, user: default.
2025.05.26 13:53:22.466976 [ 11 ] {} <Debug> TCP-Session: 2d94ad69-68f4-4955-ba36-89637fa5af36 Authenticating user 'default' from 127.0.0.1:54984
2025.05.26 13:53:22.467007 [ 11 ] {} <Debug> TCP-Session: 2d94ad69-68f4-4955-ba36-89637fa5af36 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
2025.05.26 13:53:22.467013 [ 11 ] {} <Debug> TCP-Session: 2d94ad69-68f4-4955-ba36-89637fa5af36 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
2025.05.26 13:53:22.467110 [ 11 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false
2025.05.26 13:53:22.467134 [ 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.26 13:53:22.467147 [ 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.26 13:53:22.481027 [ 11 ] {} <Trace> TCP-Session: 2d94ad69-68f4-4955-ba36-89637fa5af36 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
2025.05.26 13:53:22.481365 [ 11 ] {e8754906-bdf7-437d-91b4-732e67d18fbd} <Debug> executeQuery: (from 127.0.0.1:54984) select 'OK' (stage: Complete)
2025.05.26 13:53:22.481559 [ 11 ] {e8754906-bdf7-437d-91b4-732e67d18fbd} <Trace> Planner: Query SELECT 'OK' AS `'OK'` FROM system.one AS __table1 to stage Complete
2025.05.26 13:53:22.481590 [ 11 ] {e8754906-bdf7-437d-91b4-732e67d18fbd} <Trace> ContextAccess (default): Access granted: SELECT(dummy) ON system.one
2025.05.26 13:53:22.481649 [ 11 ] {e8754906-bdf7-437d-91b4-732e67d18fbd} <Trace> Planner: Query SELECT 'OK' AS `'OK'` FROM system.one AS __table1 from stage FetchColumns to stage Complete
2025.05.26 13:53:22.482537 [ 11 ] {e8754906-bdf7-437d-91b4-732e67d18fbd} <Debug> executeQuery: Read 1 rows, 1.00 B in 0.001198 sec., 834.7245409015025 rows/sec., 834.72 B/sec.
2025.05.26 13:53:22.482572 [ 11 ] {e8754906-bdf7-437d-91b4-732e67d18fbd} <Debug> TCPHandler: Processed in 0.001710799 sec.
2025.05.26 13:53:22.483321 [ 11 ] {} <Debug> TCPHandler: Done processing connection.
2025.05.26 13:53:22.483344 [ 11 ] {} <Debug> TCP-Session: 2d94ad69-68f4-4955-ba36-89637fa5af36 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db