2026.10.28 23:52:37.303305 [ 8 ] {} <Information> Application: Will watch for the process with pid 10
2026.10.28 23:52:37.303638 [ 10 ] {} <Information> Application: Forked a child process to watch
2026.10.28 23:52:37.304105 [ 10 ] {} <Information> SentryWriter: Sending crash reports is disabled
2026.10.28 23:52:37.304400 [ 10 ] {} <Trace> Pipe: Pipe capacity is 1.00 MiB
2026.10.28 23:52:37.413175 [ 10 ] {} <Information> Application: Starting ClickHouse 24.3.18.10427.altinitystable (revision: 4294967295, git hash: fcaf6e1267e237da0994d3e05c9aabfe63c284a1, build id: A30AA3BA3667FFAE6B8E1D3DD52AEBFE6405FDFF), PID 10
2026.10.28 23:52:37.413335 [ 10 ] {} <Information> Application: starting up
2026.10.28 23:52:37.413352 [ 10 ] {} <Information> Application: OS name: Linux, version: 5.15.0-130-generic, architecture: x86_64
2026.10.28 23:52:37.418164 [ 10 ] {} <Information> Application: Available RAM: 30.59 GiB; logical cores: 16; used cores: 16.
2026.10.28 23:52:37.418210 [ 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 23:52:37.418386 [ 10 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/thermal
2026.10.28 23:52:37.418407 [ 10 ] {} <Trace> AsynchronousMetrics: Scanning /sys/block
2026.10.28 23:52:37.418515 [ 10 ] {} <Trace> AsynchronousMetrics: Scanning /sys/devices/system/edac
2026.10.28 23:52:37.418534 [ 10 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/hwmon
2026.10.28 23:52:37.421884 [ 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 23:52:37.552705 [ 10 ] {} <Information> Application: Integrity check of the executable successfully passed (checksum: 57C7145187074368B9AC26AE558E6A35)
2026.10.28 23:52:37.552771 [ 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 23:52:37.555353 [ 10 ] {} <Debug> Application: rlimit on number of file descriptors is 1048576
2026.10.28 23:52:37.555372 [ 10 ] {} <Debug> Application: rlimit on number of threads is 18446744073709551615
2026.10.28 23:52:37.555383 [ 10 ] {} <Debug> Application: Initializing DateLUT.
2026.10.28 23:52:37.555389 [ 10 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'.
2026.10.28 23:52:37.555460 [ 10 ] {} <Debug> Context: Setting up /var/lib/clickhouse/tmp/ to store temporary data in it
2026.10.28 23:52:37.556183 [ 10 ] {} <Debug> Application: Configuration parameter 'interserver_http_host' doesn't exist or exists and empty. Will use 'github-hetzner-runner-40783431156-123171777037' as replica host.
2026.10.28 23:52:37.556202 [ 10 ] {} <Debug> Application: Initializing interserver credentials.
2026.10.28 23:52:37.556307 [ 10 ] {} <Trace> NamedCollectionsUtils: Loaded 0 collections from config
2026.10.28 23:52:37.556388 [ 10 ] {} <Trace> NamedCollectionsUtils: Loaded 0 collections from SQL
2026.10.28 23:52:37.556505 [ 10 ] {} <Information> CgroupsMemoryUsageObserver: Will read the current memory usage from '/sys/fs/cgroup/' (cgroups version: v2), wait time is 15 sec
2026.10.28 23:52:37.556724 [ 10 ] {} <Debug> ConfigReloader: Loading config '/config/config.xml'
2026.10.28 23:52:37.556732 [ 10 ] {} <Debug> ConfigProcessor: Processing configuration file '/config/config.xml'.
2026.10.28 23:52:37.560320 [ 10 ] {} <Debug> ConfigProcessor: Saved preprocessed configuration to '/var/lib/clickhouse/preprocessed_configs/config.xml'.
2026.10.28 23:52:37.560406 [ 10 ] {} <Debug> ConfigReloader: Loaded config '/config/config.xml', performing update on configuration
2026.10.28 23:52:37.563374 [ 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 23:52:37.563384 [ 10 ] {} <Information> CgroupsMemoryUsageObserver: Set new limits, soft limit: 24.78 GiB, hard limit: 26.16 GiB
2026.10.28 23:52:37.563389 [ 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 23:52:37.563394 [ 10 ] {} <Information> Application: Merges and mutations memory limit is set to 15.30 GiB
2026.10.28 23:52:37.563723 [ 10 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads
2026.10.28 23:52:37.565600 [ 10 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 512 threads
2026.10.28 23:52:37.673143 [ 10 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads
2026.10.28 23:52:37.674623 [ 10 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads
2026.10.28 23:52:37.705451 [ 10 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again.
2026.10.28 23:52:37.705770 [ 10 ] {} <Debug> ConfigReloader: Loaded config '/config/config.xml', performed update on configuration
2026.10.28 23:52:37.706756 [ 10 ] {} <Information> Application: Listening for replica communication (interserver): http://[::1]:9009
2026.10.28 23:52:37.706877 [ 10 ] {} <Information> Application: Listening for replica communication (interserver): http://127.0.0.1:9009
2026.10.28 23:52:37.711201 [ 10 ] {} <Debug> ConfigReloader: Loading config '/config/users.xml'
2026.10.28 23:52:37.711244 [ 10 ] {} <Debug> ConfigProcessor: Processing configuration file '/config/users.xml'.
2026.10.28 23:52:37.712219 [ 10 ] {} <Debug> ConfigProcessor: Saved preprocessed configuration to '/var/lib/clickhouse/preprocessed_configs/users.xml'.
2026.10.28 23:52:37.712257 [ 10 ] {} <Debug> ConfigReloader: Loaded config '/config/users.xml', performing update on configuration
2026.10.28 23:52:37.713303 [ 10 ] {} <Debug> ConfigReloader: Loaded config '/config/users.xml', performed update on configuration
2026.10.28 23:52:37.713457 [ 10 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: /config/users.xml
2026.10.28 23:52:37.713660 [ 10 ] {} <Warning> Access(local_directory): File /var/lib/clickhouse/access/users.list doesn't exist
2026.10.28 23:52:37.713678 [ 10 ] {} <Warning> Access(local_directory): Recovering lists in directory /var/lib/clickhouse/access/
2026.10.28 23:52:37.713998 [ 10 ] {} <Debug> Access(user directories): Added local_directory access storage 'local_directory', path: /var/lib/clickhouse/access/
2026.10.28 23:52:37.714124 [ 10 ] {} <Information> CgroupsMemoryUsageObserver: Started cgroup current memory usage observer thread
2026.10.28 23:52:37.714987 [ 581 ] {} <Information> CgroupsMemoryUsageObserver: Memory amount initially available to the process is 30.59 GiB
2026.10.28 23:52:37.715679 [ 10 ] {} <Information> Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32, scheduling_policy=round_robin
2026.10.28 23:52:37.718308 [ 10 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8
2026.10.28 23:52:37.720897 [ 10 ] {} <Information> Context: Initialized background executor for fetches with num_threads=16, num_tasks=16
2026.10.28 23:52:37.722909 [ 10 ] {} <Information> Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8
2026.10.28 23:52:37.724021 [ 10 ] {} <Information> DNSCacheUpdater: Update period 15 seconds
2026.10.28 23:52:37.724037 [ 10 ] {} <Information> Application: Loading metadata from /var/lib/clickhouse/
2026.10.28 23:52:37.724480 [ 37 ] {} <Debug> DNSResolver: Updating DNS cache
2026.10.28 23:52:37.727122 [ 37 ] {} <Debug> DNSResolver: Updated DNS cache
2026.10.28 23:52:37.730133 [ 10 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total.
2026.10.28 23:52:37.730144 [ 10 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 7.019e-05 sec
2026.10.28 23:52:37.730150 [ 10 ] {} <Trace> ReferentialDeps: No tables
2026.10.28 23:52:37.730154 [ 10 ] {} <Trace> LoadingDeps: No tables
2026.10.28 23:52:37.730190 [ 10 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Atomic database system': BgStartup -> FgLoad
2026.10.28 23:52:37.730195 [ 10 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Ordinary database system': BgStartup -> FgLoad
2026.10.28 23:52:37.730201 [ 10 ] {} <Debug> AsyncLoader: Schedule load job 'startup Ordinary database system' into FgLoad
2026.10.28 23:52:37.730206 [ 10 ] {} <Debug> AsyncLoader: Schedule load job 'startup Atomic database system' into FgLoad
2026.10.28 23:52:37.730211 [ 10 ] {} <Debug> AsyncLoader: Change current priority: none -> 0
2026.10.28 23:52:37.730216 [ 10 ] {} <Debug> AsyncLoader: Spawn loader worker #1 in FgLoad
2026.10.28 23:52:37.730283 [ 10 ] {} <Debug> AsyncLoader: Wait load job 'startup Atomic database system' in FgLoad
2026.10.28 23:52:37.730468 [ 646 ] {} <Debug> AsyncLoader: Execute load job 'startup Ordinary database system' in FgLoad
2026.10.28 23:52:37.730542 [ 646 ] {} <Debug> AsyncLoader: Finish load job 'startup Ordinary database system' with status OK
2026.10.28 23:52:37.730556 [ 646 ] {} <Debug> AsyncLoader: Spawn loader worker #2 in FgLoad
2026.10.28 23:52:37.730730 [ 646 ] {} <Debug> AsyncLoader: Execute load job 'startup Atomic database system' in FgLoad
2026.10.28 23:52:37.730780 [ 646 ] {} <Debug> AsyncLoader: Finish load job 'startup Atomic database system' with status OK
2026.10.28 23:52:37.730795 [ 10 ] {} <Debug> SystemLog: Creating system.query_log from query_log
2026.10.28 23:52:37.730816 [ 646 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2026.10.28 23:52:37.730900 [ 647 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2026.10.28 23:52:37.730982 [ 647 ] {} <Debug> AsyncLoader: Change current priority: 0 -> none
2026.10.28 23:52:37.731734 [ 10 ] {} <Debug> SystemLog: Creating system.query_thread_log from query_thread_log
2026.10.28 23:52:37.731985 [ 10 ] {} <Debug> SystemLog: Creating system.part_log from part_log
2026.10.28 23:52:37.732218 [ 10 ] {} <Debug> SystemLog: Creating system.trace_log from trace_log
2026.10.28 23:52:37.732357 [ 10 ] {} <Debug> SystemLog: Creating system.crash_log from crash_log
2026.10.28 23:52:37.732448 [ 10 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config
2026.10.28 23:52:37.732456 [ 10 ] {} <Debug> SystemLog: Creating system.metric_log from metric_log
2026.10.28 23:52:37.736127 [ 10 ] {} <Debug> SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config
2026.10.28 23:52:37.736143 [ 10 ] {} <Debug> SystemLog: Not creating system.filesystem_read_prefetches_log since corresponding section 'filesystem_read_prefetches_log' is missing from config
2026.10.28 23:52:37.736152 [ 10 ] {} <Debug> SystemLog: Creating system.asynchronous_metric_log from asynchronous_metric_log
2026.10.28 23:52:37.736312 [ 10 ] {} <Debug> SystemLog: Creating system.opentelemetry_span_log from opentelemetry_span_log
2026.10.28 23:52:37.736478 [ 10 ] {} <Debug> SystemLog: Creating system.query_views_log from query_views_log
2026.10.28 23:52:37.736654 [ 10 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config
2026.10.28 23:52:37.736664 [ 10 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config
2026.10.28 23:52:37.736672 [ 10 ] {} <Debug> SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config
2026.10.28 23:52:37.736686 [ 10 ] {} <Debug> SystemLog: Creating system.processors_profile_log from processors_profile_log
2026.10.28 23:52:37.736809 [ 10 ] {} <Debug> SystemLog: Creating system.asynchronous_insert_log from asynchronous_insert_log
2026.10.28 23:52:37.736971 [ 10 ] {} <Debug> SystemLog: Creating system.backup_log from backup_log
2026.10.28 23:52:37.737139 [ 10 ] {} <Debug> SystemLog: Creating system.s3queue_log from s3queue_log
2026.10.28 23:52:37.737275 [ 10 ] {} <Debug> SystemLog: Creating system.blob_storage_log from blob_storage_log
2026.10.28 23:52:37.773252 [ 10 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal.
2026.10.28 23:52:37.776402 [ 10 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total.
2026.10.28 23:52:37.776428 [ 10 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 9.266e-05 sec
2026.10.28 23:52:37.776443 [ 10 ] {} <Trace> ReferentialDeps: No tables
2026.10.28 23:52:37.776453 [ 10 ] {} <Trace> LoadingDeps: No tables
2026.10.28 23:52:37.776524 [ 10 ] {} <Information> loadMetadata: Start synchronous loading of databases
2026.10.28 23:52:37.776537 [ 10 ] {} <Information> loadMetadata: Start synchronous startup of databases
2026.10.28 23:52:37.776547 [ 10 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Atomic database default': BgStartup -> FgLoad
2026.10.28 23:52:37.776556 [ 10 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Ordinary database default': BgStartup -> FgLoad
2026.10.28 23:52:37.776570 [ 10 ] {} <Debug> AsyncLoader: Schedule load job 'startup Ordinary database default' into FgLoad
2026.10.28 23:52:37.776579 [ 10 ] {} <Debug> AsyncLoader: Schedule load job 'startup Atomic database default' into FgLoad
2026.10.28 23:52:37.776590 [ 10 ] {} <Debug> AsyncLoader: Change current priority: none -> 0
2026.10.28 23:52:37.776600 [ 10 ] {} <Debug> AsyncLoader: Spawn loader worker #1 in FgLoad
2026.10.28 23:52:37.776735 [ 10 ] {} <Debug> AsyncLoader: Wait load job 'startup Atomic database default' in FgLoad
2026.10.28 23:52:37.776864 [ 661 ] {} <Debug> AsyncLoader: Execute load job 'startup Ordinary database default' in FgLoad
2026.10.28 23:52:37.776908 [ 661 ] {} <Debug> AsyncLoader: Finish load job 'startup Ordinary database default' with status OK
2026.10.28 23:52:37.776921 [ 661 ] {} <Debug> AsyncLoader: Spawn loader worker #2 in FgLoad
2026.10.28 23:52:37.777104 [ 661 ] {} <Debug> AsyncLoader: Execute load job 'startup Atomic database default' in FgLoad
2026.10.28 23:52:37.777130 [ 661 ] {} <Debug> AsyncLoader: Finish load job 'startup Atomic database default' with status OK
2026.10.28 23:52:37.777140 [ 661 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2026.10.28 23:52:37.777274 [ 662 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2026.10.28 23:52:37.777342 [ 662 ] {} <Debug> AsyncLoader: Change current priority: 0 -> none
2026.10.28 23:52:37.777469 [ 10 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/lib/clickhouse/user_defined/
2026.10.28 23:52:37.777558 [ 10 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded
2026.10.28 23:52:37.777570 [ 10 ] {} <Debug> Application: Loaded metadata.
2026.10.28 23:52:37.777624 [ 10 ] {} <Trace> Pipe: Pipe capacity is 1.00 MiB
2026.10.28 23:52:37.777687 [ 10 ] {} <Information> Application: Tasks stats provider: procfs
2026.10.28 23:52:37.777698 [ 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 23:52:37.778239 [ 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.10427.altinitystable (altinity build))
2026.10.28 23:52:37.778329 [ 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.10427.altinitystable (altinity build))
2026.10.28 23:52:37.778335 [ 10 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair.
2026.10.28 23:52:37.823687 [ 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.10427.altinitystable (altinity build))
2026.10.28 23:52:37.823774 [ 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.10427.altinitystable (altinity build))
2026.10.28 23:52:37.823780 [ 10 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair.
2026.10.28 23:52:37.930519 [ 10 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again.
2026.10.28 23:52:37.931514 [ 10 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 49.41 MiB, peak 49.41 MiB, free memory in arenas 44.85 MiB, will set to 449.91 MiB (RSS), difference: 400.50 MiB
2026.10.28 23:52:37.933064 [ 10 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 1.188e-05 sec.
2026.10.28 23:52:37.933914 [ 10 ] {} <Information> Application: Listening for http://[::1]:8123
2026.10.28 23:52:37.933958 [ 10 ] {} <Information> Application: Listening for native protocol (tcp): [::1]:9000
2026.10.28 23:52:37.934001 [ 10 ] {} <Information> Application: Listening for MySQL compatibility protocol: [::1]:9004
2026.10.28 23:52:37.934041 [ 10 ] {} <Information> Application: Listening for PostgreSQL compatibility protocol: [::1]:9005
2026.10.28 23:52:37.934078 [ 10 ] {} <Information> Application: Listening for http://127.0.0.1:8123
2026.10.28 23:52:37.934256 [ 10 ] {} <Information> Application: Listening for native protocol (tcp): 127.0.0.1:9000
2026.10.28 23:52:37.934298 [ 10 ] {} <Information> Application: Listening for MySQL compatibility protocol: 127.0.0.1:9004
2026.10.28 23:52:37.934336 [ 10 ] {} <Information> Application: Listening for PostgreSQL compatibility protocol: 127.0.0.1:9005
2026.10.28 23:52:37.934340 [ 10 ] {} <Information> Application: Ready for connections.
2026.10.28 23:52:38.000829 [ 662 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 449.93 MiB, peak 449.93 MiB, free memory in arenas 44.91 MiB, will set to 452.71 MiB (RSS), difference: 2.78 MiB
2026.10.28 23:52:42.292298 [ 12 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:46446
2026.10.28 23:52:42.292667 [ 12 ] {} <Debug> TCPHandler: Connected ClickHouse client version 24.3.0, revision: 54467, user: default.
2026.10.28 23:52:42.292702 [ 12 ] {} <Debug> TCP-Session: 05eebb69-17ec-4f1e-bcc9-54fb0ad9dc13 Authenticating user 'default' from [::1]:46446
2026.10.28 23:52:42.292738 [ 12 ] {} <Debug> TCP-Session: 05eebb69-17ec-4f1e-bcc9-54fb0ad9dc13 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
2026.10.28 23:52:42.292746 [ 12 ] {} <Debug> TCP-Session: 05eebb69-17ec-4f1e-bcc9-54fb0ad9dc13 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
2026.10.28 23:52:42.292844 [ 12 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false
2026.10.28 23:52:42.292869 [ 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 23:52:42.292893 [ 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 23:52:42.317186 [ 12 ] {} <Trace> TCP-Session: 05eebb69-17ec-4f1e-bcc9-54fb0ad9dc13 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
2026.10.28 23:52:42.317553 [ 12 ] {88fc8772-97c2-4562-a9a0-638aad068d8a} <Debug> executeQuery: (from [::1]:46446) select 'OK' (stage: Complete)
2026.10.28 23:52:42.317782 [ 12 ] {88fc8772-97c2-4562-a9a0-638aad068d8a} <Trace> Planner: Query SELECT 'OK' AS `'OK'` FROM system.one AS __table1 to stage Complete
2026.10.28 23:52:42.317818 [ 12 ] {88fc8772-97c2-4562-a9a0-638aad068d8a} <Trace> ContextAccess (default): Access granted: SELECT(dummy) ON system.one
2026.10.28 23:52:42.317885 [ 12 ] {88fc8772-97c2-4562-a9a0-638aad068d8a} <Trace> Planner: Query SELECT 'OK' AS `'OK'` FROM system.one AS __table1 from stage FetchColumns to stage Complete
2026.10.28 23:52:42.318861 [ 12 ] {88fc8772-97c2-4562-a9a0-638aad068d8a} <Debug> executeQuery: Read 1 rows, 1.00 B in 0.001339 sec., 746.8259895444362 rows/sec., 746.83 B/sec.
2026.10.28 23:52:42.318898 [ 12 ] {88fc8772-97c2-4562-a9a0-638aad068d8a} <Debug> TCPHandler: Processed in 0.001925111 sec.
2026.10.28 23:52:42.321496 [ 12 ] {} <Debug> TCPHandler: Done processing connection.
2026.10.28 23:52:42.321522 [ 12 ] {} <Debug> TCP-Session: 05eebb69-17ec-4f1e-bcc9-54fb0ad9dc13 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
2026.10.28 23:52:42.725747 [ 7 ] {} <Information> Application: Will watch for the process with pid 9
2026.10.28 23:52:42.726070 [ 9 ] {} <Information> Application: Forked a child process to watch
2026.10.28 23:52:42.726519 [ 9 ] {} <Information> SentryWriter: Sending crash reports is disabled
2026.10.28 23:52:42.726827 [ 9 ] {} <Trace> Pipe: Pipe capacity is 1.00 MiB
2026.10.28 23:52:42.837132 [ 9 ] {} <Information> Application: Starting ClickHouse 24.3.18.10427.altinitystable (revision: 4294967295, git hash: fcaf6e1267e237da0994d3e05c9aabfe63c284a1, build id: A30AA3BA3667FFAE6B8E1D3DD52AEBFE6405FDFF), PID 9
2026.10.28 23:52:42.837299 [ 9 ] {} <Information> Application: starting up
2026.10.28 23:52:42.837317 [ 9 ] {} <Information> Application: OS name: Linux, version: 5.15.0-130-generic, architecture: x86_64
2026.10.28 23:52:42.842070 [ 9 ] {} <Information> Application: Available RAM: 30.59 GiB; logical cores: 16; used cores: 16.
2026.10.28 23:52:42.842114 [ 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 23:52:42.842291 [ 9 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/thermal
2026.10.28 23:52:42.842304 [ 9 ] {} <Trace> AsynchronousMetrics: Scanning /sys/block
2026.10.28 23:52:42.842394 [ 9 ] {} <Trace> AsynchronousMetrics: Scanning /sys/devices/system/edac
2026.10.28 23:52:42.842412 [ 9 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/hwmon
2026.10.28 23:52:42.845794 [ 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 23:52:42.975291 [ 9 ] {} <Information> Application: Integrity check of the executable successfully passed (checksum: 57C7145187074368B9AC26AE558E6A35)
2026.10.28 23:52:42.975368 [ 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 23:52:42.977303 [ 9 ] {} <Debug> Application: rlimit on number of file descriptors is 1048576
2026.10.28 23:52:42.977316 [ 9 ] {} <Debug> Application: rlimit on number of threads is 18446744073709551615
2026.10.28 23:52:42.977325 [ 9 ] {} <Debug> Application: Initializing DateLUT.
2026.10.28 23:52:42.977330 [ 9 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'.
2026.10.28 23:52:42.977359 [ 9 ] {} <Debug> Context: Setting up /var/lib/clickhouse/tmp/ to store temporary data in it
2026.10.28 23:52:42.977908 [ 9 ] {} <Debug> Application: Configuration parameter 'interserver_http_host' doesn't exist or exists and empty. Will use 'github-hetzner-runner-40783431156-123171777037' as replica host.
2026.10.28 23:52:42.977922 [ 9 ] {} <Debug> Application: Initializing interserver credentials.
2026.10.28 23:52:42.978020 [ 9 ] {} <Trace> NamedCollectionsUtils: Loaded 0 collections from config
2026.10.28 23:52:42.978091 [ 9 ] {} <Trace> NamedCollectionsUtils: Loaded 0 collections from SQL
2026.10.28 23:52:42.978194 [ 9 ] {} <Information> CgroupsMemoryUsageObserver: Will read the current memory usage from '/sys/fs/cgroup/' (cgroups version: v2), wait time is 15 sec
2026.10.28 23:52:42.978422 [ 9 ] {} <Debug> ConfigReloader: Loading config '/config/config.xml'
2026.10.28 23:52:42.978430 [ 9 ] {} <Debug> ConfigProcessor: Processing configuration file '/config/config.xml'.
2026.10.28 23:52:42.981425 [ 9 ] {} <Debug> ConfigProcessor: Saved preprocessed configuration to '/var/lib/clickhouse/preprocessed_configs/config.xml'.
2026.10.28 23:52:42.981487 [ 9 ] {} <Debug> ConfigReloader: Loaded config '/config/config.xml', performing update on configuration
2026.10.28 23:52:42.984400 [ 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 23:52:42.984412 [ 9 ] {} <Information> CgroupsMemoryUsageObserver: Set new limits, soft limit: 24.78 GiB, hard limit: 26.16 GiB
2026.10.28 23:52:42.984418 [ 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 23:52:42.984423 [ 9 ] {} <Information> Application: Merges and mutations memory limit is set to 15.30 GiB
2026.10.28 23:52:42.984670 [ 9 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads
2026.10.28 23:52:42.985675 [ 9 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 512 threads
2026.10.28 23:52:43.091596 [ 9 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads
2026.10.28 23:52:43.094040 [ 9 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads
2026.10.28 23:52:43.097920 [ 9 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again.
2026.10.28 23:52:43.098036 [ 9 ] {} <Debug> ConfigReloader: Loaded config '/config/config.xml', performed update on configuration
2026.10.28 23:52:43.101306 [ 9 ] {} <Information> Application: Listening for replica communication (interserver): http://[::1]:9009
2026.10.28 23:52:43.102320 [ 9 ] {} <Information> Application: Listening for replica communication (interserver): http://127.0.0.1:9009
2026.10.28 23:52:43.107618 [ 9 ] {} <Debug> ConfigReloader: Loading config '/config/users.xml'
2026.10.28 23:52:43.107645 [ 9 ] {} <Debug> ConfigProcessor: Processing configuration file '/config/users.xml'.
2026.10.28 23:52:43.108541 [ 9 ] {} <Debug> ConfigProcessor: Saved preprocessed configuration to '/var/lib/clickhouse/preprocessed_configs/users.xml'.
2026.10.28 23:52:43.108570 [ 9 ] {} <Debug> ConfigReloader: Loaded config '/config/users.xml', performing update on configuration
2026.10.28 23:52:43.109844 [ 9 ] {} <Debug> ConfigReloader: Loaded config '/config/users.xml', performed update on configuration
2026.10.28 23:52:43.110027 [ 9 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: /config/users.xml
2026.10.28 23:52:43.110290 [ 9 ] {} <Warning> Access(local_directory): File /var/lib/clickhouse/access/users.list doesn't exist
2026.10.28 23:52:43.110316 [ 9 ] {} <Warning> Access(local_directory): Recovering lists in directory /var/lib/clickhouse/access/
2026.10.28 23:52:43.110839 [ 9 ] {} <Debug> Access(user directories): Added local_directory access storage 'local_directory', path: /var/lib/clickhouse/access/
2026.10.28 23:52:43.111004 [ 9 ] {} <Information> CgroupsMemoryUsageObserver: Started cgroup current memory usage observer thread
2026.10.28 23:52:43.111281 [ 580 ] {} <Information> CgroupsMemoryUsageObserver: Memory amount initially available to the process is 30.59 GiB
2026.10.28 23:52:43.112947 [ 9 ] {} <Information> Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32, scheduling_policy=round_robin
2026.10.28 23:52:43.113772 [ 9 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8
2026.10.28 23:52:43.115500 [ 9 ] {} <Information> Context: Initialized background executor for fetches with num_threads=16, num_tasks=16
2026.10.28 23:52:43.116319 [ 9 ] {} <Information> Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8
2026.10.28 23:52:43.118279 [ 9 ] {} <Information> DNSCacheUpdater: Update period 15 seconds
2026.10.28 23:52:43.118309 [ 9 ] {} <Information> Application: Loading metadata from /var/lib/clickhouse/
2026.10.28 23:52:43.118401 [ 44 ] {} <Debug> DNSResolver: Updating DNS cache
2026.10.28 23:52:43.120946 [ 44 ] {} <Debug> DNSResolver: Updated DNS cache
2026.10.28 23:52:43.126620 [ 9 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total.
2026.10.28 23:52:43.126650 [ 9 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.00017354 sec
2026.10.28 23:52:43.126664 [ 9 ] {} <Trace> ReferentialDeps: No tables
2026.10.28 23:52:43.126675 [ 9 ] {} <Trace> LoadingDeps: No tables
2026.10.28 23:52:43.126751 [ 9 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Atomic database system': BgStartup -> FgLoad
2026.10.28 23:52:43.126765 [ 9 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Ordinary database system': BgStartup -> FgLoad
2026.10.28 23:52:43.126780 [ 9 ] {} <Debug> AsyncLoader: Schedule load job 'startup Ordinary database system' into FgLoad
2026.10.28 23:52:43.126793 [ 9 ] {} <Debug> AsyncLoader: Schedule load job 'startup Atomic database system' into FgLoad
2026.10.28 23:52:43.126806 [ 9 ] {} <Debug> AsyncLoader: Change current priority: none -> 0
2026.10.28 23:52:43.126819 [ 9 ] {} <Debug> AsyncLoader: Spawn loader worker #1 in FgLoad
2026.10.28 23:52:43.127007 [ 9 ] {} <Debug> AsyncLoader: Wait load job 'startup Atomic database system' in FgLoad
2026.10.28 23:52:43.127124 [ 645 ] {} <Debug> AsyncLoader: Execute load job 'startup Ordinary database system' in FgLoad
2026.10.28 23:52:43.127190 [ 645 ] {} <Debug> AsyncLoader: Finish load job 'startup Ordinary database system' with status OK
2026.10.28 23:52:43.127205 [ 645 ] {} <Debug> AsyncLoader: Spawn loader worker #2 in FgLoad
2026.10.28 23:52:43.127372 [ 645 ] {} <Debug> AsyncLoader: Execute load job 'startup Atomic database system' in FgLoad
2026.10.28 23:52:43.127473 [ 645 ] {} <Debug> AsyncLoader: Finish load job 'startup Atomic database system' with status OK
2026.10.28 23:52:43.127489 [ 645 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2026.10.28 23:52:43.127503 [ 9 ] {} <Debug> SystemLog: Creating system.query_log from query_log
2026.10.28 23:52:43.127571 [ 646 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2026.10.28 23:52:43.127613 [ 646 ] {} <Debug> AsyncLoader: Change current priority: 0 -> none
2026.10.28 23:52:43.129584 [ 9 ] {} <Debug> SystemLog: Creating system.query_thread_log from query_thread_log
2026.10.28 23:52:43.130225 [ 9 ] {} <Debug> SystemLog: Creating system.part_log from part_log
2026.10.28 23:52:43.130829 [ 9 ] {} <Debug> SystemLog: Creating system.trace_log from trace_log
2026.10.28 23:52:43.131207 [ 9 ] {} <Debug> SystemLog: Creating system.crash_log from crash_log
2026.10.28 23:52:43.131506 [ 9 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config
2026.10.28 23:52:43.131534 [ 9 ] {} <Debug> SystemLog: Creating system.metric_log from metric_log
2026.10.28 23:52:43.140578 [ 9 ] {} <Debug> SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config
2026.10.28 23:52:43.140619 [ 9 ] {} <Debug> SystemLog: Not creating system.filesystem_read_prefetches_log since corresponding section 'filesystem_read_prefetches_log' is missing from config
2026.10.28 23:52:43.140643 [ 9 ] {} <Debug> SystemLog: Creating system.asynchronous_metric_log from asynchronous_metric_log
2026.10.28 23:52:43.140992 [ 9 ] {} <Debug> SystemLog: Creating system.opentelemetry_span_log from opentelemetry_span_log
2026.10.28 23:52:43.141419 [ 9 ] {} <Debug> SystemLog: Creating system.query_views_log from query_views_log
2026.10.28 23:52:43.141847 [ 9 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config
2026.10.28 23:52:43.141886 [ 9 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config
2026.10.28 23:52:43.141907 [ 9 ] {} <Debug> SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config
2026.10.28 23:52:43.141927 [ 9 ] {} <Debug> SystemLog: Creating system.processors_profile_log from processors_profile_log
2026.10.28 23:52:43.142301 [ 9 ] {} <Debug> SystemLog: Creating system.asynchronous_insert_log from asynchronous_insert_log
2026.10.28 23:52:43.142712 [ 9 ] {} <Debug> SystemLog: Creating system.backup_log from backup_log
2026.10.28 23:52:43.143062 [ 9 ] {} <Debug> SystemLog: Creating system.s3queue_log from s3queue_log
2026.10.28 23:52:43.143393 [ 9 ] {} <Debug> SystemLog: Creating system.blob_storage_log from blob_storage_log
2026.10.28 23:52:43.166403 [ 9 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal.
2026.10.28 23:52:43.169339 [ 9 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total.
2026.10.28 23:52:43.169361 [ 9 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 7.603e-05 sec
2026.10.28 23:52:43.169373 [ 9 ] {} <Trace> ReferentialDeps: No tables
2026.10.28 23:52:43.169382 [ 9 ] {} <Trace> LoadingDeps: No tables
2026.10.28 23:52:43.169445 [ 9 ] {} <Information> loadMetadata: Start synchronous loading of databases
2026.10.28 23:52:43.169454 [ 9 ] {} <Information> loadMetadata: Start synchronous startup of databases
2026.10.28 23:52:43.169464 [ 9 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Atomic database default': BgStartup -> FgLoad
2026.10.28 23:52:43.169473 [ 9 ] {} <Debug> AsyncLoader: Prioritize load job 'startup Ordinary database default': BgStartup -> FgLoad
2026.10.28 23:52:43.169486 [ 9 ] {} <Debug> AsyncLoader: Schedule load job 'startup Ordinary database default' into FgLoad
2026.10.28 23:52:43.169495 [ 9 ] {} <Debug> AsyncLoader: Schedule load job 'startup Atomic database default' into FgLoad
2026.10.28 23:52:43.169505 [ 9 ] {} <Debug> AsyncLoader: Change current priority: none -> 0
2026.10.28 23:52:43.169514 [ 9 ] {} <Debug> AsyncLoader: Spawn loader worker #1 in FgLoad
2026.10.28 23:52:43.169668 [ 9 ] {} <Debug> AsyncLoader: Wait load job 'startup Atomic database default' in FgLoad
2026.10.28 23:52:43.169855 [ 660 ] {} <Debug> AsyncLoader: Execute load job 'startup Ordinary database default' in FgLoad
2026.10.28 23:52:43.169925 [ 660 ] {} <Debug> AsyncLoader: Finish load job 'startup Ordinary database default' with status OK
2026.10.28 23:52:43.169939 [ 660 ] {} <Debug> AsyncLoader: Spawn loader worker #2 in FgLoad
2026.10.28 23:52:43.170072 [ 660 ] {} <Debug> AsyncLoader: Execute load job 'startup Atomic database default' in FgLoad
2026.10.28 23:52:43.170095 [ 660 ] {} <Debug> AsyncLoader: Finish load job 'startup Atomic database default' with status OK
2026.10.28 23:52:43.170104 [ 660 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2026.10.28 23:52:43.170123 [ 660 ] {} <Debug> AsyncLoader: Stop worker in FgLoad
2026.10.28 23:52:43.170133 [ 660 ] {} <Debug> AsyncLoader: Change current priority: 0 -> none
2026.10.28 23:52:43.170325 [ 9 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/lib/clickhouse/user_defined/
2026.10.28 23:52:43.170387 [ 9 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded
2026.10.28 23:52:43.170409 [ 9 ] {} <Debug> Application: Loaded metadata.
2026.10.28 23:52:43.170452 [ 9 ] {} <Trace> Pipe: Pipe capacity is 1.00 MiB
2026.10.28 23:52:43.170504 [ 9 ] {} <Information> Application: Tasks stats provider: procfs
2026.10.28 23:52:43.170514 [ 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 23:52:43.171144 [ 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.10427.altinitystable (altinity build))
2026.10.28 23:52:43.171278 [ 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.10427.altinitystable (altinity build))
2026.10.28 23:52:43.171288 [ 9 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair.
2026.10.28 23:52:43.356486 [ 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.10427.altinitystable (altinity build))
2026.10.28 23:52:43.356559 [ 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.10427.altinitystable (altinity build))
2026.10.28 23:52:43.356564 [ 9 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair.
2026.10.28 23:52:43.440683 [ 9 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again.
2026.10.28 23:52:43.441833 [ 9 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 49.41 MiB, peak 49.41 MiB, free memory in arenas 43.12 MiB, will set to 447.83 MiB (RSS), difference: 398.42 MiB
2026.10.28 23:52:43.444341 [ 9 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 1.708e-05 sec.
2026.10.28 23:52:43.445425 [ 9 ] {} <Information> Application: Listening for http://[::1]:8123
2026.10.28 23:52:43.445490 [ 9 ] {} <Information> Application: Listening for native protocol (tcp): [::1]:9000
2026.10.28 23:52:43.445540 [ 9 ] {} <Information> Application: Listening for MySQL compatibility protocol: [::1]:9004
2026.10.28 23:52:43.445609 [ 9 ] {} <Information> Application: Listening for PostgreSQL compatibility protocol: [::1]:9005
2026.10.28 23:52:43.445669 [ 9 ] {} <Information> Application: Listening for http://127.0.0.1:8123
2026.10.28 23:52:43.445724 [ 9 ] {} <Information> Application: Listening for native protocol (tcp): 127.0.0.1:9000
2026.10.28 23:52:43.445776 [ 9 ] {} <Information> Application: Listening for MySQL compatibility protocol: 127.0.0.1:9004
2026.10.28 23:52:43.445828 [ 9 ] {} <Information> Application: Listening for PostgreSQL compatibility protocol: 127.0.0.1:9005
2026.10.28 23:52:43.445834 [ 9 ] {} <Information> Application: Ready for connections.
2026.10.28 23:52:44.000971 [ 662 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 447.86 MiB, peak 447.86 MiB, free memory in arenas 43.17 MiB, will set to 450.41 MiB (RSS), difference: 2.56 MiB
2026.10.28 23:52:47.730304 [ 11 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: 127.0.0.1:53302
2026.10.28 23:52:47.730595 [ 11 ] {} <Debug> TCPHandler: Connected ClickHouse client version 24.3.0, revision: 54467, user: default.
2026.10.28 23:52:47.730641 [ 11 ] {} <Debug> TCP-Session: 581c235f-a5ef-4ad5-8531-b56c22cf5216 Authenticating user 'default' from 127.0.0.1:53302
2026.10.28 23:52:47.730700 [ 11 ] {} <Debug> TCP-Session: 581c235f-a5ef-4ad5-8531-b56c22cf5216 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
2026.10.28 23:52:47.730714 [ 11 ] {} <Debug> TCP-Session: 581c235f-a5ef-4ad5-8531-b56c22cf5216 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
2026.10.28 23:52:47.730870 [ 11 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false
2026.10.28 23:52:47.730906 [ 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 23:52:47.730949 [ 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 23:52:47.751667 [ 11 ] {} <Trace> TCP-Session: 581c235f-a5ef-4ad5-8531-b56c22cf5216 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
2026.10.28 23:52:47.752254 [ 11 ] {d6babd59-d9cc-4972-b630-2dd0d71ae13e} <Debug> executeQuery: (from 127.0.0.1:53302) select 'OK' (stage: Complete)
2026.10.28 23:52:47.752554 [ 11 ] {d6babd59-d9cc-4972-b630-2dd0d71ae13e} <Trace> Planner: Query SELECT 'OK' AS `'OK'` FROM system.one AS __table1 to stage Complete
2026.10.28 23:52:47.752606 [ 11 ] {d6babd59-d9cc-4972-b630-2dd0d71ae13e} <Trace> ContextAccess (default): Access granted: SELECT(dummy) ON system.one
2026.10.28 23:52:47.752690 [ 11 ] {d6babd59-d9cc-4972-b630-2dd0d71ae13e} <Trace> Planner: Query SELECT 'OK' AS `'OK'` FROM system.one AS __table1 from stage FetchColumns to stage Complete
2026.10.28 23:52:47.754127 [ 11 ] {d6babd59-d9cc-4972-b630-2dd0d71ae13e} <Debug> executeQuery: Read 1 rows, 1.00 B in 0.001909 sec., 523.8344683080146 rows/sec., 523.83 B/sec.
2026.10.28 23:52:47.754210 [ 11 ] {d6babd59-d9cc-4972-b630-2dd0d71ae13e} <Debug> TCPHandler: Processed in 0.002712061 sec.
2026.10.28 23:52:47.755296 [ 11 ] {} <Debug> TCPHandler: Done processing connection.
2026.10.28 23:52:47.755331 [ 11 ] {} <Debug> TCP-Session: 581c235f-a5ef-4ad5-8531-b56c22cf5216 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db