2025.06.04 00:19:17.362897 [ 8 ] {} <Information> Application: Will watch for the process with pid 10
2025.06.04 00:19:17.363058 [ 10 ] {} <Information> Application: Forked a child process to watch
2025.06.04 00:19:17.363341 [ 10 ] {} <Information> SentryWriter: Sending crash reports is disabled
2025.06.04 00:19:17.363481 [ 10 ] {} <Trace> Pipe: Pipe capacity is 1.00 MiB
2025.06.04 00:19:17.457158 [ 10 ] {} <Information> Application: Starting ClickHouse 24.3.18.10388.altinitystable (revision: 54496, git hash: 0ce6c8f2a4d3031f31446142fde2337a95087b3b, build id: 3B84B7D8EF86A1D6CC2AF2855A1AA2F1EDB823A7), PID 10
2025.06.04 00:19:17.457298 [ 10 ] {} <Information> Application: starting up
2025.06.04 00:19:17.457309 [ 10 ] {} <Information> Application: OS name: Linux, version: 5.15.0-130-generic, architecture: x86_64
2025.06.04 00:19:17.460996 [ 10 ] {} <Information> Application: Available RAM: 30.60 GiB; logical cores: 16; used cores: 16.
2025.06.04 00:19:17.461019 [ 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.06.04 00:19:17.461125 [ 10 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/thermal
2025.06.04 00:19:17.461136 [ 10 ] {} <Trace> AsynchronousMetrics: Scanning /sys/block
2025.06.04 00:19:17.461199 [ 10 ] {} <Trace> AsynchronousMetrics: Scanning /sys/devices/system/edac
2025.06.04 00:19:17.461209 [ 10 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/hwmon
2025.06.04 00:19:17.464668 [ 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.06.04 00:19:17.589616 [ 10 ] {} <Information> Application: Integrity check of the executable successfully passed (checksum: 8FAB96359DCBEE06EDE3813EBB2A9026)
2025.06.04 00:19:17.589680 [ 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.06.04 00:19:17.591321 [ 10 ] {} <Debug> Application: rlimit on number of file descriptors is 1048576
2025.06.04 00:19:17.591332 [ 10 ] {} <Debug> Application: rlimit on number of threads is 18446744073709551615
2025.06.04 00:19:17.591338 [ 10 ] {} <Debug> Application: Initializing DateLUT.
2025.06.04 00:19:17.591341 [ 10 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'.
2025.06.04 00:19:17.591361 [ 10 ] {} <Debug> Context: Setting up /var/lib/clickhouse/tmp/ to store temporary data in it
2025.06.04 00:19:17.591770 [ 10 ] {} <Debug> Application: Configuration parameter 'interserver_http_host' doesn't exist or exists and empty. Will use 'github-hetzner-runner-15429959745-43426251947' as replica host.
2025.06.04 00:19:17.591782 [ 10 ] {} <Debug> Application: Initializing interserver credentials.
2025.06.04 00:19:17.591875 [ 10 ] {} <Trace> NamedCollectionsUtils: Loaded 0 collections from config
2025.06.04 00:19:17.591924 [ 10 ] {} <Trace> NamedCollectionsUtils: Loaded 0 collections from SQL
2025.06.04 00:19:17.591996 [ 10 ] {} <Information> CgroupsMemoryUsageObserver: Will read the current memory usage from '/sys/fs/cgroup/' (cgroups version: v2), wait time is 15 sec
2025.06.04 00:19:17.592195 [ 10 ] {} <Debug> ConfigReloader: Loading config '/config/config.xml'
2025.06.04 00:19:17.592199 [ 10 ] {} <Debug> ConfigProcessor: Processing configuration file '/config/config.xml'.
2025.06.04 00:19:17.595124 [ 10 ] {} <Debug> ConfigProcessor: Saved preprocessed configuration to '/var/lib/clickhouse/preprocessed_configs/config.xml'.
2025.06.04 00:19:17.595192 [ 10 ] {} <Debug> ConfigReloader: Loaded config '/config/config.xml', performing update on configuration
2025.06.04 00:19:17.598078 [ 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.06.04 00:19:17.598090 [ 10 ] {} <Information> CgroupsMemoryUsageObserver: Set new limits, soft limit: 24.79 GiB, hard limit: 26.16 GiB
2025.06.04 00:19:17.598094 [ 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.06.04 00:19:17.598097 [ 10 ] {} <Information> Application: Merges and mutations memory limit is set to 15.30 GiB
2025.06.04 00:19:17.598341 [ 10 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads
2025.06.04 00:19:17.599650 [ 10 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 512 threads
2025.06.04 00:19:17.683560 [ 10 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads
2025.06.04 00:19:17.684794 [ 10 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads
2025.06.04 00:19:17.685803 [ 10 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again.
2025.06.04 00:19:17.685830 [ 10 ] {} <Debug> ConfigReloader: Loaded config '/config/config.xml', performed update on configuration
2025.06.04 00:19:17.688713 [ 10 ] {} <Information> Application: Listening for replica communication (interserver): http://[::1]:9009
2025.06.04 00:19:17.688821 [ 10 ] {} <Information> Application: Listening for replica communication (interserver): http://127.0.0.1:9009
2025.06.04 00:19:17.690250 [ 10 ] {} <Debug> ConfigReloader: Loading config '/config/users.xml'
2025.06.04 00:19:17.690259 [ 10 ] {} <Debug> ConfigProcessor: Processing configuration file '/config/users.xml'.
2025.06.04 00:19:17.690618 [ 10 ] {} <Debug> ConfigProcessor: Saved preprocessed configuration to '/var/lib/clickhouse/preprocessed_configs/users.xml'.
2025.06.04 00:19:17.690638 [ 10 ] {} <Debug> ConfigReloader: Loaded config '/config/users.xml', performing update on configuration
2025.06.04 00:19:17.691176 [ 10 ] {} <Debug> ConfigReloader: Loaded config '/config/users.xml', performed update on configuration
2025.06.04 00:19:17.691278 [ 10 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: /config/users.xml
2025.06.04 00:19:17.691368 [ 10 ] {} <Warning> Access(local_directory): File /var/lib/clickhouse/access/users.list doesn't exist
2025.06.04 00:19:17.691377 [ 10 ] {} <Warning> Access(local_directory): Recovering lists in directory /var/lib/clickhouse/access/
2025.06.04 00:19:17.691602 [ 10 ] {} <Debug> Access(user directories): Added local_directory access storage 'local_directory', path: /var/lib/clickhouse/access/
2025.06.04 00:19:17.691664 [ 10 ] {} <Information> CgroupsMemoryUsageObserver: Started cgroup current memory usage observer thread
2025.06.04 00:19:17.691933 [ 581 ] {} <Information> CgroupsMemoryUsageObserver: Memory amount initially available to the process is 30.60 GiB
2025.06.04 00:19:17.693443 [ 10 ] {} <Information> Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32, scheduling_policy=round_robin
2025.06.04 00:19:17.694041 [ 10 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8
2025.06.04 00:19:17.694865 [ 10 ] {} <Information> Context: Initialized background executor for fetches with num_threads=16, num_tasks=16
2025.06.04 00:19:17.697493 [ 10 ] {} <Information> Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8
2025.06.04 00:19:17.699967 [ 10 ] {} <Information> DNSCacheUpdater: Update period 15 seconds
2025.06.04 00:19:17.699995 [ 10 ] {} <Information> Application: Loading metadata from /var/lib/clickhouse/
2025.06.04 00:19:17.700167 [ 41 ] {} <Debug> DNSResolver: Updating DNS cache
2025.06.04 00:19:17.700482 [ 41 ] {} <Debug> DNSResolver: Updated DNS cache
2025.06.04 00:19:17.704482 [ 10 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total.
2025.06.04 00:19:17.704499 [ 10 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 9.605e-05 sec
2025.06.04 00:19:17.704504 [ 10 ] {} <Trace> ReferentialDeps: No tables
2025.06.04 00:19:17.704507 [ 10 ] {} <Trace> LoadingDeps: No tables
2025.06.04 00:19:17.704559 [ 10 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Atomic database system': BgStartup -> FgLoad
2025.06.04 00:19:17.704565 [ 10 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Ordinary database system': BgStartup -> FgLoad
2025.06.04 00:19:17.704571 [ 10 ] {} <Debug> AsyncLoader: Schedule load job 'startup Ordinary database system' into FgLoad
2025.06.04 00:19:17.704577 [ 10 ] {} <Debug> AsyncLoader: Schedule load job 'startup Atomic database system' into FgLoad
2025.06.04 00:19:17.704583 [ 10 ] {} <Debug> AsyncLoader: Change current priority: none -> 0
2025.06.04 00:19:17.704588 [ 10 ] {} <Debug> AsyncLoader: Spawn loader worker #1 in FgLoad
2025.06.04 00:19:17.704687 [ 10 ] {} <Debug> AsyncLoader: Wait load job 'startup Atomic database system' in FgLoad
2025.06.04 00:19:17.704802 [ 646 ] {} <Debug> AsyncLoader: Execute load job 'startup Ordinary database system' in FgLoad
2025.06.04 00:19:17.704851 [ 646 ] {} <Debug> AsyncLoader: Finish load job 'startup Ordinary database system' with status OK
2025.06.04 00:19:17.704860 [ 646 ] {} <Debug> AsyncLoader: Spawn loader worker #2 in FgLoad
2025.06.04 00:19:17.704968 [ 646 ] {} <Debug> AsyncLoader: Execute load job 'startup Atomic database system' in FgLoad
2025.06.04 00:19:17.704998 [ 646 ] {} <Debug> AsyncLoader: Finish load job 'startup Atomic database system' with status OK
2025.06.04 00:19:17.705004 [ 646 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2025.06.04 00:19:17.705038 [ 10 ] {} <Debug> SystemLog: Creating system.query_log from query_log
2025.06.04 00:19:17.705065 [ 647 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2025.06.04 00:19:17.705098 [ 647 ] {} <Debug> AsyncLoader: Change current priority: 0 -> none
2025.06.04 00:19:17.706046 [ 10 ] {} <Debug> SystemLog: Creating system.query_thread_log from query_thread_log
2025.06.04 00:19:17.706463 [ 10 ] {} <Debug> SystemLog: Creating system.part_log from part_log
2025.06.04 00:19:17.706856 [ 10 ] {} <Debug> SystemLog: Creating system.trace_log from trace_log
2025.06.04 00:19:17.707038 [ 10 ] {} <Debug> SystemLog: Creating system.crash_log from crash_log
2025.06.04 00:19:17.707147 [ 10 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config
2025.06.04 00:19:17.707155 [ 10 ] {} <Debug> SystemLog: Creating system.metric_log from metric_log
2025.06.04 00:19:17.711500 [ 10 ] {} <Debug> SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config
2025.06.04 00:19:17.711524 [ 10 ] {} <Debug> SystemLog: Not creating system.filesystem_read_prefetches_log since corresponding section 'filesystem_read_prefetches_log' is missing from config
2025.06.04 00:19:17.711534 [ 10 ] {} <Debug> SystemLog: Creating system.asynchronous_metric_log from asynchronous_metric_log
2025.06.04 00:19:17.711755 [ 10 ] {} <Debug> SystemLog: Creating system.opentelemetry_span_log from opentelemetry_span_log
2025.06.04 00:19:17.711976 [ 10 ] {} <Debug> SystemLog: Creating system.query_views_log from query_views_log
2025.06.04 00:19:17.712245 [ 10 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config
2025.06.04 00:19:17.712257 [ 10 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config
2025.06.04 00:19:17.712264 [ 10 ] {} <Debug> SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config
2025.06.04 00:19:17.712270 [ 10 ] {} <Debug> SystemLog: Creating system.processors_profile_log from processors_profile_log
2025.06.04 00:19:17.712477 [ 10 ] {} <Debug> SystemLog: Creating system.asynchronous_insert_log from asynchronous_insert_log
2025.06.04 00:19:17.712766 [ 10 ] {} <Debug> SystemLog: Creating system.backup_log from backup_log
2025.06.04 00:19:17.712985 [ 10 ] {} <Debug> SystemLog: Creating system.s3queue_log from s3queue_log
2025.06.04 00:19:17.713202 [ 10 ] {} <Debug> SystemLog: Creating system.blob_storage_log from blob_storage_log
2025.06.04 00:19:17.723357 [ 10 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal.
2025.06.04 00:19:17.725186 [ 10 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total.
2025.06.04 00:19:17.725202 [ 10 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 5.638e-05 sec
2025.06.04 00:19:17.725207 [ 10 ] {} <Trace> ReferentialDeps: No tables
2025.06.04 00:19:17.725210 [ 10 ] {} <Trace> LoadingDeps: No tables
2025.06.04 00:19:17.725257 [ 10 ] {} <Information> loadMetadata: Start synchronous loading of databases
2025.06.04 00:19:17.725262 [ 10 ] {} <Information> loadMetadata: Start synchronous startup of databases
2025.06.04 00:19:17.725266 [ 10 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Atomic database default': BgStartup -> FgLoad
2025.06.04 00:19:17.725269 [ 10 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Ordinary database default': BgStartup -> FgLoad
2025.06.04 00:19:17.725276 [ 10 ] {} <Debug> AsyncLoader: Schedule load job 'startup Ordinary database default' into FgLoad
2025.06.04 00:19:17.725279 [ 10 ] {} <Debug> AsyncLoader: Schedule load job 'startup Atomic database default' into FgLoad
2025.06.04 00:19:17.725284 [ 10 ] {} <Debug> AsyncLoader: Change current priority: none -> 0
2025.06.04 00:19:17.725288 [ 10 ] {} <Debug> AsyncLoader: Spawn loader worker #1 in FgLoad
2025.06.04 00:19:17.725392 [ 10 ] {} <Debug> AsyncLoader: Wait load job 'startup Atomic database default' in FgLoad
2025.06.04 00:19:17.725538 [ 661 ] {} <Debug> AsyncLoader: Execute load job 'startup Ordinary database default' in FgLoad
2025.06.04 00:19:17.725604 [ 661 ] {} <Debug> AsyncLoader: Finish load job 'startup Ordinary database default' with status OK
2025.06.04 00:19:17.725614 [ 661 ] {} <Debug> AsyncLoader: Spawn loader worker #2 in FgLoad
2025.06.04 00:19:17.725766 [ 661 ] {} <Debug> AsyncLoader: Execute load job 'startup Atomic database default' in FgLoad
2025.06.04 00:19:17.725784 [ 661 ] {} <Debug> AsyncLoader: Finish load job 'startup Atomic database default' with status OK
2025.06.04 00:19:17.725790 [ 661 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2025.06.04 00:19:17.725921 [ 10 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/lib/clickhouse/user_defined/
2025.06.04 00:19:17.725903 [ 662 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2025.06.04 00:19:17.725959 [ 662 ] {} <Debug> AsyncLoader: Change current priority: 0 -> none
2025.06.04 00:19:17.725961 [ 10 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded
2025.06.04 00:19:17.725993 [ 10 ] {} <Debug> Application: Loaded metadata.
2025.06.04 00:19:17.726019 [ 10 ] {} <Trace> Pipe: Pipe capacity is 1.00 MiB
2025.06.04 00:19:17.726054 [ 10 ] {} <Information> Application: Tasks stats provider: procfs
2025.06.04 00:19:17.726058 [ 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.06.04 00:19:17.726396 [ 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.06.04 00:19:17.726468 [ 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.06.04 00:19:17.726473 [ 10 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair.
2025.06.04 00:19:17.865987 [ 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.06.04 00:19:17.866047 [ 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.06.04 00:19:17.866050 [ 10 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair.
2025.06.04 00:19:17.958252 [ 10 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again.
2025.06.04 00:19:17.959114 [ 10 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 49.38 MiB, peak 49.38 MiB, free memory in arenas 43.16 MiB, will set to 447.40 MiB (RSS), difference: 398.02 MiB
2025.06.04 00:19:17.960195 [ 10 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 1.229e-05 sec.
2025.06.04 00:19:17.960962 [ 10 ] {} <Information> Application: Listening for http://[::1]:8123
2025.06.04 00:19:17.961017 [ 10 ] {} <Information> Application: Listening for native protocol (tcp): [::1]:9000
2025.06.04 00:19:17.961055 [ 10 ] {} <Information> Application: Listening for MySQL compatibility protocol: [::1]:9004
2025.06.04 00:19:17.961218 [ 10 ] {} <Information> Application: Listening for PostgreSQL compatibility protocol: [::1]:9005
2025.06.04 00:19:17.961252 [ 10 ] {} <Information> Application: Listening for http://127.0.0.1:8123
2025.06.04 00:19:17.961291 [ 10 ] {} <Information> Application: Listening for native protocol (tcp): 127.0.0.1:9000
2025.06.04 00:19:17.961319 [ 10 ] {} <Information> Application: Listening for MySQL compatibility protocol: 127.0.0.1:9004
2025.06.04 00:19:17.961343 [ 10 ] {} <Information> Application: Listening for PostgreSQL compatibility protocol: 127.0.0.1:9005
2025.06.04 00:19:17.961347 [ 10 ] {} <Information> Application: Ready for connections.
2025.06.04 00:19:18.000924 [ 662 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 447.43 MiB, peak 447.43 MiB, free memory in arenas 43.15 MiB, will set to 449.90 MiB (RSS), difference: 2.47 MiB
2025.06.04 00:19:22.336129 [ 12 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:55634
2025.06.04 00:19:22.336258 [ 12 ] {} <Debug> TCPHandler: Connected ClickHouse client version 24.3.0, revision: 54467, user: default.
2025.06.04 00:19:22.336286 [ 12 ] {} <Debug> TCP-Session: de425c26-6a9c-466a-ad07-0f9c16d9c201 Authenticating user 'default' from [::1]:55634
2025.06.04 00:19:22.336324 [ 12 ] {} <Debug> TCP-Session: de425c26-6a9c-466a-ad07-0f9c16d9c201 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
2025.06.04 00:19:22.336333 [ 12 ] {} <Debug> TCP-Session: de425c26-6a9c-466a-ad07-0f9c16d9c201 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
2025.06.04 00:19:22.336435 [ 12 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false
2025.06.04 00:19:22.336463 [ 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.06.04 00:19:22.336494 [ 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.06.04 00:19:22.344521 [ 12 ] {} <Trace> TCP-Session: de425c26-6a9c-466a-ad07-0f9c16d9c201 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
2025.06.04 00:19:22.345002 [ 12 ] {4b1973fb-74de-41be-9ff3-f2e330050374} <Debug> executeQuery: (from [::1]:55634) select 'OK' (stage: Complete)
2025.06.04 00:19:22.345336 [ 12 ] {4b1973fb-74de-41be-9ff3-f2e330050374} <Trace> Planner: Query SELECT 'OK' AS `'OK'` FROM system.one AS __table1 to stage Complete
2025.06.04 00:19:22.345380 [ 12 ] {4b1973fb-74de-41be-9ff3-f2e330050374} <Trace> ContextAccess (default): Access granted: SELECT(dummy) ON system.one
2025.06.04 00:19:22.345459 [ 12 ] {4b1973fb-74de-41be-9ff3-f2e330050374} <Trace> Planner: Query SELECT 'OK' AS `'OK'` FROM system.one AS __table1 from stage FetchColumns to stage Complete
2025.06.04 00:19:22.346527 [ 12 ] {4b1973fb-74de-41be-9ff3-f2e330050374} <Debug> executeQuery: Read 1 rows, 1.00 B in 0.001595 sec., 626.9592476489028 rows/sec., 626.96 B/sec.
2025.06.04 00:19:22.346591 [ 12 ] {4b1973fb-74de-41be-9ff3-f2e330050374} <Debug> TCPHandler: Processed in 0.002244699 sec.
2025.06.04 00:19:22.347768 [ 12 ] {} <Debug> TCPHandler: Done processing connection.
2025.06.04 00:19:22.347805 [ 12 ] {} <Debug> TCP-Session: de425c26-6a9c-466a-ad07-0f9c16d9c201 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
2025.06.04 00:19:22.636241 [ 7 ] {} <Information> Application: Will watch for the process with pid 9
2025.06.04 00:19:22.636286 [ 9 ] {} <Information> Application: Forked a child process to watch
2025.06.04 00:19:22.636414 [ 9 ] {} <Information> SentryWriter: Sending crash reports is disabled
2025.06.04 00:19:22.636501 [ 9 ] {} <Trace> Pipe: Pipe capacity is 1.00 MiB
2025.06.04 00:19:22.715827 [ 9 ] {} <Information> Application: Starting ClickHouse 24.3.18.10388.altinitystable (revision: 54496, git hash: 0ce6c8f2a4d3031f31446142fde2337a95087b3b, build id: 3B84B7D8EF86A1D6CC2AF2855A1AA2F1EDB823A7), PID 9
2025.06.04 00:19:22.715963 [ 9 ] {} <Information> Application: starting up
2025.06.04 00:19:22.715978 [ 9 ] {} <Information> Application: OS name: Linux, version: 5.15.0-130-generic, architecture: x86_64
2025.06.04 00:19:22.720070 [ 9 ] {} <Information> Application: Available RAM: 30.60 GiB; logical cores: 16; used cores: 16.
2025.06.04 00:19:22.720099 [ 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.06.04 00:19:22.720208 [ 9 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/thermal
2025.06.04 00:19:22.720217 [ 9 ] {} <Trace> AsynchronousMetrics: Scanning /sys/block
2025.06.04 00:19:22.720285 [ 9 ] {} <Trace> AsynchronousMetrics: Scanning /sys/devices/system/edac
2025.06.04 00:19:22.720296 [ 9 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/hwmon
2025.06.04 00:19:22.723728 [ 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.06.04 00:19:22.857113 [ 9 ] {} <Information> Application: Integrity check of the executable successfully passed (checksum: 8FAB96359DCBEE06EDE3813EBB2A9026)
2025.06.04 00:19:22.857181 [ 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.06.04 00:19:22.859355 [ 9 ] {} <Debug> Application: rlimit on number of file descriptors is 1048576
2025.06.04 00:19:22.859372 [ 9 ] {} <Debug> Application: rlimit on number of threads is 18446744073709551615
2025.06.04 00:19:22.859379 [ 9 ] {} <Debug> Application: Initializing DateLUT.
2025.06.04 00:19:22.859383 [ 9 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'.
2025.06.04 00:19:22.859419 [ 9 ] {} <Debug> Context: Setting up /var/lib/clickhouse/tmp/ to store temporary data in it
2025.06.04 00:19:22.859834 [ 9 ] {} <Debug> Application: Configuration parameter 'interserver_http_host' doesn't exist or exists and empty. Will use 'github-hetzner-runner-15429959745-43426251947' as replica host.
2025.06.04 00:19:22.859858 [ 9 ] {} <Debug> Application: Initializing interserver credentials.
2025.06.04 00:19:22.859950 [ 9 ] {} <Trace> NamedCollectionsUtils: Loaded 0 collections from config
2025.06.04 00:19:22.860005 [ 9 ] {} <Trace> NamedCollectionsUtils: Loaded 0 collections from SQL
2025.06.04 00:19:22.860085 [ 9 ] {} <Information> CgroupsMemoryUsageObserver: Will read the current memory usage from '/sys/fs/cgroup/' (cgroups version: v2), wait time is 15 sec
2025.06.04 00:19:22.860314 [ 9 ] {} <Debug> ConfigReloader: Loading config '/config/config.xml'
2025.06.04 00:19:22.860324 [ 9 ] {} <Debug> ConfigProcessor: Processing configuration file '/config/config.xml'.
2025.06.04 00:19:22.863775 [ 9 ] {} <Debug> ConfigProcessor: Saved preprocessed configuration to '/var/lib/clickhouse/preprocessed_configs/config.xml'.
2025.06.04 00:19:22.863878 [ 9 ] {} <Debug> ConfigReloader: Loaded config '/config/config.xml', performing update on configuration
2025.06.04 00:19:22.866942 [ 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.06.04 00:19:22.866954 [ 9 ] {} <Information> CgroupsMemoryUsageObserver: Set new limits, soft limit: 24.79 GiB, hard limit: 26.16 GiB
2025.06.04 00:19:22.866958 [ 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.06.04 00:19:22.866962 [ 9 ] {} <Information> Application: Merges and mutations memory limit is set to 15.30 GiB
2025.06.04 00:19:22.867211 [ 9 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads
2025.06.04 00:19:22.868696 [ 9 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 512 threads
2025.06.04 00:19:22.949680 [ 9 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads
2025.06.04 00:19:22.951887 [ 9 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads
2025.06.04 00:19:22.953272 [ 9 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again.
2025.06.04 00:19:22.953305 [ 9 ] {} <Debug> ConfigReloader: Loaded config '/config/config.xml', performed update on configuration
2025.06.04 00:19:22.956094 [ 9 ] {} <Information> Application: Listening for replica communication (interserver): http://[::1]:9009
2025.06.04 00:19:22.956176 [ 9 ] {} <Information> Application: Listening for replica communication (interserver): http://127.0.0.1:9009
2025.06.04 00:19:22.959227 [ 9 ] {} <Debug> ConfigReloader: Loading config '/config/users.xml'
2025.06.04 00:19:22.959250 [ 9 ] {} <Debug> ConfigProcessor: Processing configuration file '/config/users.xml'.
2025.06.04 00:19:22.960125 [ 9 ] {} <Debug> ConfigProcessor: Saved preprocessed configuration to '/var/lib/clickhouse/preprocessed_configs/users.xml'.
2025.06.04 00:19:22.960161 [ 9 ] {} <Debug> ConfigReloader: Loaded config '/config/users.xml', performing update on configuration
2025.06.04 00:19:22.961667 [ 9 ] {} <Debug> ConfigReloader: Loaded config '/config/users.xml', performed update on configuration
2025.06.04 00:19:22.961899 [ 9 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: /config/users.xml
2025.06.04 00:19:22.962102 [ 9 ] {} <Warning> Access(local_directory): File /var/lib/clickhouse/access/users.list doesn't exist
2025.06.04 00:19:22.962121 [ 9 ] {} <Warning> Access(local_directory): Recovering lists in directory /var/lib/clickhouse/access/
2025.06.04 00:19:22.962675 [ 9 ] {} <Debug> Access(user directories): Added local_directory access storage 'local_directory', path: /var/lib/clickhouse/access/
2025.06.04 00:19:22.962839 [ 9 ] {} <Information> CgroupsMemoryUsageObserver: Started cgroup current memory usage observer thread
2025.06.04 00:19:22.963630 [ 580 ] {} <Information> CgroupsMemoryUsageObserver: Memory amount initially available to the process is 30.60 GiB
2025.06.04 00:19:22.964920 [ 9 ] {} <Information> Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32, scheduling_policy=round_robin
2025.06.04 00:19:22.965557 [ 9 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8
2025.06.04 00:19:22.968504 [ 9 ] {} <Information> Context: Initialized background executor for fetches with num_threads=16, num_tasks=16
2025.06.04 00:19:22.969110 [ 9 ] {} <Information> Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8
2025.06.04 00:19:22.970412 [ 9 ] {} <Information> DNSCacheUpdater: Update period 15 seconds
2025.06.04 00:19:22.970448 [ 9 ] {} <Information> Application: Loading metadata from /var/lib/clickhouse/
2025.06.04 00:19:22.970562 [ 45 ] {} <Debug> DNSResolver: Updating DNS cache
2025.06.04 00:19:22.972051 [ 45 ] {} <Debug> DNSResolver: Updated DNS cache
2025.06.04 00:19:22.975884 [ 9 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total.
2025.06.04 00:19:22.975906 [ 9 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.0001234 sec
2025.06.04 00:19:22.975916 [ 9 ] {} <Trace> ReferentialDeps: No tables
2025.06.04 00:19:22.975923 [ 9 ] {} <Trace> LoadingDeps: No tables
2025.06.04 00:19:22.975984 [ 9 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Atomic database system': BgStartup -> FgLoad
2025.06.04 00:19:22.975994 [ 9 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Ordinary database system': BgStartup -> FgLoad
2025.06.04 00:19:22.976005 [ 9 ] {} <Debug> AsyncLoader: Schedule load job 'startup Ordinary database system' into FgLoad
2025.06.04 00:19:22.976013 [ 9 ] {} <Debug> AsyncLoader: Schedule load job 'startup Atomic database system' into FgLoad
2025.06.04 00:19:22.976021 [ 9 ] {} <Debug> AsyncLoader: Change current priority: none -> 0
2025.06.04 00:19:22.976031 [ 9 ] {} <Debug> AsyncLoader: Spawn loader worker #1 in FgLoad
2025.06.04 00:19:22.976129 [ 9 ] {} <Debug> AsyncLoader: Wait load job 'startup Atomic database system' in FgLoad
2025.06.04 00:19:22.976293 [ 645 ] {} <Debug> AsyncLoader: Execute load job 'startup Ordinary database system' in FgLoad
2025.06.04 00:19:22.976344 [ 645 ] {} <Debug> AsyncLoader: Finish load job 'startup Ordinary database system' with status OK
2025.06.04 00:19:22.976355 [ 645 ] {} <Debug> AsyncLoader: Spawn loader worker #2 in FgLoad
2025.06.04 00:19:22.976473 [ 645 ] {} <Debug> AsyncLoader: Execute load job 'startup Atomic database system' in FgLoad
2025.06.04 00:19:22.976520 [ 645 ] {} <Debug> AsyncLoader: Finish load job 'startup Atomic database system' with status OK
2025.06.04 00:19:22.976543 [ 645 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2025.06.04 00:19:22.976577 [ 9 ] {} <Debug> SystemLog: Creating system.query_log from query_log
2025.06.04 00:19:22.976634 [ 646 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2025.06.04 00:19:22.976689 [ 646 ] {} <Debug> AsyncLoader: Change current priority: 0 -> none
2025.06.04 00:19:22.978439 [ 9 ] {} <Debug> SystemLog: Creating system.query_thread_log from query_thread_log
2025.06.04 00:19:22.979150 [ 9 ] {} <Debug> SystemLog: Creating system.part_log from part_log
2025.06.04 00:19:22.979810 [ 9 ] {} <Debug> SystemLog: Creating system.trace_log from trace_log
2025.06.04 00:19:22.980145 [ 9 ] {} <Debug> SystemLog: Creating system.crash_log from crash_log
2025.06.04 00:19:22.980448 [ 9 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config
2025.06.04 00:19:22.980471 [ 9 ] {} <Debug> SystemLog: Creating system.metric_log from metric_log
2025.06.04 00:19:22.989664 [ 9 ] {} <Debug> SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config
2025.06.04 00:19:22.989711 [ 9 ] {} <Debug> SystemLog: Not creating system.filesystem_read_prefetches_log since corresponding section 'filesystem_read_prefetches_log' is missing from config
2025.06.04 00:19:22.989757 [ 9 ] {} <Debug> SystemLog: Creating system.asynchronous_metric_log from asynchronous_metric_log
2025.06.04 00:19:22.990273 [ 9 ] {} <Debug> SystemLog: Creating system.opentelemetry_span_log from opentelemetry_span_log
2025.06.04 00:19:22.990927 [ 9 ] {} <Debug> SystemLog: Creating system.query_views_log from query_views_log
2025.06.04 00:19:22.991650 [ 9 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config
2025.06.04 00:19:22.991686 [ 9 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config
2025.06.04 00:19:22.991703 [ 9 ] {} <Debug> SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config
2025.06.04 00:19:22.991736 [ 9 ] {} <Debug> SystemLog: Creating system.processors_profile_log from processors_profile_log
2025.06.04 00:19:22.992121 [ 9 ] {} <Debug> SystemLog: Creating system.asynchronous_insert_log from asynchronous_insert_log
2025.06.04 00:19:22.992538 [ 9 ] {} <Debug> SystemLog: Creating system.backup_log from backup_log
2025.06.04 00:19:22.992996 [ 9 ] {} <Debug> SystemLog: Creating system.s3queue_log from s3queue_log
2025.06.04 00:19:22.993361 [ 9 ] {} <Debug> SystemLog: Creating system.blob_storage_log from blob_storage_log
2025.06.04 00:19:23.017012 [ 9 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal.
2025.06.04 00:19:23.019159 [ 9 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total.
2025.06.04 00:19:23.019178 [ 9 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 6.876e-05 sec
2025.06.04 00:19:23.019187 [ 9 ] {} <Trace> ReferentialDeps: No tables
2025.06.04 00:19:23.019192 [ 9 ] {} <Trace> LoadingDeps: No tables
2025.06.04 00:19:23.019245 [ 9 ] {} <Information> loadMetadata: Start synchronous loading of databases
2025.06.04 00:19:23.019250 [ 9 ] {} <Information> loadMetadata: Start synchronous startup of databases
2025.06.04 00:19:23.019256 [ 9 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Atomic database default': BgStartup -> FgLoad
2025.06.04 00:19:23.019262 [ 9 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Ordinary database default': BgStartup -> FgLoad
2025.06.04 00:19:23.019271 [ 9 ] {} <Debug> AsyncLoader: Schedule load job 'startup Ordinary database default' into FgLoad
2025.06.04 00:19:23.019277 [ 9 ] {} <Debug> AsyncLoader: Schedule load job 'startup Atomic database default' into FgLoad
2025.06.04 00:19:23.019284 [ 9 ] {} <Debug> AsyncLoader: Change current priority: none -> 0
2025.06.04 00:19:23.019289 [ 9 ] {} <Debug> AsyncLoader: Spawn loader worker #1 in FgLoad
2025.06.04 00:19:23.019393 [ 9 ] {} <Debug> AsyncLoader: Wait load job 'startup Atomic database default' in FgLoad
2025.06.04 00:19:23.019549 [ 660 ] {} <Debug> AsyncLoader: Execute load job 'startup Ordinary database default' in FgLoad
2025.06.04 00:19:23.019620 [ 660 ] {} <Debug> AsyncLoader: Finish load job 'startup Ordinary database default' with status OK
2025.06.04 00:19:23.019632 [ 660 ] {} <Debug> AsyncLoader: Spawn loader worker #2 in FgLoad
2025.06.04 00:19:23.019771 [ 660 ] {} <Debug> AsyncLoader: Execute load job 'startup Atomic database default' in FgLoad
2025.06.04 00:19:23.019791 [ 660 ] {} <Debug> AsyncLoader: Finish load job 'startup Atomic database default' with status OK
2025.06.04 00:19:23.019799 [ 660 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2025.06.04 00:19:23.019818 [ 660 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2025.06.04 00:19:23.019826 [ 660 ] {} <Debug> AsyncLoader: Change current priority: 0 -> none
2025.06.04 00:19:23.019973 [ 9 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/lib/clickhouse/user_defined/
2025.06.04 00:19:23.020019 [ 9 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded
2025.06.04 00:19:23.020025 [ 9 ] {} <Debug> Application: Loaded metadata.
2025.06.04 00:19:23.020051 [ 9 ] {} <Trace> Pipe: Pipe capacity is 1.00 MiB
2025.06.04 00:19:23.020092 [ 9 ] {} <Information> Application: Tasks stats provider: procfs
2025.06.04 00:19:23.020099 [ 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.06.04 00:19:23.020643 [ 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.06.04 00:19:23.020741 [ 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.06.04 00:19:23.020748 [ 9 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair.
2025.06.04 00:19:23.106799 [ 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.06.04 00:19:23.106859 [ 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.06.04 00:19:23.106863 [ 9 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair.
2025.06.04 00:19:23.167194 [ 9 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again.
2025.06.04 00:19:23.168177 [ 9 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 49.41 MiB, peak 49.41 MiB, free memory in arenas 43.08 MiB, will set to 448.04 MiB (RSS), difference: 398.64 MiB
2025.06.04 00:19:23.169964 [ 9 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 1.572e-05 sec.
2025.06.04 00:19:23.170838 [ 9 ] {} <Information> Application: Listening for http://[::1]:8123
2025.06.04 00:19:23.170903 [ 9 ] {} <Information> Application: Listening for native protocol (tcp): [::1]:9000
2025.06.04 00:19:23.170941 [ 9 ] {} <Information> Application: Listening for MySQL compatibility protocol: [::1]:9004
2025.06.04 00:19:23.170989 [ 9 ] {} <Information> Application: Listening for PostgreSQL compatibility protocol: [::1]:9005
2025.06.04 00:19:23.171024 [ 9 ] {} <Information> Application: Listening for http://127.0.0.1:8123
2025.06.04 00:19:23.171069 [ 9 ] {} <Information> Application: Listening for native protocol (tcp): 127.0.0.1:9000
2025.06.04 00:19:23.171104 [ 9 ] {} <Information> Application: Listening for MySQL compatibility protocol: 127.0.0.1:9004
2025.06.04 00:19:23.171136 [ 9 ] {} <Information> Application: Listening for PostgreSQL compatibility protocol: 127.0.0.1:9005
2025.06.04 00:19:23.171141 [ 9 ] {} <Information> Application: Ready for connections.
2025.06.04 00:19:24.000888 [ 662 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 448.07 MiB, peak 448.07 MiB, free memory in arenas 43.14 MiB, will set to 450.47 MiB (RSS), difference: 2.40 MiB
2025.06.04 00:19:27.611798 [ 11 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: 127.0.0.1:58156
2025.06.04 00:19:27.611928 [ 11 ] {} <Debug> TCPHandler: Connected ClickHouse client version 24.3.0, revision: 54467, user: default.
2025.06.04 00:19:27.611955 [ 11 ] {} <Debug> TCP-Session: 8170e78e-ed12-4748-a6d4-1607ce6b0720 Authenticating user 'default' from 127.0.0.1:58156
2025.06.04 00:19:27.611992 [ 11 ] {} <Debug> TCP-Session: 8170e78e-ed12-4748-a6d4-1607ce6b0720 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
2025.06.04 00:19:27.612001 [ 11 ] {} <Debug> TCP-Session: 8170e78e-ed12-4748-a6d4-1607ce6b0720 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
2025.06.04 00:19:27.612106 [ 11 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false
2025.06.04 00:19:27.612133 [ 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.06.04 00:19:27.612152 [ 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.06.04 00:19:27.622710 [ 11 ] {} <Trace> TCP-Session: 8170e78e-ed12-4748-a6d4-1607ce6b0720 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
2025.06.04 00:19:27.623131 [ 11 ] {66cf879f-174a-463f-b53e-16190b1b6244} <Debug> executeQuery: (from 127.0.0.1:58156) select 'OK' (stage: Complete)
2025.06.04 00:19:27.623454 [ 11 ] {66cf879f-174a-463f-b53e-16190b1b6244} <Trace> Planner: Query SELECT 'OK' AS `'OK'` FROM system.one AS __table1 to stage Complete
2025.06.04 00:19:27.623510 [ 11 ] {66cf879f-174a-463f-b53e-16190b1b6244} <Trace> ContextAccess (default): Access granted: SELECT(dummy) ON system.one
2025.06.04 00:19:27.623596 [ 11 ] {66cf879f-174a-463f-b53e-16190b1b6244} <Trace> Planner: Query SELECT 'OK' AS `'OK'` FROM system.one AS __table1 from stage FetchColumns to stage Complete
2025.06.04 00:19:27.624457 [ 11 ] {66cf879f-174a-463f-b53e-16190b1b6244} <Debug> executeQuery: Read 1 rows, 1.00 B in 0.001343 sec., 744.6016381236038 rows/sec., 744.60 B/sec.
2025.06.04 00:19:27.624532 [ 11 ] {66cf879f-174a-463f-b53e-16190b1b6244} <Debug> TCPHandler: Processed in 0.001956669 sec.
2025.06.04 00:19:27.624906 [ 11 ] {} <Debug> TCPHandler: Done processing connection.
2025.06.04 00:19:27.624930 [ 11 ] {} <Debug> TCP-Session: 8170e78e-ed12-4748-a6d4-1607ce6b0720 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db