| 1 | 2026.01.14 21:22:55.526354 [ 1 ] {} <Information> Application: Starting ClickHouse 23.8.7.1 (revision: 54477, git hash: 3042d295d963012962f5c683bd2776fa331a38c3, build id: <unknown>), PID 5169 | ||
| 2 | 2026.01.14 21:22:55.528236 [ 1 ] {} <Information> Application: starting up | ||
| 3 | 2026.01.14 21:22:55.528303 [ 1 ] {} <Information> Application: OS name: SunOS, version: 5.11, architecture: i86pc | ||
| 4 | 2026.01.14 21:22:55.546467 [ 1 ] {} <Information> Application: Available RAM: 31.99 GiB; physical cores: 8; logical cores: 8. | ||
| 5 | 2026.01.14 21:22:55.550382 [ 1 ] {} <Debug> Application: rlimit on number of file descriptors is 65536 | ||
| 6 | 2026.01.14 21:22:55.550794 [ 1 ] {} <Debug> Application: Initializing DateLUT. | ||
| 7 | 2026.01.14 21:22:55.550835 [ 1 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'. | ||
| 8 | 2026.01.14 21:22:55.550893 [ 1 ] {} <Debug> Context: Setting up /var/tmp/omicron_tmp/test_all-caec0480c7965168-test_vpc_routers_custom_delivered_to_instance.5143.1-clickhouse-s8HHnc/datastore/tmp/ to store temporary data in it | ||
| 9 | 2026.01.14 21:22:55.551384 [ 1 ] {} <Debug> Application: Initializing interserver credentials. | ||
| 10 | 2026.01.14 21:22:55.552513 [ 1 ] {} <Debug> ConfigReloader: Loading config '/var/tmp/omicron_tmp/test_all-caec0480c7965168-test_vpc_routers_custom_delivered_to_instance.5143.1-clickhouse-s8HHnc/config.xml' | ||
| 11 | 2026.01.14 21:22:55.553341 [ 1 ] {} <Debug> ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all-caec0480c7965168-test_vpc_routers_custom_delivered_to_instance.5143.1-clickhouse-s8HHnc/config.xml', performing update on configuration | ||
| 12 | 2026.01.14 21:22:55.553783 [ 1 ] {} <Information> Application: Setting max_server_memory_usage was set to 28.79 GiB (31.99 GiB available * 0.90 max_server_memory_usage_to_ram_ratio) | ||
| 13 | 2026.01.14 21:22:55.553799 [ 1 ] {} <Information> Application: Setting merges_mutations_memory_usage_soft_limit was set to 16.00 GiB (31.99 GiB available * 0.50 merges_mutations_memory_usage_to_ram_ratio) | ||
| 14 | 2026.01.14 21:22:55.553808 [ 1 ] {} <Information> Application: Merges and mutations memory limit is set to 16.00 GiB | ||
| 15 | 2026.01.14 21:22:55.553953 [ 1 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 16 | 2026.01.14 21:22:55.557110 [ 1 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 128 threads | ||
| 17 | 2026.01.14 21:22:55.578909 [ 1 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 18 | 2026.01.14 21:22:55.580637 [ 1 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 19 | 2026.01.14 21:22:55.582359 [ 1 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. | ||
| 20 | 2026.01.14 21:22:55.582483 [ 1 ] {} <Debug> ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all-caec0480c7965168-test_vpc_routers_custom_delivered_to_instance.5143.1-clickhouse-s8HHnc/config.xml', performed update on configuration | ||
| 21 | 2026.01.14 21:22:55.583920 [ 1 ] {} <Debug> ConfigReloader: Loading config '/var/tmp/omicron_tmp/test_all-caec0480c7965168-test_vpc_routers_custom_delivered_to_instance.5143.1-clickhouse-s8HHnc/config.xml' | ||
| 22 | 2026.01.14 21:22:55.584899 [ 1 ] {} <Debug> ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all-caec0480c7965168-test_vpc_routers_custom_delivered_to_instance.5143.1-clickhouse-s8HHnc/config.xml', performing update on configuration | ||
| 23 | 2026.01.14 21:22:55.587173 [ 1 ] {} <Debug> ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all-caec0480c7965168-test_vpc_routers_custom_delivered_to_instance.5143.1-clickhouse-s8HHnc/config.xml', performed update on configuration | ||
| 24 | 2026.01.14 21:22:55.588136 [ 1 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: /var/tmp/omicron_tmp/test_all-caec0480c7965168-test_vpc_routers_custom_delivered_to_instance.5143.1-clickhouse-s8HHnc/config.xml | ||
| 25 | 2026.01.14 21:22:55.590078 [ 1 ] {} <Information> Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32, scheduling_policy=round_robin | ||
| 26 | 2026.01.14 21:22:55.590833 [ 1 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8 | ||
| 27 | 2026.01.14 21:22:55.591493 [ 1 ] {} <Information> Context: Initialized background executor for fetches with num_threads=8, num_tasks=8 | ||
| 28 | 2026.01.14 21:22:55.592517 [ 1 ] {} <Information> Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8 | ||
| 29 | 2026.01.14 21:22:55.597228 [ 1 ] {} <Information> DNSCacheUpdater: Update period 15 seconds | ||
| 30 | 2026.01.14 21:22:55.597286 [ 1 ] {} <Information> Application: Loading metadata from /var/tmp/omicron_tmp/test_all-caec0480c7965168-test_vpc_routers_custom_delivered_to_instance.5143.1-clickhouse-s8HHnc/datastore/ | ||
| 31 | 2026.01.14 21:22:55.599726 [ 1 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total. | ||
| 32 | 2026.01.14 21:22:55.599761 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.000205003 sec | ||
| 33 | 2026.01.14 21:22:55.599857 [ 1 ] {} <Trace> ReferentialDeps: No tables | ||
| 34 | 2026.01.14 21:22:55.599878 [ 1 ] {} <Trace> LoadingDeps: No tables | ||
| 35 | 2026.01.14 21:22:55.600002 [ 1 ] {} <Information> DatabaseAtomic (system): Starting up tables. | ||
| 36 | 2026.01.14 21:22:55.600126 [ 1 ] {} <Debug> SystemLog: Creating system.query_log from query_log | ||
| 37 | 2026.01.14 21:22:55.602663 [ 1 ] {} <Debug> SystemLog: Not creating system.query_thread_log since corresponding section 'query_thread_log' is missing from config | ||
| 38 | 2026.01.14 21:22:55.602733 [ 1 ] {} <Debug> SystemLog: Not creating system.part_log since corresponding section 'part_log' is missing from config | ||
| 39 | 2026.01.14 21:22:55.602746 [ 1 ] {} <Debug> SystemLog: Not creating system.trace_log since corresponding section 'trace_log' is missing from config | ||
| 40 | 2026.01.14 21:22:55.602756 [ 1 ] {} <Debug> SystemLog: Not creating system.crash_log since corresponding section 'crash_log' is missing from config | ||
| 41 | 2026.01.14 21:22:55.602790 [ 1 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config | ||
| 42 | 2026.01.14 21:22:55.602808 [ 1 ] {} <Debug> SystemLog: Creating system.metric_log from metric_log | ||
| 43 | 2026.01.14 21:22:55.605150 [ 95 ] {} <Debug> DNSResolver: Updating DNS cache | ||
| 44 | 2026.01.14 21:22:55.605453 [ 95 ] {} <Debug> DNSResolver: Updated DNS cache | ||
| 45 | 2026.01.14 21:22:55.609075 [ 1 ] {} <Debug> SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config | ||
| 46 | 2026.01.14 21:22:55.609127 [ 1 ] {} <Debug> SystemLog: Not creating system.filesystem_read_prefetches_log since corresponding section 'filesystem_read_prefetches_log' is missing from config | ||
| 47 | 2026.01.14 21:22:55.609172 [ 1 ] {} <Debug> SystemLog: Creating system.asynchronous_metric_log from asynchronous_metric_log | ||
| 48 | 2026.01.14 21:22:55.609391 [ 1 ] {} <Debug> SystemLog: Not creating system.opentelemetry_span_log since corresponding section 'opentelemetry_span_log' is missing from config | ||
| 49 | 2026.01.14 21:22:55.609444 [ 1 ] {} <Debug> SystemLog: Not creating system.query_views_log since corresponding section 'query_views_log' is missing from config | ||
| 50 | 2026.01.14 21:22:55.609467 [ 1 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config | ||
| 51 | 2026.01.14 21:22:55.609478 [ 1 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config | ||
| 52 | 2026.01.14 21:22:55.609513 [ 1 ] {} <Debug> SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config | ||
| 53 | 2026.01.14 21:22:55.609529 [ 1 ] {} <Debug> SystemLog: Not creating system.processors_profile_log since corresponding section 'processors_profile_log' is missing from config | ||
| 54 | 2026.01.14 21:22:55.609540 [ 1 ] {} <Debug> SystemLog: Not creating system.asynchronous_insert_log since corresponding section 'asynchronous_insert_log' is missing from config | ||
| 55 | 2026.01.14 21:22:55.644490 [ 1 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal. | ||
| 56 | 2026.01.14 21:22:55.645227 [ 1 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total. | ||
| 57 | 2026.01.14 21:22:55.645261 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 7.4586e-05 sec | ||
| 58 | 2026.01.14 21:22:55.645272 [ 1 ] {} <Trace> ReferentialDeps: No tables | ||
| 59 | 2026.01.14 21:22:55.645280 [ 1 ] {} <Trace> LoadingDeps: No tables | ||
| 60 | 2026.01.14 21:22:55.645317 [ 1 ] {} <Information> DatabaseAtomic (default): Starting up tables. | ||
| 61 | 2026.01.14 21:22:55.645527 [ 1 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/tmp/omicron_tmp/test_all-caec0480c7965168-test_vpc_routers_custom_delivered_to_instance.5143.1-clickhouse-s8HHnc/datastore/user_defined/ | ||
| 62 | 2026.01.14 21:22:55.645589 [ 1 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded | ||
| 63 | 2026.01.14 21:22:55.645600 [ 1 ] {} <Debug> Application: Loaded metadata. | ||
| 64 | 2026.01.14 21:22:55.645614 [ 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 | 2026.01.14 21:22:55.645622 [ 1 ] {} <Information> Application: TaskStats is not implemented for this OS. IO accounting will be disabled. | ||
| 66 | 2026.01.14 21:22:55.645870 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 53741 | ||
| 67 | 2026.01.14 21:22:55.646060 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 34365 | ||
| 68 | 2026.01.14 21:22:55.647826 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 59768 | ||
| 69 | 2026.01.14 21:22:55.647906 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 37909 | ||
| 70 | 2026.01.14 21:22:55.647938 [ 1 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. | ||
| 71 | 2026.01.14 21:22:55.648177 [ 1 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 24.77 MiB, peak 24.77 MiB, free memory in arenas 0.00 B, will set to 126.96 MiB (RSS), difference: 102.19 MiB | ||
| 72 | 2026.01.14 21:22:55.648590 [ 1 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 2.2905e-05 sec. | ||
| 73 | 2026.01.14 21:22:55.649098 [ 1 ] {} <Information> Application: Listening for http://[::1]:53741 | ||
| 74 | 2026.01.14 21:22:55.649208 [ 1 ] {} <Information> Application: Listening for native protocol (tcp): [::1]:34365 | ||
| 75 | 2026.01.14 21:22:55.651886 [ 1 ] {} <Information> Application: Listening for http://127.0.0.1:59768 | ||
| 76 | 2026.01.14 21:22:55.651988 [ 1 ] {} <Information> Application: Listening for native protocol (tcp): 127.0.0.1:37909 | ||
| 77 | 2026.01.14 21:22:55.652002 [ 1 ] {} <Information> Application: Ready for connections. | ||
| 78 | 2026.01.14 21:22:55.952324 [ 2 ] {} <Trace> BaseDaemon: Received signal 15 | ||
| 79 | 2026.01.14 21:22:55.952691 [ 2 ] {} <Information> Application: Received termination signal (Terminated) | ||
| 80 | 2026.01.14 21:22:55.952898 [ 1 ] {} <Debug> Application: Received termination signal. | ||
| 81 | 2026.01.14 21:22:55.953158 [ 1 ] {} <Debug> Application: Waiting for current connections to close. | ||
| 82 | 2026.01.14 21:22:56.000945 [ 247 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 126.97 MiB, peak 126.97 MiB, free memory in arenas 0.00 B, will set to 128.39 MiB (RSS), difference: 1.42 MiB | ||
| 83 | 2026.01.14 21:22:56.657838 [ 1 ] {} <Information> Application: Closed all listening sockets. | ||
| 84 | 2026.01.14 21:22:56.657982 [ 1 ] {} <Information> Application: Closed connections. | ||
| 85 | 2026.01.14 21:22:56.658280 [ 1 ] {} <Information> Application: Shutting down storages. | ||
| 86 | 2026.01.14 21:22:56.658326 [ 1 ] {} <Information> Context: Shutdown disk default | ||
| 87 | 2026.01.14 21:22:56.658339 [ 1 ] {} <Trace> AsynchronousInsertQueue: Shutting down the asynchronous insertion queue | ||
| 88 | 2026.01.14 21:22:56.659594 [ 1 ] {} <Trace> AsynchronousInsertQueue: Asynchronous insertion queue finished | ||
| 89 | 2026.01.14 21:22:56.659650 [ 1 ] {} <Debug> Context: Shutting down dictionaries loader | ||
| 90 | 2026.01.14 21:22:56.659742 [ 1 ] {} <Debug> Context: Shutting down UDFs loader | ||
| 91 | 2026.01.14 21:22:56.659836 [ 1 ] {} <Debug> Context: Shutting down another UDFs loader | ||
| 92 | 2026.01.14 21:22:56.659853 [ 1 ] {} <Trace> Context: Shutting down named sessions | ||
| 93 | 2026.01.14 21:22:56.659903 [ 1 ] {} <Debug> Context: Shutting down system logs | ||
| 94 | 2026.01.14 21:22:56.659972 [ 234 ] {} <Trace> SystemLog (system.query_log): Terminating | ||
| 95 | 2026.01.14 21:22:57.618803 [ 189 ] {} <Trace> SystemLog (system.metric_log): Flushing system log, 2 entries to flush up to offset 2 | ||
| 96 | 2026.01.14 21:22:57.619005 [ 189 ] {} <Debug> SystemLog (system.metric_log): Creating new table system.metric_log for MetricLog | ||
| 97 | 2026.01.14 21:22:57.636721 [ 189 ] {} <Trace> StoragePolicy (default): Storage policy default created, total volumes 1 | ||
| 98 | 2026.01.14 21:22:57.637215 [ 189 ] {} <Debug> system.metric_log (a4c972d7-e01e-471a-a15d-be39b08b60d2): Loading data parts | ||
| 99 | 2026.01.14 21:22:57.637964 [ 189 ] {} <Debug> system.metric_log (a4c972d7-e01e-471a-a15d-be39b08b60d2): There are no data parts | ||
| 100 | 2026.01.14 21:22:57.686487 [ 189 ] {} <Trace> system.metric_log (a4c972d7-e01e-471a-a15d-be39b08b60d2): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 101 | 2026.01.14 21:22:57.686637 [ 189 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 127.87 GiB. | ||
| 102 | 2026.01.14 21:22:57.702040 [ 189 ] {} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 103 | 2026.01.14 21:22:57.703719 [ 189 ] {} <Trace> system.metric_log (a4c972d7-e01e-471a-a15d-be39b08b60d2): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 104 | 2026.01.14 21:22:57.711248 [ 189 ] {} <Trace> SystemLog (system.metric_log): Flushed system log up to offset 2 | ||
| 105 | 2026.01.14 21:22:57.711302 [ 189 ] {} <Trace> SystemLog (system.metric_log): Terminating | ||
| 106 | 2026.01.14 21:22:57.711514 [ 202 ] {} <Trace> SystemLog (system.asynchronous_metric_log): Flushing system log, 122 entries to flush up to offset 122 | ||
| 107 | 2026.01.14 21:22:57.711655 [ 202 ] {} <Debug> SystemLog (system.asynchronous_metric_log): Creating new table system.asynchronous_metric_log for AsynchronousMetricLog | ||
| 108 | 2026.01.14 21:22:57.713605 [ 202 ] {} <Debug> system.asynchronous_metric_log (f8023659-ab8a-48e7-a587-5c8a1d99b272): Loading data parts | ||
| 109 | 2026.01.14 21:22:57.713912 [ 202 ] {} <Debug> system.asynchronous_metric_log (f8023659-ab8a-48e7-a587-5c8a1d99b272): There are no data parts | ||
| 110 | 2026.01.14 21:22:57.714875 [ 202 ] {} <Trace> system.asynchronous_metric_log (f8023659-ab8a-48e7-a587-5c8a1d99b272): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 111 | 2026.01.14 21:22:57.714934 [ 202 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 127.87 GiB. | ||
| 112 | 2026.01.14 21:22:57.717619 [ 202 ] {} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 113 | 2026.01.14 21:22:57.717992 [ 202 ] {} <Trace> system.asynchronous_metric_log (f8023659-ab8a-48e7-a587-5c8a1d99b272): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 114 | 2026.01.14 21:22:57.718237 [ 202 ] {} <Trace> SystemLog (system.asynchronous_metric_log): Flushed system log up to offset 122 | ||
| 115 | 2026.01.14 21:22:57.718258 [ 202 ] {} <Trace> SystemLog (system.asynchronous_metric_log): Terminating | ||
| 116 | 2026.01.14 21:22:57.914110 [ 1 ] {} <Trace> Context: Shutting down database catalog | ||
| 117 | 2026.01.14 21:22:57.914220 [ 1 ] {} <Trace> DatabaseCatalog: Shutting down database INFORMATION_SCHEMA | ||
| 118 | 2026.01.14 21:22:57.914501 [ 1 ] {} <Trace> DatabaseCatalog: Shutting down database default | ||
| 119 | 2026.01.14 21:22:57.914520 [ 1 ] {} <Trace> DatabaseCatalog: Shutting down database information_schema | ||
| 120 | 2026.01.14 21:22:57.914739 [ 1 ] {} <Trace> DatabaseCatalog: Shutting down system databases | ||
| 121 | 2026.01.14 21:22:58.424102 [ 1 ] {} <Debug> Context: Shutting down merges executor | ||
| 122 | 2026.01.14 21:22:58.425092 [ 1 ] {} <Debug> Context: Shutting down fetches executor | ||
| 123 | 2026.01.14 21:22:58.425660 [ 1 ] {} <Debug> Context: Shutting down moves executor | ||
| 124 | 2026.01.14 21:22:58.426104 [ 1 ] {} <Debug> Context: Shutting down common executor | ||
| 125 | 2026.01.14 21:22:58.426525 [ 1 ] {} <Trace> Context: Shutting down DDLWorker | ||
| 126 | 2026.01.14 21:22:58.426544 [ 1 ] {} <Trace> Context: Shutting down caches | ||
| 127 | 2026.01.14 21:22:58.426905 [ 1 ] {} <Trace> BackgroundSchedulePool/BgBufSchPool: Waiting for threads to finish. | ||
| 128 | 2026.01.14 21:22:58.428258 [ 1 ] {} <Trace> BackgroundSchedulePool/BgSchPool: Waiting for threads to finish. | ||
| 129 | 2026.01.14 21:22:58.428595 [ 1 ] {} <Trace> BackgroundSchedulePool/BgDistSchPool: Waiting for threads to finish. | ||
| 130 | 2026.01.14 21:22:58.428909 [ 1 ] {} <Trace> BackgroundSchedulePool/BgMBSchPool: Waiting for threads to finish. | ||
| 131 | 2026.01.14 21:22:58.429092 [ 1 ] {} <Debug> Application: Shut down storages. | ||
| 132 | 2026.01.14 21:22:58.432115 [ 1 ] {} <Debug> Application: Destroyed global context. | ||
| 133 | 2026.01.14 21:22:58.432818 [ 1 ] {} <Information> Application: shutting down | ||
| 134 | 2026.01.14 21:22:58.432867 [ 1 ] {} <Debug> Application: Uninitializing subsystem: Logging Subsystem | ||
| 135 | 2026.01.14 21:22:58.433641 [ 2 ] {} <Trace> BaseDaemon: Received signal -2 | ||
| 136 | 2026.01.14 21:22:58.433728 [ 2 ] {} <Information> BaseDaemon: Stop SignalListener thread | ||