2025.06.08 16:30:56.192666 [ 8 ] {} <Information> Application: Will watch for the process with pid 10
2025.06.08 16:30:56.192934 [ 10 ] {} <Information> Application: Forked a child process to watch
2025.06.08 16:30:56.193307 [ 10 ] {} <Information> SentryWriter: Sending crash reports is disabled
2025.06.08 16:30:56.193526 [ 10 ] {} <Trace> Pipe: Pipe capacity is 1.00 MiB
2025.06.08 16:30:56.321895 [ 10 ] {} <Information> Application: Starting ClickHouse 24.3.18.10426.altinitystable (revision: 4294967295, git hash: ef8a945bc84037671dd803577841a5e1563cec6e, build id: 69C21F470F1541B3D2881D677C0FA4E2B4612E20), PID 10
2025.06.08 16:30:56.322294 [ 10 ] {} <Information> Application: starting up
2025.06.08 16:30:56.322310 [ 10 ] {} <Information> Application: OS name: Linux, version: 5.15.0-130-generic, architecture: x86_64
2025.06.08 16:30:56.326910 [ 10 ] {} <Information> Application: Available RAM: 30.60 GiB; logical cores: 16; used cores: 16.
2025.06.08 16:30:56.326933 [ 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.08 16:30:56.327056 [ 10 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/thermal
2025.06.08 16:30:56.327070 [ 10 ] {} <Trace> AsynchronousMetrics: Scanning /sys/block
2025.06.08 16:30:56.327152 [ 10 ] {} <Trace> AsynchronousMetrics: Scanning /sys/devices/system/edac
2025.06.08 16:30:56.327166 [ 10 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/hwmon
2025.06.08 16:30:56.331558 [ 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.08 16:30:56.477542 [ 10 ] {} <Information> Application: Integrity check of the executable successfully passed (checksum: 700DFA8A5C97C036D817800264F1BE4B)
2025.06.08 16:30:56.477617 [ 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.08 16:30:56.479817 [ 10 ] {} <Debug> Application: rlimit on number of file descriptors is 1048576
2025.06.08 16:30:56.479828 [ 10 ] {} <Debug> Application: rlimit on number of threads is 18446744073709551615
2025.06.08 16:30:56.479835 [ 10 ] {} <Debug> Application: Initializing DateLUT.
2025.06.08 16:30:56.479839 [ 10 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'.
2025.06.08 16:30:56.479862 [ 10 ] {} <Debug> Context: Setting up /var/lib/clickhouse/tmp/ to store temporary data in it
2025.06.08 16:30:56.480313 [ 10 ] {} <Debug> Application: Configuration parameter 'interserver_http_host' doesn't exist or exists and empty. Will use 'github-hetzner-runner-15520156016-43692750507' as replica host.
2025.06.08 16:30:56.480326 [ 10 ] {} <Debug> Application: Initializing interserver credentials.
2025.06.08 16:30:56.480428 [ 10 ] {} <Trace> NamedCollectionsUtils: Loaded 0 collections from config
2025.06.08 16:30:56.480486 [ 10 ] {} <Trace> NamedCollectionsUtils: Loaded 0 collections from SQL
2025.06.08 16:30:56.480572 [ 10 ] {} <Information> CgroupsMemoryUsageObserver: Will read the current memory usage from '/sys/fs/cgroup/' (cgroups version: v2), wait time is 15 sec
2025.06.08 16:30:56.481006 [ 10 ] {} <Debug> ConfigReloader: Loading config '/config/config.xml'
2025.06.08 16:30:56.481013 [ 10 ] {} <Debug> ConfigProcessor: Processing configuration file '/config/config.xml'.
2025.06.08 16:30:56.485138 [ 10 ] {} <Debug> ConfigProcessor: Saved preprocessed configuration to '/var/lib/clickhouse/preprocessed_configs/config.xml'.
2025.06.08 16:30:56.485206 [ 10 ] {} <Debug> ConfigReloader: Loaded config '/config/config.xml', performing update on configuration
2025.06.08 16:30:56.488968 [ 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.08 16:30:56.488981 [ 10 ] {} <Information> CgroupsMemoryUsageObserver: Set new limits, soft limit: 24.79 GiB, hard limit: 26.16 GiB
2025.06.08 16:30:56.488985 [ 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.08 16:30:56.488989 [ 10 ] {} <Information> Application: Merges and mutations memory limit is set to 15.30 GiB
2025.06.08 16:30:56.489273 [ 10 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads
2025.06.08 16:30:56.492028 [ 10 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 512 threads
2025.06.08 16:30:56.595466 [ 10 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads
2025.06.08 16:30:56.597895 [ 10 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads
2025.06.08 16:30:56.600101 [ 10 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again.
2025.06.08 16:30:56.600379 [ 10 ] {} <Debug> ConfigReloader: Loaded config '/config/config.xml', performed update on configuration
2025.06.08 16:30:56.607022 [ 10 ] {} <Information> Application: Listening for replica communication (interserver): http://[::1]:9009
2025.06.08 16:30:56.607136 [ 10 ] {} <Information> Application: Listening for replica communication (interserver): http://127.0.0.1:9009
2025.06.08 16:30:56.613266 [ 10 ] {} <Debug> ConfigReloader: Loading config '/config/users.xml'
2025.06.08 16:30:56.613289 [ 10 ] {} <Debug> ConfigProcessor: Processing configuration file '/config/users.xml'.
2025.06.08 16:30:56.614263 [ 10 ] {} <Debug> ConfigProcessor: Saved preprocessed configuration to '/var/lib/clickhouse/preprocessed_configs/users.xml'.
2025.06.08 16:30:56.614289 [ 10 ] {} <Debug> ConfigReloader: Loaded config '/config/users.xml', performing update on configuration
2025.06.08 16:30:56.615950 [ 10 ] {} <Debug> ConfigReloader: Loaded config '/config/users.xml', performed update on configuration
2025.06.08 16:30:56.616185 [ 10 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: /config/users.xml
2025.06.08 16:30:56.616382 [ 10 ] {} <Warning> Access(local_directory): File /var/lib/clickhouse/access/users.list doesn't exist
2025.06.08 16:30:56.616401 [ 10 ] {} <Warning> Access(local_directory): Recovering lists in directory /var/lib/clickhouse/access/
2025.06.08 16:30:56.616696 [ 10 ] {} <Debug> Access(user directories): Added local_directory access storage 'local_directory', path: /var/lib/clickhouse/access/
2025.06.08 16:30:56.616881 [ 10 ] {} <Information> CgroupsMemoryUsageObserver: Started cgroup current memory usage observer thread
2025.06.08 16:30:56.617204 [ 581 ] {} <Information> CgroupsMemoryUsageObserver: Memory amount initially available to the process is 30.60 GiB
2025.06.08 16:30:56.618295 [ 10 ] {} <Information> Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32, scheduling_policy=round_robin
2025.06.08 16:30:56.619573 [ 10 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8
2025.06.08 16:30:56.620712 [ 10 ] {} <Information> Context: Initialized background executor for fetches with num_threads=16, num_tasks=16
2025.06.08 16:30:56.621598 [ 10 ] {} <Information> Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8
2025.06.08 16:30:56.623432 [ 10 ] {} <Information> DNSCacheUpdater: Update period 15 seconds
2025.06.08 16:30:56.623478 [ 10 ] {} <Information> Application: Loading metadata from /var/lib/clickhouse/
2025.06.08 16:30:56.623608 [ 48 ] {} <Debug> DNSResolver: Updating DNS cache
2025.06.08 16:30:56.627252 [ 48 ] {} <Debug> DNSResolver: Updated DNS cache
2025.06.08 16:30:56.630719 [ 10 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total.
2025.06.08 16:30:56.630737 [ 10 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 9.2062e-05 sec
2025.06.08 16:30:56.630743 [ 10 ] {} <Trace> ReferentialDeps: No tables
2025.06.08 16:30:56.630748 [ 10 ] {} <Trace> LoadingDeps: No tables
2025.06.08 16:30:56.630818 [ 10 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Atomic database system': BgStartup -> FgLoad
2025.06.08 16:30:56.630826 [ 10 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Ordinary database system': BgStartup -> FgLoad
2025.06.08 16:30:56.630833 [ 10 ] {} <Debug> AsyncLoader: Schedule load job 'startup Ordinary database system' into FgLoad
2025.06.08 16:30:56.630839 [ 10 ] {} <Debug> AsyncLoader: Schedule load job 'startup Atomic database system' into FgLoad
2025.06.08 16:30:56.630845 [ 10 ] {} <Debug> AsyncLoader: Change current priority: none -> 0
2025.06.08 16:30:56.630851 [ 10 ] {} <Debug> AsyncLoader: Spawn loader worker #1 in FgLoad
2025.06.08 16:30:56.630922 [ 10 ] {} <Debug> AsyncLoader: Wait load job 'startup Atomic database system' in FgLoad
2025.06.08 16:30:56.631077 [ 646 ] {} <Debug> AsyncLoader: Execute load job 'startup Ordinary database system' in FgLoad
2025.06.08 16:30:56.631128 [ 646 ] {} <Debug> AsyncLoader: Finish load job 'startup Ordinary database system' with status OK
2025.06.08 16:30:56.631139 [ 646 ] {} <Debug> AsyncLoader: Spawn loader worker #2 in FgLoad
2025.06.08 16:30:56.631273 [ 646 ] {} <Debug> AsyncLoader: Execute load job 'startup Atomic database system' in FgLoad
2025.06.08 16:30:56.631327 [ 646 ] {} <Debug> AsyncLoader: Finish load job 'startup Atomic database system' with status OK
2025.06.08 16:30:56.631334 [ 646 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2025.06.08 16:30:56.631370 [ 10 ] {} <Debug> SystemLog: Creating system.query_log from query_log
2025.06.08 16:30:56.631458 [ 647 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2025.06.08 16:30:56.631518 [ 647 ] {} <Debug> AsyncLoader: Change current priority: 0 -> none
2025.06.08 16:30:56.632886 [ 10 ] {} <Debug> SystemLog: Creating system.query_thread_log from query_thread_log
2025.06.08 16:30:56.633439 [ 10 ] {} <Debug> SystemLog: Creating system.part_log from part_log
2025.06.08 16:30:56.633945 [ 10 ] {} <Debug> SystemLog: Creating system.trace_log from trace_log
2025.06.08 16:30:56.634233 [ 10 ] {} <Debug> SystemLog: Creating system.crash_log from crash_log
2025.06.08 16:30:56.634439 [ 10 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config
2025.06.08 16:30:56.634454 [ 10 ] {} <Debug> SystemLog: Creating system.metric_log from metric_log
2025.06.08 16:30:56.641279 [ 10 ] {} <Debug> SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config
2025.06.08 16:30:56.641301 [ 10 ] {} <Debug> SystemLog: Not creating system.filesystem_read_prefetches_log since corresponding section 'filesystem_read_prefetches_log' is missing from config
2025.06.08 16:30:56.641313 [ 10 ] {} <Debug> SystemLog: Creating system.asynchronous_metric_log from asynchronous_metric_log
2025.06.08 16:30:56.641609 [ 10 ] {} <Debug> SystemLog: Creating system.opentelemetry_span_log from opentelemetry_span_log
2025.06.08 16:30:56.641974 [ 10 ] {} <Debug> SystemLog: Creating system.query_views_log from query_views_log
2025.06.08 16:30:56.642419 [ 10 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config
2025.06.08 16:30:56.642437 [ 10 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config
2025.06.08 16:30:56.642449 [ 10 ] {} <Debug> SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config
2025.06.08 16:30:56.642461 [ 10 ] {} <Debug> SystemLog: Creating system.processors_profile_log from processors_profile_log
2025.06.08 16:30:56.642787 [ 10 ] {} <Debug> SystemLog: Creating system.asynchronous_insert_log from asynchronous_insert_log
2025.06.08 16:30:56.643161 [ 10 ] {} <Debug> SystemLog: Creating system.backup_log from backup_log
2025.06.08 16:30:56.643484 [ 10 ] {} <Debug> SystemLog: Creating system.s3queue_log from s3queue_log
2025.06.08 16:30:56.643760 [ 10 ] {} <Debug> SystemLog: Creating system.blob_storage_log from blob_storage_log
2025.06.08 16:30:56.663993 [ 10 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal.
2025.06.08 16:30:56.666295 [ 10 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total.
2025.06.08 16:30:56.666311 [ 10 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 5.1437e-05 sec
2025.06.08 16:30:56.666318 [ 10 ] {} <Trace> ReferentialDeps: No tables
2025.06.08 16:30:56.666322 [ 10 ] {} <Trace> LoadingDeps: No tables
2025.06.08 16:30:56.666365 [ 10 ] {} <Information> loadMetadata: Start synchronous loading of databases
2025.06.08 16:30:56.666370 [ 10 ] {} <Information> loadMetadata: Start synchronous startup of databases
2025.06.08 16:30:56.666376 [ 10 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Atomic database default': BgStartup -> FgLoad
2025.06.08 16:30:56.666380 [ 10 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Ordinary database default': BgStartup -> FgLoad
2025.06.08 16:30:56.666388 [ 10 ] {} <Debug> AsyncLoader: Schedule load job 'startup Ordinary database default' into FgLoad
2025.06.08 16:30:56.666392 [ 10 ] {} <Debug> AsyncLoader: Schedule load job 'startup Atomic database default' into FgLoad
2025.06.08 16:30:56.666398 [ 10 ] {} <Debug> AsyncLoader: Change current priority: none -> 0
2025.06.08 16:30:56.666402 [ 10 ] {} <Debug> AsyncLoader: Spawn loader worker #1 in FgLoad
2025.06.08 16:30:56.666500 [ 10 ] {} <Debug> AsyncLoader: Wait load job 'startup Atomic database default' in FgLoad
2025.06.08 16:30:56.666641 [ 661 ] {} <Debug> AsyncLoader: Execute load job 'startup Ordinary database default' in FgLoad
2025.06.08 16:30:56.666679 [ 661 ] {} <Debug> AsyncLoader: Finish load job 'startup Ordinary database default' with status OK
2025.06.08 16:30:56.666687 [ 661 ] {} <Debug> AsyncLoader: Spawn loader worker #2 in FgLoad
2025.06.08 16:30:56.666830 [ 661 ] {} <Debug> AsyncLoader: Execute load job 'startup Atomic database default' in FgLoad
2025.06.08 16:30:56.666851 [ 661 ] {} <Debug> AsyncLoader: Finish load job 'startup Atomic database default' with status OK
2025.06.08 16:30:56.666858 [ 661 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2025.06.08 16:30:56.666980 [ 662 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2025.06.08 16:30:56.667028 [ 662 ] {} <Debug> AsyncLoader: Change current priority: 0 -> none
2025.06.08 16:30:56.667072 [ 10 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/lib/clickhouse/user_defined/
2025.06.08 16:30:56.667112 [ 10 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded
2025.06.08 16:30:56.667118 [ 10 ] {} <Debug> Application: Loaded metadata.
2025.06.08 16:30:56.667150 [ 10 ] {} <Trace> Pipe: Pipe capacity is 1.00 MiB
2025.06.08 16:30:56.667191 [ 10 ] {} <Information> Application: Tasks stats provider: procfs
2025.06.08 16:30:56.667197 [ 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.08 16:30:56.667647 [ 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.10426.altinitystable (altinity build))
2025.06.08 16:30:56.667735 [ 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.10426.altinitystable (altinity build))
2025.06.08 16:30:56.667740 [ 10 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair.
2025.06.08 16:30:56.722629 [ 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.10426.altinitystable (altinity build))
2025.06.08 16:30:56.722686 [ 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.10426.altinitystable (altinity build))
2025.06.08 16:30:56.722690 [ 10 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair.
2025.06.08 16:30:56.766876 [ 10 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again.
2025.06.08 16:30:56.767957 [ 10 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 49.41 MiB, peak 49.41 MiB, free memory in arenas 43.50 MiB, will set to 449.86 MiB (RSS), difference: 400.45 MiB
2025.06.08 16:30:56.769325 [ 10 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 1.581e-05 sec.
2025.06.08 16:30:56.770296 [ 10 ] {} <Information> Application: Listening for http://[::1]:8123
2025.06.08 16:30:56.770336 [ 10 ] {} <Information> Application: Listening for native protocol (tcp): [::1]:9000
2025.06.08 16:30:56.770380 [ 10 ] {} <Information> Application: Listening for MySQL compatibility protocol: [::1]:9004
2025.06.08 16:30:56.770411 [ 10 ] {} <Information> Application: Listening for PostgreSQL compatibility protocol: [::1]:9005
2025.06.08 16:30:56.770442 [ 10 ] {} <Information> Application: Listening for http://127.0.0.1:8123
2025.06.08 16:30:56.770474 [ 10 ] {} <Information> Application: Listening for native protocol (tcp): 127.0.0.1:9000
2025.06.08 16:30:56.770504 [ 10 ] {} <Information> Application: Listening for MySQL compatibility protocol: 127.0.0.1:9004
2025.06.08 16:30:56.770541 [ 10 ] {} <Information> Application: Listening for PostgreSQL compatibility protocol: 127.0.0.1:9005
2025.06.08 16:30:56.770545 [ 10 ] {} <Information> Application: Ready for connections.
2025.06.08 16:30:57.001131 [ 663 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 449.88 MiB, peak 449.88 MiB, free memory in arenas 43.57 MiB, will set to 452.61 MiB (RSS), difference: 2.73 MiB
2025.06.08 16:31:01.172508 [ 12 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:55786
2025.06.08 16:31:01.172707 [ 12 ] {} <Debug> TCPHandler: Connected ClickHouse client version 24.3.0, revision: 54467, user: default.
2025.06.08 16:31:01.172788 [ 12 ] {} <Debug> TCP-Session: b88213e4-9b34-4cba-9f29-a71734d52c94 Authenticating user 'default' from [::1]:55786
2025.06.08 16:31:01.172838 [ 12 ] {} <Debug> TCP-Session: b88213e4-9b34-4cba-9f29-a71734d52c94 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
2025.06.08 16:31:01.172867 [ 12 ] {} <Debug> TCP-Session: b88213e4-9b34-4cba-9f29-a71734d52c94 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
2025.06.08 16:31:01.173041 [ 12 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false
2025.06.08 16:31:01.173080 [ 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.08 16:31:01.173115 [ 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.08 16:31:01.190769 [ 12 ] {} <Trace> TCP-Session: b88213e4-9b34-4cba-9f29-a71734d52c94 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
2025.06.08 16:31:01.191234 [ 12 ] {843f77e5-438e-4254-bbae-5ea7f7a7c542} <Debug> executeQuery: (from [::1]:55786) select 'OK' (stage: Complete)
2025.06.08 16:31:01.191543 [ 12 ] {843f77e5-438e-4254-bbae-5ea7f7a7c542} <Trace> Planner: Query SELECT 'OK' AS `'OK'` FROM system.one AS __table1 to stage Complete
2025.06.08 16:31:01.191591 [ 12 ] {843f77e5-438e-4254-bbae-5ea7f7a7c542} <Trace> ContextAccess (default): Access granted: SELECT(dummy) ON system.one
2025.06.08 16:31:01.191683 [ 12 ] {843f77e5-438e-4254-bbae-5ea7f7a7c542} <Trace> Planner: Query SELECT 'OK' AS `'OK'` FROM system.one AS __table1 from stage FetchColumns to stage Complete
2025.06.08 16:31:01.192943 [ 12 ] {843f77e5-438e-4254-bbae-5ea7f7a7c542} <Debug> executeQuery: Read 1 rows, 1.00 B in 0.001735 sec., 576.3688760806916 rows/sec., 576.37 B/sec.
2025.06.08 16:31:01.193004 [ 12 ] {843f77e5-438e-4254-bbae-5ea7f7a7c542} <Debug> TCPHandler: Processed in 0.002405961 sec.
2025.06.08 16:31:01.194751 [ 12 ] {} <Debug> TCPHandler: Done processing connection.
2025.06.08 16:31:01.194790 [ 12 ] {} <Debug> TCP-Session: b88213e4-9b34-4cba-9f29-a71734d52c94 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
2025.06.08 16:31:01.584330 [ 7 ] {} <Information> Application: Will watch for the process with pid 9
2025.06.08 16:31:01.584484 [ 9 ] {} <Information> Application: Forked a child process to watch
2025.06.08 16:31:01.584776 [ 9 ] {} <Information> SentryWriter: Sending crash reports is disabled
2025.06.08 16:31:01.584932 [ 9 ] {} <Trace> Pipe: Pipe capacity is 1.00 MiB
2025.06.08 16:31:01.686759 [ 9 ] {} <Information> Application: Starting ClickHouse 24.3.18.10426.altinitystable (revision: 4294967295, git hash: ef8a945bc84037671dd803577841a5e1563cec6e, build id: 69C21F470F1541B3D2881D677C0FA4E2B4612E20), PID 9
2025.06.08 16:31:01.686951 [ 9 ] {} <Information> Application: starting up
2025.06.08 16:31:01.686970 [ 9 ] {} <Information> Application: OS name: Linux, version: 5.15.0-130-generic, architecture: x86_64
2025.06.08 16:31:01.691793 [ 9 ] {} <Information> Application: Available RAM: 30.60 GiB; logical cores: 16; used cores: 16.
2025.06.08 16:31:01.691817 [ 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.08 16:31:01.691956 [ 9 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/thermal
2025.06.08 16:31:01.691968 [ 9 ] {} <Trace> AsynchronousMetrics: Scanning /sys/block
2025.06.08 16:31:01.692045 [ 9 ] {} <Trace> AsynchronousMetrics: Scanning /sys/devices/system/edac
2025.06.08 16:31:01.692059 [ 9 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/hwmon
2025.06.08 16:31:01.696478 [ 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.08 16:31:01.848416 [ 9 ] {} <Information> Application: Integrity check of the executable successfully passed (checksum: 700DFA8A5C97C036D817800264F1BE4B)
2025.06.08 16:31:01.848495 [ 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.08 16:31:01.850954 [ 9 ] {} <Debug> Application: rlimit on number of file descriptors is 1048576
2025.06.08 16:31:01.850967 [ 9 ] {} <Debug> Application: rlimit on number of threads is 18446744073709551615
2025.06.08 16:31:01.850975 [ 9 ] {} <Debug> Application: Initializing DateLUT.
2025.06.08 16:31:01.850979 [ 9 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'.
2025.06.08 16:31:01.851000 [ 9 ] {} <Debug> Context: Setting up /var/lib/clickhouse/tmp/ to store temporary data in it
2025.06.08 16:31:01.851469 [ 9 ] {} <Debug> Application: Configuration parameter 'interserver_http_host' doesn't exist or exists and empty. Will use 'github-hetzner-runner-15520156016-43692750507' as replica host.
2025.06.08 16:31:01.851482 [ 9 ] {} <Debug> Application: Initializing interserver credentials.
2025.06.08 16:31:01.851589 [ 9 ] {} <Trace> NamedCollectionsUtils: Loaded 0 collections from config
2025.06.08 16:31:01.851648 [ 9 ] {} <Trace> NamedCollectionsUtils: Loaded 0 collections from SQL
2025.06.08 16:31:01.851737 [ 9 ] {} <Information> CgroupsMemoryUsageObserver: Will read the current memory usage from '/sys/fs/cgroup/' (cgroups version: v2), wait time is 15 sec
2025.06.08 16:31:01.852150 [ 9 ] {} <Debug> ConfigReloader: Loading config '/config/config.xml'
2025.06.08 16:31:01.852157 [ 9 ] {} <Debug> ConfigProcessor: Processing configuration file '/config/config.xml'.
2025.06.08 16:31:01.856139 [ 9 ] {} <Debug> ConfigProcessor: Saved preprocessed configuration to '/var/lib/clickhouse/preprocessed_configs/config.xml'.
2025.06.08 16:31:01.856214 [ 9 ] {} <Debug> ConfigReloader: Loaded config '/config/config.xml', performing update on configuration
2025.06.08 16:31:01.860034 [ 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.08 16:31:01.860045 [ 9 ] {} <Information> CgroupsMemoryUsageObserver: Set new limits, soft limit: 24.79 GiB, hard limit: 26.16 GiB
2025.06.08 16:31:01.860050 [ 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.08 16:31:01.860054 [ 9 ] {} <Information> Application: Merges and mutations memory limit is set to 15.30 GiB
2025.06.08 16:31:01.860354 [ 9 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads
2025.06.08 16:31:01.863350 [ 9 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 512 threads
2025.06.08 16:31:01.959128 [ 9 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads
2025.06.08 16:31:01.966591 [ 9 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads
2025.06.08 16:31:01.973517 [ 9 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again.
2025.06.08 16:31:01.973889 [ 9 ] {} <Debug> ConfigReloader: Loaded config '/config/config.xml', performed update on configuration
2025.06.08 16:31:01.976799 [ 9 ] {} <Information> Application: Listening for replica communication (interserver): http://[::1]:9009
2025.06.08 16:31:01.977919 [ 9 ] {} <Information> Application: Listening for replica communication (interserver): http://127.0.0.1:9009
2025.06.08 16:31:01.981323 [ 9 ] {} <Debug> ConfigReloader: Loading config '/config/users.xml'
2025.06.08 16:31:01.981349 [ 9 ] {} <Debug> ConfigProcessor: Processing configuration file '/config/users.xml'.
2025.06.08 16:31:01.982336 [ 9 ] {} <Debug> ConfigProcessor: Saved preprocessed configuration to '/var/lib/clickhouse/preprocessed_configs/users.xml'.
2025.06.08 16:31:01.982371 [ 9 ] {} <Debug> ConfigReloader: Loaded config '/config/users.xml', performing update on configuration
2025.06.08 16:31:01.984089 [ 9 ] {} <Debug> ConfigReloader: Loaded config '/config/users.xml', performed update on configuration
2025.06.08 16:31:01.984465 [ 9 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: /config/users.xml
2025.06.08 16:31:01.984685 [ 9 ] {} <Warning> Access(local_directory): File /var/lib/clickhouse/access/users.list doesn't exist
2025.06.08 16:31:01.984707 [ 9 ] {} <Warning> Access(local_directory): Recovering lists in directory /var/lib/clickhouse/access/
2025.06.08 16:31:01.985118 [ 9 ] {} <Debug> Access(user directories): Added local_directory access storage 'local_directory', path: /var/lib/clickhouse/access/
2025.06.08 16:31:01.985285 [ 9 ] {} <Information> CgroupsMemoryUsageObserver: Started cgroup current memory usage observer thread
2025.06.08 16:31:01.985652 [ 580 ] {} <Information> CgroupsMemoryUsageObserver: Memory amount initially available to the process is 30.60 GiB
2025.06.08 16:31:01.986669 [ 9 ] {} <Information> Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32, scheduling_policy=round_robin
2025.06.08 16:31:01.987413 [ 9 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8
2025.06.08 16:31:01.988556 [ 9 ] {} <Information> Context: Initialized background executor for fetches with num_threads=16, num_tasks=16
2025.06.08 16:31:01.989307 [ 9 ] {} <Information> Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8
2025.06.08 16:31:01.997124 [ 9 ] {} <Information> DNSCacheUpdater: Update period 15 seconds
2025.06.08 16:31:01.997182 [ 9 ] {} <Information> Application: Loading metadata from /var/lib/clickhouse/
2025.06.08 16:31:01.997333 [ 30 ] {} <Debug> DNSResolver: Updating DNS cache
2025.06.08 16:31:01.998565 [ 30 ] {} <Debug> DNSResolver: Updated DNS cache
2025.06.08 16:31:02.004620 [ 9 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total.
2025.06.08 16:31:02.004645 [ 9 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.000132538 sec
2025.06.08 16:31:02.004655 [ 9 ] {} <Trace> ReferentialDeps: No tables
2025.06.08 16:31:02.004662 [ 9 ] {} <Trace> LoadingDeps: No tables
2025.06.08 16:31:02.004812 [ 9 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Atomic database system': BgStartup -> FgLoad
2025.06.08 16:31:02.004829 [ 9 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Ordinary database system': BgStartup -> FgLoad
2025.06.08 16:31:02.004840 [ 9 ] {} <Debug> AsyncLoader: Schedule load job 'startup Ordinary database system' into FgLoad
2025.06.08 16:31:02.004849 [ 9 ] {} <Debug> AsyncLoader: Schedule load job 'startup Atomic database system' into FgLoad
2025.06.08 16:31:02.004858 [ 9 ] {} <Debug> AsyncLoader: Change current priority: none -> 0
2025.06.08 16:31:02.004884 [ 9 ] {} <Debug> AsyncLoader: Spawn loader worker #1 in FgLoad
2025.06.08 16:31:02.004988 [ 9 ] {} <Debug> AsyncLoader: Wait load job 'startup Atomic database system' in FgLoad
2025.06.08 16:31:02.005113 [ 645 ] {} <Debug> AsyncLoader: Execute load job 'startup Ordinary database system' in FgLoad
2025.06.08 16:31:02.005161 [ 645 ] {} <Debug> AsyncLoader: Finish load job 'startup Ordinary database system' with status OK
2025.06.08 16:31:02.005170 [ 645 ] {} <Debug> AsyncLoader: Spawn loader worker #2 in FgLoad
2025.06.08 16:31:02.005276 [ 645 ] {} <Debug> AsyncLoader: Execute load job 'startup Atomic database system' in FgLoad
2025.06.08 16:31:02.005312 [ 645 ] {} <Debug> AsyncLoader: Finish load job 'startup Atomic database system' with status OK
2025.06.08 16:31:02.005319 [ 645 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2025.06.08 16:31:02.005408 [ 9 ] {} <Debug> SystemLog: Creating system.query_log from query_log
2025.06.08 16:31:02.005404 [ 646 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2025.06.08 16:31:02.005463 [ 646 ] {} <Debug> AsyncLoader: Change current priority: 0 -> none
2025.06.08 16:31:02.007553 [ 9 ] {} <Debug> SystemLog: Creating system.query_thread_log from query_thread_log
2025.06.08 16:31:02.008555 [ 9 ] {} <Debug> SystemLog: Creating system.part_log from part_log
2025.06.08 16:31:02.009461 [ 9 ] {} <Debug> SystemLog: Creating system.trace_log from trace_log
2025.06.08 16:31:02.009973 [ 9 ] {} <Debug> SystemLog: Creating system.crash_log from crash_log
2025.06.08 16:31:02.010333 [ 9 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config
2025.06.08 16:31:02.010357 [ 9 ] {} <Debug> SystemLog: Creating system.metric_log from metric_log
2025.06.08 16:31:02.019886 [ 9 ] {} <Debug> SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config
2025.06.08 16:31:02.019918 [ 9 ] {} <Debug> SystemLog: Not creating system.filesystem_read_prefetches_log since corresponding section 'filesystem_read_prefetches_log' is missing from config
2025.06.08 16:31:02.019938 [ 9 ] {} <Debug> SystemLog: Creating system.asynchronous_metric_log from asynchronous_metric_log
2025.06.08 16:31:02.020388 [ 9 ] {} <Debug> SystemLog: Creating system.opentelemetry_span_log from opentelemetry_span_log
2025.06.08 16:31:02.020952 [ 9 ] {} <Debug> SystemLog: Creating system.query_views_log from query_views_log
2025.06.08 16:31:02.021618 [ 9 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config
2025.06.08 16:31:02.021645 [ 9 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config
2025.06.08 16:31:02.021663 [ 9 ] {} <Debug> SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config
2025.06.08 16:31:02.021680 [ 9 ] {} <Debug> SystemLog: Creating system.processors_profile_log from processors_profile_log
2025.06.08 16:31:02.022167 [ 9 ] {} <Debug> SystemLog: Creating system.asynchronous_insert_log from asynchronous_insert_log
2025.06.08 16:31:02.022697 [ 9 ] {} <Debug> SystemLog: Creating system.backup_log from backup_log
2025.06.08 16:31:02.023171 [ 9 ] {} <Debug> SystemLog: Creating system.s3queue_log from s3queue_log
2025.06.08 16:31:02.023580 [ 9 ] {} <Debug> SystemLog: Creating system.blob_storage_log from blob_storage_log
2025.06.08 16:31:02.051063 [ 9 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal.
2025.06.08 16:31:02.053534 [ 9 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total.
2025.06.08 16:31:02.053549 [ 9 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 5.389e-05 sec
2025.06.08 16:31:02.053557 [ 9 ] {} <Trace> ReferentialDeps: No tables
2025.06.08 16:31:02.053561 [ 9 ] {} <Trace> LoadingDeps: No tables
2025.06.08 16:31:02.053614 [ 9 ] {} <Information> loadMetadata: Start synchronous loading of databases
2025.06.08 16:31:02.053620 [ 9 ] {} <Information> loadMetadata: Start synchronous startup of databases
2025.06.08 16:31:02.053626 [ 9 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Atomic database default': BgStartup -> FgLoad
2025.06.08 16:31:02.053631 [ 9 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Ordinary database default': BgStartup -> FgLoad
2025.06.08 16:31:02.053639 [ 9 ] {} <Debug> AsyncLoader: Schedule load job 'startup Ordinary database default' into FgLoad
2025.06.08 16:31:02.053644 [ 9 ] {} <Debug> AsyncLoader: Schedule load job 'startup Atomic database default' into FgLoad
2025.06.08 16:31:02.053650 [ 9 ] {} <Debug> AsyncLoader: Change current priority: none -> 0
2025.06.08 16:31:02.053655 [ 9 ] {} <Debug> AsyncLoader: Spawn loader worker #1 in FgLoad
2025.06.08 16:31:02.053755 [ 9 ] {} <Debug> AsyncLoader: Wait load job 'startup Atomic database default' in FgLoad
2025.06.08 16:31:02.053943 [ 660 ] {} <Debug> AsyncLoader: Execute load job 'startup Ordinary database default' in FgLoad
2025.06.08 16:31:02.053990 [ 660 ] {} <Debug> AsyncLoader: Finish load job 'startup Ordinary database default' with status OK
2025.06.08 16:31:02.054000 [ 660 ] {} <Debug> AsyncLoader: Spawn loader worker #2 in FgLoad
2025.06.08 16:31:02.054119 [ 660 ] {} <Debug> AsyncLoader: Execute load job 'startup Atomic database default' in FgLoad
2025.06.08 16:31:02.054141 [ 660 ] {} <Debug> AsyncLoader: Finish load job 'startup Atomic database default' with status OK
2025.06.08 16:31:02.054149 [ 660 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2025.06.08 16:31:02.054167 [ 660 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2025.06.08 16:31:02.054177 [ 660 ] {} <Debug> AsyncLoader: Change current priority: 0 -> none
2025.06.08 16:31:02.054295 [ 9 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/lib/clickhouse/user_defined/
2025.06.08 16:31:02.054342 [ 9 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded
2025.06.08 16:31:02.054348 [ 9 ] {} <Debug> Application: Loaded metadata.
2025.06.08 16:31:02.054380 [ 9 ] {} <Trace> Pipe: Pipe capacity is 1.00 MiB
2025.06.08 16:31:02.054426 [ 9 ] {} <Information> Application: Tasks stats provider: procfs
2025.06.08 16:31:02.054453 [ 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.08 16:31:02.055012 [ 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.10426.altinitystable (altinity build))
2025.06.08 16:31:02.055099 [ 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.10426.altinitystable (altinity build))
2025.06.08 16:31:02.055105 [ 9 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair.
2025.06.08 16:31:02.116975 [ 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.10426.altinitystable (altinity build))
2025.06.08 16:31:02.117041 [ 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.10426.altinitystable (altinity build))
2025.06.08 16:31:02.117045 [ 9 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair.
2025.06.08 16:31:02.192054 [ 9 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again.
2025.06.08 16:31:02.192924 [ 9 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 49.45 MiB, peak 49.45 MiB, free memory in arenas 39.83 MiB, will set to 449.38 MiB (RSS), difference: 399.92 MiB
2025.06.08 16:31:02.194599 [ 9 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 1.5328e-05 sec.
2025.06.08 16:31:02.195604 [ 9 ] {} <Information> Application: Listening for http://[::1]:8123
2025.06.08 16:31:02.195646 [ 9 ] {} <Information> Application: Listening for native protocol (tcp): [::1]:9000
2025.06.08 16:31:02.195680 [ 9 ] {} <Information> Application: Listening for MySQL compatibility protocol: [::1]:9004
2025.06.08 16:31:02.195748 [ 9 ] {} <Information> Application: Listening for PostgreSQL compatibility protocol: [::1]:9005
2025.06.08 16:31:02.195783 [ 9 ] {} <Information> Application: Listening for http://127.0.0.1:8123
2025.06.08 16:31:02.195825 [ 9 ] {} <Information> Application: Listening for native protocol (tcp): 127.0.0.1:9000
2025.06.08 16:31:02.195857 [ 9 ] {} <Information> Application: Listening for MySQL compatibility protocol: 127.0.0.1:9004
2025.06.08 16:31:02.195903 [ 9 ] {} <Information> Application: Listening for PostgreSQL compatibility protocol: 127.0.0.1:9005
2025.06.08 16:31:02.195907 [ 9 ] {} <Information> Application: Ready for connections.
2025.06.08 16:31:03.001010 [ 660 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 449.40 MiB, peak 449.40 MiB, free memory in arenas 39.89 MiB, will set to 452.02 MiB (RSS), difference: 2.62 MiB
2025.06.08 16:31:06.568121 [ 11 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: 127.0.0.1:56570
2025.06.08 16:31:06.568341 [ 11 ] {} <Debug> TCPHandler: Connected ClickHouse client version 24.3.0, revision: 54467, user: default.
2025.06.08 16:31:06.568378 [ 11 ] {} <Debug> TCP-Session: 47aa15dd-eeeb-4888-8ec6-153138acd2b9 Authenticating user 'default' from 127.0.0.1:56570
2025.06.08 16:31:06.568430 [ 11 ] {} <Debug> TCP-Session: 47aa15dd-eeeb-4888-8ec6-153138acd2b9 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
2025.06.08 16:31:06.568445 [ 11 ] {} <Debug> TCP-Session: 47aa15dd-eeeb-4888-8ec6-153138acd2b9 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
2025.06.08 16:31:06.568640 [ 11 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false
2025.06.08 16:31:06.568679 [ 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.08 16:31:06.568706 [ 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.08 16:31:06.589495 [ 11 ] {} <Trace> TCP-Session: 47aa15dd-eeeb-4888-8ec6-153138acd2b9 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
2025.06.08 16:31:06.589941 [ 11 ] {73d22dc0-cd4c-45d2-af28-73914946ce2c} <Debug> executeQuery: (from 127.0.0.1:56570) select 'OK' (stage: Complete)
2025.06.08 16:31:06.590255 [ 11 ] {73d22dc0-cd4c-45d2-af28-73914946ce2c} <Trace> Planner: Query SELECT 'OK' AS `'OK'` FROM system.one AS __table1 to stage Complete
2025.06.08 16:31:06.590304 [ 11 ] {73d22dc0-cd4c-45d2-af28-73914946ce2c} <Trace> ContextAccess (default): Access granted: SELECT(dummy) ON system.one
2025.06.08 16:31:06.590394 [ 11 ] {73d22dc0-cd4c-45d2-af28-73914946ce2c} <Trace> Planner: Query SELECT 'OK' AS `'OK'` FROM system.one AS __table1 from stage FetchColumns to stage Complete
2025.06.08 16:31:06.591662 [ 11 ] {73d22dc0-cd4c-45d2-af28-73914946ce2c} <Debug> executeQuery: Read 1 rows, 1.00 B in 0.001758 sec., 568.8282138794084 rows/sec., 568.83 B/sec.
2025.06.08 16:31:06.591721 [ 11 ] {73d22dc0-cd4c-45d2-af28-73914946ce2c} <Debug> TCPHandler: Processed in 0.002477657 sec.
2025.06.08 16:31:06.594005 [ 11 ] {} <Debug> TCPHandler: Done processing connection.
2025.06.08 16:31:06.594046 [ 11 ] {} <Debug> TCP-Session: 47aa15dd-eeeb-4888-8ec6-153138acd2b9 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db