2025.06.05 15:57:33.437449 [ 8 ] {} <Information> Application: Will watch for the process with pid 10
2025.06.05 15:57:33.437555 [ 10 ] {} <Information> Application: Forked a child process to watch
2025.06.05 15:57:33.437767 [ 10 ] {} <Information> SentryWriter: Sending crash reports is disabled
2025.06.05 15:57:33.437885 [ 10 ] {} <Trace> Pipe: Pipe capacity is 1.00 MiB
2025.06.05 15:57:33.525232 [ 10 ] {} <Information> Application: Starting ClickHouse 24.3.18.10425.altinitystable (revision: 54496, git hash: 7b7f60d703c9d032be75b347475389eb61433c88, build id: 3084ABB864DA07B3254C9E507793141F242D9A9D), PID 10
2025.06.05 15:57:33.525377 [ 10 ] {} <Information> Application: starting up
2025.06.05 15:57:33.525391 [ 10 ] {} <Information> Application: OS name: Linux, version: 5.15.0-130-generic, architecture: x86_64
2025.06.05 15:57:33.529693 [ 10 ] {} <Information> Application: Available RAM: 30.60 GiB; logical cores: 16; used cores: 16.
2025.06.05 15:57:33.529716 [ 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.05 15:57:33.529833 [ 10 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/thermal
2025.06.05 15:57:33.529847 [ 10 ] {} <Trace> AsynchronousMetrics: Scanning /sys/block
2025.06.05 15:57:33.529922 [ 10 ] {} <Trace> AsynchronousMetrics: Scanning /sys/devices/system/edac
2025.06.05 15:57:33.529935 [ 10 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/hwmon
2025.06.05 15:57:33.534556 [ 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.05 15:57:33.670751 [ 10 ] {} <Information> Application: Integrity check of the executable successfully passed (checksum: C4630C1F875596DB2C85C127B875148C)
2025.06.05 15:57:33.670814 [ 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.05 15:57:33.672560 [ 10 ] {} <Debug> Application: rlimit on number of file descriptors is 1048576
2025.06.05 15:57:33.672574 [ 10 ] {} <Debug> Application: rlimit on number of threads is 18446744073709551615
2025.06.05 15:57:33.672582 [ 10 ] {} <Debug> Application: Initializing DateLUT.
2025.06.05 15:57:33.672585 [ 10 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'.
2025.06.05 15:57:33.672616 [ 10 ] {} <Debug> Context: Setting up /var/lib/clickhouse/tmp/ to store temporary data in it
2025.06.05 15:57:33.673083 [ 10 ] {} <Debug> Application: Configuration parameter 'interserver_http_host' doesn't exist or exists and empty. Will use 'github-hetzner-runner-15470039342-43552320886' as replica host.
2025.06.05 15:57:33.673098 [ 10 ] {} <Debug> Application: Initializing interserver credentials.
2025.06.05 15:57:33.673219 [ 10 ] {} <Trace> NamedCollectionsUtils: Loaded 0 collections from config
2025.06.05 15:57:33.673280 [ 10 ] {} <Trace> NamedCollectionsUtils: Loaded 0 collections from SQL
2025.06.05 15:57:33.673369 [ 10 ] {} <Information> CgroupsMemoryUsageObserver: Will read the current memory usage from '/sys/fs/cgroup/' (cgroups version: v2), wait time is 15 sec
2025.06.05 15:57:33.673687 [ 10 ] {} <Debug> ConfigReloader: Loading config '/config/config.xml'
2025.06.05 15:57:33.673692 [ 10 ] {} <Debug> ConfigProcessor: Processing configuration file '/config/config.xml'.
2025.06.05 15:57:33.677364 [ 10 ] {} <Debug> ConfigProcessor: Saved preprocessed configuration to '/var/lib/clickhouse/preprocessed_configs/config.xml'.
2025.06.05 15:57:33.677436 [ 10 ] {} <Debug> ConfigReloader: Loaded config '/config/config.xml', performing update on configuration
2025.06.05 15:57:33.681541 [ 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.05 15:57:33.681559 [ 10 ] {} <Information> CgroupsMemoryUsageObserver: Set new limits, soft limit: 24.79 GiB, hard limit: 26.16 GiB
2025.06.05 15:57:33.681563 [ 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.05 15:57:33.681566 [ 10 ] {} <Information> Application: Merges and mutations memory limit is set to 15.30 GiB
2025.06.05 15:57:33.681864 [ 10 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads
2025.06.05 15:57:33.683228 [ 10 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 512 threads
2025.06.05 15:57:33.754389 [ 10 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads
2025.06.05 15:57:33.758322 [ 10 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads
2025.06.05 15:57:33.759285 [ 10 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again.
2025.06.05 15:57:33.759358 [ 10 ] {} <Debug> ConfigReloader: Loaded config '/config/config.xml', performed update on configuration
2025.06.05 15:57:33.760469 [ 10 ] {} <Information> Application: Listening for replica communication (interserver): http://[::1]:9009
2025.06.05 15:57:33.761161 [ 10 ] {} <Information> Application: Listening for replica communication (interserver): http://127.0.0.1:9009
2025.06.05 15:57:33.763321 [ 10 ] {} <Debug> ConfigReloader: Loading config '/config/users.xml'
2025.06.05 15:57:33.763337 [ 10 ] {} <Debug> ConfigProcessor: Processing configuration file '/config/users.xml'.
2025.06.05 15:57:33.763894 [ 10 ] {} <Debug> ConfigProcessor: Saved preprocessed configuration to '/var/lib/clickhouse/preprocessed_configs/users.xml'.
2025.06.05 15:57:33.763911 [ 10 ] {} <Debug> ConfigReloader: Loaded config '/config/users.xml', performing update on configuration
2025.06.05 15:57:33.764674 [ 10 ] {} <Debug> ConfigReloader: Loaded config '/config/users.xml', performed update on configuration
2025.06.05 15:57:33.764907 [ 10 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: /config/users.xml
2025.06.05 15:57:33.765059 [ 10 ] {} <Warning> Access(local_directory): File /var/lib/clickhouse/access/users.list doesn't exist
2025.06.05 15:57:33.765074 [ 10 ] {} <Warning> Access(local_directory): Recovering lists in directory /var/lib/clickhouse/access/
2025.06.05 15:57:33.765288 [ 10 ] {} <Debug> Access(user directories): Added local_directory access storage 'local_directory', path: /var/lib/clickhouse/access/
2025.06.05 15:57:33.765383 [ 10 ] {} <Information> CgroupsMemoryUsageObserver: Started cgroup current memory usage observer thread
2025.06.05 15:57:33.765787 [ 581 ] {} <Information> CgroupsMemoryUsageObserver: Memory amount initially available to the process is 30.60 GiB
2025.06.05 15:57:33.766197 [ 10 ] {} <Information> Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32, scheduling_policy=round_robin
2025.06.05 15:57:33.767640 [ 10 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8
2025.06.05 15:57:33.768476 [ 10 ] {} <Information> Context: Initialized background executor for fetches with num_threads=16, num_tasks=16
2025.06.05 15:57:33.771012 [ 10 ] {} <Information> Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8
2025.06.05 15:57:33.772179 [ 10 ] {} <Information> DNSCacheUpdater: Update period 15 seconds
2025.06.05 15:57:33.772222 [ 10 ] {} <Information> Application: Loading metadata from /var/lib/clickhouse/
2025.06.05 15:57:33.772956 [ 46 ] {} <Debug> DNSResolver: Updating DNS cache
2025.06.05 15:57:33.773845 [ 46 ] {} <Debug> DNSResolver: Updated DNS cache
2025.06.05 15:57:33.776626 [ 10 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total.
2025.06.05 15:57:33.776642 [ 10 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 8.3757e-05 sec
2025.06.05 15:57:33.776647 [ 10 ] {} <Trace> ReferentialDeps: No tables
2025.06.05 15:57:33.776650 [ 10 ] {} <Trace> LoadingDeps: No tables
2025.06.05 15:57:33.776694 [ 10 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Atomic database system': BgStartup -> FgLoad
2025.06.05 15:57:33.776700 [ 10 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Ordinary database system': BgStartup -> FgLoad
2025.06.05 15:57:33.776704 [ 10 ] {} <Debug> AsyncLoader: Schedule load job 'startup Ordinary database system' into FgLoad
2025.06.05 15:57:33.776709 [ 10 ] {} <Debug> AsyncLoader: Schedule load job 'startup Atomic database system' into FgLoad
2025.06.05 15:57:33.776713 [ 10 ] {} <Debug> AsyncLoader: Change current priority: none -> 0
2025.06.05 15:57:33.776716 [ 10 ] {} <Debug> AsyncLoader: Spawn loader worker #1 in FgLoad
2025.06.05 15:57:33.776776 [ 10 ] {} <Debug> AsyncLoader: Wait load job 'startup Atomic database system' in FgLoad
2025.06.05 15:57:33.776856 [ 646 ] {} <Debug> AsyncLoader: Execute load job 'startup Ordinary database system' in FgLoad
2025.06.05 15:57:33.776887 [ 646 ] {} <Debug> AsyncLoader: Finish load job 'startup Ordinary database system' with status OK
2025.06.05 15:57:33.776893 [ 646 ] {} <Debug> AsyncLoader: Spawn loader worker #2 in FgLoad
2025.06.05 15:57:33.776976 [ 646 ] {} <Debug> AsyncLoader: Execute load job 'startup Atomic database system' in FgLoad
2025.06.05 15:57:33.777007 [ 646 ] {} <Debug> AsyncLoader: Finish load job 'startup Atomic database system' with status OK
2025.06.05 15:57:33.777017 [ 646 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2025.06.05 15:57:33.777036 [ 10 ] {} <Debug> SystemLog: Creating system.query_log from query_log
2025.06.05 15:57:33.777073 [ 647 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2025.06.05 15:57:33.777100 [ 647 ] {} <Debug> AsyncLoader: Change current priority: 0 -> none
2025.06.05 15:57:33.778103 [ 10 ] {} <Debug> SystemLog: Creating system.query_thread_log from query_thread_log
2025.06.05 15:57:33.778468 [ 10 ] {} <Debug> SystemLog: Creating system.part_log from part_log
2025.06.05 15:57:33.778750 [ 10 ] {} <Debug> SystemLog: Creating system.trace_log from trace_log
2025.06.05 15:57:33.778923 [ 10 ] {} <Debug> SystemLog: Creating system.crash_log from crash_log
2025.06.05 15:57:33.779050 [ 10 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config
2025.06.05 15:57:33.779061 [ 10 ] {} <Debug> SystemLog: Creating system.metric_log from metric_log
2025.06.05 15:57:33.782691 [ 10 ] {} <Debug> SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config
2025.06.05 15:57:33.782707 [ 10 ] {} <Debug> SystemLog: Not creating system.filesystem_read_prefetches_log since corresponding section 'filesystem_read_prefetches_log' is missing from config
2025.06.05 15:57:33.782716 [ 10 ] {} <Debug> SystemLog: Creating system.asynchronous_metric_log from asynchronous_metric_log
2025.06.05 15:57:33.782895 [ 10 ] {} <Debug> SystemLog: Creating system.opentelemetry_span_log from opentelemetry_span_log
2025.06.05 15:57:33.783164 [ 10 ] {} <Debug> SystemLog: Creating system.query_views_log from query_views_log
2025.06.05 15:57:33.783468 [ 10 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config
2025.06.05 15:57:33.783485 [ 10 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config
2025.06.05 15:57:33.783494 [ 10 ] {} <Debug> SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config
2025.06.05 15:57:33.783502 [ 10 ] {} <Debug> SystemLog: Creating system.processors_profile_log from processors_profile_log
2025.06.05 15:57:33.783740 [ 10 ] {} <Debug> SystemLog: Creating system.asynchronous_insert_log from asynchronous_insert_log
2025.06.05 15:57:33.783981 [ 10 ] {} <Debug> SystemLog: Creating system.backup_log from backup_log
2025.06.05 15:57:33.784237 [ 10 ] {} <Debug> SystemLog: Creating system.s3queue_log from s3queue_log
2025.06.05 15:57:33.784512 [ 10 ] {} <Debug> SystemLog: Creating system.blob_storage_log from blob_storage_log
2025.06.05 15:57:33.796487 [ 10 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal.
2025.06.05 15:57:33.798170 [ 10 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total.
2025.06.05 15:57:33.798180 [ 10 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 3.6039e-05 sec
2025.06.05 15:57:33.798185 [ 10 ] {} <Trace> ReferentialDeps: No tables
2025.06.05 15:57:33.798188 [ 10 ] {} <Trace> LoadingDeps: No tables
2025.06.05 15:57:33.798225 [ 10 ] {} <Information> loadMetadata: Start synchronous loading of databases
2025.06.05 15:57:33.798230 [ 10 ] {} <Information> loadMetadata: Start synchronous startup of databases
2025.06.05 15:57:33.798233 [ 10 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Atomic database default': BgStartup -> FgLoad
2025.06.05 15:57:33.798236 [ 10 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Ordinary database default': BgStartup -> FgLoad
2025.06.05 15:57:33.798241 [ 10 ] {} <Debug> AsyncLoader: Schedule load job 'startup Ordinary database default' into FgLoad
2025.06.05 15:57:33.798244 [ 10 ] {} <Debug> AsyncLoader: Schedule load job 'startup Atomic database default' into FgLoad
2025.06.05 15:57:33.798247 [ 10 ] {} <Debug> AsyncLoader: Change current priority: none -> 0
2025.06.05 15:57:33.798250 [ 10 ] {} <Debug> AsyncLoader: Spawn loader worker #1 in FgLoad
2025.06.05 15:57:33.798314 [ 10 ] {} <Debug> AsyncLoader: Wait load job 'startup Atomic database default' in FgLoad
2025.06.05 15:57:33.798400 [ 661 ] {} <Debug> AsyncLoader: Execute load job 'startup Ordinary database default' in FgLoad
2025.06.05 15:57:33.798447 [ 661 ] {} <Debug> AsyncLoader: Finish load job 'startup Ordinary database default' with status OK
2025.06.05 15:57:33.798454 [ 661 ] {} <Debug> AsyncLoader: Spawn loader worker #2 in FgLoad
2025.06.05 15:57:33.798535 [ 661 ] {} <Debug> AsyncLoader: Execute load job 'startup Atomic database default' in FgLoad
2025.06.05 15:57:33.798549 [ 661 ] {} <Debug> AsyncLoader: Finish load job 'startup Atomic database default' with status OK
2025.06.05 15:57:33.798553 [ 661 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2025.06.05 15:57:33.798633 [ 662 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2025.06.05 15:57:33.798672 [ 10 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/lib/clickhouse/user_defined/
2025.06.05 15:57:33.798677 [ 662 ] {} <Debug> AsyncLoader: Change current priority: 0 -> none
2025.06.05 15:57:33.798712 [ 10 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded
2025.06.05 15:57:33.798718 [ 10 ] {} <Debug> Application: Loaded metadata.
2025.06.05 15:57:33.798740 [ 10 ] {} <Trace> Pipe: Pipe capacity is 1.00 MiB
2025.06.05 15:57:33.798777 [ 10 ] {} <Information> Application: Tasks stats provider: procfs
2025.06.05 15:57:33.798797 [ 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.05 15:57:33.799101 [ 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.10425.altinitystable (altinity build))
2025.06.05 15:57:33.799175 [ 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.10425.altinitystable (altinity build))
2025.06.05 15:57:33.799179 [ 10 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair.
2025.06.05 15:57:33.890567 [ 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.10425.altinitystable (altinity build))
2025.06.05 15:57:33.890639 [ 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.10425.altinitystable (altinity build))
2025.06.05 15:57:33.890644 [ 10 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair.
2025.06.05 15:57:33.952864 [ 10 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again.
2025.06.05 15:57:33.953664 [ 10 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 49.41 MiB, peak 49.41 MiB, free memory in arenas 43.14 MiB, will set to 448.11 MiB (RSS), difference: 398.70 MiB
2025.06.05 15:57:33.954745 [ 10 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 1.5639e-05 sec.
2025.06.05 15:57:33.955804 [ 10 ] {} <Information> Application: Listening for http://[::1]:8123
2025.06.05 15:57:33.955846 [ 10 ] {} <Information> Application: Listening for native protocol (tcp): [::1]:9000
2025.06.05 15:57:33.955876 [ 10 ] {} <Information> Application: Listening for MySQL compatibility protocol: [::1]:9004
2025.06.05 15:57:33.955906 [ 10 ] {} <Information> Application: Listening for PostgreSQL compatibility protocol: [::1]:9005
2025.06.05 15:57:33.955938 [ 10 ] {} <Information> Application: Listening for http://127.0.0.1:8123
2025.06.05 15:57:33.955969 [ 10 ] {} <Information> Application: Listening for native protocol (tcp): 127.0.0.1:9000
2025.06.05 15:57:33.955999 [ 10 ] {} <Information> Application: Listening for MySQL compatibility protocol: 127.0.0.1:9004
2025.06.05 15:57:33.956029 [ 10 ] {} <Information> Application: Listening for PostgreSQL compatibility protocol: 127.0.0.1:9005
2025.06.05 15:57:33.956033 [ 10 ] {} <Information> Application: Ready for connections.
2025.06.05 15:57:34.000769 [ 662 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 448.13 MiB, peak 448.13 MiB, free memory in arenas 43.20 MiB, will set to 450.84 MiB (RSS), difference: 2.71 MiB
2025.06.05 15:57:38.439356 [ 12 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:38296
2025.06.05 15:57:38.439593 [ 12 ] {} <Debug> TCPHandler: Connected ClickHouse client version 24.3.0, revision: 54467, user: default.
2025.06.05 15:57:38.439638 [ 12 ] {} <Debug> TCP-Session: 6cbc9251-30a8-4304-b9a2-6908e8e8242a Authenticating user 'default' from [::1]:38296
2025.06.05 15:57:38.439680 [ 12 ] {} <Debug> TCP-Session: 6cbc9251-30a8-4304-b9a2-6908e8e8242a Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
2025.06.05 15:57:38.439689 [ 12 ] {} <Debug> TCP-Session: 6cbc9251-30a8-4304-b9a2-6908e8e8242a Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
2025.06.05 15:57:38.439815 [ 12 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false
2025.06.05 15:57:38.439850 [ 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.05 15:57:38.439886 [ 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.05 15:57:38.458641 [ 12 ] {} <Trace> TCP-Session: 6cbc9251-30a8-4304-b9a2-6908e8e8242a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
2025.06.05 15:57:38.459199 [ 12 ] {7a477054-de20-4fcc-af6a-04d6ff92fe43} <Debug> executeQuery: (from [::1]:38296) select 'OK' (stage: Complete)
2025.06.05 15:57:38.459558 [ 12 ] {7a477054-de20-4fcc-af6a-04d6ff92fe43} <Trace> Planner: Query SELECT 'OK' AS `'OK'` FROM system.one AS __table1 to stage Complete
2025.06.05 15:57:38.459629 [ 12 ] {7a477054-de20-4fcc-af6a-04d6ff92fe43} <Trace> ContextAccess (default): Access granted: SELECT(dummy) ON system.one
2025.06.05 15:57:38.459725 [ 12 ] {7a477054-de20-4fcc-af6a-04d6ff92fe43} <Trace> Planner: Query SELECT 'OK' AS `'OK'` FROM system.one AS __table1 from stage FetchColumns to stage Complete
2025.06.05 15:57:38.461546 [ 12 ] {7a477054-de20-4fcc-af6a-04d6ff92fe43} <Debug> executeQuery: Read 1 rows, 1.00 B in 0.002376 sec., 420.87542087542084 rows/sec., 420.88 B/sec.
2025.06.05 15:57:38.461663 [ 12 ] {7a477054-de20-4fcc-af6a-04d6ff92fe43} <Debug> TCPHandler: Processed in 0.003226591 sec.
2025.06.05 15:57:38.462193 [ 12 ] {} <Debug> TCPHandler: Done processing connection.
2025.06.05 15:57:38.462325 [ 12 ] {} <Debug> TCP-Session: 6cbc9251-30a8-4304-b9a2-6908e8e8242a Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
2025.06.05 15:57:38.750018 [ 7 ] {} <Information> Application: Will watch for the process with pid 9
2025.06.05 15:57:38.750120 [ 9 ] {} <Information> Application: Forked a child process to watch
2025.06.05 15:57:38.750333 [ 9 ] {} <Information> SentryWriter: Sending crash reports is disabled
2025.06.05 15:57:38.750441 [ 9 ] {} <Trace> Pipe: Pipe capacity is 1.00 MiB
2025.06.05 15:57:38.839337 [ 9 ] {} <Information> Application: Starting ClickHouse 24.3.18.10425.altinitystable (revision: 54496, git hash: 7b7f60d703c9d032be75b347475389eb61433c88, build id: 3084ABB864DA07B3254C9E507793141F242D9A9D), PID 9
2025.06.05 15:57:38.839518 [ 9 ] {} <Information> Application: starting up
2025.06.05 15:57:38.839535 [ 9 ] {} <Information> Application: OS name: Linux, version: 5.15.0-130-generic, architecture: x86_64
2025.06.05 15:57:38.843723 [ 9 ] {} <Information> Application: Available RAM: 30.60 GiB; logical cores: 16; used cores: 16.
2025.06.05 15:57:38.843744 [ 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.05 15:57:38.843860 [ 9 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/thermal
2025.06.05 15:57:38.843872 [ 9 ] {} <Trace> AsynchronousMetrics: Scanning /sys/block
2025.06.05 15:57:38.843940 [ 9 ] {} <Trace> AsynchronousMetrics: Scanning /sys/devices/system/edac
2025.06.05 15:57:38.843953 [ 9 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/hwmon
2025.06.05 15:57:38.848513 [ 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.05 15:57:38.984525 [ 9 ] {} <Information> Application: Integrity check of the executable successfully passed (checksum: C4630C1F875596DB2C85C127B875148C)
2025.06.05 15:57:38.984580 [ 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.05 15:57:38.986103 [ 9 ] {} <Debug> Application: rlimit on number of file descriptors is 1048576
2025.06.05 15:57:38.986116 [ 9 ] {} <Debug> Application: rlimit on number of threads is 18446744073709551615
2025.06.05 15:57:38.986123 [ 9 ] {} <Debug> Application: Initializing DateLUT.
2025.06.05 15:57:38.986127 [ 9 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'.
2025.06.05 15:57:38.986149 [ 9 ] {} <Debug> Context: Setting up /var/lib/clickhouse/tmp/ to store temporary data in it
2025.06.05 15:57:38.986572 [ 9 ] {} <Debug> Application: Configuration parameter 'interserver_http_host' doesn't exist or exists and empty. Will use 'github-hetzner-runner-15470039342-43552320886' as replica host.
2025.06.05 15:57:38.986587 [ 9 ] {} <Debug> Application: Initializing interserver credentials.
2025.06.05 15:57:38.986704 [ 9 ] {} <Trace> NamedCollectionsUtils: Loaded 0 collections from config
2025.06.05 15:57:38.986785 [ 9 ] {} <Trace> NamedCollectionsUtils: Loaded 0 collections from SQL
2025.06.05 15:57:38.986887 [ 9 ] {} <Information> CgroupsMemoryUsageObserver: Will read the current memory usage from '/sys/fs/cgroup/' (cgroups version: v2), wait time is 15 sec
2025.06.05 15:57:38.987211 [ 9 ] {} <Debug> ConfigReloader: Loading config '/config/config.xml'
2025.06.05 15:57:38.987218 [ 9 ] {} <Debug> ConfigProcessor: Processing configuration file '/config/config.xml'.
2025.06.05 15:57:38.990889 [ 9 ] {} <Debug> ConfigProcessor: Saved preprocessed configuration to '/var/lib/clickhouse/preprocessed_configs/config.xml'.
2025.06.05 15:57:38.990985 [ 9 ] {} <Debug> ConfigReloader: Loaded config '/config/config.xml', performing update on configuration
2025.06.05 15:57:38.995189 [ 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.05 15:57:38.995200 [ 9 ] {} <Information> CgroupsMemoryUsageObserver: Set new limits, soft limit: 24.79 GiB, hard limit: 26.16 GiB
2025.06.05 15:57:38.995205 [ 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.05 15:57:38.995209 [ 9 ] {} <Information> Application: Merges and mutations memory limit is set to 15.30 GiB
2025.06.05 15:57:38.995466 [ 9 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads
2025.06.05 15:57:38.996449 [ 9 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 512 threads
2025.06.05 15:57:39.059144 [ 9 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads
2025.06.05 15:57:39.063945 [ 9 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads
2025.06.05 15:57:39.067066 [ 9 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again.
2025.06.05 15:57:39.067109 [ 9 ] {} <Debug> ConfigReloader: Loaded config '/config/config.xml', performed update on configuration
2025.06.05 15:57:39.067795 [ 9 ] {} <Information> Application: Listening for replica communication (interserver): http://[::1]:9009
2025.06.05 15:57:39.067846 [ 9 ] {} <Information> Application: Listening for replica communication (interserver): http://127.0.0.1:9009
2025.06.05 15:57:39.069285 [ 9 ] {} <Debug> ConfigReloader: Loading config '/config/users.xml'
2025.06.05 15:57:39.069293 [ 9 ] {} <Debug> ConfigProcessor: Processing configuration file '/config/users.xml'.
2025.06.05 15:57:39.069690 [ 9 ] {} <Debug> ConfigProcessor: Saved preprocessed configuration to '/var/lib/clickhouse/preprocessed_configs/users.xml'.
2025.06.05 15:57:39.069708 [ 9 ] {} <Debug> ConfigReloader: Loaded config '/config/users.xml', performing update on configuration
2025.06.05 15:57:39.070345 [ 9 ] {} <Debug> ConfigReloader: Loaded config '/config/users.xml', performed update on configuration
2025.06.05 15:57:39.070518 [ 9 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: /config/users.xml
2025.06.05 15:57:39.070609 [ 9 ] {} <Warning> Access(local_directory): File /var/lib/clickhouse/access/users.list doesn't exist
2025.06.05 15:57:39.070622 [ 9 ] {} <Warning> Access(local_directory): Recovering lists in directory /var/lib/clickhouse/access/
2025.06.05 15:57:39.070889 [ 9 ] {} <Debug> Access(user directories): Added local_directory access storage 'local_directory', path: /var/lib/clickhouse/access/
2025.06.05 15:57:39.070954 [ 9 ] {} <Information> CgroupsMemoryUsageObserver: Started cgroup current memory usage observer thread
2025.06.05 15:57:39.071390 [ 580 ] {} <Information> CgroupsMemoryUsageObserver: Memory amount initially available to the process is 30.60 GiB
2025.06.05 15:57:39.071739 [ 9 ] {} <Information> Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32, scheduling_policy=round_robin
2025.06.05 15:57:39.072115 [ 9 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8
2025.06.05 15:57:39.073463 [ 9 ] {} <Information> Context: Initialized background executor for fetches with num_threads=16, num_tasks=16
2025.06.05 15:57:39.073820 [ 9 ] {} <Information> Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8
2025.06.05 15:57:39.074623 [ 9 ] {} <Information> DNSCacheUpdater: Update period 15 seconds
2025.06.05 15:57:39.074641 [ 9 ] {} <Information> Application: Loading metadata from /var/lib/clickhouse/
2025.06.05 15:57:39.074667 [ 43 ] {} <Debug> DNSResolver: Updating DNS cache
2025.06.05 15:57:39.075708 [ 43 ] {} <Debug> DNSResolver: Updated DNS cache
2025.06.05 15:57:39.078964 [ 9 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total.
2025.06.05 15:57:39.078977 [ 9 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 6.7657e-05 sec
2025.06.05 15:57:39.078982 [ 9 ] {} <Trace> ReferentialDeps: No tables
2025.06.05 15:57:39.078986 [ 9 ] {} <Trace> LoadingDeps: No tables
2025.06.05 15:57:39.079036 [ 9 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Atomic database system': BgStartup -> FgLoad
2025.06.05 15:57:39.079045 [ 9 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Ordinary database system': BgStartup -> FgLoad
2025.06.05 15:57:39.079051 [ 9 ] {} <Debug> AsyncLoader: Schedule load job 'startup Ordinary database system' into FgLoad
2025.06.05 15:57:39.079055 [ 9 ] {} <Debug> AsyncLoader: Schedule load job 'startup Atomic database system' into FgLoad
2025.06.05 15:57:39.079061 [ 9 ] {} <Debug> AsyncLoader: Change current priority: none -> 0
2025.06.05 15:57:39.079066 [ 9 ] {} <Debug> AsyncLoader: Spawn loader worker #1 in FgLoad
2025.06.05 15:57:39.079122 [ 9 ] {} <Debug> AsyncLoader: Wait load job 'startup Atomic database system' in FgLoad
2025.06.05 15:57:39.079178 [ 645 ] {} <Debug> AsyncLoader: Execute load job 'startup Ordinary database system' in FgLoad
2025.06.05 15:57:39.079198 [ 645 ] {} <Debug> AsyncLoader: Finish load job 'startup Ordinary database system' with status OK
2025.06.05 15:57:39.079203 [ 645 ] {} <Debug> AsyncLoader: Spawn loader worker #2 in FgLoad
2025.06.05 15:57:39.079259 [ 645 ] {} <Debug> AsyncLoader: Execute load job 'startup Atomic database system' in FgLoad
2025.06.05 15:57:39.079281 [ 645 ] {} <Debug> AsyncLoader: Finish load job 'startup Atomic database system' with status OK
2025.06.05 15:57:39.079286 [ 645 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2025.06.05 15:57:39.079314 [ 9 ] {} <Debug> SystemLog: Creating system.query_log from query_log
2025.06.05 15:57:39.079381 [ 646 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2025.06.05 15:57:39.079434 [ 646 ] {} <Debug> AsyncLoader: Change current priority: 0 -> none
2025.06.05 15:57:39.080469 [ 9 ] {} <Debug> SystemLog: Creating system.query_thread_log from query_thread_log
2025.06.05 15:57:39.080922 [ 9 ] {} <Debug> SystemLog: Creating system.part_log from part_log
2025.06.05 15:57:39.081402 [ 9 ] {} <Debug> SystemLog: Creating system.trace_log from trace_log
2025.06.05 15:57:39.081618 [ 9 ] {} <Debug> SystemLog: Creating system.crash_log from crash_log
2025.06.05 15:57:39.081773 [ 9 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config
2025.06.05 15:57:39.081787 [ 9 ] {} <Debug> SystemLog: Creating system.metric_log from metric_log
2025.06.05 15:57:39.086679 [ 9 ] {} <Debug> SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config
2025.06.05 15:57:39.086699 [ 9 ] {} <Debug> SystemLog: Not creating system.filesystem_read_prefetches_log since corresponding section 'filesystem_read_prefetches_log' is missing from config
2025.06.05 15:57:39.086711 [ 9 ] {} <Debug> SystemLog: Creating system.asynchronous_metric_log from asynchronous_metric_log
2025.06.05 15:57:39.086941 [ 9 ] {} <Debug> SystemLog: Creating system.opentelemetry_span_log from opentelemetry_span_log
2025.06.05 15:57:39.087234 [ 9 ] {} <Debug> SystemLog: Creating system.query_views_log from query_views_log
2025.06.05 15:57:39.087573 [ 9 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config
2025.06.05 15:57:39.087590 [ 9 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config
2025.06.05 15:57:39.087601 [ 9 ] {} <Debug> SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config
2025.06.05 15:57:39.087611 [ 9 ] {} <Debug> SystemLog: Creating system.processors_profile_log from processors_profile_log
2025.06.05 15:57:39.087826 [ 9 ] {} <Debug> SystemLog: Creating system.asynchronous_insert_log from asynchronous_insert_log
2025.06.05 15:57:39.088139 [ 9 ] {} <Debug> SystemLog: Creating system.backup_log from backup_log
2025.06.05 15:57:39.088376 [ 9 ] {} <Debug> SystemLog: Creating system.s3queue_log from s3queue_log
2025.06.05 15:57:39.088592 [ 9 ] {} <Debug> SystemLog: Creating system.blob_storage_log from blob_storage_log
2025.06.05 15:57:39.103027 [ 9 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal.
2025.06.05 15:57:39.104581 [ 9 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total.
2025.06.05 15:57:39.104594 [ 9 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 5.0986e-05 sec
2025.06.05 15:57:39.104601 [ 9 ] {} <Trace> ReferentialDeps: No tables
2025.06.05 15:57:39.104605 [ 9 ] {} <Trace> LoadingDeps: No tables
2025.06.05 15:57:39.104641 [ 9 ] {} <Information> loadMetadata: Start synchronous loading of databases
2025.06.05 15:57:39.104646 [ 9 ] {} <Information> loadMetadata: Start synchronous startup of databases
2025.06.05 15:57:39.104651 [ 9 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Atomic database default': BgStartup -> FgLoad
2025.06.05 15:57:39.104655 [ 9 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Ordinary database default': BgStartup -> FgLoad
2025.06.05 15:57:39.104661 [ 9 ] {} <Debug> AsyncLoader: Schedule load job 'startup Ordinary database default' into FgLoad
2025.06.05 15:57:39.104665 [ 9 ] {} <Debug> AsyncLoader: Schedule load job 'startup Atomic database default' into FgLoad
2025.06.05 15:57:39.104670 [ 9 ] {} <Debug> AsyncLoader: Change current priority: none -> 0
2025.06.05 15:57:39.104674 [ 9 ] {} <Debug> AsyncLoader: Spawn loader worker #1 in FgLoad
2025.06.05 15:57:39.104740 [ 9 ] {} <Debug> AsyncLoader: Wait load job 'startup Atomic database default' in FgLoad
2025.06.05 15:57:39.104877 [ 660 ] {} <Debug> AsyncLoader: Execute load job 'startup Ordinary database default' in FgLoad
2025.06.05 15:57:39.104938 [ 660 ] {} <Debug> AsyncLoader: Finish load job 'startup Ordinary database default' with status OK
2025.06.05 15:57:39.104945 [ 660 ] {} <Debug> AsyncLoader: Spawn loader worker #2 in FgLoad
2025.06.05 15:57:39.105049 [ 660 ] {} <Debug> AsyncLoader: Execute load job 'startup Atomic database default' in FgLoad
2025.06.05 15:57:39.105067 [ 660 ] {} <Debug> AsyncLoader: Finish load job 'startup Atomic database default' with status OK
2025.06.05 15:57:39.105072 [ 660 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2025.06.05 15:57:39.105192 [ 661 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2025.06.05 15:57:39.105229 [ 661 ] {} <Debug> AsyncLoader: Change current priority: 0 -> none
2025.06.05 15:57:39.105242 [ 9 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/lib/clickhouse/user_defined/
2025.06.05 15:57:39.105282 [ 9 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded
2025.06.05 15:57:39.105288 [ 9 ] {} <Debug> Application: Loaded metadata.
2025.06.05 15:57:39.105316 [ 9 ] {} <Trace> Pipe: Pipe capacity is 1.00 MiB
2025.06.05 15:57:39.105348 [ 9 ] {} <Information> Application: Tasks stats provider: procfs
2025.06.05 15:57:39.105354 [ 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.05 15:57:39.105751 [ 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.10425.altinitystable (altinity build))
2025.06.05 15:57:39.105816 [ 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.10425.altinitystable (altinity build))
2025.06.05 15:57:39.105821 [ 9 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair.
2025.06.05 15:57:39.175952 [ 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.10425.altinitystable (altinity build))
2025.06.05 15:57:39.176022 [ 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.10425.altinitystable (altinity build))
2025.06.05 15:57:39.176027 [ 9 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair.
2025.06.05 15:57:39.303735 [ 9 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again.
2025.06.05 15:57:39.304599 [ 9 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 49.38 MiB, peak 49.38 MiB, free memory in arenas 45.76 MiB, will set to 449.69 MiB (RSS), difference: 400.31 MiB
2025.06.05 15:57:39.306066 [ 9 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 1.5439e-05 sec.
2025.06.05 15:57:39.306877 [ 9 ] {} <Information> Application: Listening for http://[::1]:8123
2025.06.05 15:57:39.306957 [ 9 ] {} <Information> Application: Listening for native protocol (tcp): [::1]:9000
2025.06.05 15:57:39.306997 [ 9 ] {} <Information> Application: Listening for MySQL compatibility protocol: [::1]:9004
2025.06.05 15:57:39.307054 [ 9 ] {} <Information> Application: Listening for PostgreSQL compatibility protocol: [::1]:9005
2025.06.05 15:57:39.307091 [ 9 ] {} <Information> Application: Listening for http://127.0.0.1:8123
2025.06.05 15:57:39.307133 [ 9 ] {} <Information> Application: Listening for native protocol (tcp): 127.0.0.1:9000
2025.06.05 15:57:39.307167 [ 9 ] {} <Information> Application: Listening for MySQL compatibility protocol: 127.0.0.1:9004
2025.06.05 15:57:39.307198 [ 9 ] {} <Information> Application: Listening for PostgreSQL compatibility protocol: 127.0.0.1:9005
2025.06.05 15:57:39.307203 [ 9 ] {} <Information> Application: Ready for connections.
2025.06.05 15:57:40.001043 [ 662 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 449.72 MiB, peak 449.72 MiB, free memory in arenas 45.73 MiB, will set to 452.51 MiB (RSS), difference: 2.79 MiB
2025.06.05 15:57:43.724766 [ 11 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: 127.0.0.1:49710
2025.06.05 15:57:43.724876 [ 11 ] {} <Debug> TCPHandler: Connected ClickHouse client version 24.3.0, revision: 54467, user: default.
2025.06.05 15:57:43.724900 [ 11 ] {} <Debug> TCP-Session: f4225476-d4c3-42a0-9e3d-358a6db3192e Authenticating user 'default' from 127.0.0.1:49710
2025.06.05 15:57:43.724953 [ 11 ] {} <Debug> TCP-Session: f4225476-d4c3-42a0-9e3d-358a6db3192e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
2025.06.05 15:57:43.724961 [ 11 ] {} <Debug> TCP-Session: f4225476-d4c3-42a0-9e3d-358a6db3192e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
2025.06.05 15:57:43.725054 [ 11 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false
2025.06.05 15:57:43.725075 [ 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.05 15:57:43.725091 [ 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.05 15:57:43.735029 [ 11 ] {} <Trace> TCP-Session: f4225476-d4c3-42a0-9e3d-358a6db3192e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
2025.06.05 15:57:43.735245 [ 11 ] {3043ddd3-86fe-4f06-a5ea-79102db190af} <Debug> executeQuery: (from 127.0.0.1:49710) select 'OK' (stage: Complete)
2025.06.05 15:57:43.735444 [ 11 ] {3043ddd3-86fe-4f06-a5ea-79102db190af} <Trace> Planner: Query SELECT 'OK' AS `'OK'` FROM system.one AS __table1 to stage Complete
2025.06.05 15:57:43.735504 [ 11 ] {3043ddd3-86fe-4f06-a5ea-79102db190af} <Trace> ContextAccess (default): Access granted: SELECT(dummy) ON system.one
2025.06.05 15:57:43.735565 [ 11 ] {3043ddd3-86fe-4f06-a5ea-79102db190af} <Trace> Planner: Query SELECT 'OK' AS `'OK'` FROM system.one AS __table1 from stage FetchColumns to stage Complete
2025.06.05 15:57:43.736339 [ 11 ] {3043ddd3-86fe-4f06-a5ea-79102db190af} <Debug> executeQuery: Read 1 rows, 1.00 B in 0.001107 sec., 903.342366757001 rows/sec., 903.34 B/sec.
2025.06.05 15:57:43.736381 [ 11 ] {3043ddd3-86fe-4f06-a5ea-79102db190af} <Debug> TCPHandler: Processed in 0.001464326 sec.
2025.06.05 15:57:43.737428 [ 11 ] {} <Debug> TCPHandler: Done processing connection.
2025.06.05 15:57:43.737467 [ 11 ] {} <Debug> TCP-Session: f4225476-d4c3-42a0-9e3d-358a6db3192e Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db