2024.09.17 04:58:21.261904 [ 1 ] {} <Information> Application: Starting ClickHouse 23.8.7.1 (revision: 54477, git hash: b6a391579f09dde47a1aa5602e154e7fcde80d1e, build id: <unknown>), PID 21806
2024.09.17 04:58:21.262020 [ 1 ] {} <Information> Application: starting up
2024.09.17 04:58:21.262052 [ 1 ] {} <Information> Application: OS name: SunOS, version: 5.11, architecture: i86pc
2024.09.17 04:58:21.268247 [ 1 ] {} <Information> Application: Available RAM: 31.32 GiB; physical cores: 8; logical cores: 8.
2024.09.17 04:58:21.270942 [ 1 ] {} <Debug> Application: rlimit on number of file descriptors is 65536
2024.09.17 04:58:21.270975 [ 1 ] {} <Debug> Application: Initializing DateLUT.
2024.09.17 04:58:21.270989 [ 1 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'.
2024.09.17 04:58:21.271057 [ 1 ] {} <Debug> Context: Setting up /var/tmp/omicron_tmp/oximeter_db-690892652d4c7fc0-test_select_array_column.21803.1-clickhouse-QPNQ19/datastore/tmp/ to store temporary data in it
2024.09.17 04:58:21.271481 [ 1 ] {} <Debug> Application: Initializing interserver credentials.
2024.09.17 04:58:21.272198 [ 1 ] {} <Debug> ConfigReloader: Loading config 'config.xml'
2024.09.17 04:58:21.272656 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performing update on configuration
2024.09.17 04:58:21.273118 [ 1 ] {} <Information> Application: Setting max_server_memory_usage was set to 28.18 GiB (31.32 GiB available * 0.90 max_server_memory_usage_to_ram_ratio)
2024.09.17 04:58:21.273141 [ 1 ] {} <Information> Application: Setting merges_mutations_memory_usage_soft_limit was set to 15.66 GiB (31.32 GiB available * 0.50 merges_mutations_memory_usage_to_ram_ratio)
2024.09.17 04:58:21.273163 [ 1 ] {} <Information> Application: Merges and mutations memory limit is set to 15.66 GiB
2024.09.17 04:58:21.273240 [ 1 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads
2024.09.17 04:58:21.274144 [ 1 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 128 threads
2024.09.17 04:58:21.284062 [ 1 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads
2024.09.17 04:58:21.285749 [ 1 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads
2024.09.17 04:58:21.288486 [ 1 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again.
2024.09.17 04:58:21.288556 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performed update on configuration
2024.09.17 04:58:21.289395 [ 1 ] {} <Debug> ConfigReloader: Loading config 'config.xml'
2024.09.17 04:58:21.289814 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performing update on configuration
2024.09.17 04:58:21.291173 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performed update on configuration
2024.09.17 04:58:21.291704 [ 1 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: config.xml
2024.09.17 04:58:21.293139 [ 1 ] {} <Information> Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32, scheduling_policy=round_robin
2024.09.17 04:58:21.293811 [ 1 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8
2024.09.17 04:58:21.294326 [ 1 ] {} <Information> Context: Initialized background executor for fetches with num_threads=8, num_tasks=8
2024.09.17 04:58:21.295157 [ 1 ] {} <Information> Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8
2024.09.17 04:58:21.296431 [ 1 ] {} <Information> DNSCacheUpdater: Update period 15 seconds
2024.09.17 04:58:21.296461 [ 1 ] {} <Information> Application: Loading metadata from /var/tmp/omicron_tmp/oximeter_db-690892652d4c7fc0-test_select_array_column.21803.1-clickhouse-QPNQ19/datastore/
2024.09.17 04:58:21.296518 [ 163 ] {} <Debug> DNSResolver: Updating DNS cache
2024.09.17 04:58:21.296592 [ 163 ] {} <Debug> DNSResolver: Updated DNS cache
2024.09.17 04:58:21.300726 [ 1 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total.
2024.09.17 04:58:21.300749 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.000104278 sec
2024.09.17 04:58:21.300764 [ 1 ] {} <Trace> ReferentialDeps: No tables
2024.09.17 04:58:21.300773 [ 1 ] {} <Trace> LoadingDeps: No tables
2024.09.17 04:58:21.300842 [ 1 ] {} <Information> DatabaseAtomic (system): Starting up tables.
2024.09.17 04:58:21.300881 [ 1 ] {} <Debug> SystemLog: Not creating system.query_log since corresponding section 'query_log' is missing from config
2024.09.17 04:58:21.300894 [ 1 ] {} <Debug> SystemLog: Not creating system.query_thread_log since corresponding section 'query_thread_log' is missing from config
2024.09.17 04:58:21.300912 [ 1 ] {} <Debug> SystemLog: Not creating system.part_log since corresponding section 'part_log' is missing from config
2024.09.17 04:58:21.300924 [ 1 ] {} <Debug> SystemLog: Not creating system.trace_log since corresponding section 'trace_log' is missing from config
2024.09.17 04:58:21.300932 [ 1 ] {} <Debug> SystemLog: Not creating system.crash_log since corresponding section 'crash_log' is missing from config
2024.09.17 04:58:21.300949 [ 1 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config
2024.09.17 04:58:21.300984 [ 1 ] {} <Debug> SystemLog: Not creating system.metric_log since corresponding section 'metric_log' is missing from config
2024.09.17 04:58:21.301006 [ 1 ] {} <Debug> SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config
2024.09.17 04:58:21.301036 [ 1 ] {} <Debug> SystemLog: Not creating system.filesystem_read_prefetches_log since corresponding section 'filesystem_read_prefetches_log' is missing from config
2024.09.17 04:58:21.301051 [ 1 ] {} <Debug> SystemLog: Not creating system.asynchronous_metric_log since corresponding section 'asynchronous_metric_log' is missing from config
2024.09.17 04:58:21.301068 [ 1 ] {} <Debug> SystemLog: Not creating system.opentelemetry_span_log since corresponding section 'opentelemetry_span_log' is missing from config
2024.09.17 04:58:21.301081 [ 1 ] {} <Debug> SystemLog: Not creating system.query_views_log since corresponding section 'query_views_log' is missing from config
2024.09.17 04:58:21.301101 [ 1 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config
2024.09.17 04:58:21.301117 [ 1 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config
2024.09.17 04:58:21.301143 [ 1 ] {} <Debug> SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config
2024.09.17 04:58:21.301157 [ 1 ] {} <Debug> SystemLog: Not creating system.processors_profile_log since corresponding section 'processors_profile_log' is missing from config
2024.09.17 04:58:21.301175 [ 1 ] {} <Debug> SystemLog: Not creating system.asynchronous_insert_log since corresponding section 'asynchronous_insert_log' is missing from config
2024.09.17 04:58:21.328203 [ 1 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal.
2024.09.17 04:58:21.330023 [ 1 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total.
2024.09.17 04:58:21.330053 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 9.6698e-05 sec
2024.09.17 04:58:21.330064 [ 1 ] {} <Trace> ReferentialDeps: No tables
2024.09.17 04:58:21.330071 [ 1 ] {} <Trace> LoadingDeps: No tables
2024.09.17 04:58:21.330092 [ 1 ] {} <Information> DatabaseAtomic (default): Starting up tables.
2024.09.17 04:58:21.330252 [ 1 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/tmp/omicron_tmp/oximeter_db-690892652d4c7fc0-test_select_array_column.21803.1-clickhouse-QPNQ19/datastore/user_defined/
2024.09.17 04:58:21.330324 [ 1 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded
2024.09.17 04:58:21.330342 [ 1 ] {} <Debug> Application: Loaded metadata.
2024.09.17 04:58:21.330353 [ 1 ] {} <Information> Application: Query Profiler and TraceCollector are disabled because they require PHDR cache to be created (otherwise the function 'dl_iterate_phdr' is not lock free and not async-signal safe).
2024.09.17 04:58:21.330371 [ 1 ] {} <Information> Application: TaskStats is not implemented for this OS. IO accounting will be disabled.
2024.09.17 04:58:21.330551 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 53840
2024.09.17 04:58:21.331118 [ 1 ] {} <Warning> Application: Listen [::1]:9000 failed: Poco::Exception. Code: 1000, e.code() = 125, Net Exception: Address already in use: [::1]:9000 (version 23.8.7.1). If it is an IPv6 or IPv4 address and your host has disabled IPv6 or IPv4, then consider to specify not disabled IPv4 or IPv6 address to listen in <listen_host> element of configuration file. Example for disabled IPv6: <listen_host>0.0.0.0</listen_host> . Example for disabled IPv4: <listen_host>::</listen_host>
2024.09.17 04:58:21.331248 [ 1 ] {} <Warning> Application: Listen [::1]:9004 failed: Poco::Exception. Code: 1000, e.code() = 125, Net Exception: Address already in use: [::1]:9004 (version 23.8.7.1). If it is an IPv6 or IPv4 address and your host has disabled IPv6 or IPv4, then consider to specify not disabled IPv4 or IPv6 address to listen in <listen_host> element of configuration file. Example for disabled IPv6: <listen_host>0.0.0.0</listen_host> . Example for disabled IPv4: <listen_host>::</listen_host>
2024.09.17 04:58:21.331328 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 51840
2024.09.17 04:58:21.331431 [ 1 ] {} <Warning> Application: Listen [127.0.0.1]:9000 failed: Poco::Exception. Code: 1000, e.code() = 125, Net Exception: Address already in use: 127.0.0.1:9000 (version 23.8.7.1). If it is an IPv6 or IPv4 address and your host has disabled IPv6 or IPv4, then consider to specify not disabled IPv4 or IPv6 address to listen in <listen_host> element of configuration file. Example for disabled IPv6: <listen_host>0.0.0.0</listen_host> . Example for disabled IPv4: <listen_host>::</listen_host>
2024.09.17 04:58:21.331521 [ 1 ] {} <Warning> Application: Listen [127.0.0.1]:9004 failed: Poco::Exception. Code: 1000, e.code() = 125, Net Exception: Address already in use: 127.0.0.1:9004 (version 23.8.7.1). If it is an IPv6 or IPv4 address and your host has disabled IPv6 or IPv4, then consider to specify not disabled IPv4 or IPv6 address to listen in <listen_host> element of configuration file. Example for disabled IPv6: <listen_host>0.0.0.0</listen_host> . Example for disabled IPv4: <listen_host>::</listen_host>
2024.09.17 04:58:21.331565 [ 1 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again.
2024.09.17 04:58:21.331800 [ 1 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 9.87 MiB, peak 16.08 MiB, free memory in arenas 0.00 B, will set to 131.55 MiB (RSS), difference: 121.68 MiB
2024.09.17 04:58:21.332129 [ 1 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 2.3517e-05 sec.
2024.09.17 04:58:21.332580 [ 1 ] {} <Information> Application: Listening for http://[::1]:53840
2024.09.17 04:58:21.332690 [ 1 ] {} <Information> Application: Listening for http://127.0.0.1:51840
2024.09.17 04:58:21.332712 [ 1 ] {} <Information> Application: Ready for connections.