| 1 | 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 | ||
| 2 | 2024.09.17 04:58:21.262020 [ 1 ] {} <Information> Application: starting up | ||
| 3 | 2024.09.17 04:58:21.262052 [ 1 ] {} <Information> Application: OS name: SunOS, version: 5.11, architecture: i86pc | ||
| 4 | 2024.09.17 04:58:21.268247 [ 1 ] {} <Information> Application: Available RAM: 31.32 GiB; physical cores: 8; logical cores: 8. | ||
| 5 | 2024.09.17 04:58:21.270942 [ 1 ] {} <Debug> Application: rlimit on number of file descriptors is 65536 | ||
| 6 | 2024.09.17 04:58:21.270975 [ 1 ] {} <Debug> Application: Initializing DateLUT. | ||
| 7 | 2024.09.17 04:58:21.270989 [ 1 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'. | ||
| 8 | 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 | ||
| 9 | 2024.09.17 04:58:21.271481 [ 1 ] {} <Debug> Application: Initializing interserver credentials. | ||
| 10 | 2024.09.17 04:58:21.272198 [ 1 ] {} <Debug> ConfigReloader: Loading config 'config.xml' | ||
| 11 | 2024.09.17 04:58:21.272656 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performing update on configuration | ||
| 12 | 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) | ||
| 13 | 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) | ||
| 14 | 2024.09.17 04:58:21.273163 [ 1 ] {} <Information> Application: Merges and mutations memory limit is set to 15.66 GiB | ||
| 15 | 2024.09.17 04:58:21.273240 [ 1 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 16 | 2024.09.17 04:58:21.274144 [ 1 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 128 threads | ||
| 17 | 2024.09.17 04:58:21.284062 [ 1 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 18 | 2024.09.17 04:58:21.285749 [ 1 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 19 | 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. | ||
| 20 | 2024.09.17 04:58:21.288556 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performed update on configuration | ||
| 21 | 2024.09.17 04:58:21.289395 [ 1 ] {} <Debug> ConfigReloader: Loading config 'config.xml' | ||
| 22 | 2024.09.17 04:58:21.289814 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performing update on configuration | ||
| 23 | 2024.09.17 04:58:21.291173 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performed update on configuration | ||
| 24 | 2024.09.17 04:58:21.291704 [ 1 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: config.xml | ||
| 25 | 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 | ||
| 26 | 2024.09.17 04:58:21.293811 [ 1 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8 | ||
| 27 | 2024.09.17 04:58:21.294326 [ 1 ] {} <Information> Context: Initialized background executor for fetches with num_threads=8, num_tasks=8 | ||
| 28 | 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 | ||
| 29 | 2024.09.17 04:58:21.296431 [ 1 ] {} <Information> DNSCacheUpdater: Update period 15 seconds | ||
| 30 | 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/ | ||
| 31 | 2024.09.17 04:58:21.296518 [ 163 ] {} <Debug> DNSResolver: Updating DNS cache | ||
| 32 | 2024.09.17 04:58:21.296592 [ 163 ] {} <Debug> DNSResolver: Updated DNS cache | ||
| 33 | 2024.09.17 04:58:21.300726 [ 1 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total. | ||
| 34 | 2024.09.17 04:58:21.300749 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.000104278 sec | ||
| 35 | 2024.09.17 04:58:21.300764 [ 1 ] {} <Trace> ReferentialDeps: No tables | ||
| 36 | 2024.09.17 04:58:21.300773 [ 1 ] {} <Trace> LoadingDeps: No tables | ||
| 37 | 2024.09.17 04:58:21.300842 [ 1 ] {} <Information> DatabaseAtomic (system): Starting up tables. | ||
| 38 | 2024.09.17 04:58:21.300881 [ 1 ] {} <Debug> SystemLog: Not creating system.query_log since corresponding section 'query_log' is missing from config | ||
| 39 | 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 | ||
| 40 | 2024.09.17 04:58:21.300912 [ 1 ] {} <Debug> SystemLog: Not creating system.part_log since corresponding section 'part_log' is missing from config | ||
| 41 | 2024.09.17 04:58:21.300924 [ 1 ] {} <Debug> SystemLog: Not creating system.trace_log since corresponding section 'trace_log' is missing from config | ||
| 42 | 2024.09.17 04:58:21.300932 [ 1 ] {} <Debug> SystemLog: Not creating system.crash_log since corresponding section 'crash_log' is missing from config | ||
| 43 | 2024.09.17 04:58:21.300949 [ 1 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config | ||
| 44 | 2024.09.17 04:58:21.300984 [ 1 ] {} <Debug> SystemLog: Not creating system.metric_log since corresponding section 'metric_log' is missing from config | ||
| 45 | 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 | ||
| 46 | 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 | ||
| 47 | 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 | ||
| 48 | 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 | ||
| 49 | 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 | ||
| 50 | 2024.09.17 04:58:21.301101 [ 1 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config | ||
| 51 | 2024.09.17 04:58:21.301117 [ 1 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config | ||
| 52 | 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 | ||
| 53 | 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 | ||
| 54 | 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 | ||
| 55 | 2024.09.17 04:58:21.328203 [ 1 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal. | ||
| 56 | 2024.09.17 04:58:21.330023 [ 1 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total. | ||
| 57 | 2024.09.17 04:58:21.330053 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 9.6698e-05 sec | ||
| 58 | 2024.09.17 04:58:21.330064 [ 1 ] {} <Trace> ReferentialDeps: No tables | ||
| 59 | 2024.09.17 04:58:21.330071 [ 1 ] {} <Trace> LoadingDeps: No tables | ||
| 60 | 2024.09.17 04:58:21.330092 [ 1 ] {} <Information> DatabaseAtomic (default): Starting up tables. | ||
| 61 | 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/ | ||
| 62 | 2024.09.17 04:58:21.330324 [ 1 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded | ||
| 63 | 2024.09.17 04:58:21.330342 [ 1 ] {} <Debug> Application: Loaded metadata. | ||
| 64 | 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). | ||
| 65 | 2024.09.17 04:58:21.330371 [ 1 ] {} <Information> Application: TaskStats is not implemented for this OS. IO accounting will be disabled. | ||
| 66 | 2024.09.17 04:58:21.330551 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 53840 | ||
| 67 | 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> | ||
| 68 | 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> | ||
| 69 | 2024.09.17 04:58:21.331328 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 51840 | ||
| 70 | 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> | ||
| 71 | 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> | ||
| 72 | 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. | ||
| 73 | 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 | ||
| 74 | 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. | ||
| 75 | 2024.09.17 04:58:21.332580 [ 1 ] {} <Information> Application: Listening for http://[::1]:53840 | ||
| 76 | 2024.09.17 04:58:21.332690 [ 1 ] {} <Information> Application: Listening for http://127.0.0.1:51840 | ||
| 77 | 2024.09.17 04:58:21.332712 [ 1 ] {} <Information> Application: Ready for connections. | ||