2026.10.28 16:38:48.419502 [ 8 ] {} <Information> Application: Will watch for the process with pid 10
2026.10.28 16:38:48.419796 [ 10 ] {} <Information> Application: Forked a child process to watch
2026.10.28 16:38:48.420294 [ 10 ] {} <Information> SentryWriter: Sending crash reports is disabled
2026.10.28 16:38:48.420566 [ 10 ] {} <Trace> Pipe: Pipe capacity is 1.00 MiB
2026.10.28 16:38:48.528232 [ 10 ] {} <Information> Application: Starting ClickHouse 24.3.18.10333.altinitystable (revision: 54496, git hash: e722d52227cc94f272a82f47e86c5818a05d098b, build id: 02E9FF5C876E3FCCAF3D208282C61399A1810A62), PID 10
2026.10.28 16:38:48.528391 [ 10 ] {} <Information> Application: starting up
2026.10.28 16:38:48.528409 [ 10 ] {} <Information> Application: OS name: Linux, version: 5.15.0-130-generic, architecture: x86_64
2026.10.28 16:38:48.533250 [ 10 ] {} <Information> Application: Available RAM: 30.59 GiB; logical cores: 16; used cores: 16.
2026.10.28 16:38:48.533292 [ 10 ] {} <Information> Application: Available CPU instruction sets: SSE, SSE2, SSE3, SSSE3, SSE41, SSE42, F16C, POPCNT, BMI1, BMI2, PCLMUL, AES, AVX, FMA, AVX2, AVX512F, AVX512DQ, AVX512IFMA, AVX512CD, AVX512BW, AVX512VL, AVX512VBMI, AVX512VBMI2, SHA, ADX, RDRAND, RDSEED, RDTSCP, CLFLUSHOPT, CLWB, XSAVE, OSXSAVE
2026.10.28 16:38:48.533451 [ 10 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/thermal
2026.10.28 16:38:48.533467 [ 10 ] {} <Trace> AsynchronousMetrics: Scanning /sys/block
2026.10.28 16:38:48.533562 [ 10 ] {} <Trace> AsynchronousMetrics: Scanning /sys/devices/system/edac
2026.10.28 16:38:48.533580 [ 10 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/hwmon
2026.10.28 16:38:48.537020 [ 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.
2026.10.28 16:38:48.666686 [ 10 ] {} <Information> Application: Integrity check of the executable successfully passed (checksum: D0EF1C7C14C3CE170EF774E2FD80FE0A)
2026.10.28 16:38:48.666753 [ 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.
2026.10.28 16:38:48.668936 [ 10 ] {} <Debug> Application: rlimit on number of file descriptors is 1048576
2026.10.28 16:38:48.668948 [ 10 ] {} <Debug> Application: rlimit on number of threads is 18446744073709551615
2026.10.28 16:38:48.668963 [ 10 ] {} <Debug> Application: Initializing DateLUT.
2026.10.28 16:38:48.668967 [ 10 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'.
2026.10.28 16:38:48.668991 [ 10 ] {} <Debug> Context: Setting up /var/lib/clickhouse/tmp/ to store temporary data in it
2026.10.28 16:38:48.669546 [ 10 ] {} <Debug> Application: Configuration parameter 'interserver_http_host' doesn't exist or exists and empty. Will use 'github-hetzner-runner-40711268593-122914749824' as replica host.
2026.10.28 16:38:48.669559 [ 10 ] {} <Debug> Application: Initializing interserver credentials.
2026.10.28 16:38:48.669649 [ 10 ] {} <Trace> NamedCollectionsUtils: Loaded 0 collections from config
2026.10.28 16:38:48.669729 [ 10 ] {} <Trace> NamedCollectionsUtils: Loaded 0 collections from SQL
2026.10.28 16:38:48.669840 [ 10 ] {} <Information> CgroupsMemoryUsageObserver: Will read the current memory usage from '/sys/fs/cgroup/' (cgroups version: v2), wait time is 15 sec
2026.10.28 16:38:48.670057 [ 10 ] {} <Debug> ConfigReloader: Loading config '/config/config.xml'
2026.10.28 16:38:48.670064 [ 10 ] {} <Debug> ConfigProcessor: Processing configuration file '/config/config.xml'.
2026.10.28 16:38:48.673093 [ 10 ] {} <Debug> ConfigProcessor: Saved preprocessed configuration to '/var/lib/clickhouse/preprocessed_configs/config.xml'.
2026.10.28 16:38:48.673155 [ 10 ] {} <Debug> ConfigReloader: Loaded config '/config/config.xml', performing update on configuration
2026.10.28 16:38:48.676173 [ 10 ] {} <Information> Application: Setting max_server_memory_usage was set to 27.54 GiB (30.59 GiB available * 0.90 max_server_memory_usage_to_ram_ratio)
2026.10.28 16:38:48.676182 [ 10 ] {} <Information> CgroupsMemoryUsageObserver: Set new limits, soft limit: 24.78 GiB, hard limit: 26.16 GiB
2026.10.28 16:38:48.676187 [ 10 ] {} <Information> Application: Setting merges_mutations_memory_usage_soft_limit was set to 15.30 GiB (30.59 GiB available * 0.50 merges_mutations_memory_usage_to_ram_ratio)
2026.10.28 16:38:48.676191 [ 10 ] {} <Information> Application: Merges and mutations memory limit is set to 15.30 GiB
2026.10.28 16:38:48.676474 [ 10 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads
2026.10.28 16:38:48.677950 [ 10 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 512 threads
2026.10.28 16:38:48.769778 [ 10 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads
2026.10.28 16:38:48.772093 [ 10 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads
2026.10.28 16:38:48.774897 [ 10 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again.
2026.10.28 16:38:48.774984 [ 10 ] {} <Debug> ConfigReloader: Loaded config '/config/config.xml', performed update on configuration
2026.10.28 16:38:48.784829 [ 10 ] {} <Information> Application: Listening for replica communication (interserver): http://[::1]:9009
2026.10.28 16:38:48.799880 [ 10 ] {} <Information> Application: Listening for replica communication (interserver): http://127.0.0.1:9009
2026.10.28 16:38:48.833269 [ 10 ] {} <Debug> ConfigReloader: Loading config '/config/users.xml'
2026.10.28 16:38:48.833302 [ 10 ] {} <Debug> ConfigProcessor: Processing configuration file '/config/users.xml'.
2026.10.28 16:38:48.834519 [ 10 ] {} <Debug> ConfigProcessor: Saved preprocessed configuration to '/var/lib/clickhouse/preprocessed_configs/users.xml'.
2026.10.28 16:38:48.834552 [ 10 ] {} <Debug> ConfigReloader: Loaded config '/config/users.xml', performing update on configuration
2026.10.28 16:38:48.835982 [ 10 ] {} <Debug> ConfigReloader: Loaded config '/config/users.xml', performed update on configuration
2026.10.28 16:38:48.836188 [ 10 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: /config/users.xml
2026.10.28 16:38:48.836473 [ 10 ] {} <Warning> Access(local_directory): File /var/lib/clickhouse/access/users.list doesn't exist
2026.10.28 16:38:48.836498 [ 10 ] {} <Warning> Access(local_directory): Recovering lists in directory /var/lib/clickhouse/access/
2026.10.28 16:38:48.836949 [ 10 ] {} <Debug> Access(user directories): Added local_directory access storage 'local_directory', path: /var/lib/clickhouse/access/
2026.10.28 16:38:48.837163 [ 10 ] {} <Information> CgroupsMemoryUsageObserver: Started cgroup current memory usage observer thread
2026.10.28 16:38:48.837715 [ 581 ] {} <Information> CgroupsMemoryUsageObserver: Memory amount initially available to the process is 30.59 GiB
2026.10.28 16:38:48.839392 [ 10 ] {} <Information> Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32, scheduling_policy=round_robin
2026.10.28 16:38:48.840380 [ 10 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8
2026.10.28 16:38:48.842233 [ 10 ] {} <Information> Context: Initialized background executor for fetches with num_threads=16, num_tasks=16
2026.10.28 16:38:48.843440 [ 10 ] {} <Information> Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8
2026.10.28 16:38:48.845659 [ 10 ] {} <Information> DNSCacheUpdater: Update period 15 seconds
2026.10.28 16:38:48.845706 [ 10 ] {} <Information> Application: Loading metadata from /var/lib/clickhouse/
2026.10.28 16:38:48.846475 [ 44 ] {} <Debug> DNSResolver: Updating DNS cache
2026.10.28 16:38:48.852388 [ 44 ] {} <Debug> DNSResolver: Updated DNS cache
2026.10.28 16:38:48.854054 [ 10 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total.
2026.10.28 16:38:48.854078 [ 10 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.00016603 sec
2026.10.28 16:38:48.854089 [ 10 ] {} <Trace> ReferentialDeps: No tables
2026.10.28 16:38:48.854099 [ 10 ] {} <Trace> LoadingDeps: No tables
2026.10.28 16:38:48.854161 [ 10 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Atomic database system': BgStartup -> FgLoad
2026.10.28 16:38:48.854178 [ 10 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Ordinary database system': BgStartup -> FgLoad
2026.10.28 16:38:48.854192 [ 10 ] {} <Debug> AsyncLoader: Schedule load job 'startup Ordinary database system' into FgLoad
2026.10.28 16:38:48.854202 [ 10 ] {} <Debug> AsyncLoader: Schedule load job 'startup Atomic database system' into FgLoad
2026.10.28 16:38:48.854212 [ 10 ] {} <Debug> AsyncLoader: Change current priority: none -> 0
2026.10.28 16:38:48.854221 [ 10 ] {} <Debug> AsyncLoader: Spawn loader worker #1 in FgLoad
2026.10.28 16:38:48.854358 [ 10 ] {} <Debug> AsyncLoader: Wait load job 'startup Atomic database system' in FgLoad
2026.10.28 16:38:48.854470 [ 646 ] {} <Debug> AsyncLoader: Execute load job 'startup Ordinary database system' in FgLoad
2026.10.28 16:38:48.854532 [ 646 ] {} <Debug> AsyncLoader: Finish load job 'startup Ordinary database system' with status OK
2026.10.28 16:38:48.854545 [ 646 ] {} <Debug> AsyncLoader: Spawn loader worker #2 in FgLoad
2026.10.28 16:38:48.854705 [ 646 ] {} <Debug> AsyncLoader: Execute load job 'startup Atomic database system' in FgLoad
2026.10.28 16:38:48.854753 [ 646 ] {} <Debug> AsyncLoader: Finish load job 'startup Atomic database system' with status OK
2026.10.28 16:38:48.854770 [ 646 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2026.10.28 16:38:48.854809 [ 10 ] {} <Debug> SystemLog: Creating system.query_log from query_log
2026.10.28 16:38:48.854861 [ 647 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2026.10.28 16:38:48.854931 [ 647 ] {} <Debug> AsyncLoader: Change current priority: 0 -> none
2026.10.28 16:38:48.856896 [ 10 ] {} <Debug> SystemLog: Creating system.query_thread_log from query_thread_log
2026.10.28 16:38:48.857773 [ 10 ] {} <Debug> SystemLog: Creating system.part_log from part_log
2026.10.28 16:38:48.858410 [ 10 ] {} <Debug> SystemLog: Creating system.trace_log from trace_log
2026.10.28 16:38:48.858814 [ 10 ] {} <Debug> SystemLog: Creating system.crash_log from crash_log
2026.10.28 16:38:48.859195 [ 10 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config
2026.10.28 16:38:48.859227 [ 10 ] {} <Debug> SystemLog: Creating system.metric_log from metric_log
2026.10.28 16:38:48.867937 [ 10 ] {} <Debug> SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config
2026.10.28 16:38:48.867985 [ 10 ] {} <Debug> SystemLog: Not creating system.filesystem_read_prefetches_log since corresponding section 'filesystem_read_prefetches_log' is missing from config
2026.10.28 16:38:48.868003 [ 10 ] {} <Debug> SystemLog: Creating system.asynchronous_metric_log from asynchronous_metric_log
2026.10.28 16:38:48.868318 [ 10 ] {} <Debug> SystemLog: Creating system.opentelemetry_span_log from opentelemetry_span_log
2026.10.28 16:38:48.868646 [ 10 ] {} <Debug> SystemLog: Creating system.query_views_log from query_views_log
2026.10.28 16:38:48.869044 [ 10 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config
2026.10.28 16:38:48.869067 [ 10 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config
2026.10.28 16:38:48.869083 [ 10 ] {} <Debug> SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config
2026.10.28 16:38:48.869110 [ 10 ] {} <Debug> SystemLog: Creating system.processors_profile_log from processors_profile_log
2026.10.28 16:38:48.869402 [ 10 ] {} <Debug> SystemLog: Creating system.asynchronous_insert_log from asynchronous_insert_log
2026.10.28 16:38:48.869779 [ 10 ] {} <Debug> SystemLog: Creating system.backup_log from backup_log
2026.10.28 16:38:48.870119 [ 10 ] {} <Debug> SystemLog: Creating system.s3queue_log from s3queue_log
2026.10.28 16:38:48.870383 [ 10 ] {} <Debug> SystemLog: Creating system.blob_storage_log from blob_storage_log
2026.10.28 16:38:48.888348 [ 10 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal.
2026.10.28 16:38:48.890258 [ 10 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total.
2026.10.28 16:38:48.890270 [ 10 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 4.068e-05 sec
2026.10.28 16:38:48.890275 [ 10 ] {} <Trace> ReferentialDeps: No tables
2026.10.28 16:38:48.890279 [ 10 ] {} <Trace> LoadingDeps: No tables
2026.10.28 16:38:48.890306 [ 10 ] {} <Information> loadMetadata: Start synchronous loading of databases
2026.10.28 16:38:48.890310 [ 10 ] {} <Information> loadMetadata: Start synchronous startup of databases
2026.10.28 16:38:48.890314 [ 10 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Atomic database default': BgStartup -> FgLoad
2026.10.28 16:38:48.890318 [ 10 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Ordinary database default': BgStartup -> FgLoad
2026.10.28 16:38:48.890324 [ 10 ] {} <Debug> AsyncLoader: Schedule load job 'startup Ordinary database default' into FgLoad
2026.10.28 16:38:48.890327 [ 10 ] {} <Debug> AsyncLoader: Schedule load job 'startup Atomic database default' into FgLoad
2026.10.28 16:38:48.890331 [ 10 ] {} <Debug> AsyncLoader: Change current priority: none -> 0
2026.10.28 16:38:48.890335 [ 10 ] {} <Debug> AsyncLoader: Spawn loader worker #1 in FgLoad
2026.10.28 16:38:48.890405 [ 10 ] {} <Debug> AsyncLoader: Wait load job 'startup Atomic database default' in FgLoad
2026.10.28 16:38:48.890576 [ 661 ] {} <Debug> AsyncLoader: Execute load job 'startup Ordinary database default' in FgLoad
2026.10.28 16:38:48.890645 [ 661 ] {} <Debug> AsyncLoader: Finish load job 'startup Ordinary database default' with status OK
2026.10.28 16:38:48.890661 [ 661 ] {} <Debug> AsyncLoader: Spawn loader worker #2 in FgLoad
2026.10.28 16:38:48.890807 [ 661 ] {} <Debug> AsyncLoader: Execute load job 'startup Atomic database default' in FgLoad
2026.10.28 16:38:48.890831 [ 661 ] {} <Debug> AsyncLoader: Finish load job 'startup Atomic database default' with status OK
2026.10.28 16:38:48.890840 [ 661 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2026.10.28 16:38:48.890960 [ 10 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/lib/clickhouse/user_defined/
2026.10.28 16:38:48.890994 [ 10 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded
2026.10.28 16:38:48.890999 [ 10 ] {} <Debug> Application: Loaded metadata.
2026.10.28 16:38:48.891034 [ 10 ] {} <Trace> Pipe: Pipe capacity is 1.00 MiB
2026.10.28 16:38:48.891034 [ 662 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2026.10.28 16:38:48.891071 [ 10 ] {} <Information> Application: Tasks stats provider: procfs
2026.10.28 16:38:48.891130 [ 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.
2026.10.28 16:38:48.891135 [ 662 ] {} <Debug> AsyncLoader: Change current priority: 0 -> none
2026.10.28 16:38:48.891489 [ 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.10333.altinitystable (altinity build))
2026.10.28 16:38:48.891698 [ 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.10333.altinitystable (altinity build))
2026.10.28 16:38:48.891705 [ 10 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair.
2026.10.28 16:38:48.933971 [ 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.10333.altinitystable (altinity build))
2026.10.28 16:38:48.934031 [ 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.10333.altinitystable (altinity build))
2026.10.28 16:38:48.934036 [ 10 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair.
2026.10.28 16:38:48.974635 [ 10 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again.
2026.10.28 16:38:48.975545 [ 10 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 49.45 MiB, peak 49.46 MiB, free memory in arenas 43.05 MiB, will set to 446.96 MiB (RSS), difference: 397.51 MiB
2026.10.28 16:38:48.977030 [ 10 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 1.239e-05 sec.
2026.10.28 16:38:48.978155 [ 10 ] {} <Information> Application: Listening for http://[::1]:8123
2026.10.28 16:38:48.978238 [ 10 ] {} <Information> Application: Listening for native protocol (tcp): [::1]:9000
2026.10.28 16:38:48.978278 [ 10 ] {} <Information> Application: Listening for MySQL compatibility protocol: [::1]:9004
2026.10.28 16:38:48.978317 [ 10 ] {} <Information> Application: Listening for PostgreSQL compatibility protocol: [::1]:9005
2026.10.28 16:38:48.978359 [ 10 ] {} <Information> Application: Listening for http://127.0.0.1:8123
2026.10.28 16:38:48.978396 [ 10 ] {} <Information> Application: Listening for native protocol (tcp): 127.0.0.1:9000
2026.10.28 16:38:48.978431 [ 10 ] {} <Information> Application: Listening for MySQL compatibility protocol: 127.0.0.1:9004
2026.10.28 16:38:48.978468 [ 10 ] {} <Information> Application: Listening for PostgreSQL compatibility protocol: 127.0.0.1:9005
2026.10.28 16:38:48.978472 [ 10 ] {} <Information> Application: Ready for connections.
2026.10.28 16:38:49.001070 [ 663 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 446.99 MiB, peak 446.99 MiB, free memory in arenas 43.12 MiB, will set to 449.71 MiB (RSS), difference: 2.73 MiB
2026.10.28 16:38:53.401817 [ 12 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:34570
2026.10.28 16:38:53.401993 [ 12 ] {} <Debug> TCPHandler: Connected ClickHouse client version 24.3.0, revision: 54467, user: default.
2026.10.28 16:38:53.402026 [ 12 ] {} <Debug> TCP-Session: 6187f7da-1098-4fe6-bd34-10a067e18399 Authenticating user 'default' from [::1]:34570
2026.10.28 16:38:53.402059 [ 12 ] {} <Debug> TCP-Session: 6187f7da-1098-4fe6-bd34-10a067e18399 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
2026.10.28 16:38:53.402064 [ 12 ] {} <Debug> TCP-Session: 6187f7da-1098-4fe6-bd34-10a067e18399 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
2026.10.28 16:38:53.402149 [ 12 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false
2026.10.28 16:38:53.402170 [ 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
2026.10.28 16:38:53.402190 [ 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
2026.10.28 16:38:53.424425 [ 12 ] {} <Trace> TCP-Session: 6187f7da-1098-4fe6-bd34-10a067e18399 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
2026.10.28 16:38:53.424669 [ 12 ] {8f26e513-27b7-4701-a446-380a52c76c05} <Debug> executeQuery: (from [::1]:34570) select 'OK' (stage: Complete)
2026.10.28 16:38:53.424882 [ 12 ] {8f26e513-27b7-4701-a446-380a52c76c05} <Trace> Planner: Query SELECT 'OK' AS `'OK'` FROM system.one AS __table1 to stage Complete
2026.10.28 16:38:53.424906 [ 12 ] {8f26e513-27b7-4701-a446-380a52c76c05} <Trace> ContextAccess (default): Access granted: SELECT(dummy) ON system.one
2026.10.28 16:38:53.424958 [ 12 ] {8f26e513-27b7-4701-a446-380a52c76c05} <Trace> Planner: Query SELECT 'OK' AS `'OK'` FROM system.one AS __table1 from stage FetchColumns to stage Complete
2026.10.28 16:38:53.426140 [ 12 ] {8f26e513-27b7-4701-a446-380a52c76c05} <Debug> executeQuery: Read 1 rows, 1.00 B in 0.001495 sec., 668.8963210702341 rows/sec., 668.90 B/sec.
2026.10.28 16:38:53.426198 [ 12 ] {8f26e513-27b7-4701-a446-380a52c76c05} <Debug> TCPHandler: Processed in 0.00194201 sec.
2026.10.28 16:38:53.428067 [ 12 ] {} <Debug> TCPHandler: Done processing connection.
2026.10.28 16:38:53.428104 [ 12 ] {} <Debug> TCP-Session: 6187f7da-1098-4fe6-bd34-10a067e18399 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
2026.10.28 16:38:53.795592 [ 7 ] {} <Information> Application: Will watch for the process with pid 9
2026.10.28 16:38:53.795912 [ 9 ] {} <Information> Application: Forked a child process to watch
2026.10.28 16:38:53.796387 [ 9 ] {} <Information> SentryWriter: Sending crash reports is disabled
2026.10.28 16:38:53.796661 [ 9 ] {} <Trace> Pipe: Pipe capacity is 1.00 MiB
2026.10.28 16:38:53.904768 [ 9 ] {} <Information> Application: Starting ClickHouse 24.3.18.10333.altinitystable (revision: 54496, git hash: e722d52227cc94f272a82f47e86c5818a05d098b, build id: 02E9FF5C876E3FCCAF3D208282C61399A1810A62), PID 9
2026.10.28 16:38:53.904923 [ 9 ] {} <Information> Application: starting up
2026.10.28 16:38:53.904939 [ 9 ] {} <Information> Application: OS name: Linux, version: 5.15.0-130-generic, architecture: x86_64
2026.10.28 16:38:53.909672 [ 9 ] {} <Information> Application: Available RAM: 30.59 GiB; logical cores: 16; used cores: 16.
2026.10.28 16:38:53.909717 [ 9 ] {} <Information> Application: Available CPU instruction sets: SSE, SSE2, SSE3, SSSE3, SSE41, SSE42, F16C, POPCNT, BMI1, BMI2, PCLMUL, AES, AVX, FMA, AVX2, AVX512F, AVX512DQ, AVX512IFMA, AVX512CD, AVX512BW, AVX512VL, AVX512VBMI, AVX512VBMI2, SHA, ADX, RDRAND, RDSEED, RDTSCP, CLFLUSHOPT, CLWB, XSAVE, OSXSAVE
2026.10.28 16:38:53.909874 [ 9 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/thermal
2026.10.28 16:38:53.909886 [ 9 ] {} <Trace> AsynchronousMetrics: Scanning /sys/block
2026.10.28 16:38:53.909985 [ 9 ] {} <Trace> AsynchronousMetrics: Scanning /sys/devices/system/edac
2026.10.28 16:38:53.910002 [ 9 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/hwmon
2026.10.28 16:38:53.913431 [ 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.
2026.10.28 16:38:54.057582 [ 9 ] {} <Information> Application: Integrity check of the executable successfully passed (checksum: D0EF1C7C14C3CE170EF774E2FD80FE0A)
2026.10.28 16:38:54.057668 [ 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.
2026.10.28 16:38:54.059809 [ 9 ] {} <Debug> Application: rlimit on number of file descriptors is 1048576
2026.10.28 16:38:54.059828 [ 9 ] {} <Debug> Application: rlimit on number of threads is 18446744073709551615
2026.10.28 16:38:54.059838 [ 9 ] {} <Debug> Application: Initializing DateLUT.
2026.10.28 16:38:54.059843 [ 9 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'.
2026.10.28 16:38:54.059881 [ 9 ] {} <Debug> Context: Setting up /var/lib/clickhouse/tmp/ to store temporary data in it
2026.10.28 16:38:54.060574 [ 9 ] {} <Debug> Application: Configuration parameter 'interserver_http_host' doesn't exist or exists and empty. Will use 'github-hetzner-runner-40711268593-122914749824' as replica host.
2026.10.28 16:38:54.060597 [ 9 ] {} <Debug> Application: Initializing interserver credentials.
2026.10.28 16:38:54.060714 [ 9 ] {} <Trace> NamedCollectionsUtils: Loaded 0 collections from config
2026.10.28 16:38:54.060815 [ 9 ] {} <Trace> NamedCollectionsUtils: Loaded 0 collections from SQL
2026.10.28 16:38:54.060954 [ 9 ] {} <Information> CgroupsMemoryUsageObserver: Will read the current memory usage from '/sys/fs/cgroup/' (cgroups version: v2), wait time is 15 sec
2026.10.28 16:38:54.061215 [ 9 ] {} <Debug> ConfigReloader: Loading config '/config/config.xml'
2026.10.28 16:38:54.061226 [ 9 ] {} <Debug> ConfigProcessor: Processing configuration file '/config/config.xml'.
2026.10.28 16:38:54.065387 [ 9 ] {} <Debug> ConfigProcessor: Saved preprocessed configuration to '/var/lib/clickhouse/preprocessed_configs/config.xml'.
2026.10.28 16:38:54.065464 [ 9 ] {} <Debug> ConfigReloader: Loaded config '/config/config.xml', performing update on configuration
2026.10.28 16:38:54.068637 [ 9 ] {} <Information> Application: Setting max_server_memory_usage was set to 27.54 GiB (30.59 GiB available * 0.90 max_server_memory_usage_to_ram_ratio)
2026.10.28 16:38:54.068650 [ 9 ] {} <Information> CgroupsMemoryUsageObserver: Set new limits, soft limit: 24.78 GiB, hard limit: 26.16 GiB
2026.10.28 16:38:54.068656 [ 9 ] {} <Information> Application: Setting merges_mutations_memory_usage_soft_limit was set to 15.30 GiB (30.59 GiB available * 0.50 merges_mutations_memory_usage_to_ram_ratio)
2026.10.28 16:38:54.068662 [ 9 ] {} <Information> Application: Merges and mutations memory limit is set to 15.30 GiB
2026.10.28 16:38:54.068919 [ 9 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads
2026.10.28 16:38:54.070508 [ 9 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 512 threads
2026.10.28 16:38:54.176557 [ 9 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads
2026.10.28 16:38:54.178451 [ 9 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads
2026.10.28 16:38:54.180607 [ 9 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again.
2026.10.28 16:38:54.180728 [ 9 ] {} <Debug> ConfigReloader: Loaded config '/config/config.xml', performed update on configuration
2026.10.28 16:38:54.182208 [ 9 ] {} <Information> Application: Listening for replica communication (interserver): http://[::1]:9009
2026.10.28 16:38:54.183488 [ 9 ] {} <Information> Application: Listening for replica communication (interserver): http://127.0.0.1:9009
2026.10.28 16:38:54.188722 [ 9 ] {} <Debug> ConfigReloader: Loading config '/config/users.xml'
2026.10.28 16:38:54.188758 [ 9 ] {} <Debug> ConfigProcessor: Processing configuration file '/config/users.xml'.
2026.10.28 16:38:54.189271 [ 9 ] {} <Debug> ConfigProcessor: Saved preprocessed configuration to '/var/lib/clickhouse/preprocessed_configs/users.xml'.
2026.10.28 16:38:54.189292 [ 9 ] {} <Debug> ConfigReloader: Loaded config '/config/users.xml', performing update on configuration
2026.10.28 16:38:54.189971 [ 9 ] {} <Debug> ConfigReloader: Loaded config '/config/users.xml', performed update on configuration
2026.10.28 16:38:54.190141 [ 9 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: /config/users.xml
2026.10.28 16:38:54.190294 [ 9 ] {} <Warning> Access(local_directory): File /var/lib/clickhouse/access/users.list doesn't exist
2026.10.28 16:38:54.190312 [ 9 ] {} <Warning> Access(local_directory): Recovering lists in directory /var/lib/clickhouse/access/
2026.10.28 16:38:54.190672 [ 9 ] {} <Debug> Access(user directories): Added local_directory access storage 'local_directory', path: /var/lib/clickhouse/access/
2026.10.28 16:38:54.190796 [ 9 ] {} <Information> CgroupsMemoryUsageObserver: Started cgroup current memory usage observer thread
2026.10.28 16:38:54.191586 [ 580 ] {} <Information> CgroupsMemoryUsageObserver: Memory amount initially available to the process is 30.59 GiB
2026.10.28 16:38:54.191932 [ 9 ] {} <Information> Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32, scheduling_policy=round_robin
2026.10.28 16:38:54.194946 [ 9 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8
2026.10.28 16:38:54.196621 [ 9 ] {} <Information> Context: Initialized background executor for fetches with num_threads=16, num_tasks=16
2026.10.28 16:38:54.199506 [ 9 ] {} <Information> Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8
2026.10.28 16:38:54.201359 [ 9 ] {} <Information> DNSCacheUpdater: Update period 15 seconds
2026.10.28 16:38:54.201382 [ 9 ] {} <Information> Application: Loading metadata from /var/lib/clickhouse/
2026.10.28 16:38:54.202001 [ 33 ] {} <Debug> DNSResolver: Updating DNS cache
2026.10.28 16:38:54.203493 [ 33 ] {} <Debug> DNSResolver: Updated DNS cache
2026.10.28 16:38:54.206596 [ 9 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total.
2026.10.28 16:38:54.206609 [ 9 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 7.79e-05 sec
2026.10.28 16:38:54.206615 [ 9 ] {} <Trace> ReferentialDeps: No tables
2026.10.28 16:38:54.206619 [ 9 ] {} <Trace> LoadingDeps: No tables
2026.10.28 16:38:54.206660 [ 9 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Atomic database system': BgStartup -> FgLoad
2026.10.28 16:38:54.206671 [ 9 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Ordinary database system': BgStartup -> FgLoad
2026.10.28 16:38:54.206680 [ 9 ] {} <Debug> AsyncLoader: Schedule load job 'startup Ordinary database system' into FgLoad
2026.10.28 16:38:54.206687 [ 9 ] {} <Debug> AsyncLoader: Schedule load job 'startup Atomic database system' into FgLoad
2026.10.28 16:38:54.206694 [ 9 ] {} <Debug> AsyncLoader: Change current priority: none -> 0
2026.10.28 16:38:54.206699 [ 9 ] {} <Debug> AsyncLoader: Spawn loader worker #1 in FgLoad
2026.10.28 16:38:54.206775 [ 9 ] {} <Debug> AsyncLoader: Wait load job 'startup Atomic database system' in FgLoad
2026.10.28 16:38:54.207008 [ 645 ] {} <Debug> AsyncLoader: Execute load job 'startup Ordinary database system' in FgLoad
2026.10.28 16:38:54.207120 [ 645 ] {} <Debug> AsyncLoader: Finish load job 'startup Ordinary database system' with status OK
2026.10.28 16:38:54.207139 [ 645 ] {} <Debug> AsyncLoader: Spawn loader worker #2 in FgLoad
2026.10.28 16:38:54.207284 [ 645 ] {} <Debug> AsyncLoader: Execute load job 'startup Atomic database system' in FgLoad
2026.10.28 16:38:54.207333 [ 645 ] {} <Debug> AsyncLoader: Finish load job 'startup Atomic database system' with status OK
2026.10.28 16:38:54.207355 [ 645 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2026.10.28 16:38:54.207355 [ 9 ] {} <Debug> SystemLog: Creating system.query_log from query_log
2026.10.28 16:38:54.207464 [ 646 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2026.10.28 16:38:54.207515 [ 646 ] {} <Debug> AsyncLoader: Change current priority: 0 -> none
2026.10.28 16:38:54.208450 [ 9 ] {} <Debug> SystemLog: Creating system.query_thread_log from query_thread_log
2026.10.28 16:38:54.208839 [ 9 ] {} <Debug> SystemLog: Creating system.part_log from part_log
2026.10.28 16:38:54.209179 [ 9 ] {} <Debug> SystemLog: Creating system.trace_log from trace_log
2026.10.28 16:38:54.209375 [ 9 ] {} <Debug> SystemLog: Creating system.crash_log from crash_log
2026.10.28 16:38:54.209535 [ 9 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config
2026.10.28 16:38:54.209550 [ 9 ] {} <Debug> SystemLog: Creating system.metric_log from metric_log
2026.10.28 16:38:54.213759 [ 9 ] {} <Debug> SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config
2026.10.28 16:38:54.213777 [ 9 ] {} <Debug> SystemLog: Not creating system.filesystem_read_prefetches_log since corresponding section 'filesystem_read_prefetches_log' is missing from config
2026.10.28 16:38:54.213788 [ 9 ] {} <Debug> SystemLog: Creating system.asynchronous_metric_log from asynchronous_metric_log
2026.10.28 16:38:54.213989 [ 9 ] {} <Debug> SystemLog: Creating system.opentelemetry_span_log from opentelemetry_span_log
2026.10.28 16:38:54.214176 [ 9 ] {} <Debug> SystemLog: Creating system.query_views_log from query_views_log
2026.10.28 16:38:54.214387 [ 9 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config
2026.10.28 16:38:54.214400 [ 9 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config
2026.10.28 16:38:54.214409 [ 9 ] {} <Debug> SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config
2026.10.28 16:38:54.214418 [ 9 ] {} <Debug> SystemLog: Creating system.processors_profile_log from processors_profile_log
2026.10.28 16:38:54.214554 [ 9 ] {} <Debug> SystemLog: Creating system.asynchronous_insert_log from asynchronous_insert_log
2026.10.28 16:38:54.214730 [ 9 ] {} <Debug> SystemLog: Creating system.backup_log from backup_log
2026.10.28 16:38:54.214938 [ 9 ] {} <Debug> SystemLog: Creating system.s3queue_log from s3queue_log
2026.10.28 16:38:54.215126 [ 9 ] {} <Debug> SystemLog: Creating system.blob_storage_log from blob_storage_log
2026.10.28 16:38:54.240888 [ 9 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal.
2026.10.28 16:38:54.243468 [ 9 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total.
2026.10.28 16:38:54.243491 [ 9 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 7.994e-05 sec
2026.10.28 16:38:54.243503 [ 9 ] {} <Trace> ReferentialDeps: No tables
2026.10.28 16:38:54.243512 [ 9 ] {} <Trace> LoadingDeps: No tables
2026.10.28 16:38:54.243572 [ 9 ] {} <Information> loadMetadata: Start synchronous loading of databases
2026.10.28 16:38:54.243581 [ 9 ] {} <Information> loadMetadata: Start synchronous startup of databases
2026.10.28 16:38:54.243591 [ 9 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Atomic database default': BgStartup -> FgLoad
2026.10.28 16:38:54.243600 [ 9 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Ordinary database default': BgStartup -> FgLoad
2026.10.28 16:38:54.243612 [ 9 ] {} <Debug> AsyncLoader: Schedule load job 'startup Ordinary database default' into FgLoad
2026.10.28 16:38:54.243620 [ 9 ] {} <Debug> AsyncLoader: Schedule load job 'startup Atomic database default' into FgLoad
2026.10.28 16:38:54.243630 [ 9 ] {} <Debug> AsyncLoader: Change current priority: none -> 0
2026.10.28 16:38:54.243639 [ 9 ] {} <Debug> AsyncLoader: Spawn loader worker #1 in FgLoad
2026.10.28 16:38:54.243775 [ 9 ] {} <Debug> AsyncLoader: Wait load job 'startup Atomic database default' in FgLoad
2026.10.28 16:38:54.244027 [ 660 ] {} <Debug> AsyncLoader: Execute load job 'startup Ordinary database default' in FgLoad
2026.10.28 16:38:54.244123 [ 660 ] {} <Debug> AsyncLoader: Finish load job 'startup Ordinary database default' with status OK
2026.10.28 16:38:54.244140 [ 660 ] {} <Debug> AsyncLoader: Spawn loader worker #2 in FgLoad
2026.10.28 16:38:54.244337 [ 660 ] {} <Debug> AsyncLoader: Execute load job 'startup Atomic database default' in FgLoad
2026.10.28 16:38:54.244376 [ 660 ] {} <Debug> AsyncLoader: Finish load job 'startup Atomic database default' with status OK
2026.10.28 16:38:54.244392 [ 660 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2026.10.28 16:38:54.244577 [ 661 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2026.10.28 16:38:54.244671 [ 661 ] {} <Debug> AsyncLoader: Change current priority: 0 -> none
2026.10.28 16:38:54.244696 [ 9 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/lib/clickhouse/user_defined/
2026.10.28 16:38:54.244791 [ 9 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded
2026.10.28 16:38:54.244803 [ 9 ] {} <Debug> Application: Loaded metadata.
2026.10.28 16:38:54.244850 [ 9 ] {} <Trace> Pipe: Pipe capacity is 1.00 MiB
2026.10.28 16:38:54.244914 [ 9 ] {} <Information> Application: Tasks stats provider: procfs
2026.10.28 16:38:54.244926 [ 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.
2026.10.28 16:38:54.245669 [ 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.10333.altinitystable (altinity build))
2026.10.28 16:38:54.245799 [ 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.10333.altinitystable (altinity build))
2026.10.28 16:38:54.245811 [ 9 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair.
2026.10.28 16:38:54.314451 [ 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.10333.altinitystable (altinity build))
2026.10.28 16:38:54.314517 [ 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.10333.altinitystable (altinity build))
2026.10.28 16:38:54.314523 [ 9 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair.
2026.10.28 16:38:54.437612 [ 9 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again.
2026.10.28 16:38:54.438521 [ 9 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 49.38 MiB, peak 49.38 MiB, free memory in arenas 44.79 MiB, will set to 449.36 MiB (RSS), difference: 399.98 MiB
2026.10.28 16:38:54.440427 [ 9 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 1.191e-05 sec.
2026.10.28 16:38:54.441236 [ 9 ] {} <Information> Application: Listening for http://[::1]:8123
2026.10.28 16:38:54.441287 [ 9 ] {} <Information> Application: Listening for native protocol (tcp): [::1]:9000
2026.10.28 16:38:54.441325 [ 9 ] {} <Information> Application: Listening for MySQL compatibility protocol: [::1]:9004
2026.10.28 16:38:54.441364 [ 9 ] {} <Information> Application: Listening for PostgreSQL compatibility protocol: [::1]:9005
2026.10.28 16:38:54.441413 [ 9 ] {} <Information> Application: Listening for http://127.0.0.1:8123
2026.10.28 16:38:54.441452 [ 9 ] {} <Information> Application: Listening for native protocol (tcp): 127.0.0.1:9000
2026.10.28 16:38:54.441489 [ 9 ] {} <Information> Application: Listening for MySQL compatibility protocol: 127.0.0.1:9004
2026.10.28 16:38:54.441535 [ 9 ] {} <Information> Application: Listening for PostgreSQL compatibility protocol: 127.0.0.1:9005
2026.10.28 16:38:54.441540 [ 9 ] {} <Information> Application: Ready for connections.
2026.10.28 16:38:55.001087 [ 662 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 449.38 MiB, peak 449.38 MiB, free memory in arenas 44.81 MiB, will set to 452.04 MiB (RSS), difference: 2.65 MiB
2026.10.28 16:38:58.797888 [ 11 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: 127.0.0.1:37692
2026.10.28 16:38:58.798158 [ 11 ] {} <Debug> TCPHandler: Connected ClickHouse client version 24.3.0, revision: 54467, user: default.
2026.10.28 16:38:58.798219 [ 11 ] {} <Debug> TCP-Session: 173e71e3-72e0-4df9-834c-c10a457f2459 Authenticating user 'default' from 127.0.0.1:37692
2026.10.28 16:38:58.798271 [ 11 ] {} <Debug> TCP-Session: 173e71e3-72e0-4df9-834c-c10a457f2459 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
2026.10.28 16:38:58.798286 [ 11 ] {} <Debug> TCP-Session: 173e71e3-72e0-4df9-834c-c10a457f2459 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
2026.10.28 16:38:58.798449 [ 11 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false
2026.10.28 16:38:58.798489 [ 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
2026.10.28 16:38:58.798525 [ 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
2026.10.28 16:38:58.817686 [ 11 ] {} <Trace> TCP-Session: 173e71e3-72e0-4df9-834c-c10a457f2459 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
2026.10.28 16:38:58.818135 [ 11 ] {f94de25f-c9ac-40d7-9393-f3ec15140ce1} <Debug> executeQuery: (from 127.0.0.1:37692) select 'OK' (stage: Complete)
2026.10.28 16:38:58.818474 [ 11 ] {f94de25f-c9ac-40d7-9393-f3ec15140ce1} <Trace> Planner: Query SELECT 'OK' AS `'OK'` FROM system.one AS __table1 to stage Complete
2026.10.28 16:38:58.818525 [ 11 ] {f94de25f-c9ac-40d7-9393-f3ec15140ce1} <Trace> ContextAccess (default): Access granted: SELECT(dummy) ON system.one
2026.10.28 16:38:58.818622 [ 11 ] {f94de25f-c9ac-40d7-9393-f3ec15140ce1} <Trace> Planner: Query SELECT 'OK' AS `'OK'` FROM system.one AS __table1 from stage FetchColumns to stage Complete
2026.10.28 16:38:58.819865 [ 11 ] {f94de25f-c9ac-40d7-9393-f3ec15140ce1} <Debug> executeQuery: Read 1 rows, 1.00 B in 0.001753 sec., 570.4506560182544 rows/sec., 570.45 B/sec.
2026.10.28 16:38:58.819938 [ 11 ] {f94de25f-c9ac-40d7-9393-f3ec15140ce1} <Debug> TCPHandler: Processed in 0.00243788 sec.
2026.10.28 16:38:58.821270 [ 11 ] {} <Debug> TCPHandler: Done processing connection.
2026.10.28 16:38:58.821322 [ 11 ] {} <Debug> TCP-Session: 173e71e3-72e0-4df9-834c-c10a457f2459 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db