2024.12.16 08:57:35.308957 [ 8 ] {} Application: Will watch for the process with pid 10 2024.12.16 08:57:35.309039 [ 10 ] {} Application: Forked a child process to watch 2024.12.16 08:57:35.309247 [ 10 ] {} SentryWriter: Sending crash reports is disabled 2024.12.16 08:57:35.309388 [ 10 ] {} Pipe: Pipe capacity is 1.00 MiB 2024.12.16 08:57:35.391270 [ 10 ] {} Application: Starting ClickHouse 24.3.12.76.altinitystable (revision: 54490, git hash: 2f7ddaa904b1e8b911d6f3d911cf6e53720aba01, build id: 1BC1C35C8C8B49CBB8E66E6A821B73DAD1764212), PID 10 2024.12.16 08:57:35.391415 [ 10 ] {} Application: starting up 2024.12.16 08:57:35.391429 [ 10 ] {} Application: OS name: Linux, version: 5.15.0-125-generic, architecture: x86_64 2024.12.16 08:57:35.395397 [ 10 ] {} Application: Available RAM: 30.60 GiB; logical cores: 16; used cores: 16. 2024.12.16 08:57:35.395419 [ 10 ] {} 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 2024.12.16 08:57:35.395535 [ 10 ] {} AsynchronousMetrics: Scanning /sys/class/thermal 2024.12.16 08:57:35.395548 [ 10 ] {} AsynchronousMetrics: Scanning /sys/block 2024.12.16 08:57:35.395608 [ 10 ] {} AsynchronousMetrics: Scanning /sys/devices/system/edac 2024.12.16 08:57:35.395621 [ 10 ] {} AsynchronousMetrics: Scanning /sys/class/hwmon 2024.12.16 08:57:35.400288 [ 10 ] {} 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. 2024.12.16 08:57:35.400399 [ 10 ] {} Application: Integrity check of the executable skipped because the reference checksum could not be read. 2024.12.16 08:57:35.400416 [ 10 ] {} 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. 2024.12.16 08:57:35.401852 [ 10 ] {} Application: rlimit on number of file descriptors is 1048576 2024.12.16 08:57:35.401861 [ 10 ] {} Application: rlimit on number of threads is 18446744073709551615 2024.12.16 08:57:35.401865 [ 10 ] {} Application: Initializing DateLUT. 2024.12.16 08:57:35.401868 [ 10 ] {} Application: Initialized DateLUT with time zone 'Zulu'. 2024.12.16 08:57:35.401890 [ 10 ] {} Context: Setting up /var/lib/clickhouse/tmp/ to store temporary data in it 2024.12.16 08:57:35.402327 [ 10 ] {} Application: Configuration parameter 'interserver_http_host' doesn't exist or exists and empty. Will use 'github-hetzner-runner-12348497406-34457740071' as replica host. 2024.12.16 08:57:35.402340 [ 10 ] {} Application: Initializing interserver credentials. 2024.12.16 08:57:35.402446 [ 10 ] {} NamedCollectionsUtils: Loaded 0 collections from config 2024.12.16 08:57:35.402506 [ 10 ] {} NamedCollectionsUtils: Loaded 0 collections from SQL 2024.12.16 08:57:35.402578 [ 10 ] {} CgroupsMemoryUsageObserver: Will read the current memory usage from '/sys/fs/cgroup/' (cgroups version: v2), wait time is 15 sec 2024.12.16 08:57:35.402923 [ 10 ] {} ConfigReloader: Loading config '/config/config.xml' 2024.12.16 08:57:35.402933 [ 10 ] {} ConfigProcessor: Processing configuration file '/config/config.xml'. 2024.12.16 08:57:35.406349 [ 10 ] {} ConfigProcessor: Saved preprocessed configuration to '/var/lib/clickhouse/preprocessed_configs/config.xml'. 2024.12.16 08:57:35.406419 [ 10 ] {} ConfigReloader: Loaded config '/config/config.xml', performing update on configuration 2024.12.16 08:57:35.410340 [ 10 ] {} 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) 2024.12.16 08:57:35.410354 [ 10 ] {} CgroupsMemoryUsageObserver: Set new limits, soft limit: 24.79 GiB, hard limit: 26.16 GiB 2024.12.16 08:57:35.410358 [ 10 ] {} 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) 2024.12.16 08:57:35.410361 [ 10 ] {} Application: Merges and mutations memory limit is set to 15.30 GiB 2024.12.16 08:57:35.410656 [ 10 ] {} BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads 2024.12.16 08:57:35.411402 [ 10 ] {} BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 512 threads 2024.12.16 08:57:35.467867 [ 10 ] {} BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads 2024.12.16 08:57:35.472525 [ 10 ] {} BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads 2024.12.16 08:57:35.473824 [ 10 ] {} CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. 2024.12.16 08:57:35.474027 [ 10 ] {} ConfigReloader: Loaded config '/config/config.xml', performed update on configuration 2024.12.16 08:57:35.475996 [ 10 ] {} Application: Listening for replica communication (interserver): http://[::1]:9009 2024.12.16 08:57:35.476066 [ 10 ] {} Application: Listening for replica communication (interserver): http://127.0.0.1:9009 2024.12.16 08:57:35.477821 [ 10 ] {} ConfigReloader: Loading config '/config/users.xml' 2024.12.16 08:57:35.477830 [ 10 ] {} ConfigProcessor: Processing configuration file '/config/users.xml'. 2024.12.16 08:57:35.478301 [ 10 ] {} ConfigProcessor: Saved preprocessed configuration to '/var/lib/clickhouse/preprocessed_configs/users.xml'. 2024.12.16 08:57:35.478320 [ 10 ] {} ConfigReloader: Loaded config '/config/users.xml', performing update on configuration 2024.12.16 08:57:35.478967 [ 10 ] {} ConfigReloader: Loaded config '/config/users.xml', performed update on configuration 2024.12.16 08:57:35.479129 [ 10 ] {} Access(user directories): Added users_xml access storage 'users_xml', path: /config/users.xml 2024.12.16 08:57:35.479226 [ 10 ] {} Access(local_directory): File /var/lib/clickhouse/access/users.list doesn't exist 2024.12.16 08:57:35.479237 [ 10 ] {} Access(local_directory): Recovering lists in directory /var/lib/clickhouse/access/ 2024.12.16 08:57:35.479383 [ 10 ] {} Access(user directories): Added local_directory access storage 'local_directory', path: /var/lib/clickhouse/access/ 2024.12.16 08:57:35.479460 [ 10 ] {} CgroupsMemoryUsageObserver: Started cgroup current memory usage observer thread 2024.12.16 08:57:35.480125 [ 581 ] {} CgroupsMemoryUsageObserver: Memory amount initially available to the process is 30.60 GiB 2024.12.16 08:57:35.480495 [ 10 ] {} Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32, scheduling_policy=round_robin 2024.12.16 08:57:35.480767 [ 10 ] {} Context: Initialized background executor for move operations with num_threads=8, num_tasks=8 2024.12.16 08:57:35.481897 [ 10 ] {} Context: Initialized background executor for fetches with num_threads=16, num_tasks=16 2024.12.16 08:57:35.485207 [ 10 ] {} Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8 2024.12.16 08:57:35.486308 [ 10 ] {} DNSCacheUpdater: Update period 15 seconds 2024.12.16 08:57:35.486328 [ 10 ] {} Application: Loading metadata from /var/lib/clickhouse/ 2024.12.16 08:57:35.486376 [ 38 ] {} DNSResolver: Updating DNS cache 2024.12.16 08:57:35.487416 [ 38 ] {} DNSResolver: Updated DNS cache 2024.12.16 08:57:35.492594 [ 10 ] {} DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total. 2024.12.16 08:57:35.492612 [ 10 ] {} TablesLoader: Parsed metadata of 0 tables in 1 databases in 6.7256e-05 sec 2024.12.16 08:57:35.492617 [ 10 ] {} ReferentialDeps: No tables 2024.12.16 08:57:35.492621 [ 10 ] {} LoadingDeps: No tables 2024.12.16 08:57:35.492676 [ 10 ] {} AsyncLoader: Prioritize load job 'startup Atomic database system': BgStartup -> FgLoad 2024.12.16 08:57:35.492681 [ 10 ] {} AsyncLoader: Prioritize load job 'startup Ordinary database system': BgStartup -> FgLoad 2024.12.16 08:57:35.492687 [ 10 ] {} AsyncLoader: Schedule load job 'startup Ordinary database system' into FgLoad 2024.12.16 08:57:35.492691 [ 10 ] {} AsyncLoader: Schedule load job 'startup Atomic database system' into FgLoad 2024.12.16 08:57:35.492696 [ 10 ] {} AsyncLoader: Change current priority: none -> 0 2024.12.16 08:57:35.492700 [ 10 ] {} AsyncLoader: Spawn loader worker #1 in FgLoad 2024.12.16 08:57:35.492768 [ 10 ] {} AsyncLoader: Wait load job 'startup Atomic database system' in FgLoad 2024.12.16 08:57:35.492836 [ 646 ] {} AsyncLoader: Execute load job 'startup Ordinary database system' in FgLoad 2024.12.16 08:57:35.492864 [ 646 ] {} AsyncLoader: Finish load job 'startup Ordinary database system' with status OK 2024.12.16 08:57:35.492869 [ 646 ] {} AsyncLoader: Spawn loader worker #2 in FgLoad 2024.12.16 08:57:35.492932 [ 646 ] {} AsyncLoader: Execute load job 'startup Atomic database system' in FgLoad 2024.12.16 08:57:35.492952 [ 646 ] {} AsyncLoader: Finish load job 'startup Atomic database system' with status OK 2024.12.16 08:57:35.492957 [ 646 ] {} AsyncLoader: Stop worker in FgLoad 2024.12.16 08:57:35.492997 [ 10 ] {} SystemLog: Creating system.query_log from query_log 2024.12.16 08:57:35.493038 [ 647 ] {} AsyncLoader: Stop worker in FgLoad 2024.12.16 08:57:35.493076 [ 647 ] {} AsyncLoader: Change current priority: 0 -> none 2024.12.16 08:57:35.502496 [ 10 ] {} SystemLog: Creating system.query_thread_log from query_thread_log 2024.12.16 08:57:35.502986 [ 10 ] {} SystemLog: Creating system.part_log from part_log 2024.12.16 08:57:35.503376 [ 10 ] {} SystemLog: Creating system.trace_log from trace_log 2024.12.16 08:57:35.503622 [ 10 ] {} SystemLog: Creating system.crash_log from crash_log 2024.12.16 08:57:35.503799 [ 10 ] {} SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config 2024.12.16 08:57:35.503816 [ 10 ] {} SystemLog: Creating system.metric_log from metric_log 2024.12.16 08:57:35.508072 [ 10 ] {} SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config 2024.12.16 08:57:35.508092 [ 10 ] {} SystemLog: Not creating system.filesystem_read_prefetches_log since corresponding section 'filesystem_read_prefetches_log' is missing from config 2024.12.16 08:57:35.508108 [ 10 ] {} SystemLog: Creating system.asynchronous_metric_log from asynchronous_metric_log 2024.12.16 08:57:35.508336 [ 10 ] {} SystemLog: Creating system.opentelemetry_span_log from opentelemetry_span_log 2024.12.16 08:57:35.508608 [ 10 ] {} SystemLog: Creating system.query_views_log from query_views_log 2024.12.16 08:57:35.508895 [ 10 ] {} SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config 2024.12.16 08:57:35.508915 [ 10 ] {} SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config 2024.12.16 08:57:35.508925 [ 10 ] {} SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config 2024.12.16 08:57:35.508934 [ 10 ] {} SystemLog: Creating system.processors_profile_log from processors_profile_log 2024.12.16 08:57:35.509181 [ 10 ] {} SystemLog: Creating system.asynchronous_insert_log from asynchronous_insert_log 2024.12.16 08:57:35.509471 [ 10 ] {} SystemLog: Creating system.backup_log from backup_log 2024.12.16 08:57:35.509701 [ 10 ] {} SystemLog: Creating system.s3queue_log from s3queue_log 2024.12.16 08:57:35.509926 [ 10 ] {} SystemLog: Creating system.blob_storage_log from blob_storage_log 2024.12.16 08:57:35.522105 [ 10 ] {} DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal. 2024.12.16 08:57:35.523839 [ 10 ] {} DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total. 2024.12.16 08:57:35.523852 [ 10 ] {} TablesLoader: Parsed metadata of 0 tables in 1 databases in 4.214e-05 sec 2024.12.16 08:57:35.523859 [ 10 ] {} ReferentialDeps: No tables 2024.12.16 08:57:35.523862 [ 10 ] {} LoadingDeps: No tables 2024.12.16 08:57:35.523911 [ 10 ] {} loadMetadata: Start synchronous loading of databases 2024.12.16 08:57:35.523916 [ 10 ] {} loadMetadata: Start synchronous startup of databases 2024.12.16 08:57:35.523933 [ 10 ] {} AsyncLoader: Prioritize load job 'startup Atomic database default': BgStartup -> FgLoad 2024.12.16 08:57:35.523936 [ 10 ] {} AsyncLoader: Prioritize load job 'startup Ordinary database default': BgStartup -> FgLoad 2024.12.16 08:57:35.523941 [ 10 ] {} AsyncLoader: Schedule load job 'startup Ordinary database default' into FgLoad 2024.12.16 08:57:35.523944 [ 10 ] {} AsyncLoader: Schedule load job 'startup Atomic database default' into FgLoad 2024.12.16 08:57:35.523947 [ 10 ] {} AsyncLoader: Change current priority: none -> 0 2024.12.16 08:57:35.523950 [ 10 ] {} AsyncLoader: Spawn loader worker #1 in FgLoad 2024.12.16 08:57:35.524002 [ 10 ] {} AsyncLoader: Wait load job 'startup Atomic database default' in FgLoad 2024.12.16 08:57:35.524091 [ 661 ] {} AsyncLoader: Execute load job 'startup Ordinary database default' in FgLoad 2024.12.16 08:57:35.524131 [ 661 ] {} AsyncLoader: Finish load job 'startup Ordinary database default' with status OK 2024.12.16 08:57:35.524138 [ 661 ] {} AsyncLoader: Spawn loader worker #2 in FgLoad 2024.12.16 08:57:35.524229 [ 661 ] {} AsyncLoader: Execute load job 'startup Atomic database default' in FgLoad 2024.12.16 08:57:35.524242 [ 661 ] {} AsyncLoader: Finish load job 'startup Atomic database default' with status OK 2024.12.16 08:57:35.524246 [ 661 ] {} AsyncLoader: Stop worker in FgLoad 2024.12.16 08:57:35.524255 [ 661 ] {} AsyncLoader: Stop worker in FgLoad 2024.12.16 08:57:35.524259 [ 661 ] {} AsyncLoader: Change current priority: 0 -> none 2024.12.16 08:57:35.524373 [ 10 ] {} UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/lib/clickhouse/user_defined/ 2024.12.16 08:57:35.524405 [ 10 ] {} UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded 2024.12.16 08:57:35.524409 [ 10 ] {} Application: Loaded metadata. 2024.12.16 08:57:35.524431 [ 10 ] {} Pipe: Pipe capacity is 1.00 MiB 2024.12.16 08:57:35.524459 [ 10 ] {} Application: Tasks stats provider: procfs 2024.12.16 08:57:35.524463 [ 10 ] {} 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. 2024.12.16 08:57:35.524770 [ 10 ] {} 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.12.76.altinitystable) 2024.12.16 08:57:35.524820 [ 10 ] {} 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.12.76.altinitystable) 2024.12.16 08:57:35.524827 [ 10 ] {} MySQLHandlerFactory: Generating new RSA key pair. 2024.12.16 08:57:35.588535 [ 10 ] {} 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.12.76.altinitystable) 2024.12.16 08:57:35.588602 [ 10 ] {} 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.12.76.altinitystable) 2024.12.16 08:57:35.588605 [ 10 ] {} MySQLHandlerFactory: Generating new RSA key pair. 2024.12.16 08:57:35.640165 [ 10 ] {} CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. 2024.12.16 08:57:35.641196 [ 10 ] {} AsynchronousMetrics: MemoryTracking: was 54.40 MiB, peak 54.40 MiB, free memory in arenas 5.16 MiB, will set to 218.66 MiB (RSS), difference: 164.25 MiB 2024.12.16 08:57:35.642331 [ 10 ] {} AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 1.4347e-05 sec. 2024.12.16 08:57:35.643195 [ 10 ] {} Application: Listening for http://[::1]:8123 2024.12.16 08:57:35.643233 [ 10 ] {} Application: Listening for native protocol (tcp): [::1]:9000 2024.12.16 08:57:35.643265 [ 10 ] {} Application: Listening for MySQL compatibility protocol: [::1]:9004 2024.12.16 08:57:35.643300 [ 10 ] {} Application: Listening for PostgreSQL compatibility protocol: [::1]:9005 2024.12.16 08:57:35.643336 [ 10 ] {} Application: Listening for http://127.0.0.1:8123 2024.12.16 08:57:35.643366 [ 10 ] {} Application: Listening for native protocol (tcp): 127.0.0.1:9000 2024.12.16 08:57:35.643398 [ 10 ] {} Application: Listening for MySQL compatibility protocol: 127.0.0.1:9004 2024.12.16 08:57:35.643430 [ 10 ] {} Application: Listening for PostgreSQL compatibility protocol: 127.0.0.1:9005 2024.12.16 08:57:35.643435 [ 10 ] {} Application: Ready for connections. 2024.12.16 08:57:36.000745 [ 661 ] {} AsynchronousMetrics: MemoryTracking: was 218.68 MiB, peak 218.68 MiB, free memory in arenas 5.19 MiB, will set to 222.14 MiB (RSS), difference: 3.46 MiB 2024.12.16 08:57:40.303878 [ 12 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:54860 2024.12.16 08:57:40.304067 [ 12 ] {} TCPHandler: Connected ClickHouse client version 24.3.0, revision: 54467, user: default. 2024.12.16 08:57:40.304094 [ 12 ] {} TCP-Session: 0bd969bc-79cc-4ecd-be4f-2a5e491e9e9b Authenticating user 'default' from [::1]:54860 2024.12.16 08:57:40.304127 [ 12 ] {} TCP-Session: 0bd969bc-79cc-4ecd-be4f-2a5e491e9e9b Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.16 08:57:40.304133 [ 12 ] {} TCP-Session: 0bd969bc-79cc-4ecd-be4f-2a5e491e9e9b Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.16 08:57:40.304236 [ 12 ] {} ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false 2024.12.16 08:57:40.304259 [ 12 ] {} 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 2024.12.16 08:57:40.304281 [ 12 ] {} 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 2024.12.16 08:57:40.313641 [ 12 ] {} TCP-Session: 0bd969bc-79cc-4ecd-be4f-2a5e491e9e9b Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.16 08:57:40.313967 [ 12 ] {9db1ceaa-a080-4b20-a3c4-9134ca99d0f6} executeQuery: (from [::1]:54860) select 'OK' (stage: Complete) 2024.12.16 08:57:40.314199 [ 12 ] {9db1ceaa-a080-4b20-a3c4-9134ca99d0f6} Planner: Query SELECT 'OK' AS `'OK'` FROM system.one AS __table1 to stage Complete 2024.12.16 08:57:40.314231 [ 12 ] {9db1ceaa-a080-4b20-a3c4-9134ca99d0f6} ContextAccess (default): Access granted: SELECT(dummy) ON system.one 2024.12.16 08:57:40.314332 [ 12 ] {9db1ceaa-a080-4b20-a3c4-9134ca99d0f6} Planner: Query SELECT 'OK' AS `'OK'` FROM system.one AS __table1 from stage FetchColumns to stage Complete 2024.12.16 08:57:40.315040 [ 12 ] {9db1ceaa-a080-4b20-a3c4-9134ca99d0f6} executeQuery: Read 1 rows, 1.00 B in 0.001103 sec., 906.6183136899365 rows/sec., 906.62 B/sec. 2024.12.16 08:57:40.315074 [ 12 ] {9db1ceaa-a080-4b20-a3c4-9134ca99d0f6} TCPHandler: Processed in 0.001603789 sec. 2024.12.16 08:57:40.324898 [ 12 ] {} TCPHandler: Done processing connection. 2024.12.16 08:57:40.324918 [ 12 ] {} TCP-Session: 0bd969bc-79cc-4ecd-be4f-2a5e491e9e9b Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.16 08:57:40.563949 [ 7 ] {} Application: Will watch for the process with pid 9 2024.12.16 08:57:40.564047 [ 9 ] {} Application: Forked a child process to watch 2024.12.16 08:57:40.564254 [ 9 ] {} SentryWriter: Sending crash reports is disabled 2024.12.16 08:57:40.564370 [ 9 ] {} Pipe: Pipe capacity is 1.00 MiB 2024.12.16 08:57:40.651114 [ 9 ] {} Application: Starting ClickHouse 24.3.12.76.altinitystable (revision: 54490, git hash: 2f7ddaa904b1e8b911d6f3d911cf6e53720aba01, build id: 1BC1C35C8C8B49CBB8E66E6A821B73DAD1764212), PID 9 2024.12.16 08:57:40.651262 [ 9 ] {} Application: starting up 2024.12.16 08:57:40.651277 [ 9 ] {} Application: OS name: Linux, version: 5.15.0-125-generic, architecture: x86_64 2024.12.16 08:57:40.655507 [ 9 ] {} Application: Available RAM: 30.60 GiB; logical cores: 16; used cores: 16. 2024.12.16 08:57:40.655528 [ 9 ] {} 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 2024.12.16 08:57:40.655645 [ 9 ] {} AsynchronousMetrics: Scanning /sys/class/thermal 2024.12.16 08:57:40.655657 [ 9 ] {} AsynchronousMetrics: Scanning /sys/block 2024.12.16 08:57:40.655718 [ 9 ] {} AsynchronousMetrics: Scanning /sys/devices/system/edac 2024.12.16 08:57:40.655731 [ 9 ] {} AsynchronousMetrics: Scanning /sys/class/hwmon 2024.12.16 08:57:40.660198 [ 9 ] {} 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. 2024.12.16 08:57:40.660474 [ 9 ] {} Application: Integrity check of the executable skipped because the reference checksum could not be read. 2024.12.16 08:57:40.660492 [ 9 ] {} 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. 2024.12.16 08:57:40.662250 [ 9 ] {} Application: rlimit on number of file descriptors is 1048576 2024.12.16 08:57:40.662262 [ 9 ] {} Application: rlimit on number of threads is 18446744073709551615 2024.12.16 08:57:40.662268 [ 9 ] {} Application: Initializing DateLUT. 2024.12.16 08:57:40.662271 [ 9 ] {} Application: Initialized DateLUT with time zone 'Zulu'. 2024.12.16 08:57:40.662294 [ 9 ] {} Context: Setting up /var/lib/clickhouse/tmp/ to store temporary data in it 2024.12.16 08:57:40.662764 [ 9 ] {} Application: Configuration parameter 'interserver_http_host' doesn't exist or exists and empty. Will use 'github-hetzner-runner-12348497406-34457740071' as replica host. 2024.12.16 08:57:40.662778 [ 9 ] {} Application: Initializing interserver credentials. 2024.12.16 08:57:40.662906 [ 9 ] {} NamedCollectionsUtils: Loaded 0 collections from config 2024.12.16 08:57:40.662970 [ 9 ] {} NamedCollectionsUtils: Loaded 0 collections from SQL 2024.12.16 08:57:40.663044 [ 9 ] {} CgroupsMemoryUsageObserver: Will read the current memory usage from '/sys/fs/cgroup/' (cgroups version: v2), wait time is 15 sec 2024.12.16 08:57:40.663349 [ 9 ] {} ConfigReloader: Loading config '/config/config.xml' 2024.12.16 08:57:40.663359 [ 9 ] {} ConfigProcessor: Processing configuration file '/config/config.xml'. 2024.12.16 08:57:40.666797 [ 9 ] {} ConfigProcessor: Saved preprocessed configuration to '/var/lib/clickhouse/preprocessed_configs/config.xml'. 2024.12.16 08:57:40.666884 [ 9 ] {} ConfigReloader: Loaded config '/config/config.xml', performing update on configuration 2024.12.16 08:57:40.670956 [ 9 ] {} 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) 2024.12.16 08:57:40.670966 [ 9 ] {} CgroupsMemoryUsageObserver: Set new limits, soft limit: 24.79 GiB, hard limit: 26.16 GiB 2024.12.16 08:57:40.670971 [ 9 ] {} 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) 2024.12.16 08:57:40.670974 [ 9 ] {} Application: Merges and mutations memory limit is set to 15.30 GiB 2024.12.16 08:57:40.671249 [ 9 ] {} BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads 2024.12.16 08:57:40.672464 [ 9 ] {} BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 512 threads 2024.12.16 08:57:40.738148 [ 9 ] {} BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads 2024.12.16 08:57:40.739624 [ 9 ] {} BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads 2024.12.16 08:57:40.741209 [ 9 ] {} CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. 2024.12.16 08:57:40.741290 [ 9 ] {} ConfigReloader: Loaded config '/config/config.xml', performed update on configuration 2024.12.16 08:57:40.743533 [ 9 ] {} Application: Listening for replica communication (interserver): http://[::1]:9009 2024.12.16 08:57:40.744701 [ 9 ] {} Application: Listening for replica communication (interserver): http://127.0.0.1:9009 2024.12.16 08:57:40.749330 [ 9 ] {} ConfigReloader: Loading config '/config/users.xml' 2024.12.16 08:57:40.749348 [ 9 ] {} ConfigProcessor: Processing configuration file '/config/users.xml'. 2024.12.16 08:57:40.749863 [ 9 ] {} ConfigProcessor: Saved preprocessed configuration to '/var/lib/clickhouse/preprocessed_configs/users.xml'. 2024.12.16 08:57:40.749886 [ 9 ] {} ConfigReloader: Loaded config '/config/users.xml', performing update on configuration 2024.12.16 08:57:40.750734 [ 9 ] {} ConfigReloader: Loaded config '/config/users.xml', performed update on configuration 2024.12.16 08:57:40.750996 [ 9 ] {} Access(user directories): Added users_xml access storage 'users_xml', path: /config/users.xml 2024.12.16 08:57:40.751124 [ 9 ] {} Access(local_directory): File /var/lib/clickhouse/access/users.list doesn't exist 2024.12.16 08:57:40.751137 [ 9 ] {} Access(local_directory): Recovering lists in directory /var/lib/clickhouse/access/ 2024.12.16 08:57:40.751491 [ 9 ] {} Access(user directories): Added local_directory access storage 'local_directory', path: /var/lib/clickhouse/access/ 2024.12.16 08:57:40.751588 [ 9 ] {} CgroupsMemoryUsageObserver: Started cgroup current memory usage observer thread 2024.12.16 08:57:40.751929 [ 580 ] {} CgroupsMemoryUsageObserver: Memory amount initially available to the process is 30.60 GiB 2024.12.16 08:57:40.752468 [ 9 ] {} Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32, scheduling_policy=round_robin 2024.12.16 08:57:40.752915 [ 9 ] {} Context: Initialized background executor for move operations with num_threads=8, num_tasks=8 2024.12.16 08:57:40.756903 [ 9 ] {} Context: Initialized background executor for fetches with num_threads=16, num_tasks=16 2024.12.16 08:57:40.757223 [ 9 ] {} Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8 2024.12.16 08:57:40.758041 [ 9 ] {} DNSCacheUpdater: Update period 15 seconds 2024.12.16 08:57:40.758061 [ 9 ] {} Application: Loading metadata from /var/lib/clickhouse/ 2024.12.16 08:57:40.758607 [ 33 ] {} DNSResolver: Updating DNS cache 2024.12.16 08:57:40.761096 [ 33 ] {} DNSResolver: Updated DNS cache 2024.12.16 08:57:40.765293 [ 9 ] {} DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total. 2024.12.16 08:57:40.765315 [ 9 ] {} TablesLoader: Parsed metadata of 0 tables in 1 databases in 9.6471e-05 sec 2024.12.16 08:57:40.765321 [ 9 ] {} ReferentialDeps: No tables 2024.12.16 08:57:40.765326 [ 9 ] {} LoadingDeps: No tables 2024.12.16 08:57:40.765384 [ 9 ] {} AsyncLoader: Prioritize load job 'startup Atomic database system': BgStartup -> FgLoad 2024.12.16 08:57:40.765389 [ 9 ] {} AsyncLoader: Prioritize load job 'startup Ordinary database system': BgStartup -> FgLoad 2024.12.16 08:57:40.765395 [ 9 ] {} AsyncLoader: Schedule load job 'startup Ordinary database system' into FgLoad 2024.12.16 08:57:40.765400 [ 9 ] {} AsyncLoader: Schedule load job 'startup Atomic database system' into FgLoad 2024.12.16 08:57:40.765405 [ 9 ] {} AsyncLoader: Change current priority: none -> 0 2024.12.16 08:57:40.765411 [ 9 ] {} AsyncLoader: Spawn loader worker #1 in FgLoad 2024.12.16 08:57:40.765479 [ 9 ] {} AsyncLoader: Wait load job 'startup Atomic database system' in FgLoad 2024.12.16 08:57:40.765595 [ 645 ] {} AsyncLoader: Execute load job 'startup Ordinary database system' in FgLoad 2024.12.16 08:57:40.765637 [ 645 ] {} AsyncLoader: Finish load job 'startup Ordinary database system' with status OK 2024.12.16 08:57:40.765648 [ 645 ] {} AsyncLoader: Spawn loader worker #2 in FgLoad 2024.12.16 08:57:40.765742 [ 645 ] {} AsyncLoader: Execute load job 'startup Atomic database system' in FgLoad 2024.12.16 08:57:40.765779 [ 645 ] {} AsyncLoader: Finish load job 'startup Atomic database system' with status OK 2024.12.16 08:57:40.765789 [ 645 ] {} AsyncLoader: Stop worker in FgLoad 2024.12.16 08:57:40.765818 [ 9 ] {} SystemLog: Creating system.query_log from query_log 2024.12.16 08:57:40.765891 [ 646 ] {} AsyncLoader: Stop worker in FgLoad 2024.12.16 08:57:40.765961 [ 646 ] {} AsyncLoader: Change current priority: 0 -> none 2024.12.16 08:57:40.776263 [ 9 ] {} SystemLog: Creating system.query_thread_log from query_thread_log 2024.12.16 08:57:40.776709 [ 9 ] {} SystemLog: Creating system.part_log from part_log 2024.12.16 08:57:40.777068 [ 9 ] {} SystemLog: Creating system.trace_log from trace_log 2024.12.16 08:57:40.777294 [ 9 ] {} SystemLog: Creating system.crash_log from crash_log 2024.12.16 08:57:40.777455 [ 9 ] {} SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config 2024.12.16 08:57:40.777472 [ 9 ] {} SystemLog: Creating system.metric_log from metric_log 2024.12.16 08:57:40.782080 [ 9 ] {} SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config 2024.12.16 08:57:40.782102 [ 9 ] {} SystemLog: Not creating system.filesystem_read_prefetches_log since corresponding section 'filesystem_read_prefetches_log' is missing from config 2024.12.16 08:57:40.782119 [ 9 ] {} SystemLog: Creating system.asynchronous_metric_log from asynchronous_metric_log 2024.12.16 08:57:40.782375 [ 9 ] {} SystemLog: Creating system.opentelemetry_span_log from opentelemetry_span_log 2024.12.16 08:57:40.782657 [ 9 ] {} SystemLog: Creating system.query_views_log from query_views_log 2024.12.16 08:57:40.782995 [ 9 ] {} SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config 2024.12.16 08:57:40.783017 [ 9 ] {} SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config 2024.12.16 08:57:40.783028 [ 9 ] {} SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config 2024.12.16 08:57:40.783038 [ 9 ] {} SystemLog: Creating system.processors_profile_log from processors_profile_log 2024.12.16 08:57:40.783262 [ 9 ] {} SystemLog: Creating system.asynchronous_insert_log from asynchronous_insert_log 2024.12.16 08:57:40.783542 [ 9 ] {} SystemLog: Creating system.backup_log from backup_log 2024.12.16 08:57:40.783774 [ 9 ] {} SystemLog: Creating system.s3queue_log from s3queue_log 2024.12.16 08:57:40.784025 [ 9 ] {} SystemLog: Creating system.blob_storage_log from blob_storage_log 2024.12.16 08:57:40.798191 [ 9 ] {} DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal. 2024.12.16 08:57:40.800244 [ 9 ] {} DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total. 2024.12.16 08:57:40.800256 [ 9 ] {} TablesLoader: Parsed metadata of 0 tables in 1 databases in 4.1058e-05 sec 2024.12.16 08:57:40.800262 [ 9 ] {} ReferentialDeps: No tables 2024.12.16 08:57:40.800265 [ 9 ] {} LoadingDeps: No tables 2024.12.16 08:57:40.800303 [ 9 ] {} loadMetadata: Start synchronous loading of databases 2024.12.16 08:57:40.800307 [ 9 ] {} loadMetadata: Start synchronous startup of databases 2024.12.16 08:57:40.800311 [ 9 ] {} AsyncLoader: Prioritize load job 'startup Atomic database default': BgStartup -> FgLoad 2024.12.16 08:57:40.800314 [ 9 ] {} AsyncLoader: Prioritize load job 'startup Ordinary database default': BgStartup -> FgLoad 2024.12.16 08:57:40.800319 [ 9 ] {} AsyncLoader: Schedule load job 'startup Ordinary database default' into FgLoad 2024.12.16 08:57:40.800322 [ 9 ] {} AsyncLoader: Schedule load job 'startup Atomic database default' into FgLoad 2024.12.16 08:57:40.800326 [ 9 ] {} AsyncLoader: Change current priority: none -> 0 2024.12.16 08:57:40.800330 [ 9 ] {} AsyncLoader: Spawn loader worker #1 in FgLoad 2024.12.16 08:57:40.800402 [ 9 ] {} AsyncLoader: Wait load job 'startup Atomic database default' in FgLoad 2024.12.16 08:57:40.800594 [ 660 ] {} AsyncLoader: Execute load job 'startup Ordinary database default' in FgLoad 2024.12.16 08:57:40.800678 [ 660 ] {} AsyncLoader: Finish load job 'startup Ordinary database default' with status OK 2024.12.16 08:57:40.800692 [ 660 ] {} AsyncLoader: Spawn loader worker #2 in FgLoad 2024.12.16 08:57:40.800845 [ 660 ] {} AsyncLoader: Execute load job 'startup Atomic database default' in FgLoad 2024.12.16 08:57:40.800875 [ 660 ] {} AsyncLoader: Finish load job 'startup Atomic database default' with status OK 2024.12.16 08:57:40.800887 [ 660 ] {} AsyncLoader: Stop worker in FgLoad 2024.12.16 08:57:40.801009 [ 9 ] {} UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/lib/clickhouse/user_defined/ 2024.12.16 08:57:40.801013 [ 661 ] {} AsyncLoader: Stop worker in FgLoad 2024.12.16 08:57:40.801048 [ 9 ] {} UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded 2024.12.16 08:57:40.801093 [ 9 ] {} Application: Loaded metadata. 2024.12.16 08:57:40.801082 [ 661 ] {} AsyncLoader: Change current priority: 0 -> none 2024.12.16 08:57:40.801121 [ 9 ] {} Pipe: Pipe capacity is 1.00 MiB 2024.12.16 08:57:40.801157 [ 9 ] {} Application: Tasks stats provider: procfs 2024.12.16 08:57:40.801162 [ 9 ] {} 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. 2024.12.16 08:57:40.801513 [ 9 ] {} 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.12.76.altinitystable) 2024.12.16 08:57:40.801584 [ 9 ] {} 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.12.76.altinitystable) 2024.12.16 08:57:40.801590 [ 9 ] {} MySQLHandlerFactory: Generating new RSA key pair. 2024.12.16 08:57:40.853970 [ 9 ] {} 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.12.76.altinitystable) 2024.12.16 08:57:40.854040 [ 9 ] {} 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.12.76.altinitystable) 2024.12.16 08:57:40.854044 [ 9 ] {} MySQLHandlerFactory: Generating new RSA key pair. 2024.12.16 08:57:40.883805 [ 9 ] {} CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. 2024.12.16 08:57:40.884634 [ 9 ] {} AsynchronousMetrics: MemoryTracking: was 54.40 MiB, peak 54.40 MiB, free memory in arenas 43.98 MiB, will set to 224.61 MiB (RSS), difference: 170.21 MiB 2024.12.16 08:57:40.886108 [ 9 ] {} AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 1.3615e-05 sec. 2024.12.16 08:57:40.886748 [ 9 ] {} Application: Listening for http://[::1]:8123 2024.12.16 08:57:40.886809 [ 9 ] {} Application: Listening for native protocol (tcp): [::1]:9000 2024.12.16 08:57:40.886928 [ 9 ] {} Application: Listening for MySQL compatibility protocol: [::1]:9004 2024.12.16 08:57:40.886968 [ 9 ] {} Application: Listening for PostgreSQL compatibility protocol: [::1]:9005 2024.12.16 08:57:40.887009 [ 9 ] {} Application: Listening for http://127.0.0.1:8123 2024.12.16 08:57:40.887055 [ 9 ] {} Application: Listening for native protocol (tcp): 127.0.0.1:9000 2024.12.16 08:57:40.887094 [ 9 ] {} Application: Listening for MySQL compatibility protocol: 127.0.0.1:9004 2024.12.16 08:57:40.887133 [ 9 ] {} Application: Listening for PostgreSQL compatibility protocol: 127.0.0.1:9005 2024.12.16 08:57:40.887138 [ 9 ] {} Application: Ready for connections. 2024.12.16 08:57:41.000687 [ 661 ] {} AsynchronousMetrics: MemoryTracking: was 224.64 MiB, peak 224.64 MiB, free memory in arenas 44.04 MiB, will set to 227.99 MiB (RSS), difference: 3.35 MiB 2024.12.16 08:57:45.555122 [ 11 ] {} TCPHandlerFactory: TCP Request. Address: 127.0.0.1:40226 2024.12.16 08:57:45.555342 [ 11 ] {} TCPHandler: Connected ClickHouse client version 24.3.0, revision: 54467, user: default. 2024.12.16 08:57:45.555379 [ 11 ] {} TCP-Session: c815bb53-bf33-43fb-89e9-f33272010e72 Authenticating user 'default' from 127.0.0.1:40226 2024.12.16 08:57:45.555426 [ 11 ] {} TCP-Session: c815bb53-bf33-43fb-89e9-f33272010e72 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.16 08:57:45.555436 [ 11 ] {} TCP-Session: c815bb53-bf33-43fb-89e9-f33272010e72 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.16 08:57:45.555569 [ 11 ] {} ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false 2024.12.16 08:57:45.555603 [ 11 ] {} 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 2024.12.16 08:57:45.555627 [ 11 ] {} 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 2024.12.16 08:57:45.565493 [ 11 ] {} TCP-Session: c815bb53-bf33-43fb-89e9-f33272010e72 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.16 08:57:45.565882 [ 11 ] {f7f0b0fb-4c55-4525-a1a7-155b7da1dc5c} executeQuery: (from 127.0.0.1:40226) select 'OK' (stage: Complete) 2024.12.16 08:57:45.566218 [ 11 ] {f7f0b0fb-4c55-4525-a1a7-155b7da1dc5c} Planner: Query SELECT 'OK' AS `'OK'` FROM system.one AS __table1 to stage Complete 2024.12.16 08:57:45.566269 [ 11 ] {f7f0b0fb-4c55-4525-a1a7-155b7da1dc5c} ContextAccess (default): Access granted: SELECT(dummy) ON system.one 2024.12.16 08:57:45.566411 [ 11 ] {f7f0b0fb-4c55-4525-a1a7-155b7da1dc5c} Planner: Query SELECT 'OK' AS `'OK'` FROM system.one AS __table1 from stage FetchColumns to stage Complete 2024.12.16 08:57:45.567683 [ 11 ] {f7f0b0fb-4c55-4525-a1a7-155b7da1dc5c} executeQuery: Read 1 rows, 1.00 B in 0.001838 sec., 544.069640914037 rows/sec., 544.07 B/sec. 2024.12.16 08:57:45.567744 [ 11 ] {f7f0b0fb-4c55-4525-a1a7-155b7da1dc5c} TCPHandler: Processed in 0.0024897 sec. 2024.12.16 08:57:45.577412 [ 11 ] {} TCPHandler: Done processing connection. 2024.12.16 08:57:45.577436 [ 11 ] {} TCP-Session: c815bb53-bf33-43fb-89e9-f33272010e72 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db